USA: +1 (725) 712-1730 
Sign in
A company produces an inexpensive line of sunglasses. The manufacturing process consists of assembling two plastic lenses (produced by the firm’s plastic molding department) into a finished frame (purchased from an outside supplier). The company is interested in using material requirements planning to schedule its operations and has asked you to prepare an example to illustrate the technique.
The firm’s sales manager has prepared a 10-week sales forecast for one of the more popular sunglasses (the Classic model) for your example. The forecast is 100 units per week. Spencer has customer orders of 118 units, 98 units, 68 units, and 38 units in weeks 1, 2, 3, and 4, respectively. The sunglasses are assembled in batches of 300 units. Presently, three such batches are scheduled: one in week 2, one in week 5, and one in week 8. Complete the following two time-phased record:
ATP – Discrete Logic
| Classic Model MPS Record | On Hand | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 |
| Forecast | |||||||||||
| Order | |||||||||||
| Projected Available Balance | 140 | ||||||||||
| Available to Promise | |||||||||||
| MPS |
MPS Lot Size = 300
ATP – Cumulative Logic
| Classic Model MPS Record | On Hand | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 |
| Forecast | |||||||||||
| Order | |||||||||||
| Projected Available Balance | 140 | ||||||||||
| Available to Promise | |||||||||||
| MPS |
MPS Lot Size = 300
Can you please provide answer with equation in order for me to understand ?
Expert Answer
ATP Discrete logic
ATP – Cumulative with look-ahead
