Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

SpareBucs Company is a company that sells coffee, tea and spices in different cities across the United States. The excel provides the sales data for

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
SpareBucs Company is a company that sells coffee, tea and spices in different cities across the United States. The excel provides the sales data for the first 4 months of 2018. Use pivot tables to answer the questions. Question: In which month did SpareBues generate the highest revenue? April O February March January QUESTION 9 Which US Region purchased the highest amount of "Coffee" products? Southeast o West QUESTION 9 Which US Region purchased the highest amount of "Coffee" products? O Southeast o West O Northeast O Midwest QUESTION 10 Which product generated the highest revenue in April 2018? O Green Tea O Earl Grey O Vanilla Decaf QUESTION 10 Which product generated the highest revenue in April 2018? O Green Tea Earl Grey O Vanilla O Decaf O Curry Mustard Oolong B D E G H TN Earl Grey Tea Customer Customer 1 Sales Month Customer ID city State 2 Jan 23 Nashville 3 Feb 44 Seattle WA 4 Mar 14 Knoxville TN 5 Apr 15 Atlanta GA 6 Feb 44 Seattle WA 7 Mar 23 Nashville TN 8 Feb 18 Denver CO 9 Mar 19 Boulder CO 10 Feb 20 Miami FL 11 Mar 16 Chicago IL 12 Apr 50 Peoria IL 13 Mar 3 Portland ME 14 Feb 2 Minneapolis MN 15 Jan 11 Portsmouth NH 16 Apr 44 Seattle WA 17 Mar 16 Chicago IL 18 Jan 49 Los Angeles CA 19 Feb 22 Cleveland OH 20 Mar 11 Portsmouth NH 21 Feb 45 Des Moines IA 22 23 24 Product US Region Product Category Southeast Breakfast Blend Coffee West Vanilla Spices Southeast Darjeeling Tea Southeast Mustard Spices West Cinnamon Spices Southeast Decaf Coffee West West Green Tea Tea Southeast French Roast Coffee Midwest Hazelnut Coffee Midwest Curry Spices Northeast Ginger Spices Midwest Oolong Tea Northeast Vanilla Spices West Mustard Spices Midwest Vanilla Coffee West Decaf Coffee Midwest Green Tea Tea Northeast Oregano Spices Midwest Curry Spices Quantity Unit Price Total Sales 300 $ 4.00 $ 1,200.00 600 $ 3.00 $ 1,800.00 300 $ 4.00 $ 1,200.00 600 $ 2.00 $ 1,200.00 800 S 3.00 $2,400.00 900 $ 4.00 $3,600.00 400 $ 5.00 $2,000.00 100 $ 6.00 $ 600.00 500 $ 5.00 $ 2,500.00 500 $ 3.00 $ 1,500.00 200 $ 4.00 $ 800.00 100 $ 2.00 $ 200.00 800 $ 3.00 $2,400.00 400 $ 3.00 $ 1,200.00 200 $ 2.00 $ 400.00 400 $ 4.00 $ 1,600.00 600 $ 4.00 $ 2,400.00 700 S 6.00 $ 4,200.00 1000 S 5.00 $ 5,000.00 300 S 1.00 $ 300.00

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Internal Audit Of The Future The Impact Of Technology Innovation

Authors: An Anthology Compiled And Contributed To By A. Michael Smith

1st Edition

1634540638, 978-1634540636

More Books

Students also viewed these Accounting questions