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

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 releases

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!