Overview- In this assignment you will help SSB, Inc. by critically analyze their procurement process and suggest the best solution, specifically you will1. 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 processThe 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. SSBs agreements with vendors has changed as follows:a. All shipments will now include an additional 10% in shipping costs for orders under $2000b. Payment terms are 1% 10/ Net 30 Requirements1. Create a process diagram similar to Figure 3.1 to describe SSBs modified procurement process. Use Microsoft Visio to create this diagram.[12 marks] 2. 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). [23 marks]3. Take the necessary data from the documents and put it into a spreadsheet and do the following: [8 marks]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. 4. Answer the following questions [12 marks] a. The average number of days it takes to complete the process.b. The average value ($) of an orderc. Which is the most purchased material, in terms of quantity? How many were purchased?d. Which is the most purchased material, in terms of value ($)? How much did SSB spend on this materiale. Which is the most frequently purchased material?f. Which is the vendor does SSB buy from the most, in terms of value ($) DeliverablesAfter completing the assignment, submit the following:1. Cover page with a. Course number and sectionb. Datec. Names of team members2. The process diagram3. For TWO process instances (the first two in the order data section)a. The documents in the correct order of process steps (keep all documents for one instance together)4. The reportsa. The various charts specified in the Requirements sectionb. Answers to the questions in the Requirements section on one page5. Notes:a. Include a footer on each page with course number, section number, , date and page numberb. Ensure that the submission is professionally prepared. Sloppy work will be penalized with the deduction of 2 marks.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 Order Data.Requisition #Requisition dateVendorMaterialsQuantity3961July 1, 2008NutcaseSuppliesENSB 3000100 HLMT 5000200 SHRT 400050 FAID 6000253962July 15, 2008Black Widow SkateboardsENSB 3000200 HLMT 5000200 FAID 6000403963July 31, 2008Black Widow SkateboardsENSB 3000150 HLMT 5000100 FAID 6000503964August 14, 2008Black Widow SkateboardsENSB 3000300 HLMT 50003003965August 28, 2008SkatelubbersENSB 3000400 P Req #Requisition dateApproval DatePO DateShipDateGoodsReceiptDateInvoiceDatePaymentDate3961July 1July 2July 7July 14July 16July 23July 303962July 15July 16July 16July 30Aug 2Aug 11Aug 223963July 31Aug 1Aug 8Aug 25Aug 28Sep 4Sep 123964Aug 14Aug 15Aug 19Sep 5Sep 8Sep 15Sep 263965Aug 28Aug 29Aug 29Sep 12Sep 17Sep 19Sep 26