Question: - X Data Table Table 1. INVENTORY RECORD DATA B G Data Category Lot-sizing rule Lead time Safety stock Scheduled receipts Beginning inventory L4L 3

- X Data Table Table 1. INVENTORY RECORD DATA B G

- X Data Table Table 1. INVENTORY RECORD DATA B G Data Category Lot-sizing rule Lead time Safety stock Scheduled receipts Beginning inventory L4L 3 weeks 20 40 (week 2) 25 L4L 2 weeks 20 120 (week 2) 20 Item D E POQ (P = 2) L4L 3 weeks 6 weeks 0 0 200 None (week 6) 70 300 F L4L 1 week 0 70 (week 3) 0 FOQ = 320 3 weeks 0 None 0 Print Done Develop the material requirements plan for all components and intermediate items associated with product for the next 10 weeks. Refer to the figure on the right for the bill of materials and table 1 for component inventory record information. The MPS for product A calls for 40 units to be started in weeks 2, 6, 8 and 9. A Click the icon to view Table 1 B (3) C (1) D(1) E (2) F (2) D (1) G (2) Complete the material requirements plan (Enter your responses as integers. A response of '0" is equivain to being not applicable) Item: B Lot Size: L4L Lead Time: 2 weeks Safety Stock: 20 units Week 5 B 7 1 2 3 4 8 9 10 120 Gross requirements Scheduled receipts Projected on-hand Inventory Planned receipts Planned order releases 20 n Item: Lot Size: 14 Lead Time: 3 weeks Safety Stock: 20 units Week 5 5 6 7 1 2 3 4 8 9 10 40 Grass requirements Scheduled receipts Projected on-hand Inventory Planned receipts Planned order releases 25 Item: D Lot Size: POQ (P=2) Lead Time: 3 weeks Safety Stock: 0 units Week 5 6 7 1 2 3 4 8 9 10 0 Gross requirements Scheduled receipts Projected on-hand inventory Planned receipts Planned order releases 70 D Item: E Lot Size: L4L Lead Time: 8 weeks Safety Stock: 0 units Week 5 6 7 1 2 3 4 9 10 200 Gross requirements Scheduled receipts Projected on-hand inventory Planned receipts Planned order releases 300 Item: F Lot Size: L4L Lead Time: 1 week Safety Stock: 0 units Week 5 6 7 1 2 3 4 8 9 10 70 Gross requirements Scheduled receipts Projected on-hand inventory Planned receipts Planned order releases 0 0 . Item: Lot Size: FOQ = 320 Lead Time: 3 weeks Safety Stock: 0 units Week 5 6 7 1 2 3 4 8 9 10 o Grass requirements Scheduled receipts Projected on-hand inventory Planned receipts Planned order releases 000 - U 1 - X Data Table Table 1. INVENTORY RECORD DATA B G Data Category Lot-sizing rule Lead time Safety stock Scheduled receipts Beginning inventory L4L 3 weeks 20 40 (week 2) 25 L4L 2 weeks 20 120 (week 2) 20 Item D E POQ (P = 2) L4L 3 weeks 6 weeks 0 0 200 None (week 6) 70 300 F L4L 1 week 0 70 (week 3) 0 FOQ = 320 3 weeks 0 None 0 Print Done Develop the material requirements plan for all components and intermediate items associated with product for the next 10 weeks. Refer to the figure on the right for the bill of materials and table 1 for component inventory record information. The MPS for product A calls for 40 units to be started in weeks 2, 6, 8 and 9. A Click the icon to view Table 1 B (3) C (1) D(1) E (2) F (2) D (1) G (2) Complete the material requirements plan (Enter your responses as integers. A response of '0" is equivain to being not applicable) Item: B Lot Size: L4L Lead Time: 2 weeks Safety Stock: 20 units Week 5 B 7 1 2 3 4 8 9 10 120 Gross requirements Scheduled receipts Projected on-hand Inventory Planned receipts Planned order releases 20 n Item: Lot Size: 14 Lead Time: 3 weeks Safety Stock: 20 units Week 5 5 6 7 1 2 3 4 8 9 10 40 Grass requirements Scheduled receipts Projected on-hand Inventory Planned receipts Planned order releases 25 Item: D Lot Size: POQ (P=2) Lead Time: 3 weeks Safety Stock: 0 units Week 5 6 7 1 2 3 4 8 9 10 0 Gross requirements Scheduled receipts Projected on-hand inventory Planned receipts Planned order releases 70 D Item: E Lot Size: L4L Lead Time: 8 weeks Safety Stock: 0 units Week 5 6 7 1 2 3 4 9 10 200 Gross requirements Scheduled receipts Projected on-hand inventory Planned receipts Planned order releases 300 Item: F Lot Size: L4L Lead Time: 1 week Safety Stock: 0 units Week 5 6 7 1 2 3 4 8 9 10 70 Gross requirements Scheduled receipts Projected on-hand inventory Planned receipts Planned order releases 0 0 . Item: Lot Size: FOQ = 320 Lead Time: 3 weeks Safety Stock: 0 units Week 5 6 7 1 2 3 4 8 9 10 o Grass requirements Scheduled receipts Projected on-hand inventory Planned receipts Planned order releases 000 - U 1

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Question 4 The BOM for product A is shown in the figure below. The MPS for product A calls for 120 units to be started in weeks 2, 4, 5, and 8. Table 11.14 shows data from the inventory records. a....

The BOM for product A is shown in the figure below. The MPS for product A calls for 120 units to be started in weeks 2, 4, 5, and 8. Table 11.14 shows data from the inventory records. a. Develop the...

Develop MRP records for the items in Figure 7.17, Table 7.23, and Table 7.24. In figure 7.17 Forty units of D are required as spare parts in week 4, and 85 units of D are required in week 7. 8 0) C3)...

Question 2: The BOM for product A is shown in the below Figure. The MPS for product A calls for xl units to be started in weeks 2, 4, 5, and 8. The following table shows data from the inventory...

The BOM for product A is shown in Figure 13.22. The gross requirements for product A calls for 120 units to be available in weeks 2, 4, 5, and 8. Table 13.7 shows data from the inventory records. a....

The BOM for product A is shown in the below Figure. The MPS for product A calls for 115 units to be started in weeks 2, 4, 5, and 8. The following table shows data from the inventory records. Develop...

Solve using excel: The BOM for product A is shown in the below Figure. The MPS for product A calls for 115 units to be started in weeks 2, 4, 5, and 8. The following table shows data from the...

needing help QUESTION 4 Develop MRP records to ale needed for them in the following product structure for product Hining the information provided in the following tables and to complete proches one...

Order Quantity 500 Week desired 4 1 2 400 5 3 300 1 4 300 7 5. The BOM for product A and data from the inventory records are given below. The MPS start row in the master production schedule for...

please don't do it in excell Order Quantity 500 Week desired 4 1 2 400 5 3 300 1 4 300 7 5. The BOM for product A and data from the inventory records are given below. The MPS start row in the master...

In which of the four types of organizational culturesfamily, Eiffel Tower, guided missile, or incubatorwould most people in the United States feel comfortable? In which would most Japanese feel...

In teams of three or four, interview several local businesses. Ask them how they maintain a safe and healthful workplace.

Which statement about life insurance policy extended term nonforfeiture options is true? The amount of the term policy s death benefit will be the same as in the underlying permanent policy. The term...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...