Question #9 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. 1 Anticipated patient visits to the emergency room by quarter Visits 2300 2700 2800 3200 11000 4 Total for year The average billed revenue per patient visit is estimated to be: 315.00 Uncollectable revenue rate is assumed to be: 23% Fixed facility & labor costs to operate the emergency room facility: $ 185,000 per quarter Variable costs per patient visit: $ 66.00 Build your budget in the boxes provided below. You may use the space below the boxes for any supporting calculations you may want to provide Budget is established as follows: Qtrs. Component 4 Total for year Patient visits Billed rate per patient visit Total Billings Less: Uncollectable/bad debt Net patient service revenues Facility & labor costs Variable costs Total costs of all types Net income budgeted for ER