You are tasked with creating a material requirements plan $($MRP$)$ for a manufacturing company that produces bicycles. The company uses the following components in the production process: fram, wheels$/$pedals$/$handlebars$/$seat$.$ The company expects to product $200$ bicylces in the next month, current inventory levels, lead times and production requirements are noted below. $(20$ marks$)$

The production requires the following quantities of each component:

$1.$ Bicycle: Frame, Wheels $(2$ units$),$ Pedals $(2$ units$),$ Handlebars, Seat

$2.$ Frame: Metal Tubes, Welding Material

$3.$ Wheels: Rim, Spokes, Hub

$4.$ Pedals: Pedal Body, Bearings

$5.$ Handlebars: Metal Tubes, Grips

$6.$ Seat: Seat Cushion, Seat Frame

Lead Times:

Bicycle: $2$ weeks

Frame: $1$ week

Wheels: $1$ week

Pedals: $1$ Week

Handlebars: $1$ week

Seat: $1$ week

Inventory:

Frame: $50$ units

Wheels: $100$ units

Pedals: $80$ units

Handlebars: $60$ units

Seat: $70$ units

Additional Information:

Safety Stock: $20\%$ of Gross Requirements

MRP Calculations Needed:

$1.$ Gross requirements for each component.

$2.$ Scheduled Receipts for each component.

$3.$ Planned Order Releases for each component. $($use a MAX formula$)$

$4.$ Net Requirements for each component. $($use a MAX formula$)$

$5.$ Planned Order Receipts for each component. $($use a MAX formula$)$

$6.$ Inventory levels for each component at the end of each week. $($use a MAX formula$)[$assume only producing for one production cycle based on above mentioned lead times$]$