Place your data in the green box below and show any supporting calculations in the space below the yellow box.
Budget is established as follows:				Qtrs.
Component		1	2	3	4	Total for year
Patient visits
Net patient service revenues							Net revenue per visit
Facility & labor costs
Variable costs
Total costs of all types
Net income budgeted for ER

The controller has asked you to build a quarterly budget for the coming fiscal year. She has provided you with the following information. In the yellow space below, please create a budget for the coming four quarters and a total for the fiscal year. Data provided is as follows: Qtr. Anticipated patient visits to the emergency room by quarter Visits 2300 2500 2700 3300 The average billed revenue per patient visit is estimated to be: 250.00 Uncollectable revenue rate is assumed to be: 28% Facility & labor costs to operate the emergency room facility: 180,000 Variable costs per patient visit: 60.00