Assignment for Class

profilevk4queen
Assn-2StudentS19-2.xls
Home>Business & Finance homework help>Operations Management homework help>Assignment for Class

MPS -Approved

BA 357 Work Assignment 2 - Worksheet 1: MPS Approved plan
Item: A Clodhopper (Fall2010) Lot Size Rule: FOQ 2500
Lead Time: 1 week
Safety Stock Level: 1500
Current Inventory: 5500
Jan 2010 Feb 2010 Mar 2010
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 2233 2232 2233 2232
Customer Orders Booked 150 350 500 600 200 1000 2500 2000
Projected On-Hand Inventory 5050 4600 4100 3500 2900 2300 3800 3200 3467 3467 3734 4002
MPS Scheduled Receipts
MPS Quantity 2500 2500 2500 2500 2500
MPS Start 2500 2500 2500 2500 2500
Available to Promise 3700 1500 2500 0 500 2500
Item: B Clodbuster (Fall2010) Lot Size Rule: FOQ 1000
Lead Time: 1 week
Safety Stock Level: 750
Current Inventory: 4000
Jan 2010 Feb 2010 Mar 2010
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 943 942 943 942
Customer Orders Booked 200 450 50 900 3000
Projected On-Hand Inventory 3700 3400 2950 2650 2250 1350 950 1550 1550 1608 1665 1723
MPS Scheduled Receipts
MPS Quantity 1000 3000 1000 1000 1000
MPS Start 1000 3000 1000 1000 1000
Available to Promise 2400 1000 0 1000 1000 1000

BOMs

BA 357 Work 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 5 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 5 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 357 Work Assignment 2 - Worksheet 3: Inventory Records and Lot-Sizing Rules
Record Date: 31-Dec-09
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 4000 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 357 Work Assignment 2 - Worksheet 4: Scheduled Receipts
Note: These are purchase order and production commitments scheduled in 2009 that are already scheduled for completion in 2010. 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 20,000
F Control lever assembly
G Grips
H Powerhead assembly 4000
I Gearbox assembly 5000
J Engine (Standard) 2500 2500 2500 2500
K Tiller blade unit
L Engine (Heavy Duty) 1000 1000 1000 1000 1000 1000
M Instruction Manual 10,000
N HD Tiller Unit
P HD Powerhead assembly 2000

MRP Form - Results

BA 357 Work Assignment 2 - Worksheet 5: MRP Form
Item: C Handle Bar Assembly Lot Size Rule: L4L
Lead Time: 2 weeks
Safety Stock Level: 1000
Current Inventory: 3100
Jan 2010 Feb 2010 Mar 2010
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: E Control Cable Lot Size Rule: FOQ 20,000
Lead Time: 2 weeks
Safety Stock Level: 10,000
Current Inventory: 5,000
Jan 2010 Feb 2010 Mar 2010
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: H Powerhead Assembly Lot Size Rule: FOQ 4,000
Lead Time: 1 week
Safety Stock Level: 0
Current Inventory: 700
Jan 2010 Feb 2010 Mar 2010
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: K Tiller Blade Unit Lot Size Rule: POQ 2 weeks
Lead Time: 1 week
Safety Stock Level: 750
Current Inventory: 850
Jan 2010 Feb 2010 Mar 2010
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: P HD Powerhead Assembly Lot Size Rule: FOQ 2,000
Lead Time: 1 week
Safety Stock Level: 0
Current Inventory: 900
Jan 2010 Feb 2010 Mar 2010
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: L Engine (Heavy Duty) Lot Size Rule: FOQ 1,000
Lead Time: 3 weeks
Safety Stock Level: 500
Current Inventory: 450
Jan 2010 Feb 2010 Mar 2010
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

Sheet1

Sheet2