CMIS2250 – SAP Exercise #3 Production Planning Posted to this Moodle site in the section entitled ERP Systems Module PP is a Process Guide document that serves as a step-by-step roadmap for successfully completing the Production Planning business process using the SAP application. There are seven (7) deliverables for this assignment for a possible total score of 100 points. Follow the instructions below as to what is expected in this assignment. Your response document must simply consist of the question numbers along with the outcomes being requested – 1 BPMN and 1 screenshot, plus the answers to 4 simple questions and lastly an export of a view to an Excel Spreadsheet. Explanation for each is not required, including the BPMN. Instructions: 1. (Deliverable 1) BPMN: Using the information regarding the Production Process as described in Chapter 10, pp. 317-321, create a BPMN (Business Process Modeling Notation) for this process. Microsoft Visio is suggested as the tool to create this BPMN (a cross-functional flowchart), but not required. (40 points) [See Appendix A at the end of this document for a screenshot of the steps] 2. (Deliverables 2,3,4, 5 and 6) SAP Screenshot and Questions: IMPORTANT: Begin and proceed through the process using the Process Guide for the following deliverables. With care and a reasonable amount of time, you will find that your probability of success for each step’s outcome will be much higher versus rushing through the instructions. The latter approach most often results in starting the entire process over. Read the instructions carefully and follow them to the exact detail. Anything that is missed may cause an error in an outcome. To avoid this, make note of your document numbers. *You also don’t need to answer the questions within the Process Guide. You only need to answer the ones within the instructions here. *** Most importantly, any part mentioning the use of ### is to be replaced with your last 3 numbers of your username i.e., LEARN-###. For example, if your username is LEARN-999, then replace each instance of ### in the Process guide with 999. If this is not done, you will be asked to start the process guide again from the beginning. *** Deliverables for this section: a. How many black Deluxe Touring Bikes are available in Dallas? (5 points) [Hint: Use the steps done in Step 8 and try using different search parameters to find this out. Be sure to remember your wildcards here *###] b. How many black Professional Touring Bikes are stored in the MI00 Plant? (5 points) [Hint: Use the steps done in Step 8 and try using different search parameters to find this out. Be sure to remember your wildcards here *###] c. SAP Screenshot: Display Routing: Scheduling Overview (15 points) [Hint: Use the display option in the path of Step 2. The screenshot will be the screen just after you access the area through the path More ➔ Extras ➔ Scheduling ➔ Schedule]. d. What is the full name of the employee responsible for the Assembly Work Center from the Dallas Plant? (5 points) [Hint: Follow the path of Logistics ➔ Production ➔ Master Data. One of the sub-display options within these folders will net you the answer] e. What does BOM stand for? Briefly explain it’s purpose. (5 points) [Explain it with relevance to Global Bikes] See Appendix B for additional Process Guide Step help. 3. (Deliverable 7) SAP Excel Sheet Export: Review Costs assigned to Production Order and export the Target/Actual – Comparison screen details to an Excel file: ProductionOrder.xlsx. Attach the file to your submission along with your answers in a pdf. (5 points) [Follow all the steps within Step 15 up until you get to the Analysis page. Once here you should be able to navigate around to find the export to Excel option.] Additional Instructions/Things to Note: 1. This Exercise #3 is worth 10% of the grade for the course. 2. Students are to work together in pairs or solo if they wish. 3. A cover page as part of your document is required: you must put your names and Class section number on this cover page. Use the Responses template file provided. If you fail to comply with this requirement, 20% will be taken from your final score. 4. Student submission should be in a single softcopy document (Moodle Drop Box for this assignment) only and in a PDF format; all other formats will be rejected, including Visio. If you create your BPMN using Visio, create a .jpg file first, then insert it into your Word document, finally save the document as a PDF document via the Export option in the File section of Word. 5. In SAP, if you make three (3) failed attempts at logging in, you will be locked out and your password will have to be reset. Only your instructor can reset your password. If you lock yourself out and the instructor must reset your password, you will be penalized 20% of your final score for the Exercise for each occurrence after the first. 6. This assignment’s deadline is 1 minute to midnight on the stated due date in your Planning Calendar or Moodle page, unless otherwise revised by your instructor; late submissions are subject to a 20% penalty. 7. Use of another person’s work without providing credit is a breach of Academic Integrity. See your Syllabus for details. The breach will be dealt seriously according to NAIT Rules and Regulations. When in doubt, ask your instructor. Use APA format for giving credit and citing sources. If you are reading this, for your submission, if you include a final message that is a single sentence message talking about this module you will get 10 points bonus to this assignment only. You cannot go above the max mark with this bonus. APPENDIX A Rainer, R.K. et al. (2020) Introduction to information systems: Supporting and Transforming Business. Toronto, ON: John Wiley & Sons Canada, Ltd. APPENDIX B Step 3: Mentions Ten Entries, but only Five should show up. So, just go along with it. Step 4: Record your version number. It is directly to the left of the field containing the words “Active Version” If you are confused by the verbiage within the Forecast: Model Selection screen, see here: If your numbers within the forecast don’t match that of image above the line: “As Target day’s supply enter 5 for each forecasted period.” Then cancel out of the popup and exit the view without saving and start from scratch. When is mentions the line: “As Target day’s supply enter 5 for each forecasted period.” You only need to enter the number 5 within the Target days’ Supply Row until the final filled field within the Sales Row. **** DON’T DISPLAY THE CHART BY PRESSING ‘CHARACTERISTIC’. You will not be able to visualize it, and if you do, you will be required to do the entire step again. **** Just Skip the visualization and instead save it. Step 5: When it asks you to save, it will automatically transfer you to the other views so you need not back out of the view and change things every time. Just check the line item, see how they compare to the line items in the Process Guide and go from there. Step 9: Be aware with selection here: Note your numbers here once you select the above option that appear in the next pop-up (Release Order): Note the Quantity here for Step 13. When you are at the screen here, press the Release Order button, and then back out with the Back Arrow in SAP, then save when it prompts you. On this line-item page, this is where you click refresh. Note your Order Number here. Step 10: Note the Two Dropdown Boxes at the top of the view. These are what need to be changed. Movement Type field is located here in the Blue Circle: Upon pressing enter for the Movement Field entry, you will get a prompt. Just agree to changing the defaults. Enter in the details they ask of within the Table by entering in the required information within each tab at the bottom. To enter into the lines you collapse the section containing the WHERE tab, and then you will be able to modify the line items and enter the required information. If the POST gives an error describing “no quantity” or something of that nature, uncheck the OK checkbox of the rows that are empty/don’t contain information regarding the table. This should let you post once you are done. Note the Material Document number here. Step 11: The Movement Type Field is in the same location within this view. The Order Field is circled in Blue: *Your numbers may not match here because these numbers are based off the forecasting done earlier. Note the Material Document here. Step 12: * Your numbers may not match here due to forecasts. Step 13: The yield quantity should be automatically entered in from step 11 and 12, but if not, your quantity is the amount recorded in Step 9 Note the order number here and ensure it is the same one as used previously/recorded at Step 9. Step 14: Note Material Document Number Step 16: Note Report Group