WGU C984 A3 – Pro Forma Operating Budget Worksheet | Verified 2026/2027 Submission

WGU C984
Pro Forma Operating Budget

Worksheet (Assignment 3)
Verified Submission

, INCOME STATEMENT
FOR ALL SERVICE LINES OPERATIONS


Budget Actual $ Variance
Operating Revenue
Inpatient Charges $47,500,000 $45,000,000 ($2,500,000)
Outpatient Charges $35,000,000 $40,500,000 $5,500,000
Total Charges $82,500,000 $85,500,000 $3,000,000

Deductions from Charges
Discounts and Allowances ($33,000,000) ($34,200,000) ($1,200,000)
Charity Care ($6,187,500) ($6,412,500) ($225,000)
Total Deductions ($39,187,500) ($40,612,500) ($1,425,000)

Net Patient Revenue $43,312,500 $44,887,500 $1,575,000
Other Operating Revenues $2,500,000 $2,350,000 ($150,000)

Total Operating Revenues $45,812,500 $47,237,500 $1,425,000



Salaries $25,000,000 $25,050,000 ($50,000)
Benefits $6,250,000 $6,262,500 ($12,500)
Insurance $550,000 $550,000 $0
Supplies $4,125,000 $4,275,000 ($150,000)
Purchased Services $3,500,000 $3,750,000 ($250,000)
Utilities $125,000 $135,000 ($10,000)
Rent $35,000 $35,000 $0
Repairs and Maintenance $25,000 $35,000 ($10,000)
Interest $180,000 $200,000 ($20,000)
Other $175,000 $155,000 $20,000
Bad Debt $4,125,000 $4,275,000 ($150,000)
Total Operating Expenses $44,090,000 $44,722,500 ($632,500)

Operating Income $1,722,500 $2,515,000 $792,500

Nonoperating Items
Investment Income $825,875 $991,050 $165,175
Donations and Fund Raising $175,000 $155,000 ($20,000)
Total Nonoperating Gain (loss) $1,000,875 $1,146,050 $145,175

Operating Income Before Noncash Items $2,723,375 $3,661,050 $937,675

Noncash Items