*** Problem Set Key — Do Not Post or Distribute ***
Chapter 12: Managing Production Across the Supply Chain
Introduction to Operations & Supply Chain Management (Bozarth & Handfield, 3rd Ed.)
DIRECTIONS To generate the key, input the same four-digit number used to generate the
original homework set. The correct answers will be calculated
automatically.
Name: *** Key ***
4-digit number: 7654
Northcutt puts together foot pedal assemblies using components they buy from outside
suppliers. Below is the bill of material (BOM) for the foot pedal assembly.
Some foot pedal assemblies are used in production, many are sold to other manufacturers,
and the rest are sold as replacements.
Foot pedal assembly
Problem 1 Complete the master production schedule for foot pedal assemblies, shown below.
On-hand inventory at end of December = 346 Foot pedal assemblies
Month / ******** January ********** ******** February **********
Week 1 2 3 4 5 6 7 8
Forecast Demand 3,460 3,460 3,460 3,460 3,806 3,806 4,152 4,152
Problem 2 Look at your answer to Problem 1.
Suppose a customer calls up & asks to place a new order for 2,700 assemblies
in Week 1. How many of these foot pedal assemblies can Northcutt promise?
Chapter 14: Managing Production Across the Supply Chain
*** Key ***
Problem 3 Complete the MRP for foot pedal assemblies, based on the above MPS quantities.
(I have already filled in the MPS due date information for Week 1; you can assume that all the
manufacturing steps have been completed for these 6920 pedals.
WEEK
1234567
*** Pedal Assemblies ***
LT (weeks) = 1 MPS Due Date 6920 03460 11070 0 0 8300
Start Assembly 6920 03460 11070 0 0 8300
Pedal Body Gross Reqmts. 0 3460 11070 0 0 8300 0
LT (weeks ) = 1 Sched. Receipts
Net Reqmts. 0 0 0 0 0 6847 0
Min. Order = 2000 Planned Receipts 0 0 0 0 0 6847 0
Planned Order 0 6847 0
Planned Order 0 30000 30000 0 0 30000 0
Acorn Nut Gross Reqmts. 3460 17990 22140 08300 16600 0
LT (weeks ) = 1 Sched. Receipts
Net Reqmts. 0 0 0 0 8300 0 0
Min. Order = 5000 Planned Receipts 0 0 0 0 8300 0 0
Planned Order 0 0 0 8300 0 0
Planned Order 0 0 0 5394 0 0
Pedal Bottom Gross Reqmts. 3460 11070 0 0 8300 0 0
LT (weeks ) = 2 Sched. Receipts
2