A sports manufacturer produces skateboards and rollerblades. The same wheels are used for both products. For the next week, the master production schedule for skateboards shows a need for 147 units, while the master production schedule for rollerblades shows a need of 149 pairs. 4 wheels are required to manufacture a skateboard, and 8 wheels are required to manufacture one pair of rollerblades. What are the gross requirements for wheels to meet the requirements on the master production schedules for the next week?
A sports manufacturer produces skateboards and rollerblades. The same wheels are used for both products. For the next week, the master production schedule for skateboards shows a need for 147 units, while the master production schedule for rollerblades shows a need of 149 pairs. 4 wheels are required to manufacture a skateboard, and 8 wheels are required to manufacture one pair of rollerblades. What are the gross requirements for wheels to meet the requirements on the master production schedules for the next week?
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
Can you help me with these three review questions
A sports manufacturer produces skateboards and rollerblades. The same wheels are used for both products. For the next week, the master production
Transcribed Image Text:SAME PROBLEM & NUMBERS AS BEFORE-USE THE SAME MRP SCHEDULE
Night Shutter Inc. has to deliver an order of 250 wood shutters in week 6. Below is the product structure tree of the finished product. The lead times are as follows: 1 week for the shutters, 2 weeks for the frames, and 3 weeks for the wood sections. Night Shutter has 30 shutters on hand and has a scheduled receipt of 100 wood sections in week 2.
Here is the MRP table in Excel (note that you need to copy the numbers from the Master Schedule and MRP tables below)-->Wood shutters problem.xlsx
Here is the MRP table in MS Word (same as the Excel one above)-> MRP shutters, problem.docx
Frames (2)
Master
Schedule for:
What are the gross requirements for wood sections in week 5?
Shutters
Gross requirements
Scheduled receipts
On hand
Net requirements
Planned order receipts
Planned order releases
Week
Quantity
Frames
Gross requirements
Scheduled receipts
On hand
Net requirements
Planned order receipts.
Planned order releases
O 440
O 250
Wood sections
Gross requirements
Scheduled receipts
On hand.
Net requirements
Planned order receipts
Planned order releases
O 880
Ⓒ 500
Shutter
Beg.
Inv.
Beg.
Inv.
30
Wood sections (4)
Beg.
Inv.
1
1
1
Beg. 1
Inv.
2
2
2
2
100
3
3
3
3
4
Week
4
4
4
5
5
5
5
6
250
6
250
6
6
7
7
7
7
8
8
8
8
Transcribed Image Text:QUESTION 14
Night Shutter Inc. has to deliver an order of 250 wood shutters in week 6. Below is the product structure tree of the finished product. The lead times are as follows: 1 week for the shutters, 2 weeks for the frames, and 3 weeks for the wood sections. Night Shutter has 30 shutters on hand and has a scheduled receipt of 100 wood sections in week 2.
Here is the MRP table in Excel (note that you need to copy the numbers from the Master Schedule and MRP tables below)-->Wood shutters problem.xlsx
Here is the MRP table in MS Word (same as the Excel one above)--> MRP shutters problem.docx
Frames (2)
Master
Schedule for:
What are the gross requirements for frames and in which week do they occur?
Week
Shutters
Gross requirements
Scheduled receipts
On hand
Quantity
Net requirements
Planned order receipts
Planned order releases
Frames
Gross requirements
Scheduled receipts
On hand
Net requirements
Planned order receipts
Planned order releases
440 units in week 5
O 220 units in week 6
O 500 units in week 5
O 220 units in week 5
Shutter
Wood sections
Gross requirements
Scheduled receipts
On hand
Net requirements
Planned order receipts
Planned order releases
Beg.
Inv.
Beg.
Inv.
30
Beg.
Inv.
Wood sections (4)
Beg.
Inv.
1
1
1
1
2
2
2
2
100
3
3
3
فها
4
Week
4
4
4
5
5
5
5
6
250
6
250
6
6
7
7
7
7
8
8
8
8
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 3 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.