Would you be able to assist in creating a mock operating budget for a simulated hospital based on the minimal information in the scenario below? A table or spreadsheet is needed to reflect the information below for Fiscal year July 1, 2019 -July 1, 2020. Thank you.

Revenue and expenses through December of the current year 2019, assuming it is Dec as of now.

Estimates of the revenue and expenses for the rest of the current fiscal year through June 30, 2020.

Budget for the next fiscal year beginning July 1, 2020.

Fiscal Year July 1, 2019 - July 1, 2020

The hospital has to cut operating expenses by 5 percent for next fiscal year.

Overview of the budget and the year-to-date numbers showing why the above cuts need to be made:

In the previous year it was assumed the entire hospital would see $1.2 billion in total patient revenue. But for half the year, they only hit just over $607 million. By this point in the year, they should be over $612 million. In terms of patient revenue, there is now a deficit of nearly $5 million that wasn't expected. The problem is made worse it has been observed that other operating revenue is also under budget by $1.5 million.

It is believed that recent efforts in the billing department coupled with some of the solid work by the c-suite team on physician engagement and external marketing are going to have an impact on the revenue side. In addition, there are currently negotiations going on with a couple of primary commercial payers, but those negotiations remain uncertain. All things considered; the hope is for about a 5% bump on the revenue side for FY 19. The operating expenses are fairly close to target so far this year, but given the situation with uncertain revenue, additional cost savings opportunities will need to be found. One goal is to be reasonably conservative in case market conditions change or negotiations with the primary commercial payers don't go as expected.