Develop a EOQ solution and calculate total relevant costs for the gross requirements in the following table 4 6 B Period 1 2 3 5 7 9 10 11 12 Gross requirements 20 40 40 20 20 20 20 50 "Holding cost $1.50/unit/week, setup cost = $150 load time 1 week, beginning inventory 40 What is the average demand per week? (enter your responses with 2 decimal places): Calculate Economic Order Quantity (E0Q) (enter your responses as whole numbers) Calculate the number of periods for POQ (enter your responses as whole numbers) primers Develop a P Q solution (enter your responses as whole numbers) 1 2 3 4 5 G 7 8 9 10 11 12 20 20 50 20 40 40 20 20 Period Gross requirements Scheduled receipt Projected On-hand Net Requirements Planned Order receipt Planned Order release 40 Setup cost for 12 weeks is s (enter your response as a whole number) 40 20 40 20 20 50 20 20 40 Gross requirements Scheduled receipt Projected On hand Net Requirements Planned Order receipt Planned Order release 11 Setup cost for 12 weeks is $ (enter your response as a whole number) Carrying cost for 12 weeks is senter 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 4 6 B Period 1 2 3 5 7 9 10 11 12 Gross requirements 20 40 40 20 20 20 20 50 "Holding cost $1.50/unit/week, setup cost = $150 load time 1 week, beginning inventory 40 What is the average demand per week? (enter your responses with 2 decimal places): Calculate Economic Order Quantity (E0Q) (enter your responses as whole numbers) Calculate the number of periods for POQ (enter your responses as whole numbers) primers Develop a P Q solution (enter your responses as whole numbers) 1 2 3 4 5 G 7 8 9 10 11 12 20 20 50 20 40 40 20 20 Period Gross requirements Scheduled receipt Projected On-hand Net Requirements Planned Order receipt Planned Order release 40 Setup cost for 12 weeks is s (enter your response as a whole number) 40 20 40 20 20 50 20 20 40 Gross requirements Scheduled receipt Projected On hand Net Requirements Planned Order receipt Planned Order release 11 Setup cost for 12 weeks is $ (enter your response as a whole number) Carrying cost for 12 weeks is senter your response as a whole number). The total cost is $(enter your response as a whole number)