? 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
-
A study of the time spent shopping in a supermarket for a market basket of 20 specific items showed an approximately uniform distribution between 20 minutes and 40 minutes. What is the probability...
-
In Fig P6.115 all pipes are 8-cm-diameter cast iron. Determine the flow rate from reservoir (1) if valve C is (a) closed; and (b) open, with Kvalve = 0.5. Oz-25 m 2) Z=0m Water at 20C 10 m L=100 m 30...
-
Prove that the order of convergence of the Crank-Nicolson finite difference method is \[O\left(\Delta x^{2}+\left(\frac{\Delta t}{2} ight)^{2} ight)\]
-
The trial balance columns of the worksheet for Firmament Roofing, Ltd. at March 31, 2017, are as follows. Other data: 1. A physical count reveals only 550 of roofing supplies on hand. 2. Depreciation...
-
4. See through a financial lens, what are the strengths and weaknesses of the two investments being evaluated? Which one looks more promising? Why?
-
In 2005, Bob Moyer was reviewing production costs for Mile High Cycles. Located in Denver, Colorado, the company sold very high-quality, handcrafted mountain bikes to bicycle retailers throughout the...
-
John and Ellen want to open their own grocery delivery service in a medium-sized city consisting of 250,000750,000 people. The service will offer elements suited for the targeted demographic needs of...
-
1) Suppose you invest $10000 into a mutual fund that is expected to earn a rate of return of 7%. How money will you have in 7 years? .Note: Express your answers in strictly numerical terms.For...
-
what financial data in this assignment supports the financial decision to reduce equity debt?
-
1) Ally wishes to leave a provision in her will that $1000 will be paid annually in perpetuity to a local charity. How much must she provide in her will for this perpetuity if the interest rate is...
-
Three paragraphs Cite an example of a work accident you have either experienced or witnessed. Fully describe the incident. What would you have done differently to avoid the occurrence? How do you...
-
What has the least impact on your credit score? Question 26 Select one: a. Amount of credit owing b. Payment history c. Length of credit history d. Acquiring new credit
-
The following data is reported for a fund and an appropriate benchmark as well as the risk-free rate each year: Risk-free Fund Benchmark Return Return rate Year 1 13% 10% 2% Year 2 10% 10% 2% Year 3...
-
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.
-
What would be the most effective option to increase employee motivation to stay and reduce the driver turnover rate? Why do you believe this option will be effective?
-
How else might the manager have handled the situation to prevent potential issues, including a negative impact on the teams performance?
-
This chapter discusses the use of job redesign to reduce turnover. Do you think this is feasible in this case? Why or why not? If so, how should the job be redesigned?
Study smarter with the SolutionInn App