Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a pivot table that shows sales revenue by region for each of the four years and quarters ( excel) Create a pivot table that

Create a pivot table that shows sales revenue by region for each of the four years and quarters ( excel)

Create a pivot table that shows sales revenue, total cost, and gross profit for each year.

regiondate_of_saleitembrandcollectiondescriptionlist_pricecostquantity_soldSales Revenuetotal costgross profit
Central1/2/2018Z115-96BNBDLRidersLindos96" CC pull$ 4.87$ 3.16446$ 2,172.02$ 1,409.36$ 762.66
Central1/2/201833854ALM*Jeffrey AlexanderSladeKnob$ 11.81$ 1.09569$ 6,719.89$ 620.21$ 6,099.68
West1/2/2018293-224PCElementsZane224 mm CC pull$ 22.65$ 14.38558$ 12,638.70$ 8,024.04$ 4,614.66
Northeast1/2/2018107DBACJeffrey AlexanderCapriKnob$ 15.05$ 3.24726$ 10,926.30$ 2,352.24$ 8,574.06
Midwest1/2/2018CL101-NIElementsLatchesCabinet Latch$ 12.65$ 7.41606$ 7,665.90$ 4,490.46$ 3,175.44
Northwest1/3/2018211SNJeffrey AlexanderNaplesKnob$ 11.95$ 7.14721$ 8,615.95$ 5,147.94$ 3,468.01


Step by Step Solution

3.42 Rating (168 Votes )

There are 3 Steps involved in it

Step: 1

Table 1 Sum of Sales Revenue Year Qtrs region Total 2018 Qtr 1 C... 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

International Financial Reporting A Practical Guide

Authors: Alan Melville

6th edition

1292200743, 1292200766, 9781292200767, 978-1292200743

More Books

Students also viewed these Economics questions

Question

Give eye contact, but do not stare.

Answered: 1 week ago