Production Costs Excel Spreadsheet Essay Assignment

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

PLACE THE ORDER WITH US TODAY AND GET A PERFECT SCORE!!!