Problem Set #7Attached Files: Building a Model - Marvel Renovations.xlsx (19.843 KB)Start with the partial model in the file attached. Marvel Pence, CEO of Marvel’s Renovations, a custom building and repair company, is preparing documentation for a line of credit request from his commercial banker. Among the required documents is a detailed sales forecast for parts of 2020 and 2021: SalesLabor and Raw MaterialsMay, 2020$75,000$80,000June, 2020$115,000$75,000July, 2020$145,000$105,000August, 2020$125,000$85,000September, 2020$120,000$65,000October, 2020$95,000$70,000November, 2020$75,000$30,000December, 2020$55,000$35,000January, 2021$45,000N/AEstimates obtained from the credit and collection department are as follows: collections within the month of sale, 20%; collections during the month following the sale, 60%; collections the second month following the sale, 25%. Payments for labor and raw materials are typically made during the month following the one in which these costs were incurred. Total costs for labor and raw materials are estimated for each month as shown in the table. General and administrative salaries will amount to approximately $25,000 a month; lease payments under long-term lease contracts will be $7,000 a month; depreciation charges will be $8,000 a month; miscellaneous expenses will be $5,000 a month; income tax payments of $30,000 will be due in both August and December; and a progress payment of $95,000 on a new office suite must be paid in October. Cash on hand on July 1 will amount to $70,000, and a minimum cash balance of $30,000 will be maintained throughout the cash budget period.a. Prepare a monthly cash budget for the last 6 months of 2020.b. Prepare an estimate of the required financing (or excess funds)—that is, the amount of money Marvel’s Renovations will need to borrow (or will have available to invest)—for each month during that period.c. If its customers began to pay late, this would slow down collections and thus increase the required loan amount. Also, if sales dropped off, this would have an effect on the required loan amount. Perform a sensitivity analysis that shows the effects of these two factors on the maximum loan requirement.Submit your answers in a Word document.

The success of an organization depends heavily on its structure, strategies, and culture. In this assignment, you will develop an understanding of the importance of these elements in the success/failure of an enterprise.Using the online library resources and the Internet, research methods of conducting internal and external environment analyses. Select at least three (3) scholarly sources to support the information in your report.Description :In this assignment, you will assess an organization’s current position in the internal and external environment.Scenario:You have been hired as a consultant to evaluate the performance of a manufacturing or service organization. As part of your function, you need to assess the organization’s current position with regard to their business operations, strategy, and organizational structure, as well as identify potential ethical issues management may face. The executive management team has asked you to submit a report of your findings.Instructions:Choose a publicly traded manufacturing or service organization to be the subject of your work for LASA 1 and LASA 2. (You should choose a different organization than you have used for previous assignments.) Select an organization about which there is an abundance of information made readily available to the public (via the corporate website, industry publications, business journals, etc.).In preparation for your report, conduct your review of the organization using the following approach:Evaluate the company’s business strategy and global competitiveness plan.Conduct an internal assessment using SWOT analysis.Assess the external environment via an external scenario evaluation.Sketch the company’s organizational structure.Using the tools of business process design, define the organization’s business process.Identify any potential ethical issues that may impact the traditional management functions of the company and recommend preventative measures.Utilize at least three sources in your research. Your document should be written in a clear, concise, and organized manner; demonstrate ethical scholarship in accurate representation and attribution of sources; and display accurate spelling, grammar, and punctuation.Write an 8–10-page report in Word format. Apply APA standards to citation of sources.Assignment ComponentsProficientMax PointsEvaluate the company’s business strategy and global competitiveness plan.Evaluation of the business strategy and global competitiveness plan is logical and reflects research of the company.32Conduct an internal assessment using SWOT analysis.SWOT analysis provides an accurate account of the organization’s strengths, weaknesses, opportunities, and threats. All elements of the SWOT analysis are complete.32Assess the external environment via an external scenario evaluation.External scenario evaluation is complete. Response reflects understanding of the organization and its place within the external environment.28Diagram the company’s organizational structure.Organizational structure diagram is complete and accurate.28Using the tools of business process design, define the organization’s business process.The organization’s business process is accurately defined. Response reflects an accurate understanding of business processes.36Academic WritingWrite in a clear, concise, and organized manner; demonstrate ethical scholarship in appropriate and accurate representation and attribution of sources (i.e., APA); and display accurate spelling, grammar, and punctuation. Use of scholarly sources aligns with specified assignment requirements.Wrote in a clear, concise, and organized manner; demonstrated ethical scholarship in appropriate and accurate representation and attribution of sources; and displayed accurate spelling, grammar, and punctuation. Use of scholarly sources aligns with specified assignment requirements.44Total