Assignment:
Background:
Your company has just acquired a new subsidiary that makes two products, Clodhopper and Clodbuster. The Clodhopper is intended for the general consumer market and its demand is higher and more seasonal than the Clodbuster, which is intended for the commercial user market. Both products share a number of component parts and subassemblies, primarily differing in their engine and tiller subassemblies. You have been assigned to run this acquisition. The only planning information you have is historical data.
Your task is to complete the MPS plans for both end items and to create material requirements plans (MRP) for any 5 items in the BOM.
• First complete all of the information in the MPS plans.
• Then, using the MRP forms supplied in the spreadsheets. Fill in all appropriate data (lot size, ordering rule, etc).
• Do not make any changes to the format/layout of the spreadsheet. This is one place in industry where creativity in presenting data is not appreciated since many of the cells in the forms are normally linked, and changes can lead to significant errors in the results.
• Use the comment function to show the formula for "projected on-hand inventory." The formula must be understandable (e.g. "beginning inventory + production..." NOT "D12 + E12...") and a comment must be entered in each cell that you calculate projected on-hand inventory.
Sreadsheet contains five different worksheets:
MPS plans for Clodhopper and Clodbuster for the first three months of 2018.
Bill of materials data for ClodHopper and ClodBuster, including quantities required per product and assembly times/lead times
Inventory records and lot-sizing rules for all subassemblies and component parts
Scheduled receipts (production commitments and purchase orders that have been scheduled by previous MPS and MRP plans for delivery in 2018.
MRP forms to use for your choice of five items in the BOM
Attachment:- Inventory records and lot sizing-rules.rar