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