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.
Attachment:- Inventory records and lot sizing rules.rar