$5$ Company ABC manufactures and sells various vehicle engines and parts.

One part the company regularly purchases is engine valve A$1100.$

Estimated Sales for this year:

$100$ units

Part $1$: Carrying Costs

Below are the estimated carrying costs for A$1100.$

$\backslash$table$[[$Valve A$1100,,],[$Annual unit cost of storage,$$,8\mathrm{.}50,*,|,-1||,],[$Insurance expense per unit,$$,2\mathrm{.}70,,],[$Interest expense per unit,$$,3\mathrm{.}50,,],[$Average theft cost per unit,$$,1\mathrm{.}00,$Also called inventory,gap$],[$Material handling expense,$$,1\mathrm{.}50,,3],[$Total Carrying Cost per Un$,$$$,17\mathrm{.}20,,]]$

Add up the total carrying cost per unit in the yellow cell above.

Complete the total carrying cost chart below by calculating the yellow cells at the various order size levels:

Create a graph of the carrying costs below $($use a X Y Scatter with Straight Lines & Markers$).$ Make sure to add axis titles: Cost to

$5$ Company ABC manufactures and sells various vehicle engines and parts.

One part the company regularly purchases is engine valve A$1100.$

Estimated Sales for this year:

$100$ units

Part $1$: Carrying Costs

Below are the estimated carrying costs for A$1100.$

$\backslash$table$[[$Valve A$1100,,],[$Annual unit cost of storage,$$,8\mathrm{.}50,*,|,-1|,],[$Insurance expense per unit,$$,2\mathrm{.}70,,],[$Interest expense per unit,$$,3\mathrm{.}50,,],[$Average theft cost per unit,$$,1\mathrm{.}00,$Also called inventory,gap$],[$Material handling expense,$$,1\mathrm{.}50,,3],[$Total Carrying Cost per Un$,$$$,17\mathrm{.}20,,]]$

Add up the total carrying cost per unit in the yellow cell above.

Complete the total carrying cost chart below by calculating the yellow cells at the various order size levels:

Create a graph of the carrying costs below $($use a X Y Scatter with Straight Lines & Markers$).$ Make sure to add axis titles: Cost to x$-$axis and Order Size $($in units$)$ to y$-$axis. x$-$axis and Order Size $($in units$)$ to y$-$axis.