Variance Analysis Exercise.xlsx = fe Exercise A Exercise A Exercise B Exercise C CATEGORY PLANNED ACTUAL 4 Surgical Volume 1400 $15,000 500,500$750,750 $17,000 1200 5 Durable Medical Equipment Revenu $12,000 6 Surgery Revenue 7 Parking Revenue $15,000 9 Instructions: 101. Determine the total variance between the planned and actual budgets. 11 2. Determine the service-related revenues and calculate variance still unexplain 12 3. Prepare a flexible budget estimate. Present side-by side the budget, flexible 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