thank you, i will like

Develop a EOQ solution and calculate total relevant costs for the gross requirements in the following table". 8 9 7 10 12 6 11 1 2 3 4 5 Period Gross requirements 20 20 20 40 60 40 30 40 "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) 22.50 Calculate Economic Order Quantity (EOQ) (enter your responses as whole numbers): 67 Calculate the number of periods for POQ (enter your responses as whole numbers) 9 6 7 8 9 10 11 12 Son 40 IS 20 20 20 40 60 20 o 40 00 0 10 60 DOO 10 60 20 0 40 10 40 40 00 0 60 0 10 Period 1 2 3 4 Gross requirements 30 40 Scheduled receipt Projected On-hand 40 10 10 40 40 Net Requirements 00700 Planned Order receipt 0 70 10 Planned Order release 070 1 Setup cost for 12 weeks is $600 (enter your response as a whole number) Carrying cost for 12 weeks is $ 270 (enter your response as a whole number). 60 60 0 0 60