assign7

profileelbrbo
week7assign.xlsx
Home>Business & Finance homework help>Management homework help>assign7

Week 7 Template

Revenues Expenses
Givens: Budgeted Actual
A Surgical volume
B Gift shop revenues Givens: Budgeted Actual
C Surgery revenues A Patient days
D Parking revenues B Pharmacy
Variance Fav or Unfav C Miscellaneous supplies
a. Total variance between the planned and actual budgets. D Fixed overhead costs
E Surgical volume [A] Variance Fav or Unfav
F Gift shop revenues [B] a. Total variance between the planned and actual budgets.
G Surgery revenues [C] E Patient days [A]
H Parking revenues [D] F Pharmacy [B]
I Total variance G Miscellaneous supplies [C]
H Fixed overhead costs [D]
b. Service-related revenues and variance still unexplained. I Total variance
J Total variance [I]
K Gift shop revenue variance [F] b. Service related costs and variance still unexplained.
L Parking revenue variance [H] J Total variance [I]
M Unexplained service-related variance [J-K-L] K Amt. explained by fixed overhead [F]
L Other fixed expenses
c. Flexible budget estimate. Budgeted Flexible Actual M Service-related variance [J-K-L]
N Surgical volume [A]
O Surgical revenue per unit [C / A] c. Flexible budget estimate. Budgeted Flexible Actual
P Surgical revenue [C] N Patient days [A]
O Cost per patient day (Pharm + Misc) [B+C]/[A]
d. Variances are due to volume and due to rate. Variance Fav or Unfav P Total cost (Pharm+Misc) [N x O]
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]