Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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?

image text in transcribedimage text in transcribed
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

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516

Students also viewed these Accounting questions