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)

Question

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)

Accepted Answer

The Answer is in the image, click to view ...

Please use Excel and read specifications Problem #1 15 Points Assume thatKeiser Healthcare has the following cost

Question:

Managerial Economics and Business Strategy

Please use Excel and read specifications Problem #1 15 Points Assume thatKeiser Healthcare has the following cost

Question:

Expert Answer:

The Answer is in the image, click to view ... View the full answer

Managerial Economics and Business Strategy

Students also viewed these Accounting questions