Answered step by step
Verified Expert Solution
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.
region | date_of_sale | item | brand | collection | description | list_price | cost | quantity_sold | Sales Revenue | total cost | gross profit |
Central | 1/2/2018 | Z115-96BNBDL | Riders | Lindos | 96" CC pull | $ 4.87 | $ 3.16 | 446 | $ 2,172.02 | $ 1,409.36 | $ 762.66 |
Central | 1/2/2018 | 33854ALM* | Jeffrey Alexander | Slade | Knob | $ 11.81 | $ 1.09 | 569 | $ 6,719.89 | $ 620.21 | $ 6,099.68 |
West | 1/2/2018 | 293-224PC | Elements | Zane | 224 mm CC pull | $ 22.65 | $ 14.38 | 558 | $ 12,638.70 | $ 8,024.04 | $ 4,614.66 |
Northeast | 1/2/2018 | 107DBAC | Jeffrey Alexander | Capri | Knob | $ 15.05 | $ 3.24 | 726 | $ 10,926.30 | $ 2,352.24 | $ 8,574.06 |
Midwest | 1/2/2018 | CL101-NI | Elements | Latches | Cabinet Latch | $ 12.65 | $ 7.41 | 606 | $ 7,665.90 | $ 4,490.46 | $ 3,175.44 |
Northwest | 1/3/2018 | 211SN | Jeffrey Alexander | Naples | Knob | $ 11.95 | $ 7.14 | 721 | $ 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...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started