the question is below and the template to be filled is attached.. for finance class

Question:(problem 8-30) Using the information from Problem 8- 29, assume that the nursing administrator expected 400 patients for flu shots and 1,600 for flu treatment. The medical group typically charges $ 50 for a flu shot and $ 80 for treating a flu patient. Actually, the group had 1,200 patients who received flu shots and 1,400 who had the flu and received treatment. On average, it was able to collect $ 55 per flu shot and $ 70 per flu patient. Compute the volume, mix, and price revenue variances. How did things turn out for the group considering just revenues? How did they turn out from a profit perspective?

1 PROBLEM 8-30 3 SOLUTION 5 (Revenue Variance Analysis) 7 Basic Data Actual 9 Flu Shot Volume 10 Treatment Volume 11 Total Volume 12 Flu Shot Price 13 Treatment Price 15 16 Original Budget: 17 Flex Budget 18 19 20 21 Budgeted Volumex Budgeted Mixx eted Mixx Budgeted Price Budgeted Price Actual Volumex Budgeted Mixx eted Mixx #DIV/0! #DIV/0! SO SO #DIV/0 ! #DIV/0 ! #DIV/0 ! SO SO 23 24 25 26 27 28 29 30 Flex Budget 31 VMA Budget 32 #DIV/0! #DIV/0! #DIV/0 ! #DIVO! #DIV/0! . -- Volume Variance #DIV/01 F Actual Volume Actual Volume x Budgeted Mix x Actual Mix x Budgeted Price x Budgeted Price #DIV/0! #DIV/0! SO SO #DIV/0 ! #DIV/0! #DIVO! 34 35 36 37 38 39 40 41 42 43 44 VMA Budget #DIV/0! #DIV/0! SO SO , #DIV/0! #DIVO! #DIVO! . -- Mix Variance #DIV/0! U Actual Volume x Actual Mix x Budgeted Price