Using excel, solve a$-$g please.:

$6-28$ Ross White $($see Problem $6-27)$ wants to reconsider

his decision of buying the brackets and is consider$-$

ing making the brackets in$-$house. He has determined

that setup cost would be $$25$ in machinist time and

lost production time and that $50$ brackets could be

produced in a day once the machine has been set up$.$

Ross estimates that the cost $($including labor time

and materials$)$ of producing one bracket would be

$$14\mathrm{.}80.$ The holding cost would be $10\%$ of this cost.

$($a$)$ What is the daily demand rate?

$($b$)$ What is the optimal production quantity?

$($c$)$ How long will it take to produce the optimal

quantity? How much inventory is sold during

this time?

$($d$)$ If Ross uses the optimal production quantity,

what would be the maximum inventory level?

What would be the average inventory level?

What is the annual holding cost?

$($e$)$ How many production runs would there be each

year? What would be the annual setup cost?

$($f$)$ Given the optimal production run size, what is

the total annual inventory cost?

$($g$)$ If the lead time is one$-$half day, what is the ROP?