The purpose of this assignment is to utilize Distribution Requirements Planning (DRP) parameters and inventory data to determine planned order releases in central warehouses. address each problem using full sentences and proper spelling and grammar and submit in an Excel template. 2. For the warehouse of Figure 14.8, suppose actual demands were 24, 16, and 18 in periods 1, 2, and 3, respectively. The initial DRP record is: Period 1 2 3 4 5 20 20 20 20 20 Forecast requirements In transit Projected available balance 6 266 Planned shipments 40 Q-40; lead time-1; 55-6. 40 266 26 40 a. Create the other three DRP records as done in Figure 14.8. What problem is created in period 2? What can be done? b. Does error addback work for this set of circumstances?
The purpose of this assignment is to utilize Distribution Requirements Planning (DRP) parameters and inventory data to determine planned order releases in central warehouses. address each problem using full sentences and proper spelling and grammar and submit in an Excel template. 2. For the warehouse of Figure 14.8, suppose actual demands were 24, 16, and 18 in periods 1, 2, and 3, respectively. The initial DRP record is: Period 1 2 3 4 5 20 20 20 20 20 Forecast requirements In transit Projected available balance 6 266 Planned shipments 40 Q-40; lead time-1; 55-6. 40 266 26 40 a. Create the other three DRP records as done in Figure 14.8. What problem is created in period 2? What can be done? b. Does error addback work for this set of circumstances?
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
100%
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!
Step 1: Examine - Given details:
VIEWStep 2: Examine - Calculation methods:
VIEWStep 3: Calculate -DRP - Following given details:
VIEWStep 4: Calculate -DRP - Following given details:
VIEWStep 5: Calculate -DRP - not follow given details:
VIEWStep 6: Calculate -DRP - not follow given details:
VIEWSolution
VIEWTrending now
This is a popular solution!
Step by step
Solved in 7 steps with 11 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