Explain how ERP could be operated (management process, who should be responsible, numbers of different users of each module, data accuracy, etc.) within the chosen firm

Integrated Learning Project Assignment ExpectationsEachcomponent, from part 3 will be the development of an Enterprise ResourcePlanning (ERP) module in Excel relevant to the topic for that part. TheExcel development will follow SAP and other ERP systems formats. The Excelfile will be accompanied by a written assignment containing:
Details onhow this ERP assignment could be implemented (assignment managementprocess, who should be involved, and why, etc.) within the chosen firm(min 300 words)Details onhow ERP could be operated (management process, who should be responsible,numbers of different users of each module, data accuracy, etc.) withinthe chosen firm (min 300 words)What couldbe the future sources of inaccuracy in the data contained the ERP system(min 300 words)How thecorruption of the data could be prevented (min 300 words)An analysisand composition of the net benefit (benefits minus costs linked to incomestatement and balance sheet) of the implemented ERP system
Theassignment will include various parts that consist of Master ProductionSchedule, Bill of Materials, Materials Requirements Planning, CapacityPlanning, Distribution Requirements Planning and Shop Floor Control. TheExcel file will be submitted simultaneous with the following writtenreport. The total course report would be about 3,000 words (excludingreferences and appendices).
Thesubmission will also include a written management report detailing (1) arecommendation for implementation based on a cost / benefits analysis (2)implementation assignment plan with responsibilities, (3) a justifiedrecommendation for an ERP system (e.g. SAP, or other) and its operation(local or cloud processing, scope of application (national, global, etc.)
Instructions (Please follow the instruction below)Part 1 – Company (Nike) selection –Characteristics – Manufacturing – Publicly available financial accounts –consumer or industrial product. Structure your assignment as follows (wordcounts are minimums):oTitlepageoCompanydescription (300 words)oFinancialtrends: Overview of inventory types/trends/productivity (trends in day’s stockby type, Etc.) (300 words)Income statements(last 3 years) (300 words)Balance sheet(last 3 years) (300 words)oOpportunitiesfor logistics to improve income statement (consider revenues and operatingcosts) and balance sheet asset productivity. Provide quantitative calculationsand probable range of costs / benefits. (300 words)Part 2 –Master Production Scheduling (MPS) – Developan Excel based Master Production Schedule for your chosen product. Usethe format and logic as shown in the illustrative Excel spread sheet to befound under Course Content. Also review the Kaptur presentation for this part,as well as pages 281 through 303 in your Logistics textbook. Your MPS Excelfile will be accompanied by a written assignment containing:
Detailson how this module could be implemented (assignment management process,who should be involved, and why, etc.) within the chosen firm (300 words)Detailson how this module could be operated (management process, key factors inthe MPS policy, who should be responsible and why, the users of thismodules data, etc.) within the chosen firm (300 words)Whatcould be the future sources of inaccuracy in the data contained in themodule (300 words)Acomparison of any 2 MPS schedule formats and logic taken fromhttp://www.softwareadvice.com/erp/?more=true#more or other MPS types fromyour own research of available MPS software (300 words)
Part 3 –Enterprise Resource Planning – Developan Excel analysis of the modules and functionality of 3 ERP systems, one ofwhich must be SAP and the other 2 are of your choice. Follow the “ERP Links”for a listing of over 100 ERP software systems, including SAP (https://www.softwareadvice.com/erp/?more=true#more).Overlay the functionality of these ERP systems onto the main manufacturingprocesses of your selected firm and determine which software best fits yourchosen company. Your Excel analysis will accompany your written assignmentwhich will contain:
Descriptionof the how the software selection criteria (and which ones) were chosenfor your company (300)Ananalysis and tabulation of the strengths and weaknesses of the mainmodules of each software solution when compared of your selectioncriteria (300)Adiscussion of any ancillary data capture equipment and other softwarethat may be advantageous to the operation of the ERP system in yourcompany (300)Considerationof which functional areas would be responsible for the operation of eachof the major ERP modules (300)Ananalysis of the possible software costs of your recommended ERP software(300)
Part 4 –Materials Requirements Planning – Developan Excel based Materials Requirements Plan for your chosen product. Use theformat and logic as shown in the illustrative Excel spread sheet to be foundunder Course Content. Show at least 4 MRP levels with sub-assemblies, purchasedcomponents, manufactured components, and raw materials. Review the Kapturpresentation for this part, as well as pages 233 through 305 in your Logisticstextbook. Your MRP Excel file will be accompanied by a written assignmentcontaining:
Detailson how this module could be implemented (assignment management process,who should be involved, and why, etc.) within the chosen firm (300 words)Detailson how this module could be operated (management process, key factors inthe MRP operating policy, who should be responsible and why, the users ofthis modules data, etc.) within the chosen firm (300 words)Whatcould be the future sources of inaccuracy in the data contained in themodule (300 words)Acomparison of any 2 MRP schedule formats and logic taken fromhttp://www.softwareadvice.com/erp/?more=true#more or other MRP types fromyour own research of available MRP software (300 words)
Part 5 –Distribution Requirements Planning – Developan Excel based Distribution Requirements Plan for your chosen product. Use theformat and logic as shown in the illustrative Excel spread sheet to be foundunder Course Content. Show at least 4 distribution warehouses with 4 componentsplanned for each with at least 1 common to all distribution warehouses. Reviewthe Kaltura presentation, as well as pages 319 through 406 in your Logisticstextbook. Your DRP Excel file will be accompanied by a written assignmentcontaining:
Detailson how this module could be implemented (assignment management process,who should be involved, and why, etc.) within the chosen firm (300 words)Detailson how this module could be operated (management process, key factors inthe DRP operating policy, who should be responsible and why, the users ofthis modules data, etc.) within the chosen firm (300 words)Whatcould be the future sources of inaccuracy in the data contained in themodule (300 words)Acomparison of any 2 DRP schedule formats and logic taken fromhttp://www.softwareadvice.com/erp/?more=true#more or other DRP types fromyour own research of available MRP software (300 words)
Part 6 –Capacity Requirements Planning – Developan Excel based Capacity Requirements Plan for your chosen product. Use theformat and logic as shown in the Integrated Learning Project Example found on. Reviewthe Kaptur presentation for this part, as well as pages 439 through 478 in yourLogistics textbook. Your CRP Excel file will be accompanied by a writtenassignment containing:
Detailson how this module could be implemented (assignment management process,who should be involved, and why, etc.) within the chosen firm (300 words)Detailson how this module could be operated (management process, key factors inthe CRP operating policy, who should be responsible and why, the users ofthis modules data, etc.) within the chosen firm (300 words)Whatcould be the future sources of inaccuracy in the data contained in themodule (300 words)Acomparison of any 2 CRP schedule formats and logic taken from ERPSoftware or other CRP types from your own research of available CRPsoftware (300 words)
Part 7 – Assignment Plan – Develop a time phased assignment plan for theimplementation of an ERP system at your selected firm. Review the assignedLearn material, as well as pages 511 through 551 in your Logistics textbook.Your time phased assignment plan Excel file will be accompanied by a written assignmentcontaining:
Overallstructure of the ERP implementation plan detailing responsibilities andtiming (300 words)Detailson the Education and Training activities of the plan, their sequencingand timing (300 words)Detailson the key activities in the Bills of Materials sub-assignment to achievea company document with 98% accuracy (300 words)Detailson the key activities in the Warehouse sub-assignment to achieve aminimum of 95% accuracy (300 words)Detailson the key activities in the Master Production Schedule sub-assignment toachieve a 98% customer service accuracy (300 words)
Part 8 – ConcludingPart(1) A recommendationfor implementation based on a cost / benefits analysis (2) Implementationassignment plan with responsibilities(3) A justifiedrecommendation for an ERP system (e.g. SAP, or other) and its operation (localor cloud processing, scope of application (national, global, etc.)