Question: Need answers to blanks, thank you! Develop an EOQ solution and calculate total relevant costs for the data in the following table. Stockout costs equal

Need answers to blanks, thank you!
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. Period 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements 35 0 45 10 20 60 5 0 10 45 0 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: Lot Size: EOQ 8 9 10 1 4 7 11 12 5 6 20 35 0 45 10 60 5 0 10 45 0 40 Level: Item: Week No. Gross requirements Scheduled receipt Projected on-hand inventory Net requirements Planned order receipts 50 15 15 30 20 0 0 0 30 0 0 60Step 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
