CASE NOTES:

This spreadsheet contains yearly operating fixed costs & per patient variable costs for three different MRI Scanning Machine models.$$ A Crossover Point Graph will help to visually determine the correct choice based on patient counts for $2025.$

Only half the $2025$ patient count needs to be considered as the hospital plans to purchase two machines.

Additionally the crossover points need to be calculated algebraically to detemine the exact break even point for each patient count. Using the exact crossover points comparison to $(1)/(2)$ the new $2025$ Patient Counts, determine which MRI machine is most cost effective.

COMPLETE THE FOLLOWING ANALYSIS:

$$ Determine total number of patients expected for Year $2025$ based on $12\%$ growth. $($Use your data from CASE PART ONE.$)$

$$Calculate $(1)/(2)$ the $2025$ patient count.$($Two machines will be used. Round to nearest whole number of patients.$)$

$$Graph the cost curves for each of the three machines showing visually the crossover points. Steps include:

$$Set up a range of patients from $0$ to $(1)/(2)$ of $2025$ Forecast

$$HINT: Increase by increments of $200$ patients up to $1200$ patients for the best graph!

$$Set up the rows with formulas calculating the fixed & variable costs totals for each machine type based on patient count starting at ZERO patients.

$$Highlight the data & create a line graph showing all three costs curves.

$$Be sure to change the Chart Title to something meaningful & include a legend.

Mathematically calculate patient crossover points where the total costs are equal.

NOTE: Type in the algebraic formulas & steps to determine the exact patient count at break even comparing two machines at a time.

$$Siemens vs$.$ General Electric

$$Philips vs$.$ Siemens

$$Lastly identify 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.