Health Care Finance -wk 8 assignment B please provide formulas to answers Exerci

Question

Health Care Finance -wk 8 assignment B please provide formulas to answers

Exercise B HOSPITALITY HOSPITAL CATEGORY PLANNED ACTUAL Patient Days 24000 30000 Pharmacy $   100,000 $   140,000 Miscellaneous supplies $     56,000 $     67,500 Fixed Overhead Costs $   708,000 $   780,000 Instructions: 1. Determine the total variance between the planned and actual budgets. 2. Calculate the amount of unexplained variance and give a possible reason for the change in fixed expense. 3. Prepare a flexible budget estimate for variable costs. Compare budget, flexible budget, and acutal (show related volume). 4. Determine what variance is due to change in volume and what variance is due to change in rates. 5. Determine the volume variance and rate variance based on per unit rates.

Explanation / Answer

Ans 1 Planned Actual Variance Patient Days 24000 30000 Pharmacy 100000 140000 40000 U Miscellaneous Supplies 56000 67500 11500 U Fixed overhead cost 708000 780000 72000 U ans 2 The unexplained variance is $72000 variance in fixed expenses. The possible reason for this variance is making wrong estimation of fixed expenses ans 3 Actual Spending Variance Flexible Activity varaince Planned Patient Days 30000 30000 24000 Pharmacy 140000 15000 U 125000 25000 U 100000 100000/24000*30000 Miscellaneous Supplies 67500 2500 F 70000 14000 U 56000 560000/24000*30000 Fixed overhead cost 780000 72000 U 708000 0 None 708000 Total 84500 U 39000 U ans 4 $84500 variance is due to change in rates $39000 U variance is due to change in volume ans 5 rate variance (84500/30000) 2.82 U per unit Volume variance (39000/6000) 6.5 U per unit

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.