Given the following product structure and inventory information of assembling skateboards. There is
an order of 120 units of skateboards by the start of week 10.
a. Identify the quantity and the period of releasing the order for Screws. You may develop the
MRP in an excel sheet and paste it as a figure to your portfolio. You are responsible for a clear
presentation. (05 Marks)
b. Explain the usage of MRP method to the above given industry in section 1. (10 marks)

Skateboard

Wheel (4) Board (1) Axle (2) Screw (8)

Tire (1) Rim (1) Screw (4) Figure 1: Product Structure for a Bicycle
Table 2: Inventory Information
On Hand Lead Time Scheduled
Receipts

Lot Size
(Multiples)
Skateboard 30 1 - 1
Wheel 20 2 30, period 2 50
Board 20 2 - 1
Axle 20 3 - 50
Screw 40 3 - 100
Tire 20 4 - 1
Rim 10 2 - 1