Resource Planning: © 2007 Pearson Education
Resource Planning: © 2007 Pearson Education
Resource Planning: © 2007 Pearson Education
Chapter 15
Process Strategy Process Analysis Process Performance and Quality Constraint Management Process Layout Lean Systems
Supply Chain Strategy Location Inventory Management Forecasting Sales and Operations Planning Resource Planning Scheduling
ERP Design
ERP revolves around a single comprehensive database that can be made available across the entire organization (or enterprise). The database collects data and feeds them into the various modular applications (or suites).
As new information is entered as a transaction in one application, related information is automatically updated in the other applications. The ERP system streamlines the data flows throughout the organization and provides employees with direct access to a wealth of real-time operating information. ERP eliminates many of the cross-functional coordination problems older nonintegrated systems suffered from.
2007 Pearson Education
Dependent Demand
Dependent demand: The demand for an item that occurs because the quantity required varies with the production plans for other items held in the firms inventory. Parent: Any product that is manufactured from one or more components.
Component: An item that goes through one or more operations to be transformed into or become part of one or more parents.
Capacity is leveraged to
control bottlenecks and entire system flow Simpler product structures and more standardized products Assemble-to-order or maketo-stock strategy Relatively higher volumes, with flexible flows transitioning to line flows
MRP Inputs
Inventory transactions
Inventory records
MRP explosion
Bills of materials
Part commonality: The degree to which a component has more than one immediate parent.
2007 Pearson Education
Bill of Materials
Back slats
Seat cushion
Leg supports
Seat-frame boards
Back legs
Front legs
A Ladder-back chair
Bill of Materials
A Ladder-back chair
May 3 4 5 6 7 8
150
120 200 200 200
150
120 200
670
670
Forecast exceeds booked orders in week 2; projected onhand inventory balance = 17 + 0 30 = 13. The shortage signals a need to schedule an MPS quantity for completion in week 2.
2007 Pearson Education
Available-To-Promise Inventory
Available-to-promise (ATP) inventory: The quantity of end items that marketing can promise to deliver on specified dates.
It is the difference between the customer orders already booked and the quantity that operations is planning to produce.
As new customer orders are accepted, the ATP inventory is reduced to reflect the commitment of the firm to ship those quantities
Actual inventory stays unchanged until the order is removed from inventory and shipped to the customer.
MPS Worksheet
MPS
Schedule with
ATP
55
1 30
2 30
38
27
24
17
137
107
77
42
122
87
150
150
150
150
17
91
150
The total of customer orders booked until the next MPS receipt is 38 is 27 The total of customer orders booked until the next MPS receipt + units. 8 = ATP = 55 The ATP = 150 (MPS quantity) 59 24 + The 2007 Pearson Education 59 units. (on-hand) + 0 (MPS quantity) 38 = 17. = 91 units.
Inventory Record
Inventory record: A record that shows an items lot-size policy, lead time, and various time-phased data.
Gross requirements: The total demand derived from all parent production plans.
Scheduled Receipts (open orders) are orders that have been placed but not yet completed.
Projected on-hand inventory: An estimate of the amount of inventory available each week after gross requirements have been satisfied. Planned receipts: Orders that are not yet released to the shop or supplier. Planned order release: An indication of when an order for a specified quantity of an item is to be issued.
2007 Pearson Education
Inventory Record
Shows an items lot-size policy, lead time, and various time-phased data.
Lot Size: 230 units Item: C Description: Ladder-back Chair Seat subassembly Lead Time: 2 weeks
Week 1 Gross requirements Scheduled receipts Projected on-hand 37 inventory Planned receipts Planned order releases 230 150 230 117 2 0 0 3 0 0 4 120 0 5 0 0 227 6 150 0 7 120 0 187 8 0 0 187
117
117
227
230
77
230 230
Projected on-hand inventory: demandorders that of Scheduled Receipts The total An are when the amount a Gross requirements:(open orders)not yet released have been Planned order release: An that are estimate ofan from all parent Planned receipts: each week after gross requirementsfor shop Orders indication of derived order the to have inventory available placedsupplier. but plans. specified quantity of an item is to be issued. production not yet completed. or thesatisfied. been
Lot Size: 230 units Item: C Description: Ladder-back Chair Seat subassembly Lead Time: 2 weeks Week 1 Gross requirements Scheduled receipts Projected on-hand 37 inventory Planned receipts Planned order releases 230 2 3 4 5 6 7 8
150
230 117
0
0 117
0
0 117
120
0 227 230
0
0 227
150
0 77
120
0
0
0 187
187
230
230
The first a planned receipt in week 4, a shortage of 3 units will occur: 117 + 0 + 0 Without planned receipt lasts until week 7, when projected inventory would drop to 120+ 03 0 120 = 43the planned receipt bringsplanned receipt117 + 0the 77 = + units. Adding units. Adding the second the balance to brings + balance to = 227 units. Offsetting187 a 2-week lead time puts the corresponding 230 120 77 + 0 + 230 120 = for units. The corresponding planned order release is for week 5 (or week 7 minus 2 weeks). planned order release back to week 2.
2007 Pearson Education 2007 Pearson Education
Planning Factors
Planning lead time: An estimate of the time between placing an order for an item and receiving the item in inventory. Setup time Processing time Materials handling time between operations Waiting time Lot-sizing rules: A rule that determines the timing and size of order quantities. 2007 Pearson Education
230
37
117
153
120
120
Lot-for-Lot
Lot-for-lot (L4L) rule: A rule under which the lot size ordered covers the gross requirements of a single week. Thus P = 1, and the goal is to minimize inventory levels. The projected on-hand inventory combined with the new order will equal zero at the end of week t.
L4L lot size to arrive in week t
L4L Rule
1 Gross requirements Scheduled receipts Projected on-hand inventory Planned receipts Planned order releases 2007 Pearson Education 3 150 2 3 4
120
230
(120 + 0 + 0) - 117 = 3
117 117 0 0 0 0 0
37
117
150
120
150
120
FOQ generates high inventory because it creates remnants. POQ reduces on-hand inventory because it does a better job of matching order quantity to requirements. L4L minimizes inventory investment but maximizes the number of orders placed.
2007 Pearson Education
Safety Stock
The usual policy is to use safety stock for end items and purchased items to protect against fluctuating customer orders and unreliable suppliers of components but to avoid using it as much as possible for intermediate items. Schedule a planned receipt whenever the projected on-hand inventory balance drops below the desired safety stock level.
Ladder-back Chair Seat subassembly
MRP translates, or explodes, the MPS and other sources of demand into the requirements needed for all of the subassemblies, components, and raw materials the firm needs to produce parent items. This process generates the material requirements plan for each component item.
MRP explosion
Capacity reports Capacity requirements planning Finite capacity scheduling Input-output control
117
117
117
300
Seat Cushions Weeks Gross Reqirements Requirements Scheduled Receipts Projected on-hand Inv. = 0 Planned Receipts Planned order Releases 2007 Pearson Education 2007 Pearson Education 1 2 3 4 5
SEAT SUBASSEMBLY Reqirements Requirements Gross Requirements Scheduled Receipts Projected on-hand: 37 Planned Receipts Planned order Releases
117
117 230
117
227 230
227
117 units is insufficient to meet gross requirements of 120 for week 4, Frames Seat so a planned order release of 230 must be scheduled.
Weeks Gross Requirements Reqirements Scheduled Receipts Projected on-hand Inv. = 40 Planned Receipts Planned order Releases 1 2 3 4 5
300
Seat Cushions Weeks Gross Reqirements Requirements Scheduled Receipts Projected on-hand Inv. = 0 Planned Receipts Planned order Releases 2007 Pearson Education 2007 Pearson Education 1 2 3 4 5
SEAT SUBASSEMBLY Reqirements Gross Requirements Scheduled Receipts Projected on-hand: 37 Planned Receipts Planned order Releases
117
117 230
117
227 230
227 230
77
187 230
187
77 units is insufficient to meet gross requirements of 150 for week 6, Frames Seat so a planned order release of 230 must be scheduled.
Weeks Gross Requirements Reqirements Scheduled Receipts Projected on-hand Inv. = 40 Planned Receipts Planned order Releases 1 2 3 4 5
300
Seat Cushions Weeks Gross Reqirements Requirements Scheduled Receipts Projected on-hand Inv. = 0 Planned Receipts Planned order Releases 2007 Pearson Education 2007 Pearson Education 1 2 3 4 5
SEAT SUBASSEMBLY Reqirements Gross Requirements Scheduled Receipts Projected on-hand: 37 Planned Receipts Planned order Releases
117
117 230
117
227 230
227 230
77
187 230
187
Gross Reqirements Requirements Scheduled Receipts Projected on-hand Inv. = 40 Planned Receipts Planned order Releases
230 300
230
Seat Cushions Weeks Gross Requirements Reqirements Scheduled Receipts Projected on-hand Inv. = 0 Planned Receipts Planned order Releases 2007 Pearson Education 1 2 3 4 5
230
230
SEAT SUBASSEMBLY Gross Reqirements Requirements Scheduled Receipts Projected on-hand: 37 Planned Receipts Planned order Releases
117
117 230
117
227 230
227 230
77
187 230
187
Seat Frames Weeks Gross Reqirements Requirements Scheduled Receipts Projected on-hand Inv. = 40 Planned Receipts Planned order Releases 1 2 3 4 5
40
230
110 300
300 110on on-handin inventory untilpreviousproduction in week 4 and is 300 must carried from week 5 plan more is needed. 40 40 hand plus be scheduled tominus whento week one.110 Lot of carried is 300 in receipts start demand of 230 = LOT SIZE = L4L arrives as planned receipt in week 5.
Seat Cushions Weeks Gross Reqirements Requirements Scheduled Receipts Projected on-hand Inv. = 0 Planned Receipts Planned order Releases 2007 Pearson Education 2007 Pearson Education 1 2 3 4 5
230
230
117
117 230
117
227 230
227 230
77
187 230
187
Gross Reqirements Requirements Scheduled Receipts Projected on-hand Inv. = 40 Planned Receipts Planned order Releases
40
180 180
300
180 180
The 180 in inventory is 300 + 110 - 230 next gross On-Hand for week 5 carried until the = 180 requirements. Seat Cushions
Weeks Reqirements Gross Requirements Scheduled Receipts Projected on-hand Inv. = 0 Planned Receipts Planned order Releases 2007 Pearson Education 2007 Pearson Education 1 2 3 4 5
230
230
117
117 230
117
227 230
227 230
77
187 230
187
Seat Frames Weeks Reqirements Gross Requirements Scheduled Receipts Projected on-hand Inv. = 40 Planned Receipts Planned order Releases 1 2 3 4 5
40
180
300
180
180 180
Planned order releases are of 230 gross requirements. Two planned order releases sized tounits zero. Projected on-hand inventory remains at are scheduled.
Seat Cushions Weeks Reqirements Gross Requirements Scheduled Receipts Projected on-hand Inv. = 0 Planned Receipts Planned order Releases 2007 Pearson Education 2007 Pearson Education 1 2 3 4 5
230
230
0
230
0
230
0
230
0
230
LOT SIZE = 230 Units LEAD TIME = 2 Weeks 6 7 8 150 120 0 77 187 230 187
117 230
117
227 230
Seat Frames Weeks Reqirements Gross Requirements Scheduled Receipts Projected on-hand Inv. = 40 Planned Receipts Planned order Releases 1 2 230 300 110 3 4 5 230 180 300
40
110
110 300
180
180
180
Gross requirements for seat-frame boards will be 1200 units (or 4 x 300) in LOT SIZE = L4L week 3. Seat Cushions LEAD TIME = 1 week
Weeks Reqirements Gross Requirements Scheduled Receipts Projected on-hand Inv. = 0 Planned Receipts Planned order Releases 2007 Pearson Education 2007 Pearson Education 1 2 230 0 230 3 4 5 230 0 230 6 7 8
0 230
0 230
Inventory Data
Application 15.5
Item D
Application 15.5
Item B
Application 15.5
Item C
Application 15.5
Drum-Buffer-Rope System
Drum-Buffer-Rope (DBR): A planning and control system that regulates the flow of work-in-process materials at the bottleneck or the capacity constrained resource (CCR) in a productive system.
Drum-Buffer-Rope System with a Capacity Constrained Resource (CCR)
Level 1 Discharge
Level 5 Surgery Level 6 Preoperative care (Angiogram) Level 7 Preoperative care (Testing)
Nurse (6 hr)
MD (1 hr)
Therapy (1 hr)
Lab (3 tests)
Kitchen (1 meal)
Solved Problem 1
A LT = 1 B (3) LT = 2 D (1) LT = 3
LT = Lead time
2007 Pearson Education
If there is no existing inventory, how many units of items G, E, and D must be purchased to produce five units of end item A?
E (2) LT = 6
Solved Problem 3
The MPS for product A calls for the assembly department to begin final assembly according to the following schedule: 100 units in week 2; 200 units in week 4; 120 units in week 6; 180 units in week 7; and 60 units in week 8. Develop a material requirements plan for the next eight weeks for items B, C, and D.
ITEM C
L4L 2 weeks 200 (week 1) 0
A LT = 2 B (1) LT = 1
D
C (2) LT = 2 D (1) LT = 3
DATA CATEGORY Lot-sizing rule Lead time Scheduled receipts Beginning (on-hand) inventory
2007 Pearson Education
Solved Problem 3
Item: B Description: Week 1 Gross requirements Scheduled receipts Projected on-hand 20 inventory Planned receipts Planned order releases 280 20 200 280 360 200 0 0 240 360 60 0 0 0 2 100 3 4 200 5 6 120 7 180 8 60 9 10 Lot size: POQ (P = 3) Lead time: 1 week
Solved Problem 3
Item: C Description: Week 1 Gross requirements Scheduled receipts Projected on-hand 0 inventory Planned receipts 200 0 400 400 240 360 0 0 240 120 0 360 0 120 0 0 2 200 3 4 400 5 6 240 7 360 8 120 9 10 Lot size: L4L Lead time: 2 weeks
200
Solved Problem 3
Item: D Description: Week 1 Gross requirements Scheduled receipts Projected on-hand 425 inventory Planned receipts Planned order releases 500 500 425 25 25 285 500 425 500 305 305 305 360 305 2 400 3 4 240 5 360 6 120 7 8 9 10 Lot size: FOQ = 500 units Lead time: 3 weeks