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,,40,,30,20,30,,10,20,,60]]$

"Holding cost $=$$$\frac{1\mathrm{.}50}{?}$ unit$/$week; setup cost $=$$$150$; 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,,40,,30,20,30,,10,20,,60],[$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$).$