Semans is a manufacturer that produces bracket assemblies. Demand for bracket assemblies (X) is 137 units. The following is the BoM in indented form: ITEM DESCRIPTION USAGE X Bracket assembly 1 A Wall board 5 B Hanger subassembly 2 D Hanger casting 2 E Ceramic knob 1 C Rivet head screw 4 F Metal tong 3 G Plastic cap 1 Below is a table indicating current inventory levels: Item X A B C D E F G Inventory 30 20 73 22 200 149 1,000 90 b. What are the net requirements of each item in the MPS? (Leave no cells blank - be certain to enter "0" wherever required.)
Semans is a manufacturer that produces bracket assemblies. Demand for bracket assemblies (X) is 137 units. The following is the BoM in indented form: ITEM DESCRIPTION USAGE X Bracket assembly 1 A Wall board 5 B Hanger subassembly 2 D Hanger casting 2 E Ceramic knob 1 C Rivet head screw 4 F Metal tong 3 G Plastic cap 1 Below is a table indicating current inventory levels: Item X A B C D E F G Inventory 30 20 73 22 200 149 1,000 90 b. What are the net requirements of each item in the MPS? (Leave no cells blank - be certain to enter "0" wherever required.)
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
Related questions
Question
Problem 21-9 (Algo)
Semans is a manufacturer that produces bracket assemblies. Demand for bracket assemblies (X) is 137 units. The following is the BoM in indented form:
| ITEM | DESCRIPTION | USAGE |
| X | Bracket assembly | 1 |
| A | Wall board | 5 |
| B | Hanger subassembly | 2 |
| D | Hanger casting | 2 |
| E | Ceramic knob | 1 |
| C | Rivet head screw | 4 |
| F | Metal tong | 3 |
| G | Plastic cap | 1 |
Below is a table indicating current inventory levels:
| Item | X | A | B | C | D | E | F | G |
| Inventory | 30 | 20 | 73 | 22 | 200 | 149 | 1,000 | 90 |
b. What are the net requirements of each item in the MPS? (Leave no cells blank - be certain to enter "0" wherever required.)
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
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
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.