Ask a question from expert
ClodHopper and ClodBuster: Assignment
3 Pages875 Words894 Views
Added on 2019-09-16
ClodHopper and ClodBuster: Assignment
Added on 2019-09-16
BookmarkShareRelated Documents
BA 357: Fall 2016 Assignment – 2Due November 15thClodhopper ClodbusterBackground: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 higherand 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 engineand tiller subassemblies. All of the managers at the acquired company quit the day your company took possession. You are the person who has been assigned to run this acquisition. Since all of the managers quit, the only planning information you have is historical data. Assignment:Your task is to create material requirements plans for items C, E, H, K, P, and L.Use the MRP form supplied and print the spreadsheets (landscape) two to a page (3 pages total). 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 theforms 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...”). Use the header function to show your name in the upper right corner of all pages.Staple the three landscape pages in the upper right corner, in the order C & E on the first page, H & K on the second page, and P & L on the third page (no cover sheet).Part 2 Data:The Assn – 3 Student” spreadsheet contains five different worksheets:MPS approved plans for Clodhopper and Clodbuster for the first three months of 2010.Bill of materials data for ClodHopper and ClodBuster, including quantities required per product and assembly times/lead timesInventory records and lot-sizing rules for all subassemblies and component parts
End of preview
Want to access all the pages? Upload your documents or become a member.