URGENT: Budget Analysis and memo

heh96
GuidelineforMedSurgExcel.xlsx

Sheet1

Medical - Surgical Budget
Med Surg 8 Month Budget FY 2019 - 2020 YTD (Jul - Feb)* FY 2019 - 2020 Budget FY 2019 - 2020 Variance TYD
OPERATING REVENUE:
Inpatient Revenue $ 23,123,516 $ 50,000,000 $ 1,876,484
TOTAL PATIENT SERVICES REVENUE $ 23,123,516 $ 50,000,000 $ 1,876,484
OPERATING EXPENSES
Salaries and Wages $ 12,157,632 $ 23,000,000 $ 657,632
Employee Benefits $ 3,040,408 $ 5,750,000 $ 165,408
Professional Fees $ 250,160 $ 400,000 $ 50,160
Supplies $ 5,883,497 $ 10,000,000 $ 883,497
Purchased Services - Utilities $ 27,456 $ 50,000 $ 2,456
Purchased Services - Other $ 23,484 $ 50,000 $ 1,516
Insurance $ 57,315 $ 105,000 $ 4,815
License and Taxes $ 21,456 $ 40,000 $ 1,456
Other Direct Expenses $ 972,157 $ 1,500,000 $ 222,157
TOTAL OPERATING EXPENSES $ 22,433,565 $ 40,895,000 $ 1,986,065
NET REVENUE OR (EXPENSE) $ 689,951 $ 9,105,000 $ 3,862,549
* Your budget may vary from the FY 2029-2020 budget given changes you are projecting based on the hospitals experience ov er the last 8 months
Med Surge 12 month Budget 2019-2020 FY 2019 - 2020 Year** FY 2019 - 2020 Budget FY 2019 - 2020 Variance TYD
OPERATING REVENUE:
Inpatient Revenue $ 50,000,000
TOTAL PATIENT SERVICES REVENUE $ 50,000,000
OPERATING EXPENSES
Salaries and Wages $ 23,000,000
Employee Benefits $ 5,750,000
Professional Fees $ 400,000
Supplies $ 10,000,000
Purchased Services - Utilities $ 50,000
Purchased Services - Other $ 50,000
Insurance $ 105,000
License and Taxes $ 40,000
Other Direct Expenses $ 1,500,000
TOTAL OPERATING EXPENSES $ - 0 $ 40,895,000
NET REVENUE OR (EXPENSE) $ 9,105,000
** Your budget may vary from the FY 2029-2020 budget given changes you are projecting based on the hopsitals experience over the last 12 months
Provide the rationale for your projections in the Memo
Med-Surg Budget Fiscal Year 2020-2021 FY 2020 - 2021 FY 2019 - 2020 Budget Variance (% increase or Decrease)***
OPERATING REVENUE:
Inpatient Revenue $ 46,247,032 $ 50,000,000
TOTAL PATIENT SERVICES REVENUE
OPERATING EXPENSES
Salaries and Wages $ 24,315,262 $ 23,000,000
Employee Benefits $ 6,080,816 $ 5,750,000
Professional Fees $ 500,320 $ 400,000
Supplies $ 11,766,994 $ 10,000,000
Purchased Services - Utilities $ 55,092 $ 50,000
Purchased Services - Other $ 46,968 $ 50,000
Insurance $ 114,630 $ 105,000
License and Taxes $ 42,912 $ 40,000
Other Direct Expenses $ 1,944,314 $ 1,500,000
TOTAL OPERATING EXPENSES $ 44,867,310 $ 40,895,000
NET REVENUE OR (EXPENSE) $ 50,000,000
*** For your project 2020-2021 budget highlight the percent changes from the previous FY, provide a rationale for your decisions in the Memo