PT Cahaya Pintar Utama (PT. CPU) makes special lights that are popular in new homes. PT. CPU demand for two popular lights (VX-1234 and BX-1010) to be the following over the next 12 weeks, as listed in Table 2. Table 2. Demand data Week 1 2 3 4 5 6 7 8 9 10 11 12 VX-1234 82 94 78 96 105 90 86 75 88 98 110 100 BX-1010 250 280 301 312 290 300 275 286 310 334 350 318 A key component in both lights is a light socket that the bulb is screwed into in the base fixture. Each light has one of these sockets. Given the following information (Table 3). Table 3. Information VX-1234 BX-1010 Light Socket On Hand 185 425 620 Lot Size 325 600 500 (purchase quantity) Lead time (week) 1 1 3 Safety Stock 0 10 20 On Order 50 (week 5) 150 (week 4) - Questions: Develop and complete the material requirement planning to plan the production of the lights and purchases of the socket. Refer to Exhibit 21.12 on page 570. You need to make a total of 3 MRP 1 MRP table for VX-1234s. 1 MRP table for BX-1010s 1 MRP table for the light sockets required for VX-1234s and BX-1010s. Determine the planned order release for those 3 items
PT Cahaya Pintar Utama (PT. CPU) makes special lights that are popular in new homes. PT. CPU demand for two popular lights (VX-1234 and BX-1010) to be the following over the next 12 weeks, as listed in Table 2. Table 2. Demand data Week 1 2 3 4 5 6 7 8 9 10 11 12 VX-1234 82 94 78 96 105 90 86 75 88 98 110 100 BX-1010 250 280 301 312 290 300 275 286 310 334 350 318 A key component in both lights is a light socket that the bulb is screwed into in the base fixture. Each light has one of these sockets. Given the following information (Table 3). Table 3. Information VX-1234 BX-1010 Light Socket On Hand 185 425 620 Lot Size 325 600 500 (purchase quantity) Lead time (week) 1 1 3 Safety Stock 0 10 20 On Order 50 (week 5) 150 (week 4) - Questions: Develop and complete the material requirement planning to plan the production of the lights and purchases of the socket. Refer to Exhibit 21.12 on page 570. You need to make a total of 3 MRP 1 MRP table for VX-1234s. 1 MRP table for BX-1010s 1 MRP table for the light sockets required for VX-1234s and BX-1010s. Determine the planned order release for those 3 items
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
PT Cahaya Pintar Utama (PT. CPU) makes special lights that are popular in new homes. PT. CPU demand for two popular lights (VX-1234 and BX-1010) to be the following over the next 12 weeks, as listed in Table 2.
Table 2. Demand data
|
|
Week |
|||||||||||
|
|
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
11 |
12 |
|
VX-1234 |
82 |
94 |
78 |
96 |
105 |
90 |
86 |
75 |
88 |
98 |
110 |
100 |
|
BX-1010 |
250 |
280 |
301 |
312 |
290 |
300 |
275 |
286 |
310 |
334 |
350 |
318 |
A key component in both lights is a light socket that the bulb is screwed into in the base fixture. Each light has one of these sockets. Given the following information (Table 3).
Table 3. Information
|
|
VX-1234 |
BX-1010 |
Light Socket |
|
On Hand |
185 |
425 |
620 |
|
Lot Size |
325 |
600 |
500 (purchase quantity) |
|
Lead time (week) |
1 |
1 |
3 |
|
Safety Stock |
0 |
10 |
20 |
|
On Order |
50 (week 5) |
150 (week 4) |
- |
Questions:
- Develop and complete the material requirement planning to plan the production of the lights and purchases of the socket. Refer to Exhibit 21.12 on page 570. You need to make a total of 3 MRP
- 1 MRP table for VX-1234s.
- 1 MRP table for BX-1010s
- 1 MRP table for the light sockets required for VX-1234s and BX-1010s.
Determine the planned order release for those 3 items
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 8 steps with 5 images
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.