A B C D E F H K M Least Total Cost 1 lead-time = 1 week 2 2 3 4 5 6 7 8 9 10 Gross requirements 80 110 80 20 140 60 80 40 0 40 4 Scheduled receipts Projected on hand 95 5 Net requirements 6 Tramvuruu 7 Tram amireu VICCI 8 0 0 0 0 0 total cost = 9 10 11 Holding cost = $1.50/week; Setup cost = $75; 12 Instructions: 131) Determine Net Requirements and fill in table above, then determine Planned Order Receipts based on Least Total Cost lot size strategy. - Use tab called "LTC-side" to determine how to group requirements - Copy "Net Requirements" calculated on this table into the "Net Requirements" column on the "LTC-side" tab 14 15 2) Fill in the table above (Projected on-hand, Planned Order Receipts, Planned Order Releases) using the lot size groups that you determine for the least Total 16 Cost lot size strategy. --> Note: Projected On-Hand = amount of material left in inventory at the end of the period. 17 18 193) Determine Total Cost for this lot size strategy and enter that in the Total Cost cell in L9. 20 21 23 24 A B C D E F H K M Least Total Cost 1 lead-time = 1 week 2 2 3 4 5 6 7 8 9 10 Gross requirements 80 110 80 20 140 60 80 40 0 40 4 Scheduled receipts Projected on hand 95 5 Net requirements 6 Tramvuruu 7 Tram amireu VICCI 8 0 0 0 0 0 total cost = 9 10 11 Holding cost = $1.50/week; Setup cost = $75; 12 Instructions: 131) Determine Net Requirements and fill in table above, then determine Planned Order Receipts based on Least Total Cost lot size strategy. - Use tab called "LTC-side" to determine how to group requirements - Copy "Net Requirements" calculated on this table into the "Net Requirements" column on the "LTC-side" tab 14 15 2) Fill in the table above (Projected on-hand, Planned Order Receipts, Planned Order Releases) using the lot size groups that you determine for the least Total 16 Cost lot size strategy. --> Note: Projected On-Hand = amount of material left in inventory at the end of the period. 17 18 193) Determine Total Cost for this lot size strategy and enter that in the Total Cost cell in L9. 20 21 23 24