Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Required information P2-1 Summarize monthly sales and compute percentage change (LO 2-6) [The following information applies to the questions displayed below.] Summarize monthly sales and
Required information P2-1 Summarize monthly sales and compute percentage change (LO 2-6) [The following information applies to the questions displayed below.] Summarize monthly sales and compute the % Change from one month to the next. Required: 1. Download the file "Problem 2-1.xls." 2. Use a PivotTable to sum monthly sales. 3. Modify the Value Field Settings and calculate the % change from one month as compared to the previous month. Part 3-b and 3-c 3-b. What is the percentage change in monthly sales from June to July? (Round your answer to 2 decimal places. Negative percentage should be indicated by a minus sign.) The percentage change in monthly sales from June to July % 3-c. What is the percentage change in monthly sales from November to December? (Round your answer to 2 decimal places.) The percentage change in monthly sales from November to December % 1 2-1.2 2 3 Row Labels Sum of Sales Sum of Sales 4 January 488,388.00 5 February -0.21% 487,364.00 6 March -3.58% 469,935.00 7 April -3.82% 451,966.00 8 May 8.82% 491,823.00 9 June 2.05% 501,923.00 10 July -5.99% 471,868.00 11 August 1.06% 476,883.00 12 September -7.87% 439,365.00 13 October -0.81% 435,811.00 14 November 2.12% 445,057.00 15 December 4.31% 464,258.00 16 Grand Total 17 5,624,641
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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