When setting up the pivot tables, please pay attention to the setup in the fields panel on the right and not the results. Your fields panel setup should be identical to the example even though your results do not.

Only get graded on the setup/settings of the field panel.

[ FIRST SHEET DOWN BELOW ]

[SECOND SHEET DOWN BELOW]

[THIRD SHEET DOWN BELOW] : ITS AN EXAMPLE ON HOW THE ANSWER SHOULD LOOK LIKE

Please note the steps listed on the "Instructions " sheet are not the complete steps and you need to manipulate some of the fields' settings to arrive at the provided example. Select the data and name the table Raw_Data before formatting it as a table. Please pay close attention to the fields dragged to the field list to make the results look like the example. Please use Currency style for all money amounts and make sure your field list selections match those of the examples. H11 G H M N J B C D E F KL 1 You will need two separate Pivot Tables similar to the Results Example. Both on this document on separate sheets. 2 Select the data and place it in a table (Use Format as a Table and select the option of your choice). 3 Use Insert/PivotTable and place the results on a separate sheet. 4 Use the examples in the "Results Example" Sheet to add the fields in the PivotTable Field List. s Please note all money amounts should be in currency format and all numbers should have two decimal points (if any). 6 Exceptions: Currency exchange rate and stock market. 7 You can always group by a field using the right click on the field. 8 Save the document as Your Name Last Name Assignment 3. 9 Submit on Titanium 10 11 12 13 D H J lakia Markup % 400% 204% 543% Cahier 1 2 3 4 1 2 3 DI uuuuuuuuu 331% 4 1 2 3 4 1 lulus 2 3 4 1 2 4 1 2 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 Date Product Department 1/1/13 Dry Beans Dry Goods 1/2/13 Onion Produce 1/3/13 Spaghetti Dry Goods 1/4/13 Cauliflower Produce 1/5/13 Grapes Produce 1/6/13 Apples Produce 1/7/13 Lettuce Produce 1/8/13 Canned Soup Dry Goods 1/9/13 Frozen Peas Frozen 1/10/13 Flour Dry Goods 1/11/13 Sugar Dry Goods 1/12/13 Frozen Pizza Frozen 1/13/13 Whale Chicken Meat 1/14/13 Cold Cuts Deli 1/15/13 Cheese Deli 1/16/13 Macaroni Salad Deli 1/17/13 Ice Cream Frozen 1/18/13 Chicken Legs Meat 1/19/13 Ground Beef Meat 1/20/13 Chuck Steak Meat 1/21/13 Fresh Fish Meat 1/22/13 Shrimp Meat 2/1/13 Dry Beans Dry Goods 2/2/13 Onion Produce 2/3/13 Spaghetti Dry Goods 2/4/13 Cauliflower Produce 2/5/13 Grapes Produce 2/6/13 Apples Produce 2/7/13 Lettuce Produce 2/8/13 Canned Soup Dry Goods 2/9/13 Frozen Peas Frozen 2/10/13 Flour Dry Goods 2/11/13 Sugar Dry Goods 2/12/13 Frozen Pizza Frozen 2/13/13 Whole Chicken Meat 2/14/13 Cold Cuts Deli 2/15/13 Cheese Deli 2/16/13 Macaroni Salad Dell 2/17/13 Ice Cream Frozen 2/18/13 Chicken Legs Meat 2/19/13 Ground Beef Meat 2/20/13 Chuck Steak Meat 2/21/13 Fresh Fish Meat 2/22/13 Shrimp Meat 3/1/13 Dry Beans Dry Goods 32/13 lnian Prana Category Vegetable Vegetable Pasta Vegetable Fruit Fruit Vegetable Soup Vegetable Baking Baking Dinners Chicken Meat Cheese Salad Dessert Chicken Beef Beef Fish Fish Vegetable Vegetable Pasta Vegetable Fruit Fruit Vegetable Soup Vegetable Baking Baking Dinners Chicken Meat Cheese Salad Dessert Chicken Beef Beef Fish Fish Vegetable Verwahl Gross Sales Cost Markup Amount $ 1,302.00 $ 260.40 $ 1,041.60 $ 1,367.10 $ 449.19 $ 917.91 $ 1,725.15 $ 268.21 $ 1,456.94 $ 1,620.99 $ 376 28 $ 1,244.71 $ 1,895.71 $ 475.23 $ 1,420.48 $ 1,649.63 $ 223.94 $ 1.425.69 $ 1,890.50 $ 471.32 $ 1.419.18 $ 2,648.27 $ 356.75 2,29152 $ 1,302.00 $ 706.99 $ 595.01 $ 1,367.10 $ 615.85 75125 $ 1,725.15 $ 404.92 $ 1,320.23 $ 1,620.99 $ 956.97 $ 664.02 $ 1895.71 $ 355.45 $ 1,540.27 $ 1,649.63 $ 2,429.53 $ (779.90) $ 1,890.50 $ 4,743.19 $ (2,852.68) $ 2,648.27 304.67 $ 2,343.60 $ 2,523.28 $ 734.33 $ 1,788.95 $ 3,300.57 $ 850.21 $ 2,450.36 $ 4,231.50 $ 318.99 $ 3,912.51 $ 9,509.81 $ 424.45 $ 9,085.36 $ 8,255.98 $ 85151 $ 7,404.47 $ 10,021.49 $ 1283.77 $ 8,737.72 $ 953.00 $ 190.60 $ 762.40 $ 1,000.65 $ 328.79 671.87 $ 1 262.73 $ 196.32 $ 1,066.41 $ 1,186.49 $ 275.42 911.07 $ 1,387.57 $ 347.85 $ 1,039.72 $ 1 207.45 $ 163.92 1,043.54 $ 1,383.76 $ 344.99 $ 1,038.77 $ 1,938.40 $ 261.12 1,677.28 $ 1,846.91 $ 517.48 $ 1,329.44 $ 2,415.86 $ 450.72 $ 1,965.09 $ 3,097.25$ 296.38 $ 2,800.87 $ 6,960.71 $ 700.46 $ 6,260.26 $ 6,042.97 $ 260.17 $ 5,782.80 $ 4,423.83 $ 1,778.30 $ 2,645.53 $ 6,045.83 $ 3,471.78 $ 2,574.05 $ 3,111.55 $ 223.00 $ 2.888.54 $ 1,383.76 $ 537.49 $ 846.26 $ 1,938.40 $ 622.31 $ 1,316.09 $ 1,846.91 $ 233.49 $ 1,613.43 $ 2.415.86 $ 310.68 $ 2,105.18 $ 3,097 25 $ 623.26 $ 2.473.99 $ 6,960.71 $ 939.66 $ 6,021.05 $ 6,042.97 $ 198.20 $ 5,844.77 4423.82 374190 $ 408192 4 Salespersol Mary Kari Larry Jerry Perry Gary Mary Kari Larry Jerry Perry Gary Mary Kari Larry Jerry Perry Gary Mary Kari Larry Jerry Perry Gary Mary Kari Larry Jerry Perry Gary Mary Kari Larry Jerry Perry Gary Mary Kari Larry Jerry Perry Gary Mary Kari Larry Tary 299% 637% 301% 642% 84% 122% 326% 69% 433% -32% -60% 769% 244% 288% 1227% 2140% 870% 681% 400% 204% 543% 331% 299% 637% 301% 642% 257% 436% 945% 894% 2223% 149% 74% 1295% 157% 211% 691% 678% 397% 641% 2949% 11949 1 2 4 1 2 WN 4 luu 1 2 3 4 1 2 1 2 3 4 1 2 3 uuuu Category Gross Sales - Cost Markup Amount Markup % Salesperson Cahier 4 1 2 4 1 2 4 1 2 Deli 4 1 2 4 1 2 Vegetable Pasta Vegetable Fruit Fruit Vegetable Soup Vegetable Baking Baking Dinners Chicken Meat Cheese Salad Dessert Chicken Beef Beef Fish Fish Vegetable Vegetable Pasta Vegetable Fruit Fruit Vegetable Soup Vegetable uuu 4 A Product Department 3/2/13 Onion Produce 3/3/13 Spaghetti Dry Goods 3/4/13 Cauliflower Produce 3/5/13 Grapes Produce 3/6/13 Apples Produce 3/7/13 Lettuce Produce 3/8/13 Canned Soup Dry Goods 3/9/13 Frozen Peas Frozen 3/10/13 Flour Dry Goods 3/11/13 Sugar Dry Goods 3/12/13 Frozen Pizza Frozen 3/13/13 Whole Chicken Meat 3/14/13Cold Cuts 3/15/13 Cheese Deli 3/16/13 Macaroni Salad Deli 3/17/13 Ice Cream Frozen 3/18/13 Chicken Legs Meat 3/19/13 Ground Beel Meat 3/20/13 Chuck Steak Meat 3/21/13 Fresh Fish Meat 3/22/13 Shrimp Meat 4/1/13 Dry Beans Dry Goods 4/2/13 Onion Produce 4/3/13 Spaghetti Dry Goods 4/4/13 Cauliflower Produce 4/5/13 Grapes Produce 4/6/13 Apples Produce 4/7/13 Lettuce Produce 4/8/13 Canned Soup Dry Goods 4/9/13 Frozen Peas Frozen 4/10/13 Flour Dry Goods 4/11/13 Sugar Dry Goods 4/12/13 Frozen Pizza Frozen 4/13/13 Whole Chicken Meat 4/14/13 Cold Cuts Deli 4/15/13 Cheese Deli 4/16/13 Macaroni Salad Deli 4/17/13 Ice Cream Frozen 4/18/13 Chicken Legs Meat 4/19/13 Ground Beef Meat 4/20/13 Chuck Steak 4/21/13 Fresh Fish Meat 4/22/13 Shrimp Meat 5/1/13 Dry Beans Dry Goods 5/2/13 Onion Produce 5/3/13 Spaghetti Dry Goods 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 1 2 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 4,423.83 6,045.83 6,283.93 4,600.22 6,286.90 3,235.62 5,596.18 3,225.71 6,298.80 2,543.90 3,730.12 7,627.73 4,600.22 6,286.90 3,235.62 5,596.18 3,225.71 6,298.80 2,543.90 3,730.12 7,627.73 1,087.60 1,141.98 1,441.07 1,354.06 1,583.55 1,377.99 1,579.20 2.212.18 2,107.77 2,757.07 3,534.70 7,943.83 6,896.47 5,048.64 6,899.73 3,551.01 6,141.68 3,540.14 6,912.79 2,791.87 4,093.73 8,371.26 1,319.00 1381.25 1,723.63 $ 341.90 $ $ 204.15 $ $ 286.40 $ $ 361.72 $ $ 170.45 $ $ 358.74 $ $ 27153 $ $ 538.11 $ $ 468.74 $ $ 308.20 $ $ 728.39 $ $ 270.54 $ $ 1,849.21 $ $ 3,610 21 $ $ 231.89 $ $ 558.92 $ $ 647.12 $ $ 242.80 $ $ 323.07 $ $ 648.11 $ $ 977.13 $ $ 217.52 $ $ 375.22 $ $ 224.05 $ $ 314.32 $ $ 396.97 $ $ 187.07 $ $ 393.71 $ $ 298.00 $ $ 590.57 $ $ 514.43 $ $ 338.24 $ $ 799.39 $ $ 296.91 $ $ 2,029.46 $ $ 3,962.13 $ $ 254.50 $ $ 613.41 $ $ 710.20 $ $ 266.46 $ $ 354.56 $ $ 711.29 $ $ 1,072.37 $ $ 323.00 $ $ 503.53 $ $ 330.47 $ 4,081.93 5,841.69 5,997.53 4,238.51 6,116.45 2,876.87 5,324.64 2,687.59 5,830.05 2,235.70 3,001.74 7,357.18 2,751.02 2,676.69 3,003.72 5,037.25 2,578.58 6,056.00 2.220.83 3,082.01 6,650.60 870.08 766.76 1,217.02 1,039.75 1,186.57 1,190.92 1,185.48 1,914.18 1,517.20 2.242.63 3,196.46 7,144.44 6,599.56 3,019.18 2.937.61 3,296.52 5,528.27 2.829.94 6,646.32 2.437.31 3,382.44 7,298.88 996.00 877.73 1,393.16 1194% 2862% 2094% 1172% 3588% 802% 1961% 499% 1244% 725% 412% 2719% 149% 74% 1295% 901% 398% 2494% 687% 476% 681% 400% 204% 543% 331% 299% 637% 301% 642% 257% 436% 945% 894% 2223% 149% 74% 1295% 901% 398% 2494% 687% 476% 681% 308% 174% 422% Jerry Perry Gary Mary Kari Larry Jerry Perry Gary Mary Kari Larry Jerry Perry Gary Mary Kari Larry Jerry Perry Gary Mary Kari Larry Jerry Perry Gary Mary Kari Larry Jerry Perry Gary Mary Kari Larry Jerry Perry Gary Mary Kari Larry Jerry Perry Gary Mary 4 1 2 4 Baking 1 2 4 1 2 3 PWN Baking Dinners Chicken Meat Cheese Salad Dessert Chicken Beef Beef Fish Fish Vegetable Vegetable uuuuuu Meat 1 2 3 4 1 2 3 4 1 Nm urulu Pasta A Cahier 4 91 92 93 la 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 LLL lele Mary 111 112 Product Department 5/2/13 Onion Produce 5/3/13 Spaghetti Dry Goods 5/4/13 Cauliflower Produce 5/5/13 Grapes Produce 5/6/13 Apples Produce 5/7/13 Lettuce Produce 5/8/13 Canned Soup Dry Goods 5/9/13 Frozen Peas Frozen 5/10/13 Flour Dry Goods 5/11/13 Sugar Dry Goods 5/12/13 Frozen Pizza Frozen 5/13/13 Whole Chicken Meat 5/14/13Cold Cuts Deli 5/15/13 Cheese Deli 5/16/13 Macaroni Salad Deli 5/17/13 Ice Cream Frozen 5/18/13 Chicken Legs Meat 5/19/13 Ground Beef Meat 5/20/13 Chuck Steak Meat 5/21/13 Fresh Fish Meat 5/22/13 Shrimp Meat 6/1/13 Dry Beans Dry Goods 6/2/13 Onion Produce 6/3/13 Spaghetti Dry Goods 6/4/13 Cauliflower Produce 6/5/13 Grapes Produce 6/6/13 Apples Produce 6/7/13 Lettuce Produce 6/3/13 Canned Soup Dry Goods 6/9/13 Frozen Peas Frozen 6/10/13 Flour Dry Goods 6/11/13 Sugar Dry Goods 6/12/13 Frozen Pizza Frozen 6/13/13 Whole Chicken Meat 6/14/13 Cold Cuts Deli 6/15/13 Cheese Deli 6/16/13 Macaroni Salad Deli 6/17/13 Ice Cream Frozen 6/18/13 Chicken Legs Meat 6/19/13 Ground Beef Meat 6/20/13 Chuck Steak Meat 6/21/13 Fresh Fish Meat 6/22/13 Shrimp Meat 7/1/13 Dry Beans Dry Goods 7/2/13 Onion Produce 7/3/13 Spaghetti Dry Goods 7/4/13 Cauliflower practure 113 Category Vegetable Pasta Vegetable Fruit Fruit Vegetable Soup Vegetable Baking Baking Dinners Chicken Meat Cheese Salad Dessert Chicken Beef Beef Fish Fish Vegetable Vegetable Pasta Vegetable Fruit Fruit Vegetable Soup Vegetable Baking Baking Dinners Chicken Meat Cheese Salad Dessert Chicken Beef Beef Fish Fish Vegetable Vegetable Pasta Ventah Gross Sales Cost Markup Amount $ 1,381.25$ 503.53 $ 877.73 $ 1,723.63 $ 330.47 $ 1,393.16 $ 1,624.03 $ 433.81 $ 1,190 22 $ 1,886.72 $ 528.43 $ 1,358.30 $ 1,651.42 $ 288.14 $ 1,363 28 $ 1,881.74 $ 524.69 $ 1,357.05 $ 2,606.33 415.13 $ 2,191.20 $ 2,486.81 $ 750.04 $ 1,736.78 $ 3,230.08 50120 $ 2,728.87 $ 4,120.25 $ 365.34 $ 3,754.91 $ 9,167.48$ 446.47 $ 8,721.01 $ 7,968.55 $ 520.75 $ 7,447.80 $ 5,853.29 332.11 $ 5,521.18 $ 7,972.28 $ 517.82 $ 7,454.46 $ 4,138.93 431.81 $ 3,707.12 $ 7,104.52 $ 694.73 $ 6,409.79 $ 4,126.48$ 626.31 $ 3,500.17 $ 7,987.22 $ 467.97 $ 7,519.25 $ 3,269.92 $ 882.39 $ 2,38753 $ 4,760.18$ 430.83 $ 4,329.35 $ 9,656.77 $ 1,987 82 $ 7,668.94 $ 1,149.00 $ 245.00 $ 904.00 1,205.50 $ 408.85 $ 796.65 1,516.25 $ 251.78 $ 1,264.47 1,425.85 $ 345.57 $ 1,080.28 1,664.28 $ 431.45 $ 1,232.83 1,450.71 $ 213.36 $ 1,23735 1,659.76 $ 428.06 $ 1,231.70 2,317.42 $ 328.62 $ 1,988.80 2,208.94 $ 632.59 $ 1,576.35 2,883.55 $ 553.49 $ 2,330.06 $ 3,691.50 $ 370.43 $ 3,321.07 8,272.52 $ 849.55 $ 7,422.97 $ 7,184.33 $ 327.49 $ 6,856.84 5,264.46 $ 2,127.58 $ 3,136.88 7,187.72$ 4,135.59 $ 3,052.13 $ 3,708.45 $ 283.42 $ 3.425.03 6,400.11 $ 656.32 $ 5,743.79 $ 3,697.15 $ 756.89 $ 2,940.26 7,201.28 $ 295.85 $ 6,905.43 $ 2,919.71 $ 387.38 $ 2,532.33 4,272.32 $ 758.02 $ 3,514.30 $ 8,716.61 $ 1,133.18$ 7,583.43 1.499.33 $ 431 07 $ 1,068.26 $ 1,566.10 $ 624.69 $ 941.41 $ 4,126.48 $ 439.08 $ 3,687.40 798722 54991 $ 743731 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 1 2 3 4 Markup % Salesperson 174% Gary 422% Mary 274% Kari 257% Larry 473% Jerry 259% Perry 528% Gary 232% Mary 544% Kari 1028% Larry 1953% Jerry 1430% Perry 1662% Gary 14409 Mary 859% Kari 923% Larry 559% Jerry 1607% Perry 271% Gary 1005% 386% Kari 369% Larry 195% Jerry 502% Perry 313% Gary 286% 580% Kari 288% Larry 605% Jerry 249% Perry 421% Gary 897% 874% Kari 2094% Larry 147% Jerry 74% Perry 1208% Gary 875% Mary 388% Kari 2334% Larry 654% Jerry 464% Perry 669% Gary 248% Mary 151% Kari 840% Larry 1215.20 Terry 114 nnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn 115 ... 116 Mary 117 118 119 120 121 122 LIITTI Mary 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 ... 1 2 3 4 1 2 3 Salesperson Cahier 1 Pasta ..... uuuuuuuuuuuuuu Larry Jerry Perry Gary Mary Kari Larry Jerry Perry Gary Mary Kari Larry Jerry Perry $ 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 A Product Department 212/13 VIRO FIGUULE 7/3/13 Spaghetti Dry Goods 7/4/13 Cauliflower Produce 7/5/13 Grapes Produce 7/6/13 Apples Produce 777/13 Lettuce Produce 7/8/13 Canned Soup Dry Goods 7/9/13 Frozen Peas Frozen 7/10/13 Flour Dry Goods 7/11/13 Sugar Dry Goods 7/12/13 Frozen Pizza Frozen 7/13/13 Whole Chicken Meat 7/14/13Cold Cuts Deli 7/15/13 Cheese Deli 7/16/13 Macaroni Salad Deli 7/17/13 Ice Cream Frozen 7/18/13 Chicken Legs Meat 7/19/13 Ground Beef Meat 7/20/13 Chuck Steak Meat 7/21/13 Fresh Fish Meat 7/22/13 Shrimp Meat 8/1/13 Dry Beans Dry Goods 8/2/13 Onion Produce 8/3/13 Spaghetti Dry Goods 8/4/13 Cauliflower Produce 8/5/13 Grapes Produce 8/6/13 Apples Produce 8/7/13 Lettuce Produce 8/8/13 Canned Soup Dry Goods 8/9/13 Frozen Peas Frozen 8/10/13 Flour Dry Goods 8/11/13 Sugar Dry Goods 8/12/13 Frozen Pizza Frozen 8/13/13 Whole Chicken Meat 8/14/13 Cold Cuts Deli 8/15/13 Cheese Deli 8/16/13 Macaroni Salad Deli 8/17/13 Ice Cream Frozen 8/18/13 Chicken Legs Meat 8/19/13 Ground Beef Meat 8/20/13 Chuck Steak Meat 8/21/13 Fresh Fish Meat 8/22/13 Shrimp Meat 9/1/13 Dry Beans Dry Goods 9/2/13 Onion Produce 9/3/13 Spaghetti Dry Goods 9/4/13 Cauliflower Produce Category Gross Sales Cost Markup Amount Vegeu 1.Uu.co U23 9 $ 4,126.48 $ 439.08 $ 3,687.40 Vegetable 7,987.22 $ 549.91 $ 743731 Fruit 3,269.92 $ 651.40 $ 2,618.52 Fruit 4,760.18 $ 393.68 $ 4,366.50 Vegetable 9,656.77 $ 647.39 $ 9,009.38 Soup 1,149.00 $ 529.88 $ 619.12 Vegetable 1,205.50 $ 889.08 $ 316.42 Baking 1,516.25 $ 795.61 $ 720.64 Baking 1,425.85 $ 579.29 $ 846.56 Dinners 1,664.28 $ 1,145.47 $ 518.81 Chicken 1,450.71 $ 528.55 $ 922.16 Meat 1,659.76 $ 2,655.73 $ (995.97] Cheese 2,317.42 $ 5,028.61 $ (2,711.19) Salad 2,208.94 $ 476.47 $ 1,732.47 Dessert 2.883.55 $ 917.13 $ 1,966.42 Chicken 3,69150 $ 1,035.97 $ 2,655.53 Beef 8,272.52 $ 491.16 $ 7,781.36 Beef 7,184.33 $ 599.32 $ 6,585.01 Fish 5,264.46 $ 1,037.31 $ 4,227.15 Fish 7,187.72 $ 1.480.64 $ 5,707.08 Vegetable 3,708.45 $ 359.48 $ 3,348.97 Vegetable 6,400.11 501.20 $ 5,898.91 Pasta 3,697.15 $ 365.34 $ 3,331.81 Vegetable 7,201.28 446.47 $ 6,754.81 Fruit $ 2,919.71 520.75 $ 2,398.96 Fruit 4,272.32 332.11 $ 3,940.21 Vegetable $ 8,716.61 517.82 $ 8,198.79 Soup 1,499.33 431.81 $ 1,067.52 Vegetable $ 1,566.10 694.73 $ 87137 Baking 1,933.31 $ 626.31 $ 1,307.01 Baking $ 1826.49 $ 467.97 $ 1,358.52 Dinners $ 2,108.24 $ 882.39 $ 1,225.86 1655 165 42012 S 1.425.04 Christopher Cortes case analysis 2 $ 115.08 Cheese 2.880.06 $ 3,724.66 $ (844.59) Salad $ 2,751.87 $ 392.71 $ 2,359.16 Dessert $ 3,549.06 715.25 $ 2,833.81 Chicken $ 4,503.83 802.24 $ 3,70159 Beef $ 6,376.33 403.46 $ 5,972.87 Beel $ 2,672.98 482.63 $ 2,190.35 Fish 3,842.92 803.22 $ 3,039.70 Fish $ 7,687.02 $ 1,127.71 $ 6,559.31 Vegetable $ 1,180.37 367.27 $ 813.10 Vegetable $ 1.231.19 514.65 $ 716.54 Pasta 1,510.69 $ 373.37 $ 1,137.32 Vegetable 1,429.38 $ 457.73 $ 971.65 uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu FFTTTTTTTTTTTTTTTTT Markup % IJU 840% 1352% 402% 1109% 1392% 117% 36% 91% 146% 45% 174% -38% -54% 364% 214% 256% 1584% 1099% 408% 385% 932% 1177% 912% 1513% 461% 1186% 1583% 247% 125% 209% 290% 139% 331% 6% -23% 601% 396% 461% 1480% 454% 378% 582% 221% 139% 305% 212% lulululululusu Gary Mary Kari Larry Jerry Perry Gary Mary Kari Larry Jerry Perry Gary Mary Kari Larry Jerry Perry Gary 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4. 1 2 3 4 Mary Kari Larry Jerry Perry Gary lela Mary Kari Mary Kari Larry Jerry lili A Category Gross Sales Cost Markup Amount Markup % Salesperson Cahler 1 4 ula uuuuuuuuu Jerry Perry Gary Mary Kari Larry Jerry Perry Gary Mary Kari Larry Jerry Perry Gary Mary Kari Larry Jerry Frozen 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 Perry Gary Product Department 9/4/13 Cauliflower Produce 9/5/13 Grapes Produce 9/6/13 Apples Produce 977/13 Lettuce Produce 9/8/13 Canned Soup Dry Goods 9/9/13 Frozen Peas Frozen 9/10/13 Flour Dry Goods 9/11/13 Sugar Dry Goods 9/12/13 Frozen Pizza Frozen 9/13/13 Whole Chicken Meat 9/14/13 Cold Cuts Deli 9/15/13 Cheese Deli 9/16/13 Macaroni Salad Deli 9/17/13 Ice Cream 9/18/13 Chicken Legs Meat 9/19/13 Ground Beel Meat 9/20/13 Chuck Steak Meat 9/21/13 Fresh Fish Meat 9/22/13 Shrimp Meat 10/1/13 Dry Beans Dry Goods 10/2/13 Onion Produce 10/3/13 Spaghetti Dry Goods 10/4/13 Cauliflower Produce 10/5/13 Grapes Produce 10/6/13 Apples Produce 10/7/13 Lettuce Produce 10/8/13 Canned Soup Dry Goods 10/9/13 Frozen Peas Frozen 10/10/13 Flour Dry Goods 10/11/13 Sugar Dry Goods 10/12/13 Frozen Pizza Frozen 10/13/13 Whole Chicken Meat 10/14/13 Cold Cuts Deli 10/15/13 Cheese Deli 10/16/13 Macaroni Salad Deli 10/17/13 Ice Cream Frozen 10/18/13 Chicken Legs Meat 10/19/13 Ground Beef Meat 10/20/13 Chuck Steak Meat 10/21/13 Fresh Fish Meat 10/22/13 Shrimp Meat 10/23/13 Dry Beans Dry Goods 10/24/13 Onion Produce 10/25/13 Spaghetti Dry Goods 10/26/13 Cauliflower Produce 10/27/13 Grapes Produce Vegetable $ 1,429.38 $ 457.73 $ Fruit $ 1,643.83 $ 534.97 $ Fruit $ 1,451.74 $ 338.82 $ Vegetable $ 1,639.77 $ 531.93 $ Soup $ 2,231 30 $ 442.49 $ Vegetable $ 2,133.72 $ 715.89 $ Baking $ 2,740.50 $ 644.74 $ Baking $ 3,467.20 $ 480.09 $ Dinners $ 7,58756 $ 911.03 $ Chicken $ 6,608.80 $ 441.47 $ Meat $ 4,881.99 $ 2,060.55 $ Cheese $ 6,61185 $ 651.40 $ Salad $ 3.482.45 $ 393.68 $ Dessert $ 5,903.44 $ 647.39 $ Chicken $ 3,472.28 $ 529.88 $ Beef $ 6,624.05 $ 889.08 $ Beef $ 2,773.02 $ 795.61 $ Fish $ 3,989.62 $ 579.29 $ Fish $ 7987.00 $ 1,145.47 $ Vegetable $ 1,279.44 $ 528.55 $ Vegetable $ 1,335.21 $ 2,655.73 $ Pasta $ 1,641.96 $ 5,028.61 $ Vegetable $ 1,552.73 $ 476.47 $ Fruit $ 1,788.08 $ 917.13 $ Fruit $ 1,577.27 $ 1,035.97$ Vegetable $ 1,783.62 $ 491.16 $ Soup $ 2,432.81 $ 599.32 $ Vegetable $ 2,325.73 $ 1,037.31 $ Baking $ 2,991.65 $ 1.480.64 $ Baking $ 3,789.19 $ 359.48 $ Dinners $ 8,311.19 $ 501.20 $ Chicken $ 7,237.02 $ 365.34 $ Meat $ 5.341 88$ 446 47 $ Christopher Cortes case analysis 2 $ uwa 32.11 $ Dessert $ 6,462.90 $ 51782 $ Chicken $ 3,794.77 $ 431.81 $ Beef $ 7,253.75 $ 694.73 $ Beef $ 3,027.34 $ 626.31 $ Fish $ 4,362.53 $ 467.97 $ Fish $ 8,749.56 $ 882.39 $ Vegetable $ 1,516.77 $ 430.83 $ Vegetable $ 1,580.61 $ 1,98782 $ Pasta $ 1931.75 $ 3,724.66 $ Vegetable $ 1829.60 $ 392.71 $ Fruit $ 2,099.02 $ 715.25 $ olalalalalalalalala 971.65 1,108.86 1,112.92 1,107.84 1,788.81 1,417 84 2,095.75 2,987.11 6,676.53 6,16733 2.821.44 5,960.45 3,088.77 5,256.05 2,942.40 5,734.96 1,977.41 3,410.33 6,841.53 750.90 (1,320.51) (3,386.65) 1,076.26 870.96 541.29 1,292.47 1,833.49 1,288.42 1,511.01 3,429.71 7,809.99 6,871.68 4,895.42 6,719.62 3,473.8 5,945.09 3,362.96 6,559.03 2,401.03 3,894.56 7,867.17 1,085.94 (407-21) (1,792.91) 1,436.89 1,383.77 212% 207% 328% 208% 404% 198% 325% 622% 733% 1397% 137% 915% 785% 812% 555% 645% 249% 589% 597% 142% -50% -67% 226% 95% 52% 263% 306% 124% 102% 954% 1558% 1881% 1096% 1290% 1046% 1148% 779% 944% 383% 832% 892% 252% -20% -48% 366% 193% 1 2 3 4 1 2 3 4 1 2 3 4 1 2 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 Mary Kari Larry Jerry Perry Gary Mary Kari Larry Juuru Jerry Perry , wa Gary Mary Kari Larry Jerry Perry Gary Mary Kari Larry Jerry Perry Gary Mary 1 woulululululu will 2 3 4 1 2 3 lua Markup % Salesperson Cahler 3 4 Ivyllylly 1 2 3 4 1 2 3 4 1 2 3 4 slo 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 Product Department 10/27/13 Grapes Produce 10/28/13 Apples Produce 10/29/13 Lettuce Produce 10/30/13 Canned Soup Dry Goods 10/31/13 Frozen Peas Frozen 11/1/13 Flour Dry Goods 11/2/13 Sugar Dry Goods 11/3/13 Frozen Pizza Frozen 11/4/13 Whole Chicken Meat 11/5/13 Cold Cuts Deli 11/6/13 Cheese Deli 11/7/13 Macaroni Salad Deli 11/8/13 Ice Cream Frozen 11/9/13 Chicken Legs Meat 11/10/13 Ground Beef Meat 11/11/13 Chuck Steak Meat 11/12/13 Fresh Fish Meat 11/13/13 Shrimp Meat 12/1/13 Dry Beans Dry Goods 12/2/13 Onion Produce 12/3/13 Spaghetti Dry Goods 12/4/13 Cauliflower Produce 12/5/13 Grapes Produce 12/6/13 Apples Produce 12/7/13 Lettuce Produce 12/8/13 Canned Soup Dry Goods 12/9/13 Frozen Peas Frozen 12/10/13 Flour Dry Goods 12/11/13 Sugar Dry Goods 12/12/13 Frozen Pizza Frozen 12/13/13 Whole Chicken Meat 12/14/13 Cold Cuts 12/15/13 Cheese Deli 12/16/13 Macaroni Salad Deli 12/17/13 Ice Cream Frozen 12/18/13 Chicken Legs Meat 12/19/13 Ground Beef Meat 12/20/13 Chuck Steak Meat 12/21/13 Fresh Fish Meat 12/22/13 Shrimp Meat 1/1/12 Dry Beans Dry Goods 1/2/12 Onion Produce 1/3/12 Spaghetti Dry Goods 1/4/12 Cauliflower Produce 1/5/12 Grapes Produce 1/6/12 Apples Produce Category Fruit Fruit Vegetable Soup Vegetable Baking Baking Dinners Chicken Meat Cheese Salad Dessert Chicken Beef Beef Fish Fish Vegetable Vegetable Pasta Vegetable Fruit Fruit Vegetable Soup Vegetable Baking Baking Dinners Chicken Meat Cheese Salad Dessert Chicken Beef Beef Fish Fish Vegetable Vegetable Pasta Vegetable Fruit Fruit | samatishta Gross Sales Cost Markup Amount $ 2,099.02 $ 715.25 $ 1,383.77 $ 1,857.69 $ 802.24 $ 1,055.45 $ 2,093.91 $ 403.46 $ 1,690.45 $ 2.837.05 $ 482.63 $ 2.354.42 $ 2,714.47 $ 803.22 $ 1,911.25 $ 3,476.76 $ 1,127.71 $ 2,349.05 $ 4,389.73 $ 367.27 $ 4,022.45 $ 9,566.17 $ 514.65 $ 9,051.52 $ 8,336.54 $ 373.37 $ 7.963.17 $ 6,167.13 $ 457.73 $ 5,709.40 $ 8,340.37$ 534.97 $ 7.805.40 $ 4.408.88 $ 338.82 $ 4,070.07 $ 7.450.39 $ 531.93 $ 6,918.46 $ 4,396.11 $ 442.49 $ 3,953.63 $ 8,355.69 $ 715.89 $ 7,639.80 $ 3,517.62 $ 644.74 $ 2.872.88 $ 5,046.04 $ 480.09 $ 4,565.95 $ 10,067.98 $ 911.03 $ 9,156.95 $ 1,342.41 $ 441.47 $ 900.95 $ 1,400.36 $ 2,060.55 $ (660.18) $ 1,719.07 $ 3,866.63 $ (2,147.571 $ 1,626.35 $ 401.83 $ 1,224.52 $ 1,870.89 $ 737.23 $ 1,133.65 $ 1,651.85 $ 827.69 $ 824.16 $ 1,866.25 $ 413.01 $ 1,453.24 $ 2,540.75 $ 495.34 $ 2,045.41 $ 2,429.49 $ 828.71 $ 1,600.78 $ 3,12137 $ 1,166.14 1,955 23 $ 3,950.00 387.09 $ 3,562.91 $ 8,648.30 $ 548.83 8,099.47 $ 7,532.25 $ 393.78 $ 7,138,47 $ 5,563.23 $ 2,346.05 $ 3,217.18 $ 7,535.73 $ 4,405.46 $ 3,130.26 $ 3,967.39 $ 454.68 $ 3,512.71 $ 6,727.95 837.12 $ 5,890.83 $ 3,955.80 $ 940.27 $ 3,015.53 $ 7,549.63 $ 467.42 $ 7,082.21 $ 3,158.45 $ 561.30 $ 2,597.16 $ 4,545.69 $ 941.43 $ 3,604.27 $ 9,103.76 $ 1,326.19 $ 7,77757 $ 1,180.20 $ 247.24 $ 932.96 $ 1,238.51 $ 416.34 $ 822.17 $ 1,559.22 $ 254.24 $ 1,304.98 $ 1.465.92 $ 351.03 $ 1,114.89 $ 1,711.99 439.66 $ 1,272.33 $ 1.49158 $ 214.59 $ 1,276.99 193% 132% 419% 4889 238% 208% 1095% 1759% 2133% 1247% 1459% 1201% 1301% 8949 1067% 446% 951% 1005% 204% -32% -56% 305% 154% 100% 352% 413% 193% 168% 920% 1476% 1813% 137% 71% 773% 704% 321% 1515% 463% 383% 586% 377% 197% 513% 318% 289% 595% 2011 Mary Kari Larry Jerry Perry Gary Mary Kari Larry Jerry Perry Gary Mary Kari Larry Jerry Perry Gary Mary Kari Larry Jerry Perry Gary Mary Kari Larry Jerry Perry Gary Mary Kari Larry Jerry 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 urus Islalalalala isles Dei lu Perry 1 2 WN 4 1 2 uuuuuuuuuu Gary Mary Kari Larry Jerry Perry Gary Mary Kari Larry Jerry 4 1 2 4 471 Cahier 1 2 4. 1 UUUUUUUUUU 2 Del 4 1 2 1 2 Meat 4 Category Vegetable Soup Vegetable Baking Baking Dinners Chicken Meat Cheese Salad Dessert Chicken Beef Beef Fish Fish Vegetable Vegetable Pasta Vegetable Fruit Fruit Vegetable Soup Vegetable 1 2 3 4 WNL 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 4 Product Department 1/7/12 Lettuce Produce 1/8/12 Canned Soup Dry Goods 1/9/12 Frozen Peas Frozen 1/10/12 Flour Dry Goods 1/11/12 Sugar Dry Goods 1/12/12 Frozen Pizza Frozen 1/13/12 Whole Chicken Meat 1/14/12 Cold Cuts 1/15/12 Cheese Deli 1/16/12 Macaroni Salad Deli 1/17/12 kce Cream Frozen 1/18/12 Chicken Legs 1/19/12 Ground Beef Meat 1/20/12 Chuck Steak Meat 1/21/12 Fresh Fish Meat 1/22/12 Shrimp Meat 2/1/12 Dry Beans Dry Goods 2/2/12 Onion Produce 2/3/12 Spaghetti Dry Goods 2/4/12 Cauliflower Produce 2/5/12 Grapes Produce 2/6/12 Apples Produce 27/12 Lettuce Produce 2/8/12 Canned Soup Dry Goods 2/9/12 Frozen Peas Frozen 2/10/12 Flour Dry Goods 2/11/12 Sugar Dry Goods 2/12/12 Frozen Pizza Frozen 2/13/12 Whole Chicken Meat 2/14/12 Cold Cuts Deli 2/15/12 Cheese Deli 2/16/12 Macaroni Salad Deli 2/17/12 Ice Cream Frozen 2/18/12 Chicken Legs Meat 2/19/12 Ground Beef Meat 2/20/12 Chuck Steak Meat 2/21/12 Fresh Fish Meat 2/22/12 Shrimp Meat 3/1/12 Dry Beans Dry Goods 3/2/12 Onion Produce 3/3/12 Spaghetti Dry Goods 3/4/12 Cauliflower Produce 3/5/12 Grapes Produce 3/6/12 Apples Produce 3/7/12 Lettuce Produce 3/8/12 Canned Soup Dry Goods 3/9/12 Frozen Peas Frozen Gross Sales Cost Markup Amount $ 1,707.32 $ 436.16 $ 1,271.16 $ 2,386.05 $ 333.54 $ 2,052.51 $ 2,274.10 $ 647.25 $ 1,626.85 $ 2,970.32 $ 565.61 $ 2.404.71 $ 3,804.15 $ 376.69 $ 3,427.47 $ 8,531.94 $ 871.16 $ 7,660.78 $ 7,408.88 $ 332.37 $ 7,076.51 $ 5,427.51 $ 2.190.13 $ 3.237.38 $ 7,412.38 $ 4,262.47 $ 3,149.91 $ 3.821.65 $ 286.89 $ 3,534.76 $ 6,599.54 $ 671.74 $ 5,927.80 $ 3,809.99 $ 775.53 $ 3,034.46 $ 7,426.38 $ 299.72 $ 7,126.66 $ 3,007.64 $ 394.18 $ 2,613.46 $ 4,403.58 $ 776.70 $ 3,626.89 $ 8,990.25 $ 1,163.87 $ 7,826.38 $ 867.60 $ 184.72 $ 682.88 $ 910.28 $ 308.49 $ 601.79 $ 1,145.02 $ 189.84 $ 955.18 $ 1,076.73 $ 260.69 $ 816.04 $ 1 256.84 $ 325.56 $ 931.28 $ 1,095.51 $ 160.82 $ 934.69 $ 1 253.43 $ 323.00 $ 930.43 $ 1,750.23 $ 247.89 $ 1,502.34 $ 1,668.28 $ 477.51 $ 1,190.77 $ 2,177 88 $ 417.75 $ 1,760.13 $ 2,788.21 $ 27947 $ 2 508.74 $ 6,248.71 $ 641.40 $ 5,60731 $ 5,426.69 $ 247.03 $ 5,179.66 $ 3,976.42 $ 1,606.82 $ 2,369.60 $ 5,429.25 $ 3,123.67 $ 2 305.58 $ 2.801.01 $ 213.74 $ 2,587.27 $ 4,834.29 $ 495.43 $ 4,338.86 $ 2,792.47 $ 571.40 $ 2,221.07 $ 5,439.49 $ 223.13 $ 5,216.36 $ 2,205.20 $ 292.27 $ 1,912.92 $ 3,226.96 $ 572.26 $ 2,654.70 $ 6,584.18 $ 855.65 $ 5,728.52 $ 901.64 $ 191.53 $ 710.11 $ 946.02 $ 320.24 $ 625.79 $ 1,190.12 $ 196.85 $ 993.27 $ 1,119.11 $ 270.53 $ 848.58 $ 1,306.40 $ 337.99 $ 968.41 $ 1,138.64 $ 166.67 $ 971.96 $ 1,302.85 $ 335.33 $ 967.53 $ 1819.46 $ 257.21 $ 1,562.24 $ 1,734.24S 495.99 $ 1,238.26 Markup % Salesperson 291% Perry 615% Gary 251% Mary 425% Kari 910% Larry 879% Jerry 2129% Perry 148% Gary 74% Mary 1232% Kari 882% Larry 391% Jerry 2378% Perry 663% Gary 467% Mary 672% Kari 370% Larry 195% Jerry 503% Perry 313% Gary 286% Mary 581% Kari 288% Larry 606% Jerry 249% Perry 421% Gary 898% Mary 874% Kari 2097% Larry 147% Jerry 74% Perry 1210% Gary 876% Mary 389% Kari 2338% Larry 654% Jerry 464% Perry 669% Gary 371% Mary 195% Kari 505% Larry 314% Jerry 287% Perry 583% Gary 289% Mary 607% Kari 250% Larry 1 2 Baking 4 olulu 1 2 4 1 2 4 Baking Dinners Chicken Meat Cheese Salad Dessert Chicken Beef Beef Fish Fish Vegetable Vegetable Pasta Vegetable Fruit Fruit Vegetable Soup Vegetable 1 2 UUUUU 3 4 1 uuuuuu NMENT 1 alia 3 1 1 Cahler taka 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 islalalalalalololololol TTCL $ 336 337 338 339 A Product Department 3/9/12 Frozen Peas Frozen 3/10/12 Flour Dry Goods 3/11/12 Sugar Dry Goods 3/12/12 Frozen Pizza Frozen 3/13/12 Whole Chicken Meat 3/14/12 Cold Cuts Deli 3/15/12 Cheese Deli 3/16/12 Macaroni Salad Deli 3/17/12 Ice Cream Frozen 3/18/12 Chicken Legs Meat 3/19/12 Ground Beef Meat 3/20/12 Chuck Steak Meat 3/21/12 Fresh Fish Meat 3/22/12 Shrimp Meat 4/1/12 Dry Beans Dry Goods 4/1/12 Onion Produce 4/2/12 Spaghetti Dry Goods 4/3/12 Cauliflower Produce 4/4/12 Grapes Produce 4/5/12 Apples Produce 4/6/12 Lettuce Produce 4/7/12 Canned Soup Dry Goods 4/8/12 Frozen Peas Frozen 4/9/12 Flour Dry Goods 4/10/12 Sugar Dry Goods 4/11/12 Frozen Pizza Frozen 4/12/12 Whole Chicken Meat 4/13/12 Cold Cuts Deli 4/14/12 Cheese Deli 4/15/12 Macaroni Salad Deli 4/16/12 Ice Cream Frozen 4/17/12 Chicken Legs Meat 4/18/12 Ground Beef Meat 4/19/12 Chuck Steak Meat 4/20/12 Fresh Fish Meat 4/21/12 Shrimp Meat 5/1/12 Dry Beans Dry Goods 5/2/12 Onion Produce 5/3/12 Spaghetti Dry Goods 5/4/12 Cauliflower Produce 5/5/12 Grapes Produce 5/6/12 Apples Produce 5/7/12 Lettuce Produce 5/8/12 Canned Soup Dry Goods 5/9/12 Frozen Peas Frozen 5/10/12 Flour Dry Goods 5/11/12 Sugar Dry Goods 340 Category Vegetable Baking Baking Dinners Chicken Meat Cheese Salad Dessert Chicken Beef Beef Fish Fish Vegetable Vegetable Pasta Vegetable Fruit Fruit Vegetable Soup Vegetable Baking Baking Dinners Chicken Meat Cheese Salad Dessert Chicken Beef Beef Fish Fish Vegetable Vegetable Pasta Vegetable Fruit Fruit Vegetable Soup Vegetable Baking Baking Gross Sales Cost Markup Amount $ 1,734.24 $ 495.99 $ 1,238.26 $ 2,264.16 $ 433.85 $ 1,830 31 $ 2.898.83 $ 290.06 $ 2,608.77 6,497.31 $ 666.41 $ 5.830.90 $ 5,642.52 $ 256.33 $ 5,386.19 $ 4,134.42 $ 1,670.33 $ 2.464.09 $ 5,645.18 $ 3,247.67 $ 2,39751 $ 2,912.14 $ 221.71 $ 2,690.43 $ 5,026.50 $ 514.63 $ 4,511.87 $ 2,903.26 $ 593.63 $ 2,309.64 $ 5,655.83 $ 231.47 $ 5,424.36 $ 2,292.57 303.37 $ 1,989.20 $ 3,355.07 $ 594.52 $ 2,760.56 $ 6,846.16 $ 889.21 $ 5,956.94 $ 988.16 $ 208.83 779.33 1,036.87 $ 350.09 $ 686.79 $ 1,304.77 $ 214.68 $ 1,090.09 1,226.83 $ 295.53 $ 931.30 1,432.38 $ 369.57 $ 1,062.81 1,248.26 $ 18156 $ 1,066.71 1,428.49 $ 366.65 $ 1,06184 1,995.45$ 280.92 $ 1,714.53 1,901.93 $ 542.97 $ 1,358.96 2,483.50 $ 474.78 $ 2,008.72 3,180.03 $ 316.96 $ 2,863.07 7,129.29 $ 730.01 $ 6,399.28 6,191.17 $ 279.95 5,911 22 4,536.07 $ 1,831.79 $ 2,704.28 6,194.09 $ 3,562.88 $ 2,631 22 3,194.64 $ 241.95 $ 2,952.69 5,515.10$ 563.43 $ 4,951.67 3,184.90 $ 650.13 $ 2,534.77 6,205.78 $ 252.67 $ 5,953.11 2,514.68 $ 331.58 $ 2.183.10 $ 3,680.75 $ 651.10 $ 3,029.65 $ 7,512.14 $ 974.53 $ 6,537.61 1,195.43 $ 303.31 $ 892.12 $ 1.251.19 $ 465.01 $ 786.18 1,557.85$ 310.00 $ 1,247.85 $ 1.468.64 $ 40256 $ 1,066.08 $ 1,703.94 $ 487.31 $ 1,216.62 $ 1,493.17 $ 272.09 $ 1,221.09 1,699.47 $ 483.96 $ 1.215.51 $ 2,348 49 $ 385.83 $ 1,962.66 2.241.44 $ 685.81 $ 1,555.63 2,907.18 $ 607.75 $ 2,299.43 3.704.51 $ 427.09 $ 327742 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 1 2 3 4 UUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUU Markup % Salesperson 250% Larry 422% Jerry 899% Perry 875% Gary 2101% Mary 148% Kari 749 Larry 1214% Jerry 877% Perry 389% Gary 2343% Mary 656% Kari 464% Larry 670% Jerry 373% Perry 196% Gary 508% Mary 315% Kari 288% Larry 588% Jerry 290% Perry 610% Gary 250% Mary 423% Kari 903% Larry 877% Jerry 2112% Perry 148% Gary 74% Mary 1220% Kari 879% Larry 390% Jerry 2356% Perry 658% Gary 465% Mary 671% Kari 294% Larry 169% Jerry 403% Perry 265% Gary 250% Mary 449% Kari 251% Larry 509% Jerry 227% Perry 378% Gary 767% Mary uuuuuuuuuuuuuuuuuuuu 341 342 343 344 345 346 347 348 349 350 $ TI 351 $ 352 353 354 355 356 357 358 359 360 361 362 363 364 lulului uuuuuuu 1 2 3 4 1 2 3 4 1 alialiai Category Cahier T , 364 365 366 367 368 Deli Deli 369 Baking Dinners Chicken Meat Cheese Salad Dessert Chicken Beef Beef 370 371 372 takala Fish 373 374 375 376 377 ololo 378 379 380 Product Department 2013 DUOUSE 5/11/12 Sugar Dry Goods 5/12/12 Frozen Pizza Frozen 5/13/12 Whole Chicken Meat 5/14/12 Cold Cuts 5/15/12 Cheese 5/16/12 Macaroni Salad Deli 5/17/12 Ice Cream Frozen 5/18/12 Chicken Legs Meat 5/19/12 Ground Beef Meat 5/20/12 Chuck Steak Meat 5/21/12 Fresh Fish Meat 5/22/12 Shrimp Meat 6/1/12 Dry Beans Dry Goods 6/2/12 Onion Produce 6/3/12 Spaghetti Dry Goods 6/4/12 Cauliflower Produce 6/5/12 Grapes Produce 6/6/12 Apples Produce 6/7/12 Lettuce Produce 6/8/12 Canned Soup Dry Goods 6/9/12 Frozen Peas Frozen 6/10/12 Flour Dry Goods 6/11/12 Sugar Dry Goods 6/12/12 Frozen Pizza Frozen 6/13/12 Whole Chicken Meat 6/14/12 Cold Cuts Deli 6/15/12 Cheese Deli 6/16/12 Macaroni Salad Deli 6/17/12 Ice Cream Frozen 6/18/12 Chicken Lees Meat 6/19/12 Ground Beef Meat 6/20/12 Chuck Steak Meat 6/21/12 Fresh Fish Meat 6/22/12 Shrimp Meat 7/1/12 Dry Beans Dry Goods 7/2/12 Onion Produce 7/3/12 Spaghetti Dry Goods 7/4/12 Cauliflower Produce 7/5/12 Grapes Produce 7/6/12 Apples Produce 7/7/12 Lettuce Produce 7/8/12 Canned Soup Dry Goods 7/9/12 Frozen Peas Frozen 7/10/12 Flour Dry Goods 7/11/12 Sugar Dry Goods 7/12/12 Frozen Pizza Frozen 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 slu Gross Sales Cost Markup Amount - + $ 3,704.51 $ 427.09 $ 3,277.42 $ 8,225.31 $ 899.91 $ 7,325,40 $ 7,151.43 $ 384.72 $ 6,766.71 $ 5,256.79 $ 2,161.15 $ 3,095.65 $ 7,154.77 $ 4,142.76 $ 3,012.01 3,721 24$ 341.23 $ 3,380.01 6,377.51 $ 709.22 $ 5,668.29 3,710.08$ 808.47 $ 2,901.61 7,168.15 $ 353.49 $ 6,814.66 2,942.86$ 443.82 $ 2,499.04 4,277.69 $ 809.59 $ 3,468.11 8,663.56 $ 1,179.82 $ 7,483.75 1,043.16 $ 233.45 $ 809.71 1,093.77 $ 380.21 $ 713.56 1,372.11 $ 239.52 $ 1,132.59 1,291.13 $ 323.53 $ 967.61 $ 1,504.70 $ 400.45 $ 1,104.25 $ 1,313.40 $ 205.11 $ 1,108.29 $ 1,500.65 $ 397.41 $ 1,10323 $ 2,089.71 $ 308.34 $ 1,781 37 $ 1,992.55 $ 580.61 $ 1,411.94 $ 2,596.80 509.76 $ 2.087.03 3,320.48 $ 345.79 $ 2,974.68 $ 7,423.70 $ 774.94 $ 6,648.75 $ 6,449.00 $ 307.33 $ 6,141,67 $ 4,729.38 $ 1,919.67 $ 2.809.70 $ 6,452.04 $ 3,718.25$ 2,733.79 $ 3,335.66 $ 267.86 $ 3,067 80 5,746.58 $ 601.87 $ 5,144.71 $ 3,325.54 $ 691.95 $ 2,633.59 6,464.19 $ 278.99 $ 6,185.19 $ 2,629.18$ 360.98 $ 2,268.21 3,840.72 $ 692.96 $ 3,147.76 $ 7,821.47 $ 1,028.99 $ 6,792.48 1,356.95 $ 400.11 $ 956.84 1,416.75 $ 573.53 $ 843.22 1,745.67 $ 40728 $ 1,338.39 1,649.98 $ 506.56 $ 1,143.43 1,902.35 $ 597.46 $ 1,304.90 1,676.30 $ 366.62 $ 1,309.68 1,897.57 $ 593.87 $ 1,303.70 2,593.67 $ 488.61 $ 2,105.06 2,478.85 $ 810.35 $ 1,668.50 3,192.90 $ 726.63 $ 2,466.27 4,048.08 $ 532.87 $ 3,51521 8,896.89 $ 1,040.00 $ 7,856.89 Fish Vegetable Vegetable Pasta Vegetable Fruit Fruit Vegetable Soup Vegetable Baking Baking Dinners Chicken Meat Cheese Salad Dessert Chicken Beef Beef Fish Fish Vegetable Vegetable Pasta Vegetable Fruit Fruit Vegetable Soup Vegetable Baking Baking Dinners UUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUU Markup % Salesperson re 767% Mary 814% Kari 1759% Larry 143% Jerry 73% Perry 991% Gary 799% Mary 359% Kari 1928% Larry 563% Jerry 428% Perry 634% Gary 347% Mary 188% Kari 473% Larry 299% Jerry 276% Perry 540% Gary 278% Mary 578% Kari 243% Larry 409% Jerry 860% Perry 858% Gary 1998% Mary 146% Kari 74% Larry 1145% Jerry 855% Perry 381% Gary 2217% Mary 628% Kari 454% Larry 660% Jerry 239% Perry 147% Gary 329% Mary 226% Kari 218% Larry 357% Jerry 220% Perry 431% Gary 206% Mary 339% 660% Larry 755% Jerry 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 401 lulusuurus lulululululululurumu 402 403 404 405 406 407 Kari 408 LIIDU 409 Cahier wwwwwwwwww uururunlululululus ... Category Dinners Chicken Meat Cheese Salad Dessert Chicken Beef Beef Fish Fish Vegetable Vegetable Pasta Vegetable Fruit Fruit Vegetable Soup Vegetable Baking Baking Dinners Chicken Meat Cheese Salad Dessert Chicken Beef Beef Fish 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 A Product Department 7/12/12 Frozen Pizza Frozen 7/13/12 Whole Chicken Meat 7/14/12 Cold Cuts Deli 7/15/12 Cheese Deli 7/16/12 Macaroni Salad Deli 7/17/12 Ice Cream Frozen 7/18/12 Chicken Lees Meat 7/19/12 Ground Beef Meat 7/20/12 Chuck Steak Meat 7/21/12 Fresh Fish Meat 7/22/12 Shrimp Meat 8/1/12 Dry Beans Dry Goods 8/2/12 Onion Produce 8/3/12 Spaghetti Dry Goods 8/4/12 Cauliflower Produce 8/5/12 Grapes Produce 8/6/12 Apples Produce 8/7/12 Lettuce Produce 8/8/12 Canned Soup Dry Goods 8/9/12 Frozen Peas Frozen 8/10/12 Flour Dry Goods 8/11/12 Sugar Dry Goods 8/12/12 Frozen Pizza Frozen 8/13/12 Whole Chicken Meat 8/14/12 Cold Cuts Deli 8/15/12 Cheese Deli 8/16/12 Macaroni Salad Deli 8/17/12 Ice Cream Frozen 8/18/12 Chicken Legs Meat 8/19/12 Ground Beef Meat 8/20/12 Chuck Steak Meat 8/21/12 Fresh Fish Meat 8/22/12 Shrimp Meat 9/1/12 Dry Beans Dry Goods 9/2/12 Onion Produce 9/3/12 Spaghetti Dry Goods 9/4/12 Cauliflower Produce 9/5/12 Grapes Produce 9/6/12 Apples Produce 977/12 Lettuce Produce 9/8/12 Canned Soup Dry Goods 9/9/12 Frozen Peas Frozen 9/10/12 Flour Dry Goods 9/11/12 Sugar Dry Goods 9/12/12 Frozen Pizza Frozen 9/13/12 Whole Chicken Meat 9/14/12 cald cuts Deli llllluuuuuuuuuu Mary Gross Sales Cost Markup Amount $ 8.896.89 $ 1,040.00 $ 7856.89 $ 7,745.09 $ 487.42 $ 7.257.67 $ 5,712.99 $ 2,392.74 $ 3,320.25 $ 7,748.68 $ 4,518.13 $ 3.230.55 $ 4,066.02 $ 440.77 $ 3,625.25 $ 6,915.02 $ 835.47 $ 6,079.55 $ 4,054.06 $ 941.92 $ 3,112.14 $ 7,763.03 $ 453.93 $ 7,309.10 $ 3,231.17 550.81 $ 2,680.36 $ 4,662.85 $ 943.12 $ 3,719.73 $ 9,366.94 $1,340 21 $ 8,026.73 $ 1,036.35 $ 335.99 $ 700.36 $ 1,080.12 $ 462.93 $ 617.20 $ 1,320.87 $ 341.24 $ 979.63 $ 1,250.84 $ 413.90 $ 836.93 $ 1.435.56 $ 480.44 $ 955.12 $ 1,270.10 311.47 $ 958.62 $ 1,432.05 $ 477-81 $ 954.25 $ 1,94157 $ 400.77 $ 1,540.80 $ 1,857.53 $ 636.27 $ 1,221.26 $ 2,380.17 $ 574.98 $ 1.805.19 $ 3,006.12 $ 433.16 $ 2,572.96 $ 6,555.21 804.35 $ 5,750.86 $ 5,712.15$ 399.89 $ 5,312.26 $ 4,224.75 $ 1,794.49 $ 2,430.26 $ 5,714.78 $ 3,350.17 $ 2,364.60 $ 3,019.25$ 365.75 $ 2,653.50 $ 5,104.59 $ 654.65 $ 4,449.93 $ 3,010.50 $ 732.57 $ 2,277.93 $ 5,725.28 $ 375.38 $ 5,349.90 $ 2,408.19 $ 446.29 $ 1,961.89 $ 3,456.10 $ 733.44 $ 2,722.66 $ 6,899.27 $ 1,024.09 $ 5,875.17 $ 1,071 26 $ 342.97 $ 728.29 $ 1,116.78 $ 474.97 $ 64181 $ 1,367.12 $ 348.43 $ 1,018.70 $ 1,294.30 $ 423.99 $ 870.31 $ 1.486.38 $ 493.18 $ 993.21 $ 1,314.32 $ 317.48 $ 996.85 $ 1,482.74 $ 490.45 $ 992 29 $ 2,012.57 $ 410.33 $ 1,602.24 $ 1,925.18$ 655.22 $ 1,269.96 $ 2.468.66 $ 591.50 $ 1,877.17 $ 3,119.57 $ 444.02 $ 2,675.55 $ 6,810.18 $ 830.01 $ 5,980.17 $ 5,933.50 $ 409.42 $ 5,524.08 4.386.80 $ 1859.63 $ 2.527.17 Markup % Salesperson 755% Jerry 1489% Perry 139% Gary 72% Mary 822% Kari 728% Larry 330% Jerry 1610% Perry 487% Gary 394% Mary 599% Kari 208% Larry 133% Jerry 287% Perry 202% Gary 199% Mary 308% Kari 200% Larry 384% Jerry 192% Perry 314% Gary 594% 715% Kari 1328% Larry 135% Jerry 71% Perry 725% Gary 680% 311% Kari 1425% Larry 440% Jerry 371% Perry 574% Gary 212% Mary 135% Kari 292% Larry 205% Jerry 201% Perry 314% Gary 202% Mary 390% Kari 194% Larry 317% Jerry 603% Perry 720% Gary 1349% Mary 126% 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 1 2 3 4 1 2 3 4 Mary wala Fish slalalalalalalalala Vegetable Vegetable Pasta Vegetable Fruit Fruit Vegetable Soup Vegetable Baking Baking Dinners Chicken Meat 1 2 3 4 uuuuuuuu 1 2 3 4 1 2 Gross Sales Cost Markup Amount Markup % Salesperson Cahier 2 3 4 1 2 3 4 1 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 2 3 4 1 2 1 2 3 4 A Product Department 9/14/12 Cold Cuts Deli 9/15/12 Cheese Deli 9/16/12 Macaroni Salad Deli 9/17/12 Ice Cream Frozen 9/18/12 Chicken Legs Meat 9/19/12 Ground Beef Meat 9/20/12 Chuck Steak Meat 9/21/12 Fresh Fish Meat 9/22/12 Shrimp Meat 10/1/12 Dry Beans Dry Goods 10/2/12 Onion Produce 10/3/12 Spaghetti Dry Goods 10/4/12 Cauliflower Produce 10/5/12 Grapes Produce 10/6/12 Apples Produce 10/7/12 Lettuce Produce 10/8/12 Canned Soup Dry Goods 10/9/12 Frozen Peas Frozen 10/10/12 Flour Dry Goods 10/11/12 Sugar Dry Goods 10/12/12 Frozen Pizza Frozen 10/13/12 Whole Chicken Meat 10/14/12 Cold Cuts 10/15/12 Cheese Deli 10/16/12 Macaroni Salad Deli 10/17/12 Ice Cream Frozen 10/18/12 Chicken Legs Meat 10/19/12 Ground Beef Meat 10/20/12 Chuck Steak Meat 10/21/12 Fresh Fish Meat 10/22/12 Shrimp Meat 11/1/12 Dry Beans Dry Goods 11/2/12 Onion Produce 11/3/12 Spaghetti Dry Goods 11/4/12 Cauliflower Produce 11/5/12 Grapes Produce 11/6/12 Apples Produce 11/7/12 Lettuce Produce 11/8/12 Canned Soup Dry Goods 11/9/12 Frozen Peas Frozen 11/10/12 Flour Dry Goods 11/11/12 Sugar Dry Goods 11/12/12 Frozen Pizza Frozen 11/13/12 Whole Chicken Meat 11/14/12 Cold Cuts Deli 11/15/12 Cheese Deli 11:16:12 475 Category Meat Cheese Salad Dessert Chicken Beef Beef Fish Fish Vegetable Vegetable Pasta Vegetable Fruit Fruit Vegetable Soup Vegetable Baking Baking Dinners Chicken Meat Cheese Salad Dessert Chicken Beel Beef Fish Fish Vegetable Vegetable Pasta Vegetable Fruit Fruit Vegetable Soup Vegetable Baking Baking Dinners Chicken Meat Cheese CH I uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu JULIE Deli $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 4,386.80 $ 1859.63 $ 5,936.23 $ 3,47734 $ 3,133.23 $ 373.92 $ 5,301.71 $ 674.34 $ 3,124.12$ 755.36 $ 5,947.16 $ 383.93 $ 2.497.79$ 457.67 $ 3,587.50 $ 756.27 $ 7,167.95 $ 1,058,51 $ 1,160.00 $ 360.72 $ 1,209.95$ 505.58 $ 1.484.70$ 366.71 $ 1,404.78$ 449.64 $ 1,615.59 $ 525.57 $ 1,426.76 $ 332.74 $ 1,611.59 $ 52257 $ 2,193.07 $ 434.65 $ 2,097.15 $ 703.41 $ 2,693.62 $ 633.47 $ 3,407.98 $ 471.62 $ 7,458.34 $ 895.23 $ 6,496.20 $ 433.65 $ 4,798.73 $ 2,025.22 $ 6,499.20 $ 3,800.62 $ 3,42296 $ 394.68 $ 5,802.82 $ 724.39 $ 3,412.97$ 813.31 $ 6,511.19 $ 405.67 $ 2,725.59 $ 486.60 $ 3,92151 $ 814.31 $ 7,850.98 $ 1,146.01 $ 1,372.57 $ 457.61 $ 1,429.75 $ 623.45 $ 1,74427 $ 464.47 $ 1,652.77 $ 559.40 $ 1,894.09 $ 646 32 $ 1,677.93 $ 425.59 $ 1,889.52 $ 642 89 $ 2,555.15$ 542.25 $ 2,445.35$ 849.90 $ 3.128.14 $ 769.84 $ 3,945.88 $ 584.56 $ 8,582.42 $ 1,069.49 $ 7.481.04 $ 541.10 $ 5,537.90 $ 2,363.01 $ 7,484.47 $4,395.35 $ 2952.04 495 50 1 Kari Larry Jerry Perry Gary Mary Kari Larry Jerry Perry Gary Mary Kari Larry Jerry Perry Gary Mary Kari Larry Jerry Perry Gary Mary Kari Larry Jerry Perry 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 2,527.17 2.458.89 2,759.31 4,627.37 2,368.76 5,563.22 2,040.12 2,831.23 6,109.44 799.28 704.37 1,118.00 955.14 1,090.02 1,094.02 1,089.02 1,758.42 1,393.75 2,060.15 2,936.36 6,563.10 6,062.55 2,773.51 2,698.57 3,028.28 5,078.43 2,599.66 6,105.51 2,238.99 3,107 21 6,704.97 914.96 806.30 1,279.79 1,093.37 1,247.77 1,252.35 1.246.63 2,012.90 1,595.45 2,358.30 3,361.32 7,512.93 6,939.94 3,174.90 3,089.12 2.46554 136% 71% 738% 686% 314% 1449% 446% 374% 577% 222% 139% 305% 212% 207% 329% 208% 405% 198% 325% 623% 733% 1398% 137% 71% 767% 701% 320% 1505% 460% 382% 585% 200% 129% 276% 195% 193% 294% 194% 371% 188% 306% 575% 702% 1283% 134% 709 SORE TE 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 Gary Mary Kari Larry Jerry Perry Gary Mary Kari Larry Jerry Perry Gary 1 2 3 4 Mary Kari Larry Jerry Perry 1 2 3 4 1 Cahier Category Meat Cheese Salad Dessert Chicken Beef Beef suurus Jerry Fish un 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 Product Department 11/14/12 Cold Cuts Deli 11/15/12 Cheese Dell 11/16/12 Macaroni Salad Deli 11/17/12 Ice Cream Frozen 11/18/12 Chicken Legs Meat 11/19/12 Ground Beef Meat 11/20/12 Chuck Steak Meat 11/21/12 Fresh Fish Meat 11/22/12 Shrimp Meat 12/1/12 Dry Beans Dry Goods 12/2/12 Onion Produce 12/3/12 Spaghetti Dry Goods 12/4/12 Cauliflower Produce 12/5/12 Grapes Produce 12/6/12 Apples Produce 12/7/12 Lettuce Produce 12/8/12 Canned Soup Dry Goods 12/9/12 Frozen Peas Frozen 12/10/12 Flour Dry Goods 12/11/12 Sugar Dry Goods 12/12/12 Frozen Pizza Frozen 12/13/12 Whole Chicken Meat 12/14/12 Cold Cuts Deli 12/15/12 Cheese Deli 12/16/12 Macaroni Salad Deli 12/17/12 Ice Cream Frozen 12/18/12 Chicken Legs Meat 12/19/12 Ground Beef Meat 12/20/12 Chuck Steak Meat 12/21/12 Fresh Fish Meat 12/22/12 Shrimp Meat Fish Vegetable Vegetable Pasta Vegetable Fruit Fruit Vegetable Soup Vegetable Baking Baking Dinners Chicken Meat Cheese Salad Dessert Chicken Beef Beef Fish Fish Gross Sales Cost Markup Amount $ 5,537.90 $ 2,363.01 $ 3,174.90 $ 7,484.47 $ 4,395.35$ 3,089.12 $ 3,963.04 $ 496.50 $ 3,466.54 $ 6,687.31 $ 873.92 $ 5,813.40 $ 3,951.60 $ 975.71 $ 2,975.89 7,498.19 $ 509.08 $ 6,989.12 3,164.74 $ 601.72 $ 2,563.02 4,533.74 $ 976.85 $ 3,556.89 9,031.89 $ 1,356.56 $ 7,675.33 1,216.40 $ 385.96 $ 830.44 1,268.30 $ 536.48 $ 731.83 1,553.77 $ 392.19 $ 1,161.58 1,470.72 $ 478.35 $ 992.38 1,689.75 $ 55724 $ 1,132.51 $ 1,493.56 $ 356.89 $ 1,136.67 1,685.60 $ 554.12 $ 1,131.48 $ 2,289.75 $ 462.77 $ 1,826.97 $ 2,190.09 $ 742.01 $ 1,448.08 $ 2.809.81 $ 669.35 $ 2.140.46 $ 3,552.02 $ 501.18 $ 3,050.83 $ 760 28 | 941.32 $ 6,818.96 $ 6,760.64 $ 461.74 $ 6,298.90 $ 4,996.99 $ 2.115.35 $ 2.881.63 $ 6,763.75 $ 3,959.97 $ 2,803.78 $ 3,567.59 $ 421.25 $ 3,146.34 $ 6,040.23 $ 763.81 $ 5,276.42 $ 3,557.21 856.20 $ 2,701.01 $ 6,776.21 $ 432.67 $ 6,343.53 $ 2,843.03 $ 516.75 $ 2,326.27 $ 4,085.58 $ 857.23 $ 3,228.34 $ 8.168.23 $ 1,201.87 $ 6,966.37 UUUUUUUUUUUUUUUUU Markup % Salesperson 134% Jerry 70% Perry 698% Gary 665% Mary 305% Kari 1373% Larry 426% 364% Perry 566% Gary 215% Mary 136% Kari 296% Larry 207% Jerry 203% Perry 318% Gary 204% Mary 395% Kari 195% Larry 320% Jerry 609% Perry 724% Gary 1364% Mary 136% Kari 71% Larry 747% Jerry 691% Perry 315% Gary 1466% Mary 450% Kari 377% Larry 580% Mary 4 1 2 3 4 1 2 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 lululululu Auriu AutoSave On Assignment 3 Pivot Table - Copy - Excel Search Piepkor FarnaP , File Home Insert Page Layout Formulas Data Review View Help Analytic Solver Data Mining Pivottable Analyze Design Share Comments 1 Calibri === AutoSum al Wrap Text SEX 11AA A- 47 02 X Cut Paste Copy Format Painter Clipboard Date $ - %, 28 % Fill Ideas Insert Delete Fomat Sensitivity Merge Center Clear Conditional Formatas Cell Formatting Table Styles Styles Sort Find Filter Select Font Alignment Number 15 Cells Editing Ideas Sensitivity A18 Dec F X liu I A 10 Apr 11 May 12 13 Jul 14 Aug 15 Sep 16 Oct 17 Nov 18 Dec 19 2013 20 Jan 21 Feb 22 Mar 23 Apr 24 May 25 Jun 20 Jul 27 Aug 28 Sep Oct 30 31 Dec 32 Grand Total 33 34 35 36 37 38 4641.6001491 5377.599391 4839.02543 5842.560220 4319.54400 4485.41894 4906.961864 5661.802335 5109.440881 4577.301170 20162.402 4527.067067 4707.580333 5166.462533 5988.165 5386.876667 2052.04 2578.2788 4992.04434 5462.723974 6305.462024 5688.780209 4748.569078 13924.80147 16182.79817 14517.07629 17527.680 12958.78383 13456.25684 14720.68559 16985.407 15328.32204 164785.0024 G188.406 13581.203 14122.741 15499.3875 17964.495 16100.63 6186.12 7734,825494 14976.28317 16388.17192 18916.38607 17065.34213 341876.9736 D 1990.382544 2347.691014 2084.449961 2587.453529 1937.016512 2007.837734 2187.872787 2549.900304 2284.34828 2550.409829 1753.5336 1933.4464 5305.535 2206,52288 2599.856 2311.544 1943.38124 25%2.446477 2226.010044 2302_577197 3933.24566 2534.719520 2354.866221 E 9951.912718 11713.4551 10422.2498 12937.26764 9685.082559 10039.1857 10939.36368 12145.00155 11421.7414 153024.5897 8767.058 9667.232 26527.675 11032.6144 12949.28 11557.72 9716.9052 12664.73238 11130.05322 18420.61758 7860.49332 12673.59763 282583.9405 4848.772557 5614.25 5054.274083 6046.92130 4505.774559 4679.02265 5119.437585 5905.027979 5330.1999 4535.037773 1815.422 3397.127823 4184.002 5397.75 6252.935 5627.19 1917.776667 2407.801520 5208.242325 4953.574153 8508.27402 5935.246064 4835.261398 6 14546.31767 16844.26164 15162.82225 18290.7645 13517.32 RON 14037.06795 15358.3126 17715.0894 15990.5497 163261.399 5446.266 10191.82 12552.006 16193.2764 18738.805 16881.57 5758.33 7223.4014579 15624.72097 19814.29001 17016.55802 17805.73819 348138.8207 H 1 4881.569389 29289.410 Pivot Table Fields 5652.297145 33913,787 Choose fields to add to report 5088.349497 30530.09 6137.188725 36823.137 Search 4535.248185 27211.489 4709.671513 28258.02 Date 5153.073965 30918.443 O Product 5943.5X2352 35661.194 Department 5365.147044 32190.885 OC Category 5505.185844 396373.38 Gross Sales 6202.511 37215.01 Cost 3717.017667 22302.1 Markup Amount Markup % 5175.662667 31053,4 5434.374007 Salesperson 320062 O Cahier a 6294.85 37704 5005.233333 3399 5508_54 33001 Drag fields between areas below 4489.824507 26938.44 Y Filters II Columns 5242.400101 31454.7661 Department 5737.494658 34424.907 Values 6619.9981 5974.76330 Average of Cross Sales Valuc: 6619.99816 5837.40950 2013 - Nov Column: Meat - Average of Gross Sales Values Years Average of Gross Sales2 Date Sum of Cross Sales Instructions Sheet1 Rew Data Results Example + Defer Layout Update Update - + 100% + 9:09 AM B 3/11/2021 Type here to search O * S x ? A 4x Table To ON Dege P H This Heh 47 48 Copy or Super 49 Post Fm Data RE Beloper 50 51 Sub Report 52 Code de To Lot 53 Option 2. ! :3 54 10 6827.824045479 55 F 0 56 57 Sum of Gross Sales Column Labels 58 RowLabels Dell Dry Golds Frere Meat Producer Grand Total 59 Balling Flour 567,693 $67,693 60 Sugw 6,112 $06,112 $1536 61 $1538206 Beel 62 Our Seat SARSIE S6R55 63 Ground Beet $164, 128 $166, 125 12 Bed Total 64 24.62 65 Cheese 165,035 SE65, 15 Cheese Total 66 $165,815 $165.815 Chicken 6712 Cente SH.241 $86.24 68 whole dan $165.730 $165,730 19 Chicken Total $251.97 69 Dessert Ice Cream $147.00 $147 CD 22 Dessert Total $147.80 5147.25 Depan VE Som 70 71 $190,54 5195 72 72 Frozen Plaza Sheet Data Please note the steps listed on the "Instructions " sheet are not the complete steps and you need to manipulate some of the fields' settings to arrive at the provided example. Select the data and name the table Raw_Data before formatting it as a table. Please pay close attention to the fields dragged to the field list to make the results look like the example. Please use Currency style for all money amounts and make sure your field list selections match those of the examples. H11 G H M N J B C D E F KL 1 You will need two separate Pivot Tables similar to the Results Example. Both on this document on separate sheets. 2 Select the data and place it in a table (Use Format as a Table and select the option of your choice). 3 Use Insert/PivotTable and place the results on a separate sheet. 4 Use the examples in the "Results Example" Sheet to add the fields in the PivotTable Field List. s Please note all money amounts should be in currency format and all numbers should have two decimal points (if any). 6 Exceptions: Currency exchange rate and stock market. 7 You can always group by a field using the right click on the field. 8 Save the document as Your Name Last Name Assignment 3. 9 Submit on Titanium 10 11 12 13 D H J lakia Markup % 400% 204% 543% Cahier 1 2 3 4 1 2 3 DI uuuuuuuuu 331% 4 1 2 3 4 1 lulus 2 3 4 1 2 4 1 2 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 Date Product Department 1/1/13 Dry Beans Dry Goods 1/2/13 Onion Produce 1/3/13 Spaghetti Dry Goods 1/4/13 Cauliflower Produce 1/5/13 Grapes Produce 1/6/13 Apples Produce 1/7/13 Lettuce Produce 1/8/13 Canned Soup Dry Goods 1/9/13 Frozen Peas Frozen 1/10/13 Flour Dry Goods 1/11/13 Sugar Dry Goods 1/12/13 Frozen Pizza Frozen 1/13/13 Whale Chicken Meat 1/14/13 Cold Cuts Deli 1/15/13 Cheese Deli 1/16/13 Macaroni Salad Deli 1/17/13 Ice Cream Frozen 1/18/13 Chicken Legs Meat 1/19/13 Ground Beef Meat 1/20/13 Chuck Steak Meat 1/21/13 Fresh Fish Meat 1/22/13 Shrimp Meat 2/1/13 Dry Beans Dry Goods 2/2/13 Onion Produce 2/3/13 Spaghetti Dry Goods 2/4/13 Cauliflower Produce 2/5/13 Grapes Produce 2/6/13 Apples Produce 2/7/13 Lettuce Produce 2/8/13 Canned Soup Dry Goods 2/9/13 Frozen Peas Frozen 2/10/13 Flour Dry Goods 2/11/13 Sugar Dry Goods 2/12/13 Frozen Pizza Frozen 2/13/13 Whole Chicken Meat 2/14/13 Cold Cuts Deli 2/15/13 Cheese Deli 2/16/13 Macaroni Salad Dell 2/17/13 Ice Cream Frozen 2/18/13 Chicken Legs Meat 2/19/13 Ground Beef Meat 2/20/13 Chuck Steak Meat 2/21/13 Fresh Fish Meat 2/22/13 Shrimp Meat 3/1/13 Dry Beans Dry Goods 32/13 lnian Prana Category Vegetable Vegetable Pasta Vegetable Fruit Fruit Vegetable Soup Vegetable Baking Baking Dinners Chicken Meat Cheese Salad Dessert Chicken Beef Beef Fish Fish Vegetable Vegetable Pasta Vegetable Fruit Fruit Vegetable Soup Vegetable Baking Baking Dinners Chicken Meat Cheese Salad Dessert Chicken Beef Beef Fish Fish Vegetable Verwahl Gross Sales Cost Markup Amount $ 1,302.00 $ 260.40 $ 1,041.60 $ 1,367.10 $ 449.19 $ 917.91 $ 1,725.15 $ 268.21 $ 1,456.94 $ 1,620.99 $ 376 28 $ 1,244.71 $ 1,895.71 $ 475.23 $ 1,420.48 $ 1,649.63 $ 223.94 $ 1.425.69 $ 1,890.50 $ 471.32 $ 1.419.18 $ 2,648.27 $ 356.75 2,29152 $ 1,302.00 $ 706.99 $ 595.01 $ 1,367.10 $ 615.85 75125 $ 1,725.15 $ 404.92 $ 1,320.23 $ 1,620.99 $ 956.97 $ 664.02 $ 1895.71 $ 355.45 $ 1,540.27 $ 1,649.63 $ 2,429.53 $ (779.90) $ 1,890.50 $ 4,743.19 $ (2,852.68) $ 2,648.27 304.67 $ 2,343.60 $ 2,523.28 $ 734.33 $ 1,788.95 $ 3,300.57 $ 850.21 $ 2,450.36 $ 4,231.50 $ 318.99 $ 3,912.51 $ 9,509.81 $ 424.45 $ 9,085.36 $ 8,255.98 $ 85151 $ 7,404.47 $ 10,021.49 $ 1283.77 $ 8,737.72 $ 953.00 $ 190.60 $ 762.40 $ 1,000.65 $ 328.79 671.87 $ 1 262.73 $ 196.32 $ 1,066.41 $ 1,186.49 $ 275.42 911.07 $ 1,387.57 $ 347.85 $ 1,039.72 $ 1 207.45 $ 163.92 1,043.54 $ 1,383.76 $ 344.99 $ 1,038.77 $ 1,938.40 $ 261.12 1,677.28 $ 1,846.91 $ 517.48 $ 1,329.44 $ 2,415.86 $ 450.72 $ 1,965.09 $ 3,097.25$ 296.38 $ 2,800.87 $ 6,960.71 $ 700.46 $ 6,260.26 $ 6,042.97 $ 260.17 $ 5,782.80 $ 4,423.83 $ 1,778.30 $ 2,645.53 $ 6,045.83 $ 3,471.78 $ 2,574.05 $ 3,111.55 $ 223.00 $ 2.888.54 $ 1,383.76 $ 537.49 $ 846.26 $ 1,938.40 $ 622.31 $ 1,316.09 $ 1,846.91 $ 233.49 $ 1,613.43 $ 2.415.86 $ 310.68 $ 2,105.18 $ 3,097 25 $ 623.26 $ 2.473.99 $ 6,960.71 $ 939.66 $ 6,021.05 $ 6,042.97 $ 198.20 $ 5,844.77 4423.82 374190 $ 408192 4 Salespersol Mary Kari Larry Jerry Perry Gary Mary Kari Larry Jerry Perry Gary Mary Kari Larry Jerry Perry Gary Mary Kari Larry Jerry Perry Gary Mary Kari Larry Jerry Perry Gary Mary Kari Larry Jerry Perry Gary Mary Kari Larry Jerry Perry Gary Mary Kari Larry Tary 299% 637% 301% 642% 84% 122% 326% 69% 433% -32% -60% 769% 244% 288% 1227% 2140% 870% 681% 400% 204% 543% 331% 299% 637% 301% 642% 257% 436% 945% 894% 2223% 149% 74% 1295% 157% 211% 691% 678% 397% 641% 2949% 11949 1 2 4 1 2 WN 4 luu 1 2 3 4 1 2 1 2 3 4 1 2 3 uuuu Category Gross Sales - Cost Markup Amount Markup % Salesperson Cahier 4 1 2 4 1 2 4 1 2 Deli 4 1 2 4 1 2 Vegetable Pasta Vegetable Fruit Fruit Vegetable Soup Vegetable Baking Baking Dinners Chicken Meat Cheese Salad Dessert Chicken Beef Beef Fish Fish Vegetable Vegetable Pasta Vegetable Fruit Fruit Vegetable Soup Vegetable uuu 4 A Product Department 3/2/13 Onion Produce 3/3/13 Spaghetti Dry Goods 3/4/13 Cauliflower Produce 3/5/13 Grapes Produce 3/6/13 Apples Produce 3/7/13 Lettuce Produce 3/8/13 Canned Soup Dry Goods 3/9/13 Frozen Peas Frozen 3/10/13 Flour Dry Goods 3/11/13 Sugar Dry Goods 3/12/13 Frozen Pizza Frozen 3/13/13 Whole Chicken Meat 3/14/13Cold Cuts 3/15/13 Cheese Deli 3/16/13 Macaroni Salad Deli 3/17/13 Ice Cream Frozen 3/18/13 Chicken Legs Meat 3/19/13 Ground Beel Meat 3/20/13 Chuck Steak Meat 3/21/13 Fresh Fish Meat 3/22/13 Shrimp Meat 4/1/13 Dry Beans Dry Goods 4/2/13 Onion Produce 4/3/13 Spaghetti Dry Goods 4/4/13 Cauliflower Produce 4/5/13 Grapes Produce 4/6/13 Apples Produce 4/7/13 Lettuce Produce 4/8/13 Canned Soup Dry Goods 4/9/13 Frozen Peas Frozen 4/10/13 Flour Dry Goods 4/11/13 Sugar Dry Goods 4/12/13 Frozen Pizza Frozen 4/13/13 Whole Chicken Meat 4/14/13 Cold Cuts Deli 4/15/13 Cheese Deli 4/16/13 Macaroni Salad Deli 4/17/13 Ice Cream Frozen 4/18/13 Chicken Legs Meat 4/19/13 Ground Beef Meat 4/20/13 Chuck Steak 4/21/13 Fresh Fish Meat 4/22/13 Shrimp Meat 5/1/13 Dry Beans Dry Goods 5/2/13 Onion Produce 5/3/13 Spaghetti Dry Goods 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 1 2 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 4,423.83 6,045.83 6,283.93 4,600.22 6,286.90 3,235.62 5,596.18 3,225.71 6,298.80 2,543.90 3,730.12 7,627.73 4,600.22 6,286.90 3,235.62 5,596.18 3,225.71 6,298.80 2,543.90 3,730.12 7,627.73 1,087.60 1,141.98 1,441.07 1,354.06 1,583.55 1,377.99 1,579.20 2.212.18 2,107.77 2,757.07 3,534.70 7,943.83 6,896.47 5,048.64 6,899.73 3,551.01 6,141.68 3,540.14 6,912.79 2,791.87 4,093.73 8,371.26 1,319.00 1381.25 1,723.63 $ 341.90 $ $ 204.15 $ $ 286.40 $ $ 361.72 $ $ 170.45 $ $ 358.74 $ $ 27153 $ $ 538.11 $ $ 468.74 $ $ 308.20 $ $ 728.39 $ $ 270.54 $ $ 1,849.21 $ $ 3,610 21 $ $ 231.89 $ $ 558.92 $ $ 647.12 $ $ 242.80 $ $ 323.07 $ $ 648.11 $ $ 977.13 $ $ 217.52 $ $ 375.22 $ $ 224.05 $ $ 314.32 $ $ 396.97 $ $ 187.07 $ $ 393.71 $ $ 298.00 $ $ 590.57 $ $ 514.43 $ $ 338.24 $ $ 799.39 $ $ 296.91 $ $ 2,029.46 $ $ 3,962.13 $ $ 254.50 $ $ 613.41 $ $ 710.20 $ $ 266.46 $ $ 354.56 $ $ 711.29 $ $ 1,072.37 $ $ 323.00 $ $ 503.53 $ $ 330.47 $ 4,081.93 5,841.69 5,997.53 4,238.51 6,116.45 2,876.87 5,324.64 2,687.59 5,830.05 2,235.70 3,001.74 7,357.18 2,751.02 2,676.69 3,003.72 5,037.25 2,578.58 6,056.00 2.220.83 3,082.01 6,650.60 870.08 766.76 1,217.02 1,039.75 1,186.57 1,190.92 1,185.48 1,914.18 1,517.20 2.242.63 3,196.46 7,144.44 6,599.56 3,019.18 2.937.61 3,296.52 5,528.27 2.829.94 6,646.32 2.437.31 3,382.44 7,298.88 996.00 877.73 1,393.16 1194% 2862% 2094% 1172% 3588% 802% 1961% 499% 1244% 725% 412% 2719% 149% 74% 1295% 901% 398% 2494% 687% 476% 681% 400% 204% 543% 331% 299% 637% 301% 642% 257% 436% 945% 894% 2223% 149% 74% 1295% 901% 398% 2494% 687% 476% 681% 308% 174% 422% Jerry Perry Gary Mary Kari Larry Jerry Perry Gary Mary Kari Larry Jerry Perry Gary Mary Kari Larry Jerry Perry Gary Mary Kari Larry Jerry Perry Gary Mary Kari Larry Jerry Perry Gary Mary Kari Larry Jerry Perry Gary Mary Kari Larry Jerry Perry Gary Mary 4 1 2 4 Baking 1 2 4 1 2 3 PWN Baking Dinners Chicken Meat Cheese Salad Dessert Chicken Beef Beef Fish Fish Vegetable Vegetable uuuuuu Meat 1 2 3 4 1 2 3 4 1 Nm urulu Pasta A Cahier 4 91 92 93 la 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 LLL lele Mary 111 112 Product Department 5/2/13 Onion Produce 5/3/13 Spaghetti Dry Goods 5/4/13 Cauliflower Produce 5/5/13 Grapes Produce 5/6/13 Apples Produce 5/7/13 Lettuce Produce 5/8/13 Canned Soup Dry Goods 5/9/13 Frozen Peas Frozen 5/10/13 Flour Dry Goods 5/11/13 Sugar Dry Goods 5/12/13 Frozen Pizza Frozen 5/13/13 Whole Chicken Meat 5/14/13Cold Cuts Deli 5/15/13 Cheese Deli 5/16/13 Macaroni Salad Deli 5/17/13 Ice Cream Frozen 5/18/13 Chicken Legs Meat 5/19/13 Ground Beef Meat 5/20/13 Chuck Steak Meat 5/21/13 Fresh Fish Meat 5/22/13 Shrimp Meat 6/1/13 Dry Beans Dry Goods 6/2/13 Onion Produce 6/3/13 Spaghetti Dry Goods 6/4/13 Cauliflower Produce 6/5/13 Grapes Produce 6/6/13 Apples Produce 6/7/13 Lettuce Produce 6/3/13 Canned Soup Dry Goods 6/9/13 Frozen Peas Frozen 6/10/13 Flour Dry Goods 6/11/13 Sugar Dry Goods 6/12/13 Frozen Pizza Frozen 6/13/13 Whole Chicken Meat 6/14/13 Cold Cuts Deli 6/15/13 Cheese Deli 6/16/13 Macaroni Salad Deli 6/17/13 Ice Cream Frozen 6/18/13 Chicken Legs Meat 6/19/13 Ground Beef Meat 6/20/13 Chuck Steak Meat 6/21/13 Fresh Fish Meat 6/22/13 Shrimp Meat 7/1/13 Dry Beans Dry Goods 7/2/13 Onion Produce 7/3/13 Spaghetti Dry Goods 7/4/13 Cauliflower practure 113 Category Vegetable Pasta Vegetable Fruit Fruit Vegetable Soup Vegetable Baking Baking Dinners Chicken Meat Cheese Salad Dessert Chicken Beef Beef Fish Fish Vegetable Vegetable Pasta Vegetable Fruit Fruit Vegetable Soup Vegetable Baking Baking Dinners Chicken Meat Cheese Salad Dessert Chicken Beef Beef Fish Fish Vegetable Vegetable Pasta Ventah Gross Sales Cost Markup Amount $ 1,381.25$ 503.53 $ 877.73 $ 1,723.63 $ 330.47 $ 1,393.16 $ 1,624.03 $ 433.81 $ 1,190 22 $ 1,886.72 $ 528.43 $ 1,358.30 $ 1,651.42 $ 288.14 $ 1,363 28 $ 1,881.74 $ 524.69 $ 1,357.05 $ 2,606.33 415.13 $ 2,191.20 $ 2,486.81 $ 750.04 $ 1,736.78 $ 3,230.08 50120 $ 2,728.87 $ 4,120.25 $ 365.34 $ 3,754.91 $ 9,167.48$ 446.47 $ 8,721.01 $ 7,968.55 $ 520.75 $ 7,447.80 $ 5,853.29 332.11 $ 5,521.18 $ 7,972.28 $ 517.82 $ 7,454.46 $ 4,138.93 431.81 $ 3,707.12 $ 7,104.52 $ 694.73 $ 6,409.79 $ 4,126.48$ 626.31 $ 3,500.17 $ 7,987.22 $ 467.97 $ 7,519.25 $ 3,269.92 $ 882.39 $ 2,38753 $ 4,760.18$ 430.83 $ 4,329.35 $ 9,656.77 $ 1,987 82 $ 7,668.94 $ 1,149.00 $ 245.00 $ 904.00 1,205.50 $ 408.85 $ 796.65 1,516.25 $ 251.78 $ 1,264.47 1,425.85 $ 345.57 $ 1,080.28 1,664.28 $ 431.45 $ 1,232.83 1,450.71 $ 213.36 $ 1,23735 1,659.76 $ 428.06 $ 1,231.70 2,317.42 $ 328.62 $ 1,988.80 2,208.94 $ 632.59 $ 1,576.35 2,883.55 $ 553.49 $ 2,330.06 $ 3,691.50 $ 370.43 $ 3,321.07 8,272.52 $ 849.55 $ 7,422.97 $ 7,184.33 $ 327.49 $ 6,856.84 5,264.46 $ 2,127.58 $ 3,136.88 7,187.72$ 4,135.59 $ 3,052.13 $ 3,708.45 $ 283.42 $ 3.425.03 6,400.11 $ 656.32 $ 5,743.79 $ 3,697.15 $ 756.89 $ 2,940.26 7,201.28 $ 295.85 $ 6,905.43 $ 2,919.71 $ 387.38 $ 2,532.33 4,272.32 $ 758.02 $ 3,514.30 $ 8,716.61 $ 1,133.18$ 7,583.43 1.499.33 $ 431 07 $ 1,068.26 $ 1,566.10 $ 624.69 $ 941.41 $ 4,126.48 $ 439.08 $ 3,687.40 798722 54991 $ 743731 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 1 2 3 4 Markup % Salesperson 174% Gary 422% Mary 274% Kari 257% Larry 473% Jerry 259% Perry 528% Gary 232% Mary 544% Kari 1028% Larry 1953% Jerry 1430% Perry 1662% Gary 14409 Mary 859% Kari 923% Larry 559% Jerry 1607% Perry 271% Gary 1005% 386% Kari 369% Larry 195% Jerry 502% Perry 313% Gary 286% 580% Kari 288% Larry 605% Jerry 249% Pe