Excel File Edit View Insert Format Tools Data Window Help .. . AutoSave O OFF ~ A 9 9 . G ... Hospital MRI - Machine Choice Data Case Part 3 Aut2022(2) Home Insert Draw Page Layout Formulas Data Review View Shape Format Tell me LE s Calibri 14 AA O V ab Wrap Text ~ General Insert v ZAY. O. Paste Delete I UV V MV Av = Merge & Center $ ~ % 9 108 98 Conditional Format Cell Formatting as Table Styles Format Filter Select TextBox 1 4 X fx MRI EQUIPMENT MODEL'S OPERATING COSTS CASE NOTES: This spreadsheet contains yearly operating fixed costs & per patient variable costs for three different models MANUFACTURER MODEL YEARLY FIXED VARIABLE PER COST PATIENT COST of MRI Scanning Machines as well as the number of patients from 2021. Due to the expected patient growth over the next 3 years, the hospital is planning to buy new equipment. General Electric Signa Pioneer MR 26,000.00 244.56 With new machines, MRI Scan times are faster & more accurate, therefore the Director feels she can replace the current 3 machines with 2 new machines & still improve their processing times. In order to choose the siemens Magnetom Lumina - 3.OT MRI 145,000.00 $ 87.12 correct machine, we need to know the 2022 patient forecast. However since we are buying TWO machines, only half the forecast is needed to determine which machine is the best choice based on the Break Even Philips MR5300 - Helium Free Model 300,000.00 24.12 Crossover points. YEAR Number of Patients y/2 - 2022 patient count Mathematical Calculations COMPLETE THE FOLLOWING ANALYSIS: .Mathematically calculate patient crossover points where the total costs are equal for: .Siemens vs. General Electric X=Number of Patient MRI's 2021 Historical Data 435 -Philips vs. Siemens 2022 Forecast GE vs. Siemens Detemine the number of patients expected for Year 2022 based on 12% growth. Calculate 1/2 the 2022 patient count since two machines will be used. + .Graph the cost curves for each of the three machines showing visually the crossover points graphically. 14 S Suggested Chart Format for graphing: Steps include: .Set up a range of patients from 0 to 2 12 of 2022 Forecast Siemens Fixed & Variable .HINT: Increase by increments of 250 patients. Patients GE Fixed & Variable Costs Costs Philips Fixed & Variable Costs Siemens vs. Philips Set up columns with formulas calculating the fixed & variable costs for each machine type based on the patient amount. .Highlight the data & choose a line graph. . Be sure to change the Chart Title to something meaningful & include a legend. .Indicate which machine brand should be purchased based on future patier future patient forecasts & costs. NOTE: Cells where formula calculations are required should not be typed in numbers. You do not have to use the format provided as long as the data guidelines are fulfilled! 35 Sheet1 + Ready x Accessibility: Investigate WA 000Excel File Edit View Insert Format Tools Data Window Help AutoSave OFF MAP? G ... Hospital MRI - Machine Choice Data Case Part 3 Aut2022(2) Home Insert Draw Page Layout Formulas Data Review View Shape Format ? Tell me Calibri 14 A A de Wrap Text General Paste B I U V | BF V MV AV E Merge & Center $ % 9 Conditional Form Formatting as Ta TextBox 1 X V fx B E F G H 1 MRI EQUIPMENT MODEL'S OPERATING COSTS W N CASE NOTES: This spreadshe MANUFACTURER MODEL YEARLY FIXED VARIABLE PER of MRI Scanni COST PATIENT COST Due to the ex 5 General Electric Signa Pioneer MR 26,000.00 244.56 With new ma the current 3 6 Siemens Magnetom Lumina - 3.0T MRI 145,000.00 87.12 correct machi only half the Philips MR529 - Helium Free Model 300,000.00 $ 24.12 Crossover poi 8 COMPLETE T YEAR Number of Patients Mathematical Calculations: 1/2 - 2022 patient count . Mathematic 9 . Siem X= Number of Patient MRI's . Phili 10 2021 Historical Data 4355 . Detemine 11 2022 Forecast GE vs. Siemens . Calculate 7/2 12 . Graph the 13 Steps include 14 Suggested Chart Format for graphing: . Set 15 Number of Siemens Fixed & Variable . Set 16 Patients GE Fixed & Variable Costs Costs Philips Fixed & Variable Costs Siemens vs. Philips the 17 . High 18 . Be 19 . Indicate v 20 21 NOTE: Cells 22 provided as I 23 24 25 26 Sheet1 + Ready x Accessibility: Investigate NOV citv 13View Insert Format Tools Data Window Help A FDC... Hospital MRI - Machine Choice Data Case Part 3 Aut2022(2) age Layout Formulas Data Review View Shape Format Tell me 14 AA ap Wrap Text General Merge & Center 1% 9 Conditional Form Formatting as Tab H R CASE NOTES: This spreadsheet contains yearly operating fixed costs & per patient variable costs for three different models E PER of MRI Scanning Machines as well as the number of patients from 2021. COST Due to the expected patient growth over the next 3 years, the hospital is planning to buy new equipment. 244.56 With new machines, MRI Scan times are faster & more accurate, therefore the Director feels she can replace the current 3 machines with 2 new machines & still improve their processing times. In order to choose the 87.12 correct machine, we need to know the 2022 patient forecast. However since we are buying TWO machines, only half the forecast is needed to determine which machine is the best choice based on the Break Even 24.12 Crossover points. COMPLETE THE FOLLOWING ANALYSIS: . Mathematically calculate patient crossover points where the total costs are equal for: .Siemens vs. General Electric . Philips vs. Siemens . Detemine the number of patients expected for Year 2022 based on 12% growth. . Calculate 1/2 the 2022 patient count since two machines will be used. .Graph the cost curves for each of the three machines showing visually the crossover points graphically. Steps include: .Set up a range of patients from 0 to 2 12 of 2022 Forecast . HINT: Increase by increments of 250 patients. .Set up columns with formulas calculating the fixed & variable costs for each machine type based on the patient amount. "Highlight the data & choose a line graph. . Be sure to change the Chart Title to something meaningful & include a legend. . Indicate which machine brand should be purchased based on future patient forecasts & costs. NOTE: Cells where formula calculations are required should not be typed in numbers. You do not have to use the format provided as long as the data guidelines are fulfilled! tv W NOV 12