Variance Analysis Exercise.xlsx = fe Exercise B Exercise A Exercise B ExerciseC + Exercise B 2 HOSPITALITY HOSPITAL CATEGORY PLANNED ACTUAL 3 4 Patient Days 5 Pharmacy 6 Miscellaneous supplies 7 Fixed Overhead Costs 24000 30000 $100,000 $140,000 $56,000 $67,500 $708,000 $780,000 9 Instructions: 101. Determine the total variance between the planned and actual budgets. 11 2. Calculate the amount of unexplained variance and give a possible reason for 12 3. Prepare a flexible budget estimate for variable costs. Compare budget, flexibl 13 4. Determine what variance is due to change in volume and what variance is du 145. Determine the volume variance and rate variance based on per unit rates 15