Develop a EOQ solution and calculate total relevant costs for the gross requirements in the following tatle" Period 1 2 3 4 5 6 7 8 10 11 12 Gross requirements 30 40 30 30 20 10 20 50 "Holding cost $2.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 (EG) enter your responses a whole numbers): Calculate the number of periods for POC (etter your responses as whole numbers) Develop a PO solution (ater your responses as whole numbers 1 2 4 8 10 11 3 40 7 30 20 12 50 30 30 10 20 40 Period Gross requirements Scheduled recept Projected On hand Not Requirements Planned Order recept Planned Order release Setup cost for 12 weeks in Stortor your response as a whole number) Carrying cost for 12 weeksi Center your response as a whole number The total cost is senter your response as a whole number). 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 3 5 6. 7 8 9 10 11 Period 2 4 12 Gross requirements 30 40 30 30 20 10 20 50 Holding cost $2.50unitWook 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 (EOQ) (enter your responses as whole numbers Calculate the number of periods for POQ (enter your responses as whole numbers): Develop a PO solution (enter your responses as whole numbers). 1 2 4 5 5 7 o 11 12 30 40 30 30 20 10 20 50 40 Period Gross requirements Scheduled receipt Projected On-hand Net Requirements Planned Order receipt Planned Order release Setup Cost for 12 weeks is SJ (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). Enter your answer in each of the answer boxes