Please use Excel and read specifications

Problem #1 15 Points Assume thatKeiser Healthcare has the following cost structure: Fixed Coats $625,000 Variable Cou per procedure $42.50 Average revenue [change] per procedure $130 Assume the group expects to perform 3,500 procedures during the al Construct the group's base cave projected PAL statement b] What is the group's contribution margin? cl What Is the breakeven point ? dJ How many procedures must the practice do to make a $55,000 profit? ") Now assume that the practice contracts with one HMO, and the plan proposes a 30%% discount from charges on 15% of its patients. Should the hospital accept the discount? YOU MUST SHOW PROFIT & LOSS STATEMENTS AND CONTRIBUTION MARGINS FOR BOTH SCENARIOSProblem #3 15 Points MPA Outpatient Surgery Center is developing an operating budget for the month ending April 2021. The Center expects to perform 80 surgical procedures during the month. the Sumptry Center's average charge (erico) per surgical procedure is $2.500. The cost of disposable surgical supplies is $300 per surgical procedure. MPA Outpotent Surgery Center o contracts with orthopedic surgeons at a fee of $1.500 per surgical procedure. The monthly salaries for the Center's receptionist, bookkeeper, and two surgical nurses total $10,800. The Center's occupancy costs, which include space rental, insurance, and all utilities, are $8,200 per month, Average monthly communication costs are $1,200. Office and operating room equipment was installed at a cost of $240.000. The equipment is expected to have a 5-year life and has no salvage value, so the monthly depreciation is $4,080 per month. Please prepare MPA Outpatient Surgery Center's Operating Budget for the month of April 2021 based on given budget Inputs (0.g. revenues Operating Budget - Month Ending April 30 2021 Budget Inputs Number of Surgeries Average Charge per Surgery 2.500 Surgical Supply Disposal 300 Surgeon's Fees 1 500 Receptionist & Nurses Salaries 10 500 Occupancy Costs 6.200 Monthly Communications Costs 1.200 Office & Operating Equipment $ 240 000 Useful Life In years 5 Useful Life In Monthy Monthly Depreciation\fProblem #2 (5 Points] Please fill in the highlighted cell (YOU MUST USE EXCEL FORMULAS TO RECEIVE CREDIT] 17/31/3019 Clinic C Aspets $10.000 00 542,000.00 585,375 00 Liabilities $4.200 00 $12.900.00 Equity $22.000.03 542.500.00 $65.000 00 Clinle C Clink D Aspets $22.500.00 $125,000.00 LLiblitici 54.200.00 $300 00 Equity 513 350 60 565 37500 During 2020 Clinic B Clinic C Clinkc D Total revenue 59.250.00 509.225 00 Toll openin 55 3060 537.000 06 Net IncomeB C E F H Problem #5 (5 Points] Assume you are the owner of your own HC clink. You purchased a fleet of warn for $12,750. You expect to use it for 5.5 years and well it at $3,500 (salvage value]. 1j What value would appear on BOTH the balance sheet and income statement at the end of 4 years, and under what names? 2) What amount would appear on BOTH the balance sheet and income statement at the end of 1 year, and under what names? 1) What voice would appear on BOTH the balance that and income statement at the end of 4 year, and ande what moment Amount Income Sheet 2) What amount would appear on BOTH the balance wheat and income statement at the and of 1 your, and under what ramest Balance Sheet Income Statement YOU MUST SHOW HOW YOU DERIVED YOUR ANSWER (DO NOT JUST PUT IN A NUMBER)