Reference no: EM131557330
You will submit both the excel spreadsheet and the 2- to 3-page paper as follows:
1. Using the provided Excel spreadsheet, calculate the variances for each line item under the tab labeled "Variances." A guideline for calculating the variances is located in the Weekly Resources.
2. Using the provided Excel spreadsheet, calculate the expense proportion of each line item under the tab labeled "Proportional Allocations."
3. After completing the spreadsheet, please address the following in a 2- to 3-page paper. The first paragraph should address the first two elements. The bulk of the paper should address the remaining elements.
4. Explain the concept of variance. Cite your sources.
5. Briefly describe the Northeast Health System from the information found in the annual report.
6. Summarize the key variances (positive or negative) you uncovered during your analysis (data only). Focus on the most significant variance items.
7. Summarize the key findings from your proportional allocation analysis. Focus on the most significant proportions.
8. What observations can you make about the Northeast Health System based on the variances and proportional allocations that you calculated?
9. What do you believe led to the variances you identified?
10. Since certain line items in a budget are more controllable than others, what actions might you recommend to the Northeast Health System to either decrease or increase their significant variances and proportional allocations?
APA format. Include References. Own Words. Separate Excel from essay.