Please answer all questions

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