Financial Analysis

QKhalid
BudgetRequest.xlsx

Sheet1

Budgeted Actual Variance
Revenues
Surgical volume $ 2,300.00 $ 2,600.00 $ 300.00
Gift shop $ 18,000.00 $ 19,000.00 $ 1,000.00
Surgery $ 589,500.00 $ 852,750.00 $ 263,250.00
Parking $ 17,000.00 $ 19,000.00 $ 2,000.00
Total $ 626,800.00 $ 893,350.00 $ 266,550.00
Expenses
Patient days $ 26,000.00 $ 25,000.00 $ 1,000.00
Pharmacy $ 119,000.00 $ 158,000.00 $ (39,000.00)
Misc. Supplies $ 68,000.00 $ 795,600.00 $ (727,600.00)
Fixed Overheads $ 832,000.00 $ 890,000.00 $ (58,000.00)
Total $ 1,045,000.00 $ 1,868,600.00 $ (823,600.00)