Problem $2$

Barbara Bright is the purchasing agent for West Valve Company. West Valve sells industrial valves and fluid control devices. One of the most popular valves is the Western, which has an annual demand of $"\backslash (\backslash$mathbf$\{10\backslash \%\}\backslash )$ of your ID units". The cost of each valve is $\backslash (\backslash$$ $90\backslash ),$ and the inventory carrying cost is estimated to be $\backslash (20\backslash \%\backslash )$ of the cost of each valve. Barbara has made a study of the costs involved in placing an order for any of the valves that West Valve stocks, and she has concluded that the average ordering cost is $\backslash (\backslash$$ $25\backslash )$ per order. Furthermore, it takes about two weeks for an order to arrive from the supplier, and during this time, the demand per week for West valves is approximately $80.$

Use excel OM$/$QM: $($show the results$)$

$($a$)$ What is the EOQ?

$($b$)$ What is the ROP?

$($c$)$ Is the ROP greater than the EOQ? If so$,$ how is this situation handled?

$($d$)$ What is the average inventory? What is the annual holding cost?

$($e$)$ How many orders per year would be placed? What is the annual ordering cost?

$($f$)$ What is the total inventory cost?