MRP problem

profileOssain
BA314Assignment2W18.xlsx
Home>Business & Finance homework help>Operations Management homework help>MRP problem

MPS -Approved

BA 314 Assignment 2 - Worksheet 1: MPS Approved plan
Item: A Clodhopper (Winter2018) Lot Size Rule:
Lead Time:
Safety Stock Level:
Current Inventory:
Jan 2018 Feb 2018 Mar 2018
Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 Week 10 Week 11 Week 12
Forecast 450 450 450 450 600 600 600 600 2400 2500 2600 2700
Customer Orders Booked 150 350 500 600 0 200 1000 0 0 2200 2000 0
Projected On-Hand Inventory
MPS Scheduled Receipts
MPS Quantity
MPS Start
Available to Promise
Item: B Clodbuster (Winter2018) Lot Size Rule:
Lead Time:
Safety Stock Level:
Current Inventory:
Jan 2018 Feb 2018 Mar 2018
Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 Week 10 Week 11 Week 12
Forecast 300 300 300 300 400 400 400 400 1000 1100 1100 1200
Customer Orders Booked 200 0 450 0 50 900 0 0 500 0 0 0
Projected On-Hand Inventory
MPS Scheduled Receipts
MPS Quantity
MPS Start
Available to Promise

BOMs

BA 314 Assignment 2 - Worksheet 2: Bill of Materials Data
ClodHopper BOM (Product A)
Name Quantity Assembly Time Lead Time
A ClodHopper 1 1 week
C Handle Bar Assembly 1 2 weeks
D Steel Tubing 1" dia 10 feet 3 weeks
E Control cable 8 feet 2 weeks
F Control lever assembly 1 1 week
G Grips 2 1 week
H Powerhead assembly 1 1 week
I Gearbox assembly 1 1 week
J Engine (Standard) 1 2 weeks
K Tiller blade unit 1 1 week
M Instruction Manual 1 4 weeks
ClodBuster BOM (Product B)
Name Quantity Assembly Time Lead Time
B ClodBuster 1 1 week
C Handle Bar Assembly 1 2 weeks
D Steel Tubing 1" dia 10 feet 3 weeks
E Control cable 8 feet 2 weeks
F Control lever assembly 1 1 week
G Grips 2 1 week
P HD Powerhead assembly 1 1 week
I Gearbox assembly 1 1 week
L Engine (Heavy Duty) 1 3 weeks
N HD Tiller Unit 1 2 weeks
M Instruction Manual 1 4 weeks

Inventory Records

BA 314 Assignment 2 - Worksheet 3: Inventory Records and Lot-Sizing Rules
Record Date: 31-Dec-17
Item Name Current Inventory On-Hand Lot-Size Rule Lot Size Lead or Assembly Time Desired Safety Stock Level Units
A ClodHopper 5500 FOQ 2500 1 week 1500
B ClodBuster 4000 FOQ 1000 1 week 750
C Handle Bar Assembly 3100 L4L 2 weeks 1000
D Steel Tubing 1" dia 50,000 POQ Period = 4 weeks 3 weeks 20,000 feet
E Control cable 5,000 FOQ 20,000 2 weeks 10,000 feet
F Control lever assembly 2500 L4L 1 week
G Grips 2000 L4L 1 week
H Powerhead assembly 700 FOQ 4000 1 week
I Gearbox assembly 650 FOQ 5000 1 week 750
J Engine (Standard) 500 FOQ 2500 2 weeks 750
K Tiller blade unit 850 POQ Period = 2 weeks 1 week 750
L Engine (Heavy Duty) 450 FOQ 1000 3 weeks 500
M Instruction Manual 6000 FOQ 10,000 4 weeks 2500
N HD Tiller Unit 1250 POQ Period = 3 weeks 2 weeks 500
P HD Powerhead assembly 900 FOQ 2000 1 week

Scheduled Receipts

BA 314 Assignment 2 - Worksheet 4: Scheduled Receipts
Note: These are purchase order and production commitments scheduled in 2017 that are already scheduled for completion in 2018. The sizes of the orders or production lots are listed by week of scheduled delivery. Include these quantities in "Projected on-hand inventory" - do not include them in "Planned order releases."
Item Name Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 Week 10 Week 11 Week 12
A ClodHopper
B ClodBuster
C Handle Bar Assembly
D Steel Tubing 1" dia (feet) 100,000
E Control cable (feet) 20,000
F Control lever assembly
G Grips
H Powerhead assembly 200
I Gearbox assembly 5000
J Engine (Standard) 2500 2500 2500 2500
K Tiller blade unit
L Engine (Heavy Duty) 1000 1000
M Instruction Manual 10,000
N HD Tiller Unit
P HD Powerhead assembly 1000

MRP Form - Results

BA 314 Assignment 2 - Worksheet 5: MRP Forms
Item: Lot Size Rule:
Lead Time:
Safety Stock Level:
Current Inventory:
Jan 2018 Feb 2018 Mar 2018
Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 Week 10 Week 11 Week 12
Gross Requirements
Scheduled Receipts
Projected On-Hand Inventory
Planned Receipts
Planned Order Releases
Item: Lot Size Rule:
Lead Time:
Safety Stock Level:
Current Inventory:
Jan 2018 Feb 2018 Mar 2018
Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 Week 10 Week 11 Week 12
Gross Requirements
Scheduled Receipts
Projected On-Hand Inventory
Planned Receipts
Planned Order Releases
Item: Lot Size Rule:
Lead Time:
Safety Stock Level:
Current Inventory:
Jan 2018 Feb 2018 Mar 2018
Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 Week 10 Week 11 Week 12
Gross Requirements
Scheduled Receipts
Projected On-Hand Inventory
Planned Receipts
Planned Order Releases
Item: Lot Size Rule:
Lead Time:
Safety Stock Level:
Current Inventory:
Jan 2018 Feb 2018 Mar 2018
Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 Week 10 Week 11 Week 12
Gross Requirements
Scheduled Receipts
Projected On-Hand Inventory
Planned Receipts
Planned Order Releases
Item: Lot Size Rule:
Lead Time:
Safety Stock Level:
Current Inventory:
Jan 2018 Feb 2018 Mar 2018
Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 Week 10 Week 11 Week 12
Gross Requirements
Scheduled Receipts
Projected On-Hand Inventory
Planned Receipts
Planned Order Releases