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
Tired of getting an average grade in all your school assignments, projects, essays, and homework? Try us today for all your academic schoolwork needs. We are among the most trusted and recognized professional writing services in the market.
We provide unique, original and plagiarism-free high quality academic, homework, assignments and essay submissions for all our clients. At our company, we capitalize on producing A+ Grades for all our clients and also ensure that you have smooth academic progress in all your school term and semesters.
High-quality academic submissions, A 100% plagiarism-free submission, Meet even the most urgent deadlines, Provide our services to you at the most competitive rates in the market, Give you free revisions until you meet your desired grades and Provide you with 24/7 customer support service via calls or live chats.