Production Costs Excel Spreadsheet Essay Assignment
Order ID:89JHGSJE83839 Style:APA/MLA/Harvard/Chicago Pages:5-10 Instructions:
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
RUBRIC
Excellent Quality
95-100%
Introduction 45-41 points
The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.
Literature Support
91-84 points
The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.
Methodology
58-53 points
Content is well-organized with headings for each slide and bulleted lists to group related material as needed. Use of font, color, graphics, effects, etc. to enhance readability and presentation content is excellent. Length requirements of 10 slides/pages or less is met.
Average Score
50-85%
40-38 points
More depth/detail for the background and significance is needed, or the research detail is not clear. No search history information is provided.
83-76 points
Review of relevant theoretical literature is evident, but there is little integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are included. Summary of information presented is included. Conclusion may not contain a biblical integration.
52-49 points
Content is somewhat organized, but no structure is apparent. The use of font, color, graphics, effects, etc. is occasionally detracting to the presentation content. Length requirements may not be met.
Poor Quality
0-45%
37-1 points
The background and/or significance are missing. No search history information is provided.
75-1 points
Review of relevant theoretical literature is evident, but there is no integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are not included in the summary of information presented. Conclusion does not contain a biblical integration.
48-1 points
There is no clear or logical organizational structure. No logical sequence is apparent. The use of font, color, graphics, effects etc. is often detracting to the presentation content. Length requirements may not be met
You Can Also Place the Order at www.collegepaper.us/orders/ordernow or www.crucialessay.com/orders/ordernow Production Costs Excel Spreadsheet Essay Assignment
Production Costs Excel Spreadsheet Essay Assignment