Develop a EOQ solution and calculate total relevant costs for the gross requirements in the following table$*.$

$\backslash$table$[[$Period$,1,2,3,4,5,6,7,8,9,10,11,12],[$Gross requirements,$20,,30,,30,20,30,,20,20,,50]]$

$*$Holding cost $=$$$\frac{1\mathrm{.}50}{?}$ unit$/$week; setup cost $=$$$200$; lead time $=1$ week; beginning inventory $=40.$

What is the average demand per week? $($enter your responses with $2$ decimal places$)$:

Calculate Economic Order Quantity $($EOQ$)($enter your responses as whole numbers$).$

Develop a EOQ solution $($enter your responses as whole numbers$).$

$\backslash$table$[[$Period$,,1,2,3,4,5,6,7,8,9,10,11,12],[$Gross requirements,,$20,,30,,30,20,30,,20,20,,50],[$Scheduled receipt$],[$Projected On$-$hand,$40,,,,,,,,,,,,],[$Net Requirements$],[$Planned Order receipt$],[$Planned Order release,,,,,,,,,,,,,$]]$

Setup cost for $12$ weeks is $ $($enter your response as a whole number$).$

$.$ Carrying cost for $12$ weeks is

$($enter your response as a whole number$).$

The total cost is $

$($enter your response as a whole number$).$