Procurement Process Individual Assignment 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 fiow 2. Execute five instances of the process on paper. That is, you will create the various documents needed and ensure that the correct dota is included in eoch document 3. Generate reports bosed on the dota 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 ossignment 1. After evaluating the current process, it is determined that the process will be more efficient if Tim Jones initiotes the process (ie, creates the requisition) insteod of Dovid Bloomburg. This is becouse Tim is more aware of the state of inventory than Dowd os 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 odditional 10% in shipping costs for orders under $2000 b. Payment terms are 1%10/ Net 30 Requirements 1. Create a process diogram 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 neotly and scan into your Word doc for submitting. 2. For Requisition 13961 only - Creote 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 dota in the documents (dates, quantities, prices, etc.) are occurate. Clearly state any assumptions made on a separate sheet at the beginning of the submission (It is not typical to have to make assumptions). 3. For all requisitions, 13961,3962,3963,3964, and 3965 - Toke the necessary dota 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 eoch material purchosed 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 1. The averoge number of days it takes to complete the process. ii. The averoge 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 volue (\$)? How much did $SB spend on this moterial v. Which is the most frequently purchased moterial? vi. Which is the vendor does $SB buy from the most, in terms of value ($) | Procurement Assignment |Poge 1 of 2 | After completing the assignment, submit the following: 1. Cover poge with a. Course number and section b. Date c. Your nome d. Your student number 2. The process diogram 3. For H3961, 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. Ensure that the submission is professionally prepared. Sloppy work will be penalized b. 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. c. Submit the word document electronically vio the Blackboard system Order Data. | Procurement Assignment |Poge 2 of 2 |