I need help in these questions from the pivot table which I created, Please answer them correctly and fast. I need it in an hour from now

This is part 2

Task 3 Questions: Examine the report to determine if seasonality plays a role in your products' demand. Specifically: 3. Does seasonality play a role in the demand of any of your products? If so, which product(s) are impacted by seasonality? 4. Describe the impact of seasonality for the product(s) identified as seasonal in the previous question (estimate the relative differences in the demand levels for each season from the plot and the pivot table.) 5. Please insert ONE Bar-chart that shows the seasonality of these four products. [Hint: You need to reorganize the data from the pivot table to show all 12 quarters' sales revenue of each product.] Task 3 Seasonality Analysis Report (15 points) There are two competing theories within your company about the demand for the products. Several members of the Marketing Team believe that the demand for all four products varies consistently by the season of the year. In contrast, members of the Engineering Team argue that demand is not impacted by seasonality and steady throughout the year. You have been asked to provide data that will shed light on this issue and end the debate. Prepare a pivot table report that details the Sales Revenue ($) for each product for each season in the three years represented by your data. The report should follow the format below: Sum of Sales Revenue by Season and Year Product Name Season SDD-100 Chip 1: Winter 2: Spring 3: Summer 2006 124832 155803 159744 Year 2007 94816 64352 44704 2008 78336 109184 114880 Grand Total 297984 329344 319328 40 SDD-100 Chip Total SSD-2200 Chip 1: 2: 4: SSD-2200 Chip Total TM-1000X Board 1: 2: Data Omitted from this example. 54 26 B2 54 56 40 00 10 80 60 BO s 375630 320745 1602750 10660206 4: TM-1000X Board Total XU-422 Relay 1: 2: 3: Summer 4: Autumn 183975 159780 783405 3902645 123990 109620 529605 3384621 67665 51345 289740 3372940 XJ-422 Relay Total Grand Total 2 3 Sum of Sales Revenue 4 Product Name 5 OSDD-100 Chip 5 7 3 9 SDD-100 Chip Total 0-SSD-2200 Chip 1 2 3 4 SSD-2200 Chip Total 5 TM-1000X Board 6 7 8 9 TM-1000X Board Total EO XJ-422 Relay Year Season 2007 2008 2009 Grand Total 1: Winter 262528 330336 282560 875424 2: Spring 295712 288768 363168 947648 3: Summer 341152 294912 310816 946880 4: Autumn 299008 289600 261888 850496 1198400 1203616 1218432 3620448 1: Winter 335676 188782 186296 710754 2: Spring 297330 180444 228118 705892 3: Summer 265518 171424 198726 635668 4: Autumn 258324 169708 186296 614328 1156848 710358 799436 2666642 1: Winter 1080840 1100880 1090920 3272640 2: Spring 1839240 1952640 1726680 5518560 3: Summer 2688840 2588040 2925000 8201880 4: Autumn 650640 426720 535800 1613160 6259560 6068280 6278400 18606240 1: Winter 32445 96570 144345 273360 2: Spring 59265 99855 160770 319890 3: Summer 75045 104745 181995 361785 4: Autumn 87690 119640 203280 410610 254445 420810 690390 1365645 8869253 8403064 8986658 26258975 LOOO O ON WN O O O 01 4 XJ-422 Relay Total 25 Grand Total 26 Chart 1 for G G H J K O Sum of Units Sold + 7000 6000 1173 5000 Product Name SDD-100 Chip 4000 O 3000 SSD-2200 Chip O TM-1000X Board 2000 B D E F 1 2 3 Sum of Units Sold Product Name 4 Month SDD-100 Chip SSD-2200 Chip TM-1000X Board XJ-422 Relay Grand Total 5 1 3200 5100 3000 500 11800 62 2676 4898 3016 718 11308 73 2328 5260 2991 945 11524 84 3784 5169 5074 15200 9 5 2358 4793 5124 1297 13572 10 6 3099 3553 5129 1481 13262 117 3904 3152 7595 1696 16347 12 8 4110 4760 7409 1662 17941 13 9 2647 4157 7403 1645 15852 14 10 3372 3772 1807 1740 10691 15 11 2513 4595 1881 1962 10951 16 12 3459 3375 1734 2144 10712 17 13 2858 2280 2988 2143 10269 18 14 4151 2634 3095 2148 12028 19 15 3314 3667 3091 2147 12219 20 16 3619 2291 5475 2120 13505 21 17 2896 2960 5423 2232 13511 22 18 2509 2951 5374 2305 13139 23 19 2200 2844 7157 2332 14533 24 20 3651 1768 7144 2297 14860 25 21 3365 3180 7266 2354 16165 26 22 2703 2830 1118 2463 9114 27 23 3820 1952 1211 2687 9670 28 24 2527 2932 1227 2826 9512 29 25 3058 2094 2938 3059 11149 XJ-422 Relay 1000 0 0 1 3 5 7 9 11 13 15 17 19 21 23 25 27 29 31 33 35 Month O O K > B D. GO 2047 -X1-422 Relay + 1000 3 5 7 9 11 13 15 17 19 21 23 25 27 29 31 33 35 7 4157 3712 5275 2280 2634 BAAZ 2291 2960 2951 3844 4788 2180 Month O 0 NNNN 2858 4151 3314 3619 2896 2509 2200 3651 2265 2703 3820 2527 3058 3214 4408 4104 3119 3137 3745 2831 2547 2742 7403 1049 Tou? 100 1734 2144 2999 2112 3095 2148 2001 2147 5475 2120 5423 2232 5374 2305 7157 2332 7144 2297 7266 2354 1119 2463 1211 2687 1227 2826 2938 3039 3010 --- are 4985 2599 4720 3774 2054 3978 8165 3967 8156 4188 1433 4345 1540 4535 1492 4672 11502 15505291043480445 1000 4063 2211 3995 2594 3874 2565 2482 352 2443 12424 Grand Total 113139 Task 3 Questions: Examine the report to determine if seasonality plays a role in your products' demand. Specifically: 3. Does seasonality play a role in the demand of any of your products? If so, which product(s) are impacted by seasonality? 4. Describe the impact of seasonality for the product(s) identified as seasonal in the previous question (estimate the relative differences in the demand levels for each season from the plot and the pivot table.) 5. Please insert ONE Bar-chart that shows the seasonality of these four products. [Hint: You need to reorganize the data from the pivot table to show all 12 quarters' sales revenue of each product.] Task 3 Seasonality Analysis Report (15 points) There are two competing theories within your company about the demand for the products. Several members of the Marketing Team believe that the demand for all four products varies consistently by the season of the year. In contrast, members of the Engineering Team argue that demand is not impacted by seasonality and steady throughout the year. You have been asked to provide data that will shed light on this issue and end the debate. Prepare a pivot table report that details the Sales Revenue ($) for each product for each season in the three years represented by your data. The report should follow the format below: Sum of Sales Revenue by Season and Year Product Name Season SDD-100 Chip 1: Winter 2: Spring 3: Summer 2006 124832 155803 159744 Year 2007 94816 64352 44704 2008 78336 109184 114880 Grand Total 297984 329344 319328 40 SDD-100 Chip Total SSD-2200 Chip 1: 2: 4: SSD-2200 Chip Total TM-1000X Board 1: 2: Data Omitted from this example. 54 26 B2 54 56 40 00 10 80 60 BO s 375630 320745 1602750 10660206 4: TM-1000X Board Total XU-422 Relay 1: 2: 3: Summer 4: Autumn 183975 159780 783405 3902645 123990 109620 529605 3384621 67665 51345 289740 3372940 XJ-422 Relay Total Grand Total 2 3 Sum of Sales Revenue 4 Product Name 5 OSDD-100 Chip 5 7 3 9 SDD-100 Chip Total 0-SSD-2200 Chip 1 2 3 4 SSD-2200 Chip Total 5 TM-1000X Board 6 7 8 9 TM-1000X Board Total EO XJ-422 Relay Year Season 2007 2008 2009 Grand Total 1: Winter 262528 330336 282560 875424 2: Spring 295712 288768 363168 947648 3: Summer 341152 294912 310816 946880 4: Autumn 299008 289600 261888 850496 1198400 1203616 1218432 3620448 1: Winter 335676 188782 186296 710754 2: Spring 297330 180444 228118 705892 3: Summer 265518 171424 198726 635668 4: Autumn 258324 169708 186296 614328 1156848 710358 799436 2666642 1: Winter 1080840 1100880 1090920 3272640 2: Spring 1839240 1952640 1726680 5518560 3: Summer 2688840 2588040 2925000 8201880 4: Autumn 650640 426720 535800 1613160 6259560 6068280 6278400 18606240 1: Winter 32445 96570 144345 273360 2: Spring 59265 99855 160770 319890 3: Summer 75045 104745 181995 361785 4: Autumn 87690 119640 203280 410610 254445 420810 690390 1365645 8869253 8403064 8986658 26258975 LOOO O ON WN O O O 01 4 XJ-422 Relay Total 25 Grand Total 26 Chart 1 for G G H J K O Sum of Units Sold + 7000 6000 1173 5000 Product Name SDD-100 Chip 4000 O 3000 SSD-2200 Chip O TM-1000X Board 2000 B D E F 1 2 3 Sum of Units Sold Product Name 4 Month SDD-100 Chip SSD-2200 Chip TM-1000X Board XJ-422 Relay Grand Total 5 1 3200 5100 3000 500 11800 62 2676 4898 3016 718 11308 73 2328 5260 2991 945 11524 84 3784 5169 5074 15200 9 5 2358 4793 5124 1297 13572 10 6 3099 3553 5129 1481 13262 117 3904 3152 7595 1696 16347 12 8 4110 4760 7409 1662 17941 13 9 2647 4157 7403 1645 15852 14 10 3372 3772 1807 1740 10691 15 11 2513 4595 1881 1962 10951 16 12 3459 3375 1734 2144 10712 17 13 2858 2280 2988 2143 10269 18 14 4151 2634 3095 2148 12028 19 15 3314 3667 3091 2147 12219 20 16 3619 2291 5475 2120 13505 21 17 2896 2960 5423 2232 13511 22 18 2509 2951 5374 2305 13139 23 19 2200 2844 7157 2332 14533 24 20 3651 1768 7144 2297 14860 25 21 3365 3180 7266 2354 16165 26 22 2703 2830 1118 2463 9114 27 23 3820 1952 1211 2687 9670 28 24 2527 2932 1227 2826 9512 29 25 3058 2094 2938 3059 11149 XJ-422 Relay 1000 0 0 1 3 5 7 9 11 13 15 17 19 21 23 25 27 29 31 33 35 Month O O K > B D. GO 2047 -X1-422 Relay + 1000 3 5 7 9 11 13 15 17 19 21 23 25 27 29 31 33 35 7 4157 3712 5275 2280 2634 BAAZ 2291 2960 2951 3844 4788 2180 Month O 0 NNNN 2858 4151 3314 3619 2896 2509 2200 3651 2265 2703 3820 2527 3058 3214 4408 4104 3119 3137 3745 2831 2547 2742 7403 1049 Tou? 100 1734 2144 2999 2112 3095 2148 2001 2147 5475 2120 5423 2232 5374 2305 7157 2332 7144 2297 7266 2354 1119 2463 1211 2687 1227 2826 2938 3039 3010 --- are 4985 2599 4720 3774 2054 3978 8165 3967 8156 4188 1433 4345 1540 4535 1492 4672 11502 15505291043480445 1000 4063 2211 3995 2594 3874 2565 2482 352 2443 12424 Grand Total 113139