? 6. Format the data from A1:K179 on CustSales worksheet as a Table. Name this table Orders.
Fantastic news! We've Found the answer you've been seeking!
Question:
?
Transcribed Image Text:
6. Format the data from A1:K179 on CustSales worksheet as a Table. Name this table Orders. Apply a table style of your choice, not default. 7. Format table columns for Unit Price through Net Cost with comma style, and remove all decimal places from Quantity (column G) data since there are only whole items ordered. 8. Complete a multi-level sort of the table. First sort level is by Category (A to Z), then by Sales Rep (A to Z), then by Net Cost (largest to smallest). This is one sort. SAVE! Page 2 of 4 9. Create a pivot table on a new worksheet that shows the three shippers as row headings and the count of orders they have shipped. Rename Row Label "Shippers" and rename the column with number of shipments "Count of Shipments". Apply a style of your choice, not default, to the pivot table from the Pivot Table Styles gallery. Rename the worksheet as Shippers.. SAVE! 10. Create another pivot table on a new worksheet. Use your own judgement to select and present data that would be meaningful and useful for your company. Format and rename worksheet. 11. On the Documentation sheet, in B7, describe why you created the pivot table you developed in step 10 and what information it presents. 12. Go back to your Orders table and add a Total row, in row 180, using the SUBTOTAL function to calculate the Average Net Cost. Change the default label appropriately, don't leave it as Total. Order Date Sales Rep Shipper 1/3/2019 Buchanan United Package 3/6/2019 Buchanan Speedy Express 3/5/2019 Buchanan Speedy Express 10/3/2019 Duchasan Speedy Express 7/21/2019 Buchanan Speedy Express 4/2/2019 Buchanan Federal Shipping 3/22/2019 Buchanan Federal Shipping 2/25/2019 Buchanan Speedy Express 9/28/2019 Buchanan United Package 3/5/2019 Buchanan Speedy Express 11/21/2019 Buchanan Federal Shipping 10/3/2019 Buchanan Speedy Express 7/21/2019 Buchanan Speedy Express 2/8/2019 Buchanan United Package 3/6/2019 Buchanas Speedy Express 9/28/2019 Buchanan United Package 2/8/2019 Buchanan United Package 2/25/2019 Buchanan Speedy Express 20 9/29/2019 Buchanan Federal Shipping Federal Shipping United Packag 17 18 19 21 federal Shipping Speedy Express Spendy Express United Package United Package United Package 4 5 6 7 B 9 10 11 12 13 14 16 16 23 265 26 27 28 4/2/2019 Buchanen 10/20/2019 Buchanan 9/29/2019 Buchanan 10/1/2019 Buchanan /27/2019 Buchanan 10/20/2019 Buchanan 4/26/2019 Davis 6/1/2019 Da CustSales Product Name Côte de Baye Chai Chang Chartreuse verte Lakkalkö Category Beverages Beverages Beverages Beverages Beverages Beverages Beverages Beverages Beverages Beverages Condiments Condiments Condiments Condiments Original Frankfurter grüne Sole Grains/Cereah Tunnbröd Grains/Cereals Custaf's Knäckebröd Guaraná Fantástica Chartreuse verte Chang Garand Fantástica Guaraná Fontánk Gula Malacca Chef Anton's Cajun Seasoning Vege spread Grains/Cereals Favo Angelo Grains/Cereals Ravioli Angelo Mest/Poultry Perth Pasties Nice Mumon Meat/Poultry Meat/Poury Perth Pasties Meat/Poultry Tourtière Meat/Poultry Produce Produce Beverages Beverages Tourtière Manjup Dried Apples Tofu Côte de Maye Ipoh Coffee Unit Price Quantity 210.8 18 19 18 18 4.5 18 19 4.5 4.5 19.45 22 43.9 13 19 21 19.5 195 32.8 39 328 7.45 7.45 51 23.25 263.5 46 40 40 21 20 10 35 SubTotal a 5 15 6 50 12 6 15 50 15 15 10 25 15 10 30 6 48 30 60 00 Freight Discount Net Cost Discount% Freight Feet Highest 0.0% Highest $ Lowest 0.0% Lowest $ Q 1 Order Date Sales Rep 2 1/3/2019 Buchanan Nm. Shipper United Package 3/6/2019 Buchanan Speedy Express 3/5/2019 Buchanan Speedy Express 4 5 10/3/2019 Buchanan Speedy Express 6 3 A1 7 8 9 10 16 17 18 19 20 888588388588959445 30 Beverages 11 13 14 15 Beverages 7/21/2019 Buchanan Speedy Express 4/2/2019 Buchanan Federal Shipping Beverages 3/22/2019 Buchanan Federal Shipping Beverages 2/25/2019 Buchanan Speedy Express Beverages 9/28/2019 Buchanan United Package 3/5/2019 Buchanan Speedy Express 12 11/29/2019 Buchanan Federal Shipping 10/3/2019 Buchanan Speedy Express 7/21/2019 Buchanan Speedy Express 2/8/2019 Buchanan United Package 3/6/2019 Buchanan Speedy Express 9/28/2019 Buchanan United Package 2/8/2019 Buchanan United Package 2/25/2019 Buchanan Speedy Express 9/29/2019 Buchanan Federal Shipping 4/2/2019 Buchanan Federal Shipping 22 10/20/2019 Buchanan United Package 23 9/29/2019 Buchanan Federal Shipping 24 10/3/2019 Buchanan Speedy Express 25 6/27/2019 Buchanan Speedy Express 26 10/20/2019 Buchanan United Package 27 4/26/2019 Davis 21 28 6/1/2019 Davis 29 5/1/2019 Davis 5/14/2019 Davis 5/1/2019 Davis 32 12/23/2019 Davis 9/20/2019 Davis 9/13/2019 Davis 11/1/2019 Davis 36 1/31/2019 Davis 37 5/21/2019 Davis 8/2/2019 Davis 1/21/2019 Davis 3/24/2019 Davis 5/1/2019 Davis 1/8/2019 Davis 2/4/2019 Davis 2/28/2019 Davis 5/17/2019 Davis 1/17/2019 Davis 3/22/2019 Davis 31 33 40 41 42 B 46 47 C fix CustSales D Category Beverages Beverages Beverages Beverages Beverages Condiments Condiments United Package United Package Speedy Express United Package Speedy Express United Package Beverages United Package Beverages Beverages United Package Beverages United Package Beverages Federal Shipping Beverages United Package Beverages Speedy Express Beverages United Package Beverages United Package Speedy Express Beverages Beverages Federal Shipping Beverages Speedy Express United Package United Package Beverages Beverages Beverages Federal Shipping Beverages United Package Beverages Product Name Côte de Blaye Chai Chang E Chartreuse verte Lakkalikööri Guaraná Fantástica Chartreuse verte Chang Guaraná Fantástica Guaraná Fantástica Gula Malacca Chef Anton's Cajun Seasoning egie-spread Condiments Condiments Original Frankfurter grüne Soß Grains/Cereals Tunnbröd Grains/Cereals Gustaf's Knäckebröd Grains/Cereals Ravioli Angelo Grains/Cereals Ravioli Angelo Meat/Poultry Perth Pasties Meat/Poultry Alice Mutton Meat/Poultry Perth Pasties Meat/Poultry Tourtière Meat/Poultry Tourtière Produce Produce Beverages Beverages Beverages Beverages Manjimup Dried Apples Tofu Côte de Blaye Ipoh Coffee Lakkalikööri Ipoh Coffee Chang Chartreuse verte Chai Lakkalikööri Chai Steeleye Stout Steeleye Stout Steeleye Stout Rhönbräu Klosterbier Outback Lager Outback Lager Chartreuse verte Chang Guaraná Fantástica Chartreuse verte Rhönbräu Klosterbier Outback Lager Unit Prici Quantity 210.8 15 15 15 18 5 18 18 19 18 4.5 19 4.5 4.5 19.45 22 43.9 13 9 555556 21 19.5 19.5 32.8 39 32.8 7.45 7.45 53 23.25 263.5 46 18 46 19 14.4 14.4 18 18 14.4 18 18 7.75 12 15 14.4 19 4.5 G 18 7.75 15 8888888888888.855588 21 20 SubTotal 35 12 15 50 15 25 30 48 30 60 30 50 54 45 35 35 24 20 25 20 20 H 40 10 10 Freight 50 51 52 53 46 1/17/2019 Davis 47 3/22/2019 Davis 48 11/17/2019 Davis 49 3/15/2019 Davis 2/5/2019 Davis 4/15/2019 Davis 11/2/2019 Davis 8/2/2019 Davis 54 55 56 57 58 59 60 61 62 63 64 A1 65 66 67 68 69 70 71 72 K 38888588 90 File 93 LO Home 11/9/2019 Davis 2/14/2019 Davis 73 74 6/1/2019 Davis 75 11/24/2019 Davis 76 10/16/2019 Davis 77 1/25/2019 Davis 78 11/17/2019 Davis. 79 4/26/2019 Davis 7/5/2019 Davis 4/24/2019 Davis 80 81 82 5/21/2019 Davis 83 84 85 12/8/2019 Davis 1/8/2019 Davis 1/25/2019 Davis 86 6/4/2019 Davis 87 12/8/2019 Davis 11/9/2019 Davis 89 4/26/2019 Davis 5/14/2019 Davis 191 4/15/2019 Davis 92 10/18/2019 Denton 15/2019 Denton 2/28/2019 Davis 11/2/2019 Davis 5/21/2019 Davis 10/16/2019 Davis) 1/26/2019 Davis 7/5/2019 Davis 12/8/2019 Davis 1/31/2019 Davis 3/31/2019 Davis 2/14/2019 Davis 9/20/2019 Davis 3/25/2019 Davis 2/8/2019 Davis 7/5/2019 Davis 9/11/2019 Davis 9/13/2019 Davis 2/28/2019 Davis 6/20/2019 Davis seossa... Insert Page Layout fx Speedy Express United Package United Package Formulas D Speedy Express Federal Shipping Beverages Rhönbräu Klosterbier Outback Lager United Package Beverages Northwoods Cranberry Sauce Federal Shipping Condiments Condiments Original Frankfurter grüne Soll Speedy Express Aniseed Syrup Condiments Speedy Express Speedy Express Condiments Grandma's Boysenberry Spread Condiments Original Frankfurter grüne Soße Condiments Speedy Express Original Frankfurter grüne Soße Grandma's Boysenberry Spread Federal Shipping Condiments Original Frankfurter grüne Soße Federal Shipping Condiments - United Package Grains/Cereals Wimmers gute Semmelknödel Speedy Express Grains/Cereals Gnocchi di nonna Alice, United Package United Package Federal Shipping Grains/Cereals Ravioli Angelo United Package Grains/Cereals Filo Mix Data CustSales Federal Shipping Grains/Cereals Filo Mix Federal Shipping Meat/Poultry Thüringer Rostbratwurst Federal Shipping Meat/Poultry Pâté chinois Federal Shipping Meat/Poultry Thüringer Rostbratwurst United Package Meat/Poultry Speedy Express Meat/Poultry E Review Grains/Cereals Wimmers gute Semmelknödel Grains/Cereals Tunnbrod Perth Pasties Páté chinois Meat/Poultry Perth Pasties Meat/Poultry Perth Pasties Meat/Poultry Perth Pasties United Package Meat/Poultry Pâté chinois United Package Meat/Poultry Tourtière Federal Shipping Meat/Poultry Tourtière United Package Meat/Poultry Tourtière United Package Meat/Poultry Tourtière United Package Meat/Poultry Pâté chinois Federal Shipping Meat/Poultry Tourtière Manjimup Dried Apples Federal Shipping Produce United Package Produce Manjimup Dried Apples United Package Produce Manjimup Dried Apples Rössle Sauerkraut Produce Produce Speedy Express United Package Federal Shipping Produce Federal Shipping Produce Federal Shipping Produce Speedy Express Produce Federal Shipping Produce Federal Shipping Produce United Package Produce United Package Produce Produce Beverages Federal Shipping Beverages Speedy Express United Package Côte de Blaye Lakkalikoori View Rössle Sauerkraut Rössle Sauerkraut Rössle Sauerkraut Manjimup Dried Apples Uncle Bob's Organic Dried Pear Tofu Tofu Longlife Tofu Uncle Bob's Organic Dried Pear Rossle Sauerkraut F 7.75 15 40 13 8 25 13 13 20 13 33.25 38 19.5 33.25 7.2 7782 99 19.2 123 79 26.2 24 32.8 32.8 32.8 24 7.45 7.45 7.45 7.45 24 7.45 53 42.4 53 45.6 45.6 45.6 36.4 53 30 5096500 23.25 18.6 8 30 45.6 Help 263.5 18 6 10 3 99222222298258 222999222222299 RE 40 40 50 16 30 20 6 30 20 15 40 21 60 8 36 30 20 18 12 12 35 24 15 Acrobat 15 4 7 28 25 20 20 20 20 20 10 15 16 H 9 16 4 2 15 21 A1 96 97 98 B 93 2/15/2019 Denton 94 3/26/2019 Denton 95 5/16/2019 Denton 2/12/2019 Denton 7/4/2019 Denton 1/17/2019 Denton 6/15/2019 Denton 1/25/2019 Denton 1/17/2019 Denton 102 3/20/2019 Denton 103 3/20/2019 Denton 104 2/12/2019 Denton 105 2/22/2019 Denton 106 12/19/2019 Denton 107 5/29/2019 Denton 7/4/2019 Denton 3/20/2019 Denton 5/10/2019 Denton 108 99 100 101 109 110 111 File 128 129 130 131 132 133 Home Insert Page Layout fx 112 113 114 5/27/2019 Kaplan 117 115 12/5/2019 Kaplan 116 4/18/2019 Kaplan 11/6/2019 Kaplan 118 4/17/2019 Kaplan 119 9/14/2019 Kaplan 120 4/25/2019 Kaplan 121 9/7/2019 Kaplan 122 2/20/2019 Kaplan 123 11/28/2019 Kaplan 124 1/18/2019 Kaplan 125 5/23/2019 Kaplan 126 4/12/2019 Kaplan 127 4/30/2019 Kaplan 9/22/2019 Kaplan 3/7/2019 Kaplan 4/17/2019 Kaplan 2/8/2019 Kaplan 4/16/2019 Kaplan 8/29/2019 Kaplan 11/1/2019 Kaplan 5/8/2019 Kaplan 3/31/2019 Kaplan 134 135 6/3/2019 Kaplan 9/21/2019 Kaplan 4/18/2019 Kaplan 136 137 9/7/2019 Kaplan 138 1/18/2019 Kaplan 139 6/12/2019 Kaplan 140 4/25/2019 Kaplan LAS Channin C D Federal Shipping Beverages United Package United Package Beverages Beverages Speedy Express United Package Federal Shipping Beverages Beverages Beverages CustSales Formulas Federal Shipping Beverages Federal Shipping Beverages Federal Shipping Beverages. United Package Beverages United Package Condiments - Speedy Express United Package Speedy Express Federal Shipping United Package United Package Federal Shipping United Package Beverages Federal Shipping Beverages Speedy Express United Package Beverages Beverages Beverages Federal Shipping Beverages United Package Beverages Federal Shipping Beverages Federal Shipping Beverages Speedy Express Beverages Federal Shipping Beverages United Package Beverages Speedy Express Beverages United Package Speedy Express Beverages United Package Beverages Speedy Express Beverages Speedy Express Beverages Federal Shipping Beverages United Package Beverages Federal Shipping Beverages Speedy Express Beverages United Package Beverages Federal Shipping Beverages United Package Beverages United Package Beverages Speedy Express Beverages United Package Beverages Speedy Express Condiments Speedy Express Condiments Federal Shipping Condiments 17414 Data Lakkalikööri Chai Outback Lager Chang Rhönbräu Klosterbier. Sasquatch Ale Outback Lager Guaraná Fantástica Guaraná Fantástica Guaraná Fantástica Northwoods Cranberry Sauce Northwoods Cranberry Sauce Review Condiments Condiments Condiments Condiments Aniseed Syrup Gula Malacca Sirop d'érable Grains/Cereals Wimmers gute Semmelknödel Meat/Poultry Thüringer Rostbratwurst Meat/Poultry Tourtière Ipoh Coffee Steeleye Stout Lakkalikööri Lakkalikööri Chai Lakkalikööri Outback Lager Steeleye Stout Chang Chartreuse verte Steeleye Stout Steeleye Stout Steeleve Stout Rhönbräu Klosterbier Steeleye Stout Guaraná Fantástica Ipoh Coffee Sasquatch Ale Chang Outback Lager Outback Lager Rhönbräu Klosterbier Chartreuse verte Lakkalikööri Guaraná Fantástica Rhönbräu Klosterbier Guaraná Fantástica Northwoods Cranberry Sauce Chef Anton's Cajun Seasoning Vegie-spread Call. View Help Acrobat F | 18 18 15 19 5 ² 155 35 5 7.75 11.2 4.5 3.6 45 40 40 10 19.45 28.5 33.25 123.79 7.45 46 14.4 18 18 18 18 15 18 19 18 18 18 18 7.75 18 3.6 46 11.2 15.2 12 15 7.75 18. 14.4 4.5 6.2 4.5 40 22 43.9 G 21 20 14 10 20 10 7 20 15 10 30 20 49 16 4 30 24 20 36 100 60 50 50 44 50 40 30 30 30 25 21 42 18 80 6 20 10 12 9 12 5 6 14 4 3 30 50 20 A1 A B 137 138 9/7/2019 Kaplan 1/18/2019 Kaplan 139 6/12/2019 Kaplan) 140 4/25/2019 Kaplan 6/3/2019 Kaplan 9/27/2019 Kaplan 141 142 143 148 2/27/2019 Kaplan 144 9/12/2019 Kaplan 145 9/12/2019 Kaplan 146 2/20/2019 Kaplan 147 9/27/2019 Kaplan 2/20/2019 Kaplan 2/20/2019 Kaplan 6/21/2019 Kaplan 151 1/15/2019 Kaplan 152 10/10/2019 Kaplan 153 2/20/2019 Kaplan 154 5/8/2019 Kaplan 10/2/2019 Kaplan 149 150 155 156 157 158 File 180 181 182 183 Home 2/1/2019 Kaplan 5/3/2019 Kaplan 159 160 3/1/2019 Kaplan 161 4/18/2019 Kaplan 162 9/27/2019 Kaplan 163 2/27/2019 Kaplan 164 8/30/2019 Kaplan 165 5/28/2019 Kaplan 166 4/18/2019 Kaplan 167 9/13/2019 Kaplan 168 2/20/2019 Kaplan 169 5/31/2019 Kaplan 170 6/12/2019 Kaplan 171 4/17/2019 Kaplan 172 11/6/2019 Kaplan 173 4/30/2019 Kaplan 174 4/18/2019 Kaplan 175 5/28/2019 Kaplan 176 4/12/2019 Kaplan. 177 4/25/2019 Kaplan 178 9/7/2019 Kaplan 179 6/3/2019 Kaplan 184 LOC 4/17/2019 Kaplan 3/7/2019 Kaplan Insert Page Layout PA United Package Speedy Express Speedy Express Speedy Express Speedy Express United Package Federal Shipping United Package Speedy Express United Package United Package Federal Shipping United Package Speedy Express United Package United Package Speedy Express Formulas United Package Speedy Express Condiments Speedy Express Federal Shipping Condiments United Package Condiments Speedy Express Condiments United Package Condiments United Package Condiments Condiments CustSales Beverages Condiments Condiments Condiments Data Review View Guaraná Fantástical Northwoods Cranberry Sauce Chef Anton's Cajun Seasoning Vegie-spread Original Frankfurter grüne Soß Chef Anton's Gumbo Mix Aniseed Syrup Vegie-spread Gula Malacca iginal Frankfurter grüne Soße Original Frankfurter grüne Soße Grains/Cereals Wimmers gute Semmelknödel Grains/Cereals Tunnbröd Grains/Cereals Tunnbröd Grains/Cereals Gnocchi di nonna Alice Grains/Cereals Gnocchi di nonna Alice Grains/Cereals Singaporean Hokkien Fried Mec Grains/Cereals Singaporean Hokkien Fried Mee Grains/Cereals Gustaf's Knäckebröd Grains/Cereals Wimmers gute Semmelknödel Grains/Cereals Gustaf's Knäckebröd Grains/Cereals Tunnbröd Grains/Cereals Filo Mix Grains/Cereals Filo Mix Grains/Cereals Filo Mix Speedy Express Meat/Poultry Thüringer Rostbratwurst United Package Meat/Poultry Thüringer Rostbratwurst Federal Shipping Meat/Poultry Thüringer Rostbratwurst United Package Meat/Poultry Päté chinois United Package Meat/Poultry Perth Pasties United Package Meat/Poultry Alice Mutton Speedy Express Meat/Poultry Perth Pasties Speedy Express Meat/Poultry Tourtière United Package Meat/Poultry Tourtière Federal Shipping Meat/Poultry Paté chinois Federal Shipping Produce Speedy Express United Package United Package Speedy Express Produce Produce Produce Produce Federal Shipping Produce Produce Produce United Package United Package Uncle Bob's Organic Dried Pear Uncle Bob's Organic Dried Pear Uncle Bob's Organic Dried Pear Uncle Bob's Organic Dried Pear Manjimup Dried Apples Manjimup Dried Apples Tofu Rössle Sauerkraut F 4.5 40 22 43.9 13 17 10 35.1 15.5 10.4 10.4 33.25 9 9 30.4 30.4 14 14 21 33.25 16.8 9 7 7 7 99 123.79 99 24 32.8 31.2 26.2 7.45 7.45 19.2 30 30 30 30 42.4 53 23.25 45.6 Help G 3 30 50 20 28 20 30 8 16 10 10 48 70 70 20 20 42 30 20 8 12 18. 20 8 6 15 10 10 35 20 15 15 20 10 Acrobat 2 90 60 45 40 18 10 21 H 6. Format the data from A1:K179 on CustSales worksheet as a Table. Name this table Orders. Apply a table style of your choice, not default. 7. Format table columns for Unit Price through Net Cost with comma style, and remove all decimal places from Quantity (column G) data since there are only whole items ordered. 8. Complete a multi-level sort of the table. First sort level is by Category (A to Z), then by Sales Rep (A to Z), then by Net Cost (largest to smallest). This is one sort. SAVE! Page 2 of 4 9. Create a pivot table on a new worksheet that shows the three shippers as row headings and the count of orders they have shipped. Rename Row Label "Shippers" and rename the column with number of shipments "Count of Shipments". Apply a style of your choice, not default, to the pivot table from the Pivot Table Styles gallery. Rename the worksheet as Shippers.. SAVE! 10. Create another pivot table on a new worksheet. Use your own judgement to select and present data that would be meaningful and useful for your company. Format and rename worksheet. 11. On the Documentation sheet, in B7, describe why you created the pivot table you developed in step 10 and what information it presents. 12. Go back to your Orders table and add a Total row, in row 180, using the SUBTOTAL function to calculate the Average Net Cost. Change the default label appropriately, don't leave it as Total. Order Date Sales Rep Shipper 1/3/2019 Buchanan United Package 3/6/2019 Buchanan Speedy Express 3/5/2019 Buchanan Speedy Express 10/3/2019 Duchasan Speedy Express 7/21/2019 Buchanan Speedy Express 4/2/2019 Buchanan Federal Shipping 3/22/2019 Buchanan Federal Shipping 2/25/2019 Buchanan Speedy Express 9/28/2019 Buchanan United Package 3/5/2019 Buchanan Speedy Express 11/21/2019 Buchanan Federal Shipping 10/3/2019 Buchanan Speedy Express 7/21/2019 Buchanan Speedy Express 2/8/2019 Buchanan United Package 3/6/2019 Buchanas Speedy Express 9/28/2019 Buchanan United Package 2/8/2019 Buchanan United Package 2/25/2019 Buchanan Speedy Express 20 9/29/2019 Buchanan Federal Shipping Federal Shipping United Packag 17 18 19 21 federal Shipping Speedy Express Spendy Express United Package United Package United Package 4 5 6 7 B 9 10 11 12 13 14 16 16 23 265 26 27 28 4/2/2019 Buchanen 10/20/2019 Buchanan 9/29/2019 Buchanan 10/1/2019 Buchanan /27/2019 Buchanan 10/20/2019 Buchanan 4/26/2019 Davis 6/1/2019 Da CustSales Product Name Côte de Baye Chai Chang Chartreuse verte Lakkalkö Category Beverages Beverages Beverages Beverages Beverages Beverages Beverages Beverages Beverages Beverages Condiments Condiments Condiments Condiments Original Frankfurter grüne Sole Grains/Cereah Tunnbröd Grains/Cereals Custaf's Knäckebröd Guaraná Fantástica Chartreuse verte Chang Garand Fantástica Guaraná Fontánk Gula Malacca Chef Anton's Cajun Seasoning Vege spread Grains/Cereals Favo Angelo Grains/Cereals Ravioli Angelo Mest/Poultry Perth Pasties Nice Mumon Meat/Poultry Meat/Poury Perth Pasties Meat/Poultry Tourtière Meat/Poultry Produce Produce Beverages Beverages Tourtière Manjup Dried Apples Tofu Côte de Maye Ipoh Coffee Unit Price Quantity 210.8 18 19 18 18 4.5 18 19 4.5 4.5 19.45 22 43.9 13 19 21 19.5 195 32.8 39 328 7.45 7.45 51 23.25 263.5 46 40 40 21 20 10 35 SubTotal a 5 15 6 50 12 6 15 50 15 15 10 25 15 10 30 6 48 30 60 00 Freight Discount Net Cost Discount% Freight Feet Highest 0.0% Highest $ Lowest 0.0% Lowest $ Q 1 Order Date Sales Rep 2 1/3/2019 Buchanan Nm. Shipper United Package 3/6/2019 Buchanan Speedy Express 3/5/2019 Buchanan Speedy Express 4 5 10/3/2019 Buchanan Speedy Express 6 3 A1 7 8 9 10 16 17 18 19 20 888588388588959445 30 Beverages 11 13 14 15 Beverages 7/21/2019 Buchanan Speedy Express 4/2/2019 Buchanan Federal Shipping Beverages 3/22/2019 Buchanan Federal Shipping Beverages 2/25/2019 Buchanan Speedy Express Beverages 9/28/2019 Buchanan United Package 3/5/2019 Buchanan Speedy Express 12 11/29/2019 Buchanan Federal Shipping 10/3/2019 Buchanan Speedy Express 7/21/2019 Buchanan Speedy Express 2/8/2019 Buchanan United Package 3/6/2019 Buchanan Speedy Express 9/28/2019 Buchanan United Package 2/8/2019 Buchanan United Package 2/25/2019 Buchanan Speedy Express 9/29/2019 Buchanan Federal Shipping 4/2/2019 Buchanan Federal Shipping 22 10/20/2019 Buchanan United Package 23 9/29/2019 Buchanan Federal Shipping 24 10/3/2019 Buchanan Speedy Express 25 6/27/2019 Buchanan Speedy Express 26 10/20/2019 Buchanan United Package 27 4/26/2019 Davis 21 28 6/1/2019 Davis 29 5/1/2019 Davis 5/14/2019 Davis 5/1/2019 Davis 32 12/23/2019 Davis 9/20/2019 Davis 9/13/2019 Davis 11/1/2019 Davis 36 1/31/2019 Davis 37 5/21/2019 Davis 8/2/2019 Davis 1/21/2019 Davis 3/24/2019 Davis 5/1/2019 Davis 1/8/2019 Davis 2/4/2019 Davis 2/28/2019 Davis 5/17/2019 Davis 1/17/2019 Davis 3/22/2019 Davis 31 33 40 41 42 B 46 47 C fix CustSales D Category Beverages Beverages Beverages Beverages Beverages Condiments Condiments United Package United Package Speedy Express United Package Speedy Express United Package Beverages United Package Beverages Beverages United Package Beverages United Package Beverages Federal Shipping Beverages United Package Beverages Speedy Express Beverages United Package Beverages United Package Speedy Express Beverages Beverages Federal Shipping Beverages Speedy Express United Package United Package Beverages Beverages Beverages Federal Shipping Beverages United Package Beverages Product Name Côte de Blaye Chai Chang E Chartreuse verte Lakkalikööri Guaraná Fantástica Chartreuse verte Chang Guaraná Fantástica Guaraná Fantástica Gula Malacca Chef Anton's Cajun Seasoning egie-spread Condiments Condiments Original Frankfurter grüne Soß Grains/Cereals Tunnbröd Grains/Cereals Gustaf's Knäckebröd Grains/Cereals Ravioli Angelo Grains/Cereals Ravioli Angelo Meat/Poultry Perth Pasties Meat/Poultry Alice Mutton Meat/Poultry Perth Pasties Meat/Poultry Tourtière Meat/Poultry Tourtière Produce Produce Beverages Beverages Beverages Beverages Manjimup Dried Apples Tofu Côte de Blaye Ipoh Coffee Lakkalikööri Ipoh Coffee Chang Chartreuse verte Chai Lakkalikööri Chai Steeleye Stout Steeleye Stout Steeleye Stout Rhönbräu Klosterbier Outback Lager Outback Lager Chartreuse verte Chang Guaraná Fantástica Chartreuse verte Rhönbräu Klosterbier Outback Lager Unit Prici Quantity 210.8 15 15 15 18 5 18 18 19 18 4.5 19 4.5 4.5 19.45 22 43.9 13 9 555556 21 19.5 19.5 32.8 39 32.8 7.45 7.45 53 23.25 263.5 46 18 46 19 14.4 14.4 18 18 14.4 18 18 7.75 12 15 14.4 19 4.5 G 18 7.75 15 8888888888888.855588 21 20 SubTotal 35 12 15 50 15 25 30 48 30 60 30 50 54 45 35 35 24 20 25 20 20 H 40 10 10 Freight 50 51 52 53 46 1/17/2019 Davis 47 3/22/2019 Davis 48 11/17/2019 Davis 49 3/15/2019 Davis 2/5/2019 Davis 4/15/2019 Davis 11/2/2019 Davis 8/2/2019 Davis 54 55 56 57 58 59 60 61 62 63 64 A1 65 66 67 68 69 70 71 72 K 38888588 90 File 93 LO Home 11/9/2019 Davis 2/14/2019 Davis 73 74 6/1/2019 Davis 75 11/24/2019 Davis 76 10/16/2019 Davis 77 1/25/2019 Davis 78 11/17/2019 Davis. 79 4/26/2019 Davis 7/5/2019 Davis 4/24/2019 Davis 80 81 82 5/21/2019 Davis 83 84 85 12/8/2019 Davis 1/8/2019 Davis 1/25/2019 Davis 86 6/4/2019 Davis 87 12/8/2019 Davis 11/9/2019 Davis 89 4/26/2019 Davis 5/14/2019 Davis 191 4/15/2019 Davis 92 10/18/2019 Denton 15/2019 Denton 2/28/2019 Davis 11/2/2019 Davis 5/21/2019 Davis 10/16/2019 Davis) 1/26/2019 Davis 7/5/2019 Davis 12/8/2019 Davis 1/31/2019 Davis 3/31/2019 Davis 2/14/2019 Davis 9/20/2019 Davis 3/25/2019 Davis 2/8/2019 Davis 7/5/2019 Davis 9/11/2019 Davis 9/13/2019 Davis 2/28/2019 Davis 6/20/2019 Davis seossa... Insert Page Layout fx Speedy Express United Package United Package Formulas D Speedy Express Federal Shipping Beverages Rhönbräu Klosterbier Outback Lager United Package Beverages Northwoods Cranberry Sauce Federal Shipping Condiments Condiments Original Frankfurter grüne Soll Speedy Express Aniseed Syrup Condiments Speedy Express Speedy Express Condiments Grandma's Boysenberry Spread Condiments Original Frankfurter grüne Soße Condiments Speedy Express Original Frankfurter grüne Soße Grandma's Boysenberry Spread Federal Shipping Condiments Original Frankfurter grüne Soße Federal Shipping Condiments - United Package Grains/Cereals Wimmers gute Semmelknödel Speedy Express Grains/Cereals Gnocchi di nonna Alice, United Package United Package Federal Shipping Grains/Cereals Ravioli Angelo United Package Grains/Cereals Filo Mix Data CustSales Federal Shipping Grains/Cereals Filo Mix Federal Shipping Meat/Poultry Thüringer Rostbratwurst Federal Shipping Meat/Poultry Pâté chinois Federal Shipping Meat/Poultry Thüringer Rostbratwurst United Package Meat/Poultry Speedy Express Meat/Poultry E Review Grains/Cereals Wimmers gute Semmelknödel Grains/Cereals Tunnbrod Perth Pasties Páté chinois Meat/Poultry Perth Pasties Meat/Poultry Perth Pasties Meat/Poultry Perth Pasties United Package Meat/Poultry Pâté chinois United Package Meat/Poultry Tourtière Federal Shipping Meat/Poultry Tourtière United Package Meat/Poultry Tourtière United Package Meat/Poultry Tourtière United Package Meat/Poultry Pâté chinois Federal Shipping Meat/Poultry Tourtière Manjimup Dried Apples Federal Shipping Produce United Package Produce Manjimup Dried Apples United Package Produce Manjimup Dried Apples Rössle Sauerkraut Produce Produce Speedy Express United Package Federal Shipping Produce Federal Shipping Produce Federal Shipping Produce Speedy Express Produce Federal Shipping Produce Federal Shipping Produce United Package Produce United Package Produce Produce Beverages Federal Shipping Beverages Speedy Express United Package Côte de Blaye Lakkalikoori View Rössle Sauerkraut Rössle Sauerkraut Rössle Sauerkraut Manjimup Dried Apples Uncle Bob's Organic Dried Pear Tofu Tofu Longlife Tofu Uncle Bob's Organic Dried Pear Rossle Sauerkraut F 7.75 15 40 13 8 25 13 13 20 13 33.25 38 19.5 33.25 7.2 7782 99 19.2 123 79 26.2 24 32.8 32.8 32.8 24 7.45 7.45 7.45 7.45 24 7.45 53 42.4 53 45.6 45.6 45.6 36.4 53 30 5096500 23.25 18.6 8 30 45.6 Help 263.5 18 6 10 3 99222222298258 222999222222299 RE 40 40 50 16 30 20 6 30 20 15 40 21 60 8 36 30 20 18 12 12 35 24 15 Acrobat 15 4 7 28 25 20 20 20 20 20 10 15 16 H 9 16 4 2 15 21 A1 96 97 98 B 93 2/15/2019 Denton 94 3/26/2019 Denton 95 5/16/2019 Denton 2/12/2019 Denton 7/4/2019 Denton 1/17/2019 Denton 6/15/2019 Denton 1/25/2019 Denton 1/17/2019 Denton 102 3/20/2019 Denton 103 3/20/2019 Denton 104 2/12/2019 Denton 105 2/22/2019 Denton 106 12/19/2019 Denton 107 5/29/2019 Denton 7/4/2019 Denton 3/20/2019 Denton 5/10/2019 Denton 108 99 100 101 109 110 111 File 128 129 130 131 132 133 Home Insert Page Layout fx 112 113 114 5/27/2019 Kaplan 117 115 12/5/2019 Kaplan 116 4/18/2019 Kaplan 11/6/2019 Kaplan 118 4/17/2019 Kaplan 119 9/14/2019 Kaplan 120 4/25/2019 Kaplan 121 9/7/2019 Kaplan 122 2/20/2019 Kaplan 123 11/28/2019 Kaplan 124 1/18/2019 Kaplan 125 5/23/2019 Kaplan 126 4/12/2019 Kaplan 127 4/30/2019 Kaplan 9/22/2019 Kaplan 3/7/2019 Kaplan 4/17/2019 Kaplan 2/8/2019 Kaplan 4/16/2019 Kaplan 8/29/2019 Kaplan 11/1/2019 Kaplan 5/8/2019 Kaplan 3/31/2019 Kaplan 134 135 6/3/2019 Kaplan 9/21/2019 Kaplan 4/18/2019 Kaplan 136 137 9/7/2019 Kaplan 138 1/18/2019 Kaplan 139 6/12/2019 Kaplan 140 4/25/2019 Kaplan LAS Channin C D Federal Shipping Beverages United Package United Package Beverages Beverages Speedy Express United Package Federal Shipping Beverages Beverages Beverages CustSales Formulas Federal Shipping Beverages Federal Shipping Beverages Federal Shipping Beverages. United Package Beverages United Package Condiments - Speedy Express United Package Speedy Express Federal Shipping United Package United Package Federal Shipping United Package Beverages Federal Shipping Beverages Speedy Express United Package Beverages Beverages Beverages Federal Shipping Beverages United Package Beverages Federal Shipping Beverages Federal Shipping Beverages Speedy Express Beverages Federal Shipping Beverages United Package Beverages Speedy Express Beverages United Package Speedy Express Beverages United Package Beverages Speedy Express Beverages Speedy Express Beverages Federal Shipping Beverages United Package Beverages Federal Shipping Beverages Speedy Express Beverages United Package Beverages Federal Shipping Beverages United Package Beverages United Package Beverages Speedy Express Beverages United Package Beverages Speedy Express Condiments Speedy Express Condiments Federal Shipping Condiments 17414 Data Lakkalikööri Chai Outback Lager Chang Rhönbräu Klosterbier. Sasquatch Ale Outback Lager Guaraná Fantástica Guaraná Fantástica Guaraná Fantástica Northwoods Cranberry Sauce Northwoods Cranberry Sauce Review Condiments Condiments Condiments Condiments Aniseed Syrup Gula Malacca Sirop d'érable Grains/Cereals Wimmers gute Semmelknödel Meat/Poultry Thüringer Rostbratwurst Meat/Poultry Tourtière Ipoh Coffee Steeleye Stout Lakkalikööri Lakkalikööri Chai Lakkalikööri Outback Lager Steeleye Stout Chang Chartreuse verte Steeleye Stout Steeleye Stout Steeleve Stout Rhönbräu Klosterbier Steeleye Stout Guaraná Fantástica Ipoh Coffee Sasquatch Ale Chang Outback Lager Outback Lager Rhönbräu Klosterbier Chartreuse verte Lakkalikööri Guaraná Fantástica Rhönbräu Klosterbier Guaraná Fantástica Northwoods Cranberry Sauce Chef Anton's Cajun Seasoning Vegie-spread Call. View Help Acrobat F | 18 18 15 19 5 ² 155 35 5 7.75 11.2 4.5 3.6 45 40 40 10 19.45 28.5 33.25 123.79 7.45 46 14.4 18 18 18 18 15 18 19 18 18 18 18 7.75 18 3.6 46 11.2 15.2 12 15 7.75 18. 14.4 4.5 6.2 4.5 40 22 43.9 G 21 20 14 10 20 10 7 20 15 10 30 20 49 16 4 30 24 20 36 100 60 50 50 44 50 40 30 30 30 25 21 42 18 80 6 20 10 12 9 12 5 6 14 4 3 30 50 20 A1 A B 137 138 9/7/2019 Kaplan 1/18/2019 Kaplan 139 6/12/2019 Kaplan) 140 4/25/2019 Kaplan 6/3/2019 Kaplan 9/27/2019 Kaplan 141 142 143 148 2/27/2019 Kaplan 144 9/12/2019 Kaplan 145 9/12/2019 Kaplan 146 2/20/2019 Kaplan 147 9/27/2019 Kaplan 2/20/2019 Kaplan 2/20/2019 Kaplan 6/21/2019 Kaplan 151 1/15/2019 Kaplan 152 10/10/2019 Kaplan 153 2/20/2019 Kaplan 154 5/8/2019 Kaplan 10/2/2019 Kaplan 149 150 155 156 157 158 File 180 181 182 183 Home 2/1/2019 Kaplan 5/3/2019 Kaplan 159 160 3/1/2019 Kaplan 161 4/18/2019 Kaplan 162 9/27/2019 Kaplan 163 2/27/2019 Kaplan 164 8/30/2019 Kaplan 165 5/28/2019 Kaplan 166 4/18/2019 Kaplan 167 9/13/2019 Kaplan 168 2/20/2019 Kaplan 169 5/31/2019 Kaplan 170 6/12/2019 Kaplan 171 4/17/2019 Kaplan 172 11/6/2019 Kaplan 173 4/30/2019 Kaplan 174 4/18/2019 Kaplan 175 5/28/2019 Kaplan 176 4/12/2019 Kaplan. 177 4/25/2019 Kaplan 178 9/7/2019 Kaplan 179 6/3/2019 Kaplan 184 LOC 4/17/2019 Kaplan 3/7/2019 Kaplan Insert Page Layout PA United Package Speedy Express Speedy Express Speedy Express Speedy Express United Package Federal Shipping United Package Speedy Express United Package United Package Federal Shipping United Package Speedy Express United Package United Package Speedy Express Formulas United Package Speedy Express Condiments Speedy Express Federal Shipping Condiments United Package Condiments Speedy Express Condiments United Package Condiments United Package Condiments Condiments CustSales Beverages Condiments Condiments Condiments Data Review View Guaraná Fantástical Northwoods Cranberry Sauce Chef Anton's Cajun Seasoning Vegie-spread Original Frankfurter grüne Soß Chef Anton's Gumbo Mix Aniseed Syrup Vegie-spread Gula Malacca iginal Frankfurter grüne Soße Original Frankfurter grüne Soße Grains/Cereals Wimmers gute Semmelknödel Grains/Cereals Tunnbröd Grains/Cereals Tunnbröd Grains/Cereals Gnocchi di nonna Alice Grains/Cereals Gnocchi di nonna Alice Grains/Cereals Singaporean Hokkien Fried Mec Grains/Cereals Singaporean Hokkien Fried Mee Grains/Cereals Gustaf's Knäckebröd Grains/Cereals Wimmers gute Semmelknödel Grains/Cereals Gustaf's Knäckebröd Grains/Cereals Tunnbröd Grains/Cereals Filo Mix Grains/Cereals Filo Mix Grains/Cereals Filo Mix Speedy Express Meat/Poultry Thüringer Rostbratwurst United Package Meat/Poultry Thüringer Rostbratwurst Federal Shipping Meat/Poultry Thüringer Rostbratwurst United Package Meat/Poultry Päté chinois United Package Meat/Poultry Perth Pasties United Package Meat/Poultry Alice Mutton Speedy Express Meat/Poultry Perth Pasties Speedy Express Meat/Poultry Tourtière United Package Meat/Poultry Tourtière Federal Shipping Meat/Poultry Paté chinois Federal Shipping Produce Speedy Express United Package United Package Speedy Express Produce Produce Produce Produce Federal Shipping Produce Produce Produce United Package United Package Uncle Bob's Organic Dried Pear Uncle Bob's Organic Dried Pear Uncle Bob's Organic Dried Pear Uncle Bob's Organic Dried Pear Manjimup Dried Apples Manjimup Dried Apples Tofu Rössle Sauerkraut F 4.5 40 22 43.9 13 17 10 35.1 15.5 10.4 10.4 33.25 9 9 30.4 30.4 14 14 21 33.25 16.8 9 7 7 7 99 123.79 99 24 32.8 31.2 26.2 7.45 7.45 19.2 30 30 30 30 42.4 53 23.25 45.6 Help G 3 30 50 20 28 20 30 8 16 10 10 48 70 70 20 20 42 30 20 8 12 18. 20 8 6 15 10 10 35 20 15 15 20 10 Acrobat 2 90 60 45 40 18 10 21 H
Expert Answer:
Answer rating: 100% (QA)
6 Format the data from A1 K179 on CutSales worksheet as a Table Name this table Orders Apply a table style of your choice not default Keystroke to Insert Table Go to First Cell A1 of your Data and Pre... View the full answer
Related Book For
Introduction to Management Accounting
ISBN: 978-0133058789
16th edition
Authors: Charles Horngren, Gary Sundem, Jeff Schatzberg, Dave Burgsta
Posted Date:
Students also viewed these organizational behavior questions
-
A prix fixed menu offers a choice of 2 appetizers 4 main courses and 3 desserts If a tree diagramis used to list all possible me al combinations from the prix tixed meru, how many brandhes will there...
-
Name the three ways that an absorption-costing format differs from a variable-costing format.
-
Name several consumer behavior theories that apply both on and offline.
-
In Exercises 7980, find the value of y if the line through the two given points is to have the indicated slope. (3, y) and (1, 4), m = -3
-
What are social networks, and how are organizations using them?
-
Mill Co., a calendar-year manufacturer, which uses the FIFO inventory method, previously allocated production costs to inventory by use of a burden rate based on the ratios oft otal indirect...
-
A trial weight should generate a force equal to 10% of the rotor weight in order to establish the location and amount of imbalance. The rotor weighs 100 lb and has an operating speed of 3,600 rpm....
-
Omar Marquez is the audio engineer for Summer Musical Enterprises. The group is considering the purchase of a new sound system consisting of five separate components. The components are arranged in...
-
Weller Company's budgeted unit sales for next year are provided below: Budgeted unit sales 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 26,000 27,000 19,000 24,000 The company's variable selling...
-
Find the effective value of the voltage waveform in Fig. 11.57. v(t) LI-LI 0 2 46 8 10
-
Instrument A is table 1, and Instrument B is table 2. Answers the questions based on these two tables Instrument A Instrument B A F Annual payments Accumulated payments Guaranteed total Annual Annual...
-
Your friend Alex comes to you with his plan to start a business. He brings you the projected financial statements for the first two years, which you carefully analyze to compute the Free Cash Flow...
-
How do theories of team performance measurement and assessment, such as the Input-Process-Output model and Team Diagnostic Survey, provide insights into identifying areas for improvement and...
-
You want to purchase a $1,000,000, 8% cap rate property. The tenant has a long (100 years) lease with fixed rent (i.e., g = 0). A lender will lend you $800,000 as a 10-year balloon loan at a 6%...
-
Consider a $1000 face value 3-year treasury with 2.5% annual coupon and a yield of 1.3%. Suppose that after one year and after receiving one coupon payment, you decide to sell your treasury note....
-
Good Life Pte Ltd (Good Life) has been carrying on a business in Singapore of selling health supplements from Australia since 1 February 2014. It obtained its Goods and Services Tax (GST)...
-
A newly married couple wants $25,000 twenty years from now to take an anniversary trip to Hawaii. How much money must be deposited every month into an account earning 3.8% interest in order to meet...
-
Modify the counter from Exercise 5.44 such that the counter will either increment by 4 or load a new 32-bit value, D, on each clock edge, depending on a control signal Load. When Load = 1, the...
-
This chapter discussed transferring profits between divisions of a multinational company. Another situation where transfer prices have a similar effect is when a parent company transfers items to or...
-
You are given the following data: Sales $227,500,000 Invested capital $ 65,000,000 Net income .. $ 9,100,000 Compute the following: 1. Turnover of capital 2. Return on sales 3. Return on investment...
-
Explain why accelerated depreciation methods are superior to straight-line methods for income tax purposes.
-
Tesco plc is one of the worlds largest food retailers. Fiscal year 2014 (the year ended February 28, 2015) was a rocky year for the retailer. The companys sales and margins had come under pressure as...
-
Exhibit P2 displays a selected set of financial ratios for the years 20152017 of three fashion retailers: USbased Gap, UK-based Next, and Japan-based Uniqlo (Fast Retailing). Using this set of...
-
In 2009, following the worldwide credit crisis, several US-based car manufacturers, such as Chrysler and General Motors, approached bankruptcy and needed to be bailed out by the US government and...
Study smarter with the SolutionInn App