Question: Hello, Can you help me with this question please? Thank you! Problem 3: Use data given sheet Problem 3 SpareBucs Company is a company that

Hello, Can you help me with this question please?

Thank you!

  1. Problem 3: Use data given sheet "Problem 3" 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.

In which month did SpareBucs generate the highest revenue?

Hello, Can you help me with this question please? Thank you! Problem3: Use data given sheet "Problem 3" SpareBucs Company is a company

Wrap Text . General Merge & Center . W Auto Sur LA Conditional Format Formatting as Table Cell Styles Insert Fill Delete ] Format nt to continue working where you left off? Clear lantity Unit Price Total Sales 300 4.00 600 8 $ 1,200.00 $ 1,800.00 4.00 Questions 300 $ 1,200.00 600 2.00 $ 1,200.00 a. In which month did SpareBucs generate the highest revenue? 8 888 8 8 8 3.00 $ 2,400.00 b. Which US Region purchased the highest amount of "Coffee" products? 4.00 $ 3,600.00 c. Which product generated the highest revenue in April 20187 5.00 $ 2,000.00 8 8 8 8 $ 2,500.00 $ 1,500.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 6.00 $ 4,200.00 1000 5.00 $ 5,000.00 300 1.00 300.00Calibri (Body) A Copy . Wrap Text . General iste Format H Merge & Center 35 Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? X Customer Customer Product Customer ID City State US Region Product Category Quantity Unit Price Total Sales 23 Nashville Southeast Breakfast Blend Coffee 4.00 $ 1,200.00 44 Seattle West Vanilla Spices 3.00 $ 1,800.00 Questions 14 Knoxville Southeast Darjeeling Tea 4.00 $ 1,200.00 a. In which month did 15 Atlanta Southeast Mustard Spices 600 $ 2.00 $ 1,200.00 b. Which US Region 44 Seattle WA West Cinnamon Spices 800 $ 3.00 $ 2,400.00 c. Which product gen 23 Nashville Southeast Decaf Coffee 900 S 4.00 $ 3,600.00 18 Denver West Earl Grey Tea 400 $ 5.00 $ 2,000.00 19 Boulder West Green Tea Tea 100 $ 6.00 20 Miami Southeast French Roast Coffee 500 $ 5.00 $ 2,500.00 16 Chicago Midwest Hazelnut Coffee 500 $ 3.00 $ 1,500.00 50 Peoria Midwest Curry Spices 200 $ 4.00 800.00 3 Portland ME Northeast Ginger Spices 2.00 $ 200.00 2 Minneapolis MN Midwest Oolong Tea 800 $ 3.00 $ 2,400.00 11 Portsmouth NH Northeast Vanilla Spices 400 $ 3.00 $ 1,200.00 44 Seattle WA West Mustard Spices 200 $ 2.00 $ 400 00 16 Chicago Midwest Vanilla Coffee 4.00 $ 1,600.00 49 Los Angeles CA West Decaf Coffee 4.00 $ 2,400.00 22 Cleveland OH Midwest Green Tea Tea $ 6.00 $ 4,200.00 11 Portsmouth NH Northeast Oregano Spices 1000 5.00 $ 5,000.00 45 Des Moines IA Midwest Curry Spices 300 1.00 300.00

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!