I need help with questions 8-29 and 8-30. using the templates.

otal varlance? 8-29. Assume that you are the nursing admin- istrator for a medical group that expects a severe outbreak of flu this winter. You hire additional staff to treat patients and administer shots. Your special project bud- get was for 1,000 hours of part-time nurses' services at $40 per hour, for a total cost of $40,000. It was expected that these nurses would treat 2,000 patients. After the flu season was over, it turned out that the total spent on part-time nurses was $50,000. The nurses worked 1,200 hours and 2,600 patients were treated. Calculate the vari- ances. Was the overall result favorable or unfavorable? Week 4 Problems-Compatibility Mode Excel File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do A2 EL 5 (Expense Variance Analysis Budgeted Volume x Budgeted Quantity x Budgeted Rate Actual Volume xBudgeted Quantity x Budgeted Rate 11 Flex Budget 22? 0.5 0.5 UE! U 17 There was a $12,000 Unfavorable variance due to the high er than expected mumber of patients 18 20 Flex Budget 21 VQA Budget Actual Volume x Budgeted Quantiby x Budgeted Rate Actual Volume x Actual Quantity Budgeted Rate S40 $40 Quantity Variance - '#VALUE! #VALUE! #VALUE! F ?29 2,600 2.600 - x -- x , 27 There was a favorable Quantity Variance of $4,000 because it took less labor per patient than expected. 28 This might not be good. It might mean that patients received a lower quality of care than expected 29 Favorable variances do not always mean that someting good has happened 8-26 8-27 8-28829-30G Type here to search licus. was the &Verall result favorable or unfavorable? 8-3o. 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 col- lect $55 per flu shot and $7o per flu patient. Compute the volume, mix, and price reve- nue variances. How did things turn out for the group considering just revenues? How did they turn out from a profit perspective? Week 4 Problems Compatibilty Mede File Home InsertPage Layout FormulasDats Review Visw Hslp PTell me what yau want to da F19 3 SOLUTION 5 (Rewsnue Variance Analys) 7 Basic Data Budgst 9 Flu Shot Volume 10 Treatment Voluma 11 Total Volume 12 Flu Shot Price 13 Treatment Price 16 Original Budget 7 Flex Budzet Budgeted Volume x Budgeted Wix Budgeted Price Actual Valume x Budgeted Mx x Badgeted Price 18 Drvo, DIvo so S0 DIV O 23 DIVIO! 6-26 | 8-27 | B.28 | 11-29 | O Type here to search