Part 6 – Capacity Requirements Planning – Develop an Excel based Capacity Requirements Plan for your chosen product. Use the format and logic as shown in the Integrated Learning Project Example found on . Review the Kaptur presentation for this week, as well as pages 439 through 478 in your Logistics textbook. Your CRP Excel file will be accompanied by a written assignment containing:
- Details on how this module could be implemented (assignment management process, who should be involved, and why, etc.) within the chosen firm (300 words)
- Details on how this module could be operated (management process, key factors in the CRP operating policy, who should be responsible and why, the users of this modules data, etc.) within the chosen firm (300 words)
- What could be the future sources of inaccuracy in the data contained in the module (300 words)
- A comparison of any 2 CRP schedule formats and logic taken from ERP Software or other CRP types from your own research of available CRP software (300 words)
Part 7 – Assignment Plan – Develop a time phased assignment plan for the implementation of an ERP system at your selected firm. Review the assigned Learn 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 assignment containing:
- Overall structure of the ERP implementation plan detailing responsibilities and timing (300 words)
- Details on the Education and Training activities of the plan, their sequencing and timing (300 words)
- Details on the key activities in the Bills of Materials sub-assignment to achieve a company document with 98% accuracy (300 words)
- Details on the key activities in the Warehouse sub-assignment to achieve a minimum of 95% accuracy (300 words)
- Details on the key activities in the Master Production Schedule sub-assignment to achieve a 98% customer service accuracy (300 words)
Part 8 – Final Submission – The final integrated Excel ERP working model for your chosen firm, due at the end of week 8, will tie all the preceding modules together into a fully integrated working ERP model in Excel. The integrated modules will include, Master Production Schedule, Bill of Materials, Materials Requirements Planning, Capacity Planning, Distribution Requirements Planning and Shop Floor Control. The Excel file will be submitted simultaneous with the following written report. The final course report would be about 3,000 words (excluding references and appendices), much of which would have been accumulated over the preceding 6 weeks.
- The final submission will also include a written management report detailing (1) a recommendation for implementation based on a cost / benefits analysis (2) implementation assignment plan with responsibilities, (3) a justified recommendation for an ERP system (e.g. SAP, or other) and its operation (local or cloud processing, scope of application (national, global, etc.)