2. MRP (25 Marks)Specialty Bikes Inc (SBI) assembles road bikes for recreational use. There has been a surge in road cycling with the baby boom generation. The assembly of the bike has the following BOM:AHB (1)W (2)C (1)G (5) A = Finished assembled bike HB = Handle bars W = Wheels C = Chain set with pedals G = Gear set The assembly department already has the frame which includes the seat. Orders for bikes and parts schedules to be received are as follows:Orders for BikesWeekBikes Ordered530062007400Current on OrderHB300 in week 3W200 in week 4 Inventory StatusPartAHBWCGOn Hand10050150200300Lead Time (Weeks)22200Lot SizeLFL300LFL250LFLSafety Stock0001000The inventory status is as follows:Requirement: Complete the MRP RecordsPartLotLeadOnSafetyNo.SizeTimeHandStockWeeks1234567Gross RequirementsScheduled ReceiptsProjected on Hand Net RequirementsPlanned Order ReceiptsPlanned Order ReleasesPartLotLeadOnSafetyNo.SizeTimeHandStockWeeks1234567Gross RequirementsScheduled ReceiptsProjected on Hand Net RequirementsPlanned Order ReceiptsPlanned Order ReleasesPartLotLeadOnSafetyNo.SizeTimeHandStockWeeks1234567Gross RequirementsScheduled ReceiptsProjected on Hand Net RequirementsPlanned Order ReceiptsPlanned Order Releases

Published by
Essays
View all posts