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
Purchasing and Supply Chain Management
6th Edition
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
ChapterC: Cases
Section: Chapter Questions
Problem 5.1SC: Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing...
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
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
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