Determine the total variance between the planned and actual budgets for Surgical Volume. Is the variance favorable or unfavorable?

-See the attached files:
-Determine the total variance between the planned and actual budgets for Surgical Volume. Is the variance favorable or unfavorable?
-Determine the total variance between the planned and actual budgets for Patient Days. Is the variance favorable or unfavorable?
-Determine the service-related variance for Surgical Volume.
-Determine the service-related variance for Patient Days.
-Prepare a flexible budget estimate. Present a side-by-side budget, flexible budget estimate, and the actual Surgical Revenues.
-Prepare a flexible budget estimate. Present a side-by-side budget, flexible budget estimate, and the actual Patient Expenses.
-Determine what variances are due to change in volume and what variances are due to change in rates.

 ATTACHMENT PREVIEW Download attachment

RevenuesGivens:BudgetedActual[A]Surgical volume[B]Gif shop revenues[C]Surgery revenues[D]Parking revenuesBudgetedActualVariance[E]Surgical volume [A][F]Gif shop revenues [B][G]Surgery revenues [C][H]Parking revenues [D][I]Total variance [E]Variance[J]Total variance [I][K]Gif shop revenue variance [F][L]Parking revenue variance [H][M]Service-related variance [J-K-L]BudgetedFlexibleActual[N]Surgical volume [A][O]Surgical revenue per unit [C / A][P]Surgical revenue [C]7. Determine what variances are due to change in volume and what variances are due to change in ratBudgetedFlexibleActual[Q]Budgeted surgical revenue [P][R]Flexible surgical revenue [P][S]Actual surgical revenue [P][T]Volume variance [R – Q][U]Rate variance [S – R]1. Determine the total variance between the planned and actual budgets ±orSurgical Volume.Is the v±avorable or un±avorable?3. Determine the service related variance ±orSurgical Volume.5. Prepare a ²exible budget es³mate. Present side-by-side budget, ²exible budget es³mate, and the asurgical revenues.

View the Answer

ExpensesGivens:BudgetedActual[A]PaTent days[B]Pharmacy[C]Miscellaneous supplies[D]Fixed overhead costs[E]PatenT days [A][F]Pharmacy [B][G]Miscellaneous supplies [C][H]Fixed overhead cosTs [D][I]±oTal variance[J]±oTal variance [I][K]AmT. explained by fxed overhead [F][L]OTher fxed expenses[M]Service-relaTed variance [J-K-L]BudgetedFlexible[N]PatenT days [A][O]CosT per patenT day (Pharm + Misc) [B+C]/[A][P]±oTal cosT (Pharm+Misc) [N x O]Tes.Variancevariance2. DeTermine The ToTal variance beTween The planned and acTual budgeTs ²orPaTent Days. Is Thun²avorable?4. DeTermine The service relaTed variance ²orPaTent Days.acTual6. Prepare a ³exible budgeT estmaTe. PresenT side-by-side budgeT, ³exible budgeT estmaTe, andexpenses.

Show 

Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"