Develop a EOQ solution and calculate total relevant costs for the gross requirements in the following table 1 2 3 4 5 6 8 9 10 11 12 Period Gross requirements 7 30 30 30 40 30 20 40 60 *Holding cost = $1.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). Develop a EOQ solution (enter your responses as whole numbers). Develop a EOQ solution (enter your responses as whole numbers). Period 1 2 3 4 5 6 7 8 9 10 11 12 30 30 40 30 30 20 40 60 40 Gross requirements Scheduled receipt Projected On-hand Net Requirements Planned Order receipt Planned Order release (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)