$T{c}_c=2640(220)+480(100)+40(50)=$$$630,800$

$($d$)$ Identity the best of these three plans. Plan B would be the $h$

$2.$ Oru Openers orders batteries to

batteries per year at at an alteries from the Brandon Battery Company and uses $55,000$ openers that they produce apoximately

Order Quantity $11\mathrm{.}7999$ are indicated in the table below.

$\backslash$table$[[,,,]]$

Page $1$ of the Hand out gives Excel$-$output tays.

Delow. Be sure to label all answelloutpout for this problem. Use it to answer the questions

a$)$ Specify orru Openers' optimal batteny order quantity

$Q^{**}=8,000$ butteries $\frac{?}{\text{o}\text{r}\text{d}\text{e}\text{r}}$ quantity.

$owto$ calculer.

Show how to calculate Orry's optimal Annual Holding cost.

TaC$(Q)=c_h(\frac{Q}{2})+c_0(\frac{D}{Q})+D$

$2pts.$