The bill of materials and the data from the inventory records for product A are shown in the figure to the right. Assume that the MPS start quantities for A are 70 units in weeks 1, 2, and 7. Derive an MRP plan for the components going into product A using the data in the table below. Data Category Lot-sizing rule Lead time Scheduled receipts Beginning inventory L4L 1 week None 155 Item: D Item D Fr L4L FOQ=200 2 weeks 2 weeks 70 (week 2) None 230 160 Complete the material requirements plan. (Enter your responses as integers. A response of "0" is equivalent to being not applicable.) Item: C Gross requirements Scheduled receipts Projected on-hand inventory 155 Planned receipts Planned order releases Item: E Gross requirements Scheduled receipts Projected on-hand inventory 230 Planned receipts Planned order releases 1 2 1 IN 0 ☐ 0 0 0 2 70 E 0 3 0 0 0 3 0 0 4 0 0 4 0 0 Lot Size: L4L Lead Time: 1 week Week 5 0 Week 0 6 0 Lot Size: L4L Lead Time: 2 weeks 5 0 6 Lot Size: FOQ=200 Lead Time: 2 weeks 7 0 0 7 0 8 0 0 0 8 0

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...
icon
Related questions
Question
The bill of materials and the data from the inventory records for product A are shown in the figure to the right. Assume that the MPS start quantities for A are 70 units in
weeks 1, 2, and 7. Derive an MRP plan for the components going into product A using the data in the table below.
Data Category
Lot-sizing rule
Lead time
Scheduled receipts
Beginning inventory
Item: C
L4L
1 week
None
155
Item: D
с
Gross requirements
Scheduled receipts
Projected on-hand inventory 155
Planned receipts
Planned order releases
Item: E
Complete the material requirements plan. (Enter your responses as integers. A response of "0" is equivalent to being not applicable.)
Gross requirements
Scheduled receipts
Projected on-hand inventory
Planned receipts
Planned order releases
L4L
2 weeks
70 (week 2)
230
Item
D
230
Gross requirements
Scheduled receipts
Projected on-hand inventory 160
Planned receipts
Planned order releases
1
П
1
E
FOQ = 200
2 weeks
1
None
160
2
0
N200
70
2
☐☐☐
3
☐☐☐
1
3
3
4
0
4
☐☐☐
4
Lot Size: L4L
Lead Time: 1 week
Week
Week
5
Lot Size: L4L
Lead Time: 2 weeks
Week
5
6
Lot Size: FOQ = 200
Lead Time: 2 weeks
5
6
6
7
1
7
7
8
8
8
D
E
A
D
E
E
Transcribed Image Text:The bill of materials and the data from the inventory records for product A are shown in the figure to the right. Assume that the MPS start quantities for A are 70 units in weeks 1, 2, and 7. Derive an MRP plan for the components going into product A using the data in the table below. Data Category Lot-sizing rule Lead time Scheduled receipts Beginning inventory Item: C L4L 1 week None 155 Item: D с Gross requirements Scheduled receipts Projected on-hand inventory 155 Planned receipts Planned order releases Item: E Complete the material requirements plan. (Enter your responses as integers. A response of "0" is equivalent to being not applicable.) Gross requirements Scheduled receipts Projected on-hand inventory Planned receipts Planned order releases L4L 2 weeks 70 (week 2) 230 Item D 230 Gross requirements Scheduled receipts Projected on-hand inventory 160 Planned receipts Planned order releases 1 П 1 E FOQ = 200 2 weeks 1 None 160 2 0 N200 70 2 ☐☐☐ 3 ☐☐☐ 1 3 3 4 0 4 ☐☐☐ 4 Lot Size: L4L Lead Time: 1 week Week Week 5 Lot Size: L4L Lead Time: 2 weeks Week 5 6 Lot Size: FOQ = 200 Lead Time: 2 weeks 5 6 6 7 1 7 7 8 8 8 D E A D E E
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 5 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
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…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.