Can you please explain how to do this in excel. Below is a simple of the information I am given. Ihe information is from 1/1/2011- 12/31/20
a. create a monthly aggregation of sales data input product Amonthly sales in February 2012 input product B montly sales in December 2019 input product C montly sales in April 2017 b. calculate average monthly price what was product A average price in February 2012? what was product B average price in December 2019? what was product Caverage price in April 2017? which month is the discount month for product A? which month is the discount month for product B? which month is the discount month for product C? c. percentage returns by month input product A percentage returns for sales in February 2012 input product B percentage returns for sales in December 2019 input product C percentage returns for sales in April 2017 d. percentage warrantry exercised by month input product A percentage warranty exercises for sales in February 2012 input product B percentage warranty exercises for sales in December 2019 input product C percentage warranty exercises for sales in April 2017 Sales Data B C A Date Units Sold Total Sales 1/1/11 488 $ 195,200.00 1/2/11 578 $ 231,200.00 1/3/11 676 $ 270,400.00 1/4/11 629 $ 251,600.00 1/5/11 737 $ 294,800.00 1/6/11 578 $ 231,200.00 1/7/11 740 $ 296,000.00 1/8/11 661 $ 264,400.00 1/9/11 720 $ 288,000.00 1/10/11 558 $ 223,200.00 1/11/11 559 $ 223,600.00 1/12/11 589 235,600.00 1/13/11 576 $ 230,400.00 1/14/11 654 $ 261,600.00 1/15/11 664 $ 265,600.00 1/16/11 766 $ 306,400.00 1/17/11 609 $ 243,600.00 1/18/11 607 $ 242,800.00 1/19/11 670 $ 268,000.00 1/20/11 623 $ 249,200.00 1/21/11 631 $ 252,400.00 1/22/11 529 $ 211,600.00 1/23/11 725 $ 290,000.00 1/24/11 501 $ 200,400.00 1/25/11 580 $ 232,000.00 1/26/11 629 $ 251,600.00 1/27/11 649 $ 259,600.00 1/28/11 716 $ 286,400.00 1/29/11 721 $ 288,400.00 1/30/11 583 $ 233,200.00 1/31/11 548 $ 219,200.00 2/1/11 671 $268.400.00 Units Sold Total Sales Units Sold Total Sales 676 $ 243,360.00 262 $ 246,280.00 716 $ 257,760.00 319 $ 299,860.00 782 $ 281,520.00 280 $ 263,200.00 752 $ 270,720.00 252 $ 236,880.00 698 $ 251,280.00 300 $ 282,000.00 735 $ 264,600.00 262 $ 246,280.00 789 $ 284,040.00 274 $ 257,560.00 707 $ 254,520.00 282 $ 265,080.00 685 $ 246,600.00 279 $ 262,260.00 629 $ 226,440.00 248 $ 233,120.00 674 $ 242,640.00 258 $ 242,520.00 719 258,840.00 251 235,940.00 512 $ 184,320.00 306 $ 287,640.00 605 $ 217,800.00 286 $ 268,840.00 675 $ 243,000.00 319 $ 299,860.00 718 $ 258,480.00 280 $ 263,200.00 703 $ 253,080.00 256 $ 240,640.00 738 $ 265,680.00 252 $ 236,880.00 781 $ 281,160.00 326 $ 306,440.00 748 $ 269,280.00 201 $ 188,940.00 805 $ 289,800.00 281 $ 264,140.00 689 $ 248,040.00 290 $ 272,600.00 845 $ 304,200.00 279 $ 262,260.00 801 $ 288,360.00 274 $ 257,560.00 713 $ 256,680.00 275 $ 258,500.00 781 $ 281,160.00 2501 $ 235,000.00 826 $ 297,360.00 291 $ 273,540.00 597 $ 214,920.00 247 $ 232,180.00 808 $ 290,880.00 236 $ 221,840.00 728 $ 262,080.00 286 $ 268,840.00 675 $ 243,000.00 234 $ 219,960.00 718 $ 258.480.00 243 $ 228.420.00 Return & Warranty Claims B A Warranty Return Return Warranty Return Warranty 2288 754 238 2790 2673 3085 378 645 693 481 392 415 234 2736 712 715 640 3006 307 2128 2259 3191 3356 0 2046 2257 2300 636 667 275 318 461 714 2920 3109 3028 2945 440 321 728 685 1210 2281 3483 226 3080 459 384 657 661 459 380 520 278 2244 2212 1052 0 305 0 Product Type Wanuary 2011 February 2011 March 2011 April 2011 May 2011 une 2011 uly 2011 August 2011 September 2011 October 2011 Vovember 2011 December 2011 Manuary 2012 February 2012 March 2012 April 2012 May 2012 une 2012 uly 2012 August 2012 September 2012 October 2012 November 2012 December 2012 anuary 2013 February 2013 March 2013 April 2013 May 2013 une 2013 uly 2013 2768 2265 2167 493 354 694 725 401 258 2154 3421 3436 645 794 307 614 806 628 266 686 308 264 235 291 268 273 212 234 249 574 53 401 334 258 305 336 352 378 318 290 258 436 373 539 258 300 347 250 382 2871 3329 2664 3270 2784 2966 3069 2736 3263 0 772 749 357 446 411 314 58 272 2328 2267 1983 2192 2112 2283 2254 362 538 506 340 3356 258 0 489 279 422 722 732 1138 1158 0 707 676 731 674 699 416 361 532 230 397 1914 2019 3066 3433 3159 2288 3121 3125 2787 2861 563 496 357 396 o 654 204 698 a. create a monthly aggregation of sales data input product Amonthly sales in February 2012 input product B montly sales in December 2019 input product C montly sales in April 2017 b. calculate average monthly price what was product A average price in February 2012? what was product B average price in December 2019? what was product Caverage price in April 2017? which month is the discount month for product A? which month is the discount month for product B? which month is the discount month for product C? c. percentage returns by month input product A percentage returns for sales in February 2012 input product B percentage returns for sales in December 2019 input product C percentage returns for sales in April 2017 d. percentage warrantry exercised by month input product A percentage warranty exercises for sales in February 2012 input product B percentage warranty exercises for sales in December 2019 input product C percentage warranty exercises for sales in April 2017 Sales Data B C A Date Units Sold Total Sales 1/1/11 488 $ 195,200.00 1/2/11 578 $ 231,200.00 1/3/11 676 $ 270,400.00 1/4/11 629 $ 251,600.00 1/5/11 737 $ 294,800.00 1/6/11 578 $ 231,200.00 1/7/11 740 $ 296,000.00 1/8/11 661 $ 264,400.00 1/9/11 720 $ 288,000.00 1/10/11 558 $ 223,200.00 1/11/11 559 $ 223,600.00 1/12/11 589 235,600.00 1/13/11 576 $ 230,400.00 1/14/11 654 $ 261,600.00 1/15/11 664 $ 265,600.00 1/16/11 766 $ 306,400.00 1/17/11 609 $ 243,600.00 1/18/11 607 $ 242,800.00 1/19/11 670 $ 268,000.00 1/20/11 623 $ 249,200.00 1/21/11 631 $ 252,400.00 1/22/11 529 $ 211,600.00 1/23/11 725 $ 290,000.00 1/24/11 501 $ 200,400.00 1/25/11 580 $ 232,000.00 1/26/11 629 $ 251,600.00 1/27/11 649 $ 259,600.00 1/28/11 716 $ 286,400.00 1/29/11 721 $ 288,400.00 1/30/11 583 $ 233,200.00 1/31/11 548 $ 219,200.00 2/1/11 671 $268.400.00 Units Sold Total Sales Units Sold Total Sales 676 $ 243,360.00 262 $ 246,280.00 716 $ 257,760.00 319 $ 299,860.00 782 $ 281,520.00 280 $ 263,200.00 752 $ 270,720.00 252 $ 236,880.00 698 $ 251,280.00 300 $ 282,000.00 735 $ 264,600.00 262 $ 246,280.00 789 $ 284,040.00 274 $ 257,560.00 707 $ 254,520.00 282 $ 265,080.00 685 $ 246,600.00 279 $ 262,260.00 629 $ 226,440.00 248 $ 233,120.00 674 $ 242,640.00 258 $ 242,520.00 719 258,840.00 251 235,940.00 512 $ 184,320.00 306 $ 287,640.00 605 $ 217,800.00 286 $ 268,840.00 675 $ 243,000.00 319 $ 299,860.00 718 $ 258,480.00 280 $ 263,200.00 703 $ 253,080.00 256 $ 240,640.00 738 $ 265,680.00 252 $ 236,880.00 781 $ 281,160.00 326 $ 306,440.00 748 $ 269,280.00 201 $ 188,940.00 805 $ 289,800.00 281 $ 264,140.00 689 $ 248,040.00 290 $ 272,600.00 845 $ 304,200.00 279 $ 262,260.00 801 $ 288,360.00 274 $ 257,560.00 713 $ 256,680.00 275 $ 258,500.00 781 $ 281,160.00 2501 $ 235,000.00 826 $ 297,360.00 291 $ 273,540.00 597 $ 214,920.00 247 $ 232,180.00 808 $ 290,880.00 236 $ 221,840.00 728 $ 262,080.00 286 $ 268,840.00 675 $ 243,000.00 234 $ 219,960.00 718 $ 258.480.00 243 $ 228.420.00 Return & Warranty Claims B A Warranty Return Return Warranty Return Warranty 2288 754 238 2790 2673 3085 378 645 693 481 392 415 234 2736 712 715 640 3006 307 2128 2259 3191 3356 0 2046 2257 2300 636 667 275 318 461 714 2920 3109 3028 2945 440 321 728 685 1210 2281 3483 226 3080 459 384 657 661 459 380 520 278 2244 2212 1052 0 305 0 Product Type Wanuary 2011 February 2011 March 2011 April 2011 May 2011 une 2011 uly 2011 August 2011 September 2011 October 2011 Vovember 2011 December 2011 Manuary 2012 February 2012 March 2012 April 2012 May 2012 une 2012 uly 2012 August 2012 September 2012 October 2012 November 2012 December 2012 anuary 2013 February 2013 March 2013 April 2013 May 2013 une 2013 uly 2013 2768 2265 2167 493 354 694 725 401 258 2154 3421 3436 645 794 307 614 806 628 266 686 308 264 235 291 268 273 212 234 249 574 53 401 334 258 305 336 352 378 318 290 258 436 373 539 258 300 347 250 382 2871 3329 2664 3270 2784 2966 3069 2736 3263 0 772 749 357 446 411 314 58 272 2328 2267 1983 2192 2112 2283 2254 362 538 506 340 3356 258 0 489 279 422 722 732 1138 1158 0 707 676 731 674 699 416 361 532 230 397 1914 2019 3066 3433 3159 2288 3121 3125 2787 2861 563 496 357 396 o 654 204 698
