Practical Management Science
Practical Management Science
6th Edition
ISBN: 9781337406659
Author: WINSTON, Wayne L.
Publisher: Cengage,
Bartleby Related Questions Icon

Related questions

Question

need a excel formula

4. The Spencer Optics Company produces an inexpensive line of sunglasses. The manufacturing
process consists of assembling two plastic lenses (produced by the firm's plastic molding depart-
ment) 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 110 units, 80 units, 50 units, and 20 units in weeks 1, 2, 3, and 4, respectively.
The sunglasses are assembled in batches of 300 units. Presently, three such batches are sched-
uled: one in week 2, one in week 5, and one in week 8.
Complete the following time-phased record:
Classic Model
On
MPS Record
Forecast
Orders
Projected available
balance
Available-to-promise
MPS
Week
hand 12345678910
140
expand button
Transcribed Image Text:4. The Spencer Optics Company produces an inexpensive line of sunglasses. The manufacturing process consists of assembling two plastic lenses (produced by the firm's plastic molding depart- ment) 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 110 units, 80 units, 50 units, and 20 units in weeks 1, 2, 3, and 4, respectively. The sunglasses are assembled in batches of 300 units. Presently, three such batches are sched- uled: one in week 2, one in week 5, and one in week 8. Complete the following time-phased record: Classic Model On MPS Record Forecast Orders Projected available balance Available-to-promise MPS Week hand 12345678910 140
Expert Solution
Check Mark
Knowledge Booster
Background pattern image
Recommended textbooks for you
Text book image
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Text book image
Operations Management
Operations Management
ISBN:9781259667473
Author:William J Stevenson
Publisher:McGraw-Hill Education
Text book image
Operations and Supply Chain Management (Mcgraw-hi...
Operations Management
ISBN:9781259666100
Author:F. Robert Jacobs, Richard B Chase
Publisher:McGraw-Hill Education
Text book image
Business in Action
Operations Management
ISBN:9780135198100
Author:BOVEE
Publisher:PEARSON CO
Text book image
Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning
Text book image
Production and Operations Analysis, Seventh Editi...
Operations Management
ISBN:9781478623069
Author:Steven Nahmias, Tava Lennon Olsen
Publisher:Waveland Press, Inc.