Develop a EOQ solution and calculate total relevant costs for the gross requirements in the following table* 1 2 3 4 5 6 7 8 9 10 11 12 Period Gross requirements 20 40 40 20 20 10 40 60 *Holding cost = $1.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) Calculate the number of periods for POQ (enter your responses as whole numbers) Develop a POQ solution (enter your responses as whole numbers). 1 3 4 6 7 8 9 10 11 12 N 20 40 40 20 20 10 40 60 Period Gross requirements Scheduled receipt Projected On-hand Net Requirements Planned Order receipt Planned Order release 40 Planned Order red Planned Order rel (enter your respor Setup cost for 12 weeks is S Carrying cost for 12 weeks is $ (enter your response as a whole number). The total cost is $ (enter your response as a who Enter your answer in each of the answer boxes. Develop a EOQ solution and calculate total relevant costs for the gross requirements in the following table* 1 2 3 4 5 6 7 8 9 10 11 12 Period Gross requirements 20 40 40 20 20 10 40 60 *Holding cost = $1.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) Calculate the number of periods for POQ (enter your responses as whole numbers) Develop a POQ solution (enter your responses as whole numbers). 1 3 4 6 7 8 9 10 11 12 N 20 40 40 20 20 10 40 60 Period Gross requirements Scheduled receipt Projected On-hand Net Requirements Planned Order receipt Planned Order release 40 Planned Order red Planned Order rel (enter your respor Setup cost for 12 weeks is S Carrying cost for 12 weeks is $ (enter your response as a whole number). The total cost is $ (enter your response as a who Enter your answer in each of the answer boxes