please find the estemated revnue and expenses for eaxh catagory and each year or thumbs down please do so for year 1-3 based on a-f

Item Year 0 Revenue $ Routine Revenue Lab Radiology OB-nursery Pharmacy Emergency service Medical and Surgical Operating Rooms Anesthesiology Respiratory Therapy Physical therapy Total Operating Revenue A A A A A A A A A A A A $ $ $ $ 9,850,000.00 7,375,000.00 5,825,000.00 450,000.00 3,175,000.00 2,200,000.00 5,050,000.00 5,250,000.00 1,600,000.00 900,000.00 1,475,000.00 43,150,000.00 $ $ Expenses Nursing Services Other professional services General services Support services Depreciation Amortization Interest Property, Plant and Equipment Provision for doubtful accounts Total Expenses $ $ $ $ $ $ $ $ $ $ 5,025,000.00 13,100,000.00 3,200,000.00 8,300,000.00 1,900,000.00 50,000.00 325,000.00 19,300,000.00 14,500,000.00 65,700,000.00 evenue and Gains in Excesses of Expenses and Loss $ (22,550,000.00) Finance Assignment 2 Name: Create a budget for the next fiscal year (see page 180). In doing your budget, make sure you review checklist 16-2 on page 186 for items to consider. 1.Items to be included in your budget: The items in the tables on pages 475, 476 477 (see excel spreadsheet attached to assignment). Your budget is for 3 years and must be adjusted for the following a. You hire a new surgeon that will begin doing elective surgeries in year 2. This increases your surgical volume by 10% from year 1 and another 15% in year 3. Surgery patients use operating rooms and anesthesiology services. Surgeon salary is $350,000 per year plus 25% for benefits. Support staff costs for the surgeon are $50,000 in Year 1. $55.000 in Year 2 and $60,000 in year 3. b. A nearby hospital closes their OB unit and you receive an influx of new patients in year 2. This increases your OB volume by 25% in Year 2 and 30% in Year 3, however, many are uninsured or not able to pay their bills. With this increase, you need to increase the staff costs by 20% per year to care for these patients. The average current revenue per delivery is $15,000. With the increase in uninsured patients, doubtful accounts need to increase by 10% to account for these losses. c. You lose half your physical therapists over a contract dispute midway through year 1 and don't get them to return by the end of year 3. One physical therapist creates $49.166.67 per year in revenue (total of 50 therapists) and costs $131,000 under other professional services. d. Covid testing is a new source of revenue for your lab and increases your revenue by 50% every year for the next 3 years. You also need to add $20,000 per year for staff to complete the tests (under professional revenue). e. You build a new Emergency Department, and your visits increase by 25% in year 3. ED patients flow into radiology services, and they also increase by 10%. The new building increases depreciation by $1,000,000 year. No increase in staffing costs in the ED or other services