For all requisitions, #3961, 3962, 3963, 3964, 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 

v. Which is the most frequently purchased material?

vi. Which is the vendor does SSB buy from the most, in terms of value  

Transcribed Image Text:

Order Data. Requisition # Requisition date 3961 July 1, 2020 3962 3963 3964 3965 P Req # 3961 3962 3963 3964 3965 July 1 July 15 July 31 July 15, 2020 Aug 14 Aug 28 July 31, 2020 August 14, 2020 Requisition date August 28, 2020 July 2 July 16 Vendor Aug 1 Aug 15 Aug 29 NutcaseSupplies Black Widow Skateboards Black Widow Skateboards Black Widow Skateboards Approval Date Skatelubbers 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 Date July 16 Aug 2 Aug 28 Sep 8 Sep 17 Invoice Date 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 Order Data. Requisition # Requisition date 3961 July 1, 2020 3962 3963 3964 3965 P Req # 3961 3962 3963 3964 3965 July 1 July 15 July 31 July 15, 2020 Aug 14 Aug 28 July 31, 2020 August 14, 2020 Requisition date August 28, 2020 July 2 July 16 Vendor Aug 1 Aug 15 Aug 29 NutcaseSupplies Black Widow Skateboards Black Widow Skateboards Black Widow Skateboards Approval Date Skatelubbers 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 Date July 16 Aug 2 Aug 28 Sep 8 Sep 17 Invoice Date 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

Answer rating: 100% (QA)

i The average number of days it takes to complete the process can be calculated by finding the difference between the Payment Date and the Requisition ... View the full answer