Colnago manufactures sports bikes. Each bike is assembled using the following components

1 frame

2 wheels

1 handlebar

A frame is made up of 1 seat

Each wheel requires 4 screws

Each handlebar requires 3 screws

Both the wheel and handlebar require the same type of screw

Assume constant production. The demand for bicycles in January is expected to be 560 units (140 for each of the 4 weeks in January)

Lead-time for each component is as follows,

bike- 3 weeks

frame- 2 weeks

wheel 1 weeks

seat- 2 weeks

handlebar- 1 week

screw- 2 weeks

The order strategies for each item are given below,

bike- EOQ of 150

frame- EOQ of 200

wheel LFL

seat- LFL

handlebar- EOQ of 250

screw- EOQ of 450

The following quantities of each item are on hand,

bike- 85

frame- 20

wheel 10

seat- 0

handlebar- 25

screw- 0

Draw the bill-of-materials (product structure tree). Develop a 14-week Materials Requirement Planning schedule to ensure required production in January.