Question: Need help with blanks please Develop an EOQ solution and calculate total relevant costs for the data in the following table. Stockout costs equal $10

Need help with blanks please
Develop an EOQ solution and calculate total relevant costs for the data in the following table. Stockout costs equal $10 per unit. Holding cost is $1.50/unit/week; setup cost is $120; lead time is 1 week; beginning inventory is 50 units. 1 2 3 4 5 6 7 8 9 10 11 12 Period Gross requirements 35 0 45 10 20 60 5 0 10 45 O 40 The economical order quantity (EOQ) is 60 units (round your response to the nearest whole number). Compute the projected on-hand inventory, the net requirement, and the planned receipt (enter your responses as whole numbers). Parent: Lead Time: 1 2 3 Quantity: Size: 8 9 4 5 6 7 10 11 12 1 35 O 45 10 20 60 5 0 10 45 0 40 Level: em: Week No. Gross requirements Scheduled receipt Projected on-hand inventory Net requirements Planned order receipts 50 15 15 30 20 0 55 55 45 0 0 0 0 30 0 0 60 5 0 0 0 0 40 0 60 0 0 60 60 0 0 0 0 60 Planned order releasesStep by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
