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

$$

Period

$1$

$2$

$3$

$4$

$5$

$6$

$7$

$8$

$9$

$10$

$11$

$12$

Gross requirements

$*$Holding cost$$$$/$unit$/$week; setup cost$$$$$; lead time$1$week; beginning inventory$40.$

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

$$

enter your response here

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

$$

enter your response here

Calculate the number of periods for POQ $($enter your responses as whole numbers$)$:

$$

enter your response here

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

Period

$1$

$2$

$3$

$4$

$5$

$6$

$7$

$8$

$9$

$10$

$11$

$12$

Gross requirements

Scheduled receipt

Projected$$ On$-$hand

$40$

$$

enter your response here

$$

enter your response here

$$

enter your response here

$$

enter your response here

$$

enter your response here

$$

enter your response here

$$

enter your response here

$$

enter your response here

$$

enter your response here

$$

enter your response here

$$

enter your response here

$$

enter your response here

Net Requirements

$$

enter your response here

$$

enter your response here

$$

enter your response here

$$

enter your response here

$$

enter your response here

$$

enter your response here

$$

enter your response here

$$

enter your response here

$$

enter your response here

$$

enter your response here

$$

enter your response here

$$

enter your response here

Planned Order receipt

$$

enter your response here

$$

enter your response here

$$

enter your response here

$$

enter your response here

$$

enter your response here

$$

enter your response here

$$

enter your response here

$$

enter your response here

$$

enter your response here

$$

enter your response here

$$

enter your response here

Planned Order release

$$

enter your response here

$$

enter your response here

$$

enter your response here

$$

enter your response here

$$

enter your response here

$$

enter your response here

$$

enter your response here

$$

enter your response here

$$

enter your response here

$$

enter your response here

$$

enter your response here

Setup cost for $12$ weeks is $$$

$$

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

Carrying cost for $12$ weeks is

$$ $

$$

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

The total cost is $$$

$$

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