HCA 302: Assignment 3 Ch. 4 Cost Allocation Jagbud prif For Q1 and 2, use the excel spreadsheets to answer the questions below. Submit your excel spreadsheets with the answers. 19y69 You can also write your answers in excel spreadsheet (e.g., 1.4, 2.7) 19y69 16JOT mazudmis 1. Variance analysis: Consider the following budget data (in millions of dollars). You can find this table in the textbook (p. 181). 19/69 Simple Flexible Actual que Budget Budget Budget baxi Revenues 4.7 4.8 4.5 Costs 4.1 4.1 4.2 Profit 0.6 0.7 0.3 1.1. Calculate and interpret the two profit variances. Show your work. 1.2. Calculate and interpret the two revenue variances. Show your work. 1.3. Calculate and interpret the two cost variances. Show your work.to 1.4. How are the variance related? Explain. uneven stable t.s