EOQ Lead-time = 1 week 1 3 4 5 6 7 8 9 10 80 110 80 20 140 60 80 40 0 40 Gross requirements Scheduled receipts Projected on hand 95 Net requirements Planned order receipts Planned order releases total cost = Holding cost = $1.50/week; Setup cost = $75; Instructions: 1) Calculate EOQ based the following inputs, ing formula shown at righ D = 65 units per week Q* = 2DS = Q S = set-up cost 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. --> Note: Musil follow lead-time 3) Determine Total Cost for this lot size strategy and enter that in the Total Cost cell in L9