the charts are below the prompt, feel free to comment for any further clarifications
complete the pivot table analysis that was discussed in class. You may use pivot tables and charts. You are to look at the sales categories for each of the four categories and THINK. 1) What items sold the most? 2) What items sold the least and 31 As an analyst you should propose utilizing text boxes) what you would recommend to increase sales. This frattem is up to your imagination however you must show your work and how you came to your analytical conclusion. One hint is to understand what percentage of sales for each item on a quarterly basis. Hint number two is that you should familiarize yourself with the product categories and the item names w Ral am C 4330 G HO ONS Sier We 35 22 125 43 Ou Q 172 DI 3100 11425 os Bawah GO Q SIS RES See 000 TO 391 IM 27 10 TE 710 OPE D 1 111 2011 Oror + TE CEN 1950 Don CH 3200 101 172 > ME UR Ou D Sud ITS ITE IN BUTA 403 7201 TS 151 YO 0 OL Clow CO LE DANCE OM IC HE 147 PI O ONE 06 IVE CON Wh PE Sorted that Sum of Units Sold Column Labels Row Labels Baking on Sanelas Grand Total Brak 4320 1400 17250 15030 21320 10110 2820 3450 Cake Flour Canola Oil Cercal Chocolate Chip Cookie Corn Chips Corn Flakes Corn Oil Fruit Cereal Multi Grain Cookie Oatmeal Cookie Olive Oil Potato Chips Potato Flour Sunflower Oil Wheat Flour White Flour Grand Total 11260 1510 4320 1400 17250 15030 21320 10110 2820 3450 11260 1510 980 530 18750 2810 14710 32050 158300 980 530 18750 2810 14710 32050 69830 30810 8010 49650 Sorted Sales Data Pivot Table 1 Uits sold Unit Price CO Category Brak Sack Hecht Oil Breakfast Sanck Oil 1020 1440 13 3 25 4900 4330 1925 E 540 100 7730 10 . 2.35 Oil Haki Blake Saacks 2100 17425 595 12120 457% 15600 20504 19525 2 T 191 1.14 4200 4600 1100 2.75 S Oil Het Oil Snacks $ 42 24 2.19 Imam Cerval Chocolate Chip Cookie Com Flakes Com O Fruit Cereal Oatmeal Cookie Olive Oil Potate Flour Sunflower oil Wheat Flower Cereal Chocolate Chip Cookie Cam Chips Carol Fruit Cereal Olive Oil Porta Chips Pota Flour Wheat Flour White Per Cola Oil Cercal Chocolate Chip Cookie Comes Fruit Coral Multi Grain Cookie Oatmeal Cookie Olive Oil Sunflower Oil What Fleur White Flour Caker Canals Oil Cercal Cam Chips Com Flakes Com 01 Fruit Cereal Oatmeal Cookie Pot Pour Sunflower Oil While Bolin Taking Oil Break Stacks Sales Date Owner Qure Quarter Quarter Quarter Owner Owner Owner Quarter Quarter Our Owner 2 Oune Oy pre 2 Quarter 2 Quarter 2 Owner Owner 2 Quarter 2 One Quarter Quarter Owner Our Owner 3 One Quan Quarter Quarter Owner Quarter 4 Ouarter4 Ourer Quarter 4 Order 4 Quarter 4 Quarter 4 Quarter 4 Quarter 4 Owner 4 Our 670 340 $30 270 00 20 1040 3150 3520 1900 920 11260 570 14586 15052 73986 10731 132016 34212 11015 190 3919 1004 231 0.93 5.4 101 110 2 141 3.17 Hecks Saada Sacks Oil O Halang 1.90 970 3750 11230 4920 160 1943.7 X76 41122 7275 22994 7516 640 Oil Breakfast Snacks Oil Heakfast Socks Baking Oil Baking 10260 2290 670 1190 400 3710 310 12800 1.74 1.75 05 2.96 0.00 25 142 3.06 0.12 505 19 103696 2367.1 1726 14 20:24 2920.2 3155 430 Your assignment is to complete the pivot table analysis that was discussed in class. You may use pivot tables and charts. You are to look at the sales categories for each of the four categories and THINK. 1) What items sold the most? 2) What items sold the least? and 3) As an analyst you should propose (utilizing text boxes) what you would recommend to increase sales. This final item is up to your imagination however you must show your work and how you came to your analytical conclusion. One hint is to understand what percentage of sales for each item on a quarterly basis. Hint number two is that you should familiarize yourself with the product categories and the item names
