Assessment2: Preparing and Managing and Operating Budget

Vila Health: Developing an Operating Budget Income Statement

FY 2017 YTD (Jul -

Dec) FY 2017 Budget

FY 2017 Variance YTD

Operating Revenue

Inpatient Revenue $345,040,349 $700,000,000 $(4,959,651)

Outpatient Revenue $232,498,397 $525,000,000 $(30,001,603)

Total Patient Services Revenue $577,538,746 $1,225,000,000 $(34,961,254)

Deductions From Revenue

Contractual Adjustments $476,543,215 $950,000,000 $1.543,215

Charity and Uncompensated Care $6,725,412 $14,000,000 $(274,588)

Total Deductions From Revenue $483,268,627 $964,000,000 $1,268,627

Net Patient Services Revenue $94,270,119 $261,000,000 $(36,229,881)

Other Operating Revenue

Other Operating Revenue $3,500,000 $10,000,000 $(1,500,000)

Total Operating Revenue $97,770,119 $271,000,000 $(37,729,881)

Operating Expenses

Salaries and Wages $42,932,230 $88,000,000 $(1,067,770)

Employee Benefits $12,624,012 $25,000,000 $124,012

Professional Fees $4,082,215 $9,000,000 $(417,785)

Supplies $23,883,407 $46,000,000 $883,407

Purchased Services - Utilities $1,632,191 $3,000,000 $132,191

Purchased Services - Other $11,536,320 $22,000,000 $536,320

Depreciation $8,455,254 $17,000,000 $(44,746)

Rentals and Leases $2,252,670 $4,000,000 $252,670

Insurance $2,715,378 $5,000,000 $215,378

License and Taxes $7,992,144 $18,000,000 $(1,007,856)

Interest $8,393,790 $18,000,000 $(606,210)

Provision for Bad Debts - - -

Other Direct Expenses $4,744,642 $8,000,000 $744,642

Total Operating Expenses $131,244,253 $263,000,000 $(255,747)

Net Operating Revenue $(33,474,134) $8,000,000 $(37,474,134)

Net Revenue Before Items Listed Below $(33,474,134) $8,000,000 $(37,474,134)

Extraordinary Item - - -

Net Revenue or (Expense) $(33,474,134) $8,000,000 $(37,474,134)

Med/Surg Department Budget

FY 2017 YTD (Jul - Dec) FY 2017 Budget FY 2017 Variance YTD

Operating Revenue

Inpatient Revenue $21,123,516 $50,000,000 $(3,876,484)

Total Patient Services Revenue $21,123,516 $50,000,000 $(3,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) $(1,310,049) $9,105,000 $(5,862,549)