5. Safe Rider also manufactures the plastic water bottles that fit into metal brackets on bicycles so that cyclists can easily reach the bottles for a drink without stopping their pedaling. The current on-hand balance, the gross requirements, and the scheduled receipts for one of the bottle parts are indicated in the inventory status record shown below. Complete the time-phased inventory record. Recall that this company uses lotfor-

lot ordering.

Transcribed Image Text:

Bottle part: LT = 3 weeks Gross requirements Scheduled receipts On hand Week 1 2 3 4 5 6 7 8 80 60 95 125 80 65 45 175 85 Net requirements Planned order releases