Production Costs Excel Spreadsheet Essay Assignment
Using an Excel spreadsheet, calculate the bottom line improvement using the base line below under these scenarios:
Increase sales by 50%
Reduce finance costs by 50%, keeping sales at $100,000
Reduce production costs by 20% (cost of goods sold), keeping sales and finance costs at the initial levels
What option offers the best overall result?
Upload the Excel file with your calculations.
Base Line Financials Item Base Line Sales $100,000 Cost of goods sold $80,000 Gross margin $20,000 Finance costs $6,000 Subtotal $14,000 Taxes at 25% $3,500 Contribution $ 10,500 United Healthcare Case Study
In this capstone assignment in the course, you will present an in-depth analysis of a financial decision undertaken by a health care organization of the group’s choice. The analysis should consider actions such as a capital investment, merger/acquisition, implementation of a new business line, or insurance contract. This is not an exhaustive list and other types of decisions covered in this course could be used for the assignment. Ideally the issue covered in this assignment would be something of use to the organization represented by a member of the group. Your perspective on this assignment should be that of a consultant advising the governing board of the organization on a financial decision. Quantitative and verbal analyses of the case should be done collaboratively in work teams. Case analyses should be prepared in memo format for presentation to and consideration by a planning and finance committee of a board of trustees or directors. A recommended structure for the memo is:
Introduction – description of the project, organization, background of the decision and its context in the organization (the “why bother with this decision”)
Options to be evaluated – a minimum of two (2) options must be presented
Analysis – financial and strategic analysis of decision options
Recommendation – recommended alternative with explanation of decision rationale
Projected outcome – how implementation of this recommendation will impact the organization’s financial position – HINT: a pro forma set of financial statements for the organization with a “before” and “after” would be a good idea here