Using the MRP Tables below, and the BOM for the bike, and the inventory, Quantity per, lead time, and ordering Rule (EOQ or LFL), fill out the planning tables for the Wheel and Spokes;

Period (weeks)	1	2	3	4	5	6	7	8	9	10	11
MPS BIKE 5				40		30	40		50		45

ITEM: Wheel

Quantity per:

LT: Order Rule:

Gross Requirements
Scheduled Receipts
Inventory on Hand 30
Net Requirements
Planned Order Receipts
Planned Order Releases

ITEM: Spokes

Quantity per:

LT: Order Rule:

Gross Requirements
Scheduled Receipts
Inventory on Hand 500
Net Requirements
Planned Order Receipts
Planned Order Releases

Example: Bike Assembly Bike Chain(1) Wheel(2) Frame(1) Brakes(2) Spokes(20) Hub(1) Rim(1) Handlebars(1) Mainframe(1) Axel(1) Hubcase(1) Frontframe(1) Rearframe(1) Product Structure of a Bicycle Lot-sizing Rule On Hand 5 20 30 10 100 500 Item Bike Chain Wheel Frame Brakes Spokes Hub Rim Handlebars Mainframe Axle Hubcaps Frontframe Rearframe 25 Lead Time 0 1 1 2 3 1 1 2 2 2 1 1 2 1 0 15 40 0 20 20 30 EOQ (150) Lot-for-Lot Lot-for-Lot EOQ (300) EOQ (2000) Lot-for-Lot EOQ (150) EOQ (250) Lot-for-Lot EOQ (200) EOQ (200) Lot-for-Size EOQ (420)