Title: Analyzing Sales Data for SSB Materials and Customers

3. 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 sold
b. Create a pie chart showing the value ($) of each material sold
c. Create a bar chart showing the number of times each material is ordered
d. Create a bar chart showing the amount ($) purchased by each customer
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 SSB’s best selling material in terms of quantity? How many were sold?
iv. Which is the best selling material in terms of value ($)?
v. Which is the most frequently sold material?
vi. Who is SBBs best customer, in terms of value ($)

The post Title: Analyzing Sales Data for SSB Materials and Customers appeared first on get essay fast.