Overview In this assignment you will help SSB, Inc. with their procurement process. Specifically you will 1. Define their procurement process in terms of the physical flow 2. Execute five instances of the process on paper. That is, you will create the various documents needed and ensure that the correct data is included in each document 3. Generate reports based on the data in the documents The business process The process used by SSB is similar to the one described in Chapter 3. However, there are some differences. These differences are explained below and you must incorporate them in your assignment 1. After evaluating the current process, it is determined that the process will be more efficient if Tim Jones initiates the process (ie, creates the requisition) instead of David Bloomburg. This is because Tim is more aware of the state of inventory than David as Tim is constantly in the Warehouse. However, David must approve all requisitions. 2. SSB's agreements with vendors has changed as follows: a. All shipments will now include an additional 10% in shipping costs for orders under $2000 b. Payment terms are 1% 10/Net 30 Requirements 1. As a group it is MANDATORY to use the group site in Blackboard for all group communication and document sharing to complete this assignment. You can only receive a grade if you use the group site. 2. Create a process diagram similar to Figure 3.1 to describe SSBs modified procurement process. Use Microsoft Visio or other software to create this diagram. You may hand draw neatly and scan into your Word doc for submitting. 3. For Requisition #3961 only - Create the documents needed to execute the process for the data provided in the Order Data Section at the end. Be careful to ensure that the data in the documents (dates, quantities, prices, etc.) are accurate. Clearly state any assumptions made on a separate sheet at the beginning of the submission (It is not typical to have to make assumptions). 4. For all requisitions, #3961, 3962, 3963, 3 and 3965-Take the necessary data from the documents and put it into a spreadsheet and do the following a. Create a pie chart showing the quantity of each material purchased b. Create a pie chart showing the value ($) of each material purchased C. Create a bar chart showing the number of times each material is ordered d.- Create a bar chart showing the amount ($) purchased from each vendor e. Answer the following questions i. The average number of days it takes to complete the process. ii. The average value ($) of an order iii. Which is the most purchased material, in terms of quantity? How many were purchased? iv. Which is the most purchased material, in terms of value ($)? How much did SSB spend on this material | Procurement Assignment |Page 1 of 31 Deliverables After completing the assignment, submit the following: 1. Cover page with a. Course number and section b. Date . Team number d. Names of team members 2. The process diagram 3. For #3961, requisition: a. The documents in the correct order of process steps 4. The reports a. The various charts specified in the Requirements section b. Answers to the questions in the Requirements section on one page 5. Notes: a. Order Data. v. Which is the most frequently purchased material? vi. Which is the vendor does SSB buy from the most, in terms of value ($) Include a footer on each page with course number, section number, team number, date and page number b. Ensure that the submission is professionally prepared. Sloppy work will be penalized C. Submit one word document with all the required material. You will have to figure out how to export data from Visio and Excel into Word. d. Submit the word document electronically via the Blackboard system Requisition # 3961 3962 3963 3964 3965 P Reg # 3961 3962 3963 3964 3965 Requisition date July 1, 2020 July 1 July 15 July 31 Aug 14 Aug 28 July 15, 2020 July 31, 2020 August 14, 2020 August 28, 2020 Requisition date Vendor July 2 July 16 Aug 1 Aug 15 Aug 29 NutcaseSupplies Black Widow Skateboards Black Widow Skateboards Black Widow Skateboards Skatelubbers Approval Date PO Date July 7 July 16 Aug 8 Aug 19 Aug 29 Ship Date July 14 July 30 Aug 25 Sep 5 Sep 12 Materials ENSB 3000 HLMT 5000 SHRT 4000 FAID 6000 ENSB 3000 HLMT 5000 FAID 6000 ENSB 3000 HLMT 5000 FAID 6000 ENSB 3000 HLMT 5000 ENSB 3000 Goods Invoice Receipt Date Date July 16 Aug 2 Aug 28 Sep & Sep 17 July 23 Aug 11 Sep 4 Sep 15 Sep 19 Quantity 100 200 50 25 200 200 40 150 100 50 300 300 400 Payment Date July 30 Aug 22 Sep 12 Sep 26 Sep 26 Here is how you work in groups: Meet in your Bb group site and choose a leader. As a group, divide the work. While each group member is responsible for a section of the assignment all group members are responsible for all sections of the assignment as well. Work together and help each other. Each member reviews all sections created by other members. Make comments, provide feedback, discuss changes, etc. Once all members are satisfied with all of the sections then complete the cover page with the names of the students only that participated. I will check your group site to ensure it was used and to validate the reason why any members were not included on the cover page. Your name on the cover page of the assignment means that you personally accept all sections of the assignment and the grade that goes with it. One member of the group only submits the assignment for grading. I will review your group site to make sure it was used fully to complete the assignment and to warrant your group receiving a grade for the assignment. Richard Yip-Chuck