EOQ Lead-time = 1 week 1 2 3 4 5 6 7 8 9 10 Gross requirements 90 30 150 70 90 50 10 50 90 50 Scheduled receipts Projected on hand 95 Net requirements Planned order receipts Planned order releases total cost = Holding cost = $2.50/week; Setup cost = $80; Instructions: 1) Calculate EOQ based on the following inputs, using formula shown at right: D = 68 units per week S = set-up cost = Q (show 2 decimal places) H = holding cost 2) Fill in the table above (Net Requirements, Projected on-hand, Planned Order Receipts) using your calculated EOQ as the Lot Size --> Note: Projected On-Hand = amount of material left in inventory at the end of the period. 3) Determine Total Cost for this lot size strategy and enter that in the Total Cost cell in L9