Fluent Essays

Evaluation Criteria:Your submission will be graded based on whether the answers provided for each question are correct with supporting excel file. Create one sheet per question and name each sheet as Q1, Q2 etc. for Question 1, Question 2 etc.Questions [Maximum possible points: 25]1. What are the five best-selling products based on quantity sold? [2 pt.]2. What are the five worst selling products based on quantity sold? [2 pt.]3. What’s the average extended price by order? [2 pt.](HINT: Look at the extended price by order and then use “value field setting” to change to AVERAGE function)4. What is the average quantity sold per order? [3 pt.](HINT: Look at the total quantity by order and then use “value field setting” to change to AVERAGE function)5. Are our sales seasonal (look at total sales in dollars)? Explain. [3 pt.]6. Based on the data we have, does our discount policy appear to help sales? HINT: You need to compare the average discount and average $ sales across product lines.[3 pt.]7. What are the five most heavily discounted products? [2 pt.]8. Who are our five best customers based on total sales (i.e., Extended Price)? [2 pt.]9. What are the five most popular (quantity sold) products among our five best customers? (HINT: Apply a filter to include only the five best customers found in #8) [2 pt.]10. Create a pi-chart to demonstrate the average discount enjoyed by each customer segment? [ 2 pt.]11. Demonstrate (use a line graph) to show how total sales revenue (extended price) change for each State (customer State) [2 pt.] dd8d0b6_2c27_4fed_a121_dee847f7c84b.png b18802_f41f_4c25_a736_fdc91680fd56.png food_emporium.xlsx Unformatted Attachment Preview Sample Order Reports Workbook Source Data Write Your Full Name Here before submitting this assignment Order ID 10248 10248 10248 10249 10249 10250 10250 10250 10251 10251 10251 10252 10252 10252 10253 10253 10253 10254 10254 10254 10255 10255 10255 10255 10256 10256 10257 10257 10257 10258 10258 10258 10259 10259 10260 10260 10260 10260 10261 10261 10262 10262 10262 10263 10263 10263 10263 10264 10264 10265 10265 10266 10267 10267 10267 10268 10268 10269 10269 10270 10270 10271 10272 10272 10272 10273 10273 10273 10273 10273 10274 10274 10275 10275 10276 10276 10277 10277 10278 10278 10278 10278 10279 10280 10280 10280 10281 10281 10281 Page 1 Customer Name Suzan Plock Suzan Plock Suzan Plock Allan Strate Allan Strate Elnora Willison Elnora Willison Elnora Willison Daniela Becknell Daniela Becknell Daniela Becknell Cathrine Delamater Cathrine Delamater Cathrine Delamater Leota Vonderheide Leota Vonderheide Leota Vonderheide Tyrone Hine Tyrone Hine Tyrone Hine Christin Tillinghast Christin Tillinghast Christin Tillinghast Christin Tillinghast Kisha Grauer Kisha Grauer Darryl Manuelito Darryl Manuelito Darryl Manuelito Robin Balla Robin Balla Robin Balla Tomasa Gallow Tomasa Gallow Lucretia Moret Lucretia Moret Lucretia Moret Lucretia Moret Kelly Latorre Kelly Latorre Shayla Mcbath Shayla Mcbath Shayla Mcbath Carlene Phegley Carlene Phegley Carlene Phegley Carlene Phegley Tyrone Hine Tyrone Hine Oma Mehlman Oma Mehlman Daniela Becknell Melisa Pangle Melisa Pangle Melisa Pangle Bennie Schook Bennie Schook Malcolm Potthoff Malcolm Potthoff Erlinda Veltman Erlinda Veltman Kurt Bissonette Karrie Gue Karrie Gue Karrie Gue Darryl Manuelito Darryl Manuelito Darryl Manuelito Darryl Manuelito Darryl Manuelito Larissa Rumery Larissa Rumery Cathrine Martensen Cathrine Martensen Robin Balla Robin Balla Kelvin Ravencraft Kelvin Ravencraft Allan Laubach Allan Laubach Allan Laubach Allan Laubach Melisa Pangle Pete Heatley Pete Heatley Pete Heatley Kelvin Ravencraft Kelvin Ravencraft Kelvin Ravencraft Customer City Pittsburgh Pittsburgh Pittsburgh Miami Miami Philadelphia Philadelphia Philadelphia Tacoma Tacoma Tacoma Philadelphia Philadelphia Philadelphia Philadelphia Philadelphia Philadelphia Pittsburgh Pittsburgh Pittsburgh Tacoma Tacoma Tacoma Tacoma Salt Lake City Salt Lake City Charleston Charleston Charleston Kansas City Kansas City Kansas City Charleston Charleston Canton Canton Canton Canton Ann Arbor Ann Arbor Canton Canton Canton Salt Lake City Salt Lake City Salt Lake City Salt Lake City Pittsburgh Pittsburgh Kansas City Kansas City Tacoma Miami Miami Miami Providence Providence Honolulu Honolulu Honolulu Honolulu Miami Rochester Rochester Rochester Charleston Charleston Charleston Charleston Charleston Savannah Savannah Kansas City Kansas City Kansas City Kansas City St. Petersburg St. Petersburg New York New York New York New York Miami Alexandria Alexandria Alexandria St. Petersburg St. Petersburg St. Petersburg Customer State PA PA PA FL FL PA PA PA WA WA WA PA PA PA PA PA PA PA PA PA WA WA WA WA UT UT SC SC SC MO MO MO SC SC OH OH OH OH MI MI OH OH OH UT UT UT UT PA PA MO MO WA FL FL FL RI RI HI HI HI HI FL NY NY NY SC SC SC SC SC GA GA MO MO MO MO FL FL NY NY NY NY FL VA VA VA FL FL FL Customer Status Silver Silver Silver Platinum Platinum Platinum Platinum Platinum Platinum Platinum Platinum Platinum Platinum Platinum Platinum Platinum Platinum Gold Gold Gold Gold Gold Gold Gold Silver Silver Silver Silver Silver Gold Gold Gold Platinum Platinum Platinum Platinum Platinum Platinum Silver Silver Gold Gold Gold Gold Gold Gold Gold Gold Gold Gold Gold Platinum Silver Silver Silver Gold Gold Platinum Platinum Gold Gold Platinum Platinum Platinum Platinum Silver Silver Silver Silver Silver Silver Silver Silver Silver Gold Gold Platinum Platinum Silver Silver Silver Silver Silver Gold Gold Gold Platinum Platinum Platinum Order Product Unit Extended Total Date ID Product Price Quantity Discount Full Price Price Discount Jan-11 11 Queso Cabrales $14 12 0\% $168 $168 $0 Jan-11 42 Singaporean Hokkien Fried Mee $10 10 0\% $98 $98 $0 Jan-11 72 Mozzarella di Giovanni $35 5 0\% $174 $174 $0 Jan-11 51 Manjimup Dried Apples $42 40 0\% $1,696 $1,696 $0 Jan-11 14 Tofu $19 9 0\% $167 $167 $0 Jan-11 51 Manjimup Dried Apples $42 35 15\% $1,484 $1,261 $223 Jan-11 41 Jacks New England Clam Chowder $8 10 0\% $77 $77 $0 Jan-11 65 Louisiana Fiery Hot Pepper Sauce $17 15 15\% $252 $214 $38 Jan-11 65 Louisiana Fiery Hot Pepper Sauce $17 20 0\% $336 $336 $0 Jan-11 22 Gustafs Knäckebröd $17 6 5\% $101 $96 $5 Jan-11 57 Ravioli Angelo $16 15 5\% $234 $222 $12 Jan-11 33 Geitost $2 25 5\% $50 $48 $3 Jan-11 20 Sir Rodneys Marmalade $65 40 5\% $2,592 $2,462 $130 Jan-11 60 Camembert Pierrot $27 40 0\% $1,088 $1,088 $0 Jan-11 49 Maxilaku $16 40 0\% $640 $640 $0 Jan-11 39 Chartreuse verte $14 42 0\% $605 $605 $0 Jan-11 31 Gorgonzola Telino $10 20 0\% $200 $200 $0 Jan-11 55 Pâté chinois $19 21 15\% $403 $343 $60 Jan-11 74 Longlife Tofu $8 21 0\% $168 $168 $0 Jan-11 24 Guaraná Fantástica $4 15 15\% $54 $46 $8 Jan-11 36 Inlagd Sill $15 25 0\% $380 $380 $0 Jan-11 59 Raclette Courdavault $44 30 0\% $1,320 $1,320 $0 Jan-11 16 Pavlova $14 35 0\% $487 $487 $0 Jan-11 2 Chang $15 20 0\% $304 $304 $0 Jan-11 53 Perth Pasties $26 15 15\% $393 $393 $0 Jan-11 77 Original Frankfurter grüne Soße $10 12 0\% $125 $125 $0 Jan-11 27 Schoggi Schokolade $35 25 0\% $878 $878 $0 Jan-11 39 Chartreuse verte $14 6 0\% $86 $86 $0 Jan-11 77 Original Frankfurter grüne Soße $10 15 0\% $156 $156 $0 Jan-11 2 Chang $15 50 20\% $760 $608 $152 Jan-11 32 Mascarpone Fabioli $26 6 20\% $154 $123 $31 Jan-11 5 Chef Antons Gumbo Mix $17 65 20\% $1,105 $884 $221 Jan-11 21 Sir Rodneys Scones $8 10 0\% $80 $80 $0 Jan-11 37 Gravad lax $21 1 0\% $21 $21 $0 Jan-11 70 Outback Lager $12 21 25\% $252 $189 $63 Jan-11 57 Ravioli Angelo $16 50 0\% $780 $780 $0 Jan-11 62 Tarte au sucre $39 15 25\% $591 $443 $148 Jan-11 41 Jacks New England Clam Chowder $8 16 25\% $123 $92 $31 Jan-11 35 Steeleye Stout $14 20 0\% $288 $288 $0 Jan-11 21 Sir Rodneys Scones $8 20 0\% $160 $160 $0 Jan-11 5 Chef Antons Gumbo Mix $17 12 20\% $204 $163 $41 Jan-11 7 Uncle Bobs Organic Dried Pears $24 15 0\% $360 $360 $0 Jan-11 56 Gnocchi di nonna Alice $30 2 0\% $61 $61 $0 Jan-11 16 Pavlova $14 60 25\% $834 $626 $209 Jan-11 30 Nord-Ost Matjeshering $21 60 25\% $1,242 $932 $311 Jan-11 74 Longlife Tofu $8 36 25\% $288 $216 $72 Jan-11 24 Guaraná Fantástica $4 28 0\% $101 $101 $0 Jan-11 2 Chang $15 35 0\% $532 $532 $0 Jan-11 41 Jacks New England Clam Chowder $8 25 15\% $193 $164 $29 Jan-11 17 Alice Mutton $31 30 0\% $936 $936 $0 Jan-11 70 Outback Lager $12 20 0\% $240 $240 $0 Jan-11 12 Queso Manchego La Pastora $30 12 5\% $365 $347 $18 Jan-11 76 Lakkalikööri $14 15 15\% $216 $184 $32 Jan-11 40 Boston Crab Meat $15 50 0\% $735 $735 $0 Jan-11 59 Raclette Courdavault $44 70 15\% $3,080 $2,618 $462 Jan-11 29 Thüringer Rostbratwurst $99 10 0\% $990 $990 $0 Jan-11 72 Mozzarella di Giovanni $28 4 0\% $111 $111 $0 Jan-11 72 Mozzarella di Giovanni $28 20 5\% $556 $528 $28 Jan-11 33 Geitost $2 60 5\% $120 $114 $6 Jan-11 36 Inlagd Sill $15 30 0\% $456 $456 $0 Jan-11 43 Ipoh Coffee $37 25 0\% $920 $920 $0 Jan-11 33 Geitost $2 24 0\% $48 $48 $0 Jan-11 31 Gorgonzola Telino $10 40 0\% $400 $400 $0 Jan-11 72 Mozzarella di Giovanni $28 24 0\% $667 $667 $0 Jan-11 20 Sir Rodneys Marmalade $65 6 0\% $389 $389 $0 Jan-11 33 Geitost $2 20 0\% $40 $40 $0 Jan-11 40 Boston Crab Meat $15 60 5\% $882 $838 $44 Jan-11 10 Ikura $25 24 5\% $595 $565 $30 Jan-11 31 Gorgonzola Telino $10 15 5\% $150 $143 $8 Jan-11 76 Lakkalikööri $14 33 5\% $475 $451 $24 Jan-11 72 Mozzarella di Giovanni $28 7 0\% $195 $195 $0 Jan-11 71 Fløtemysost $17 20 0\% $344 $344 $0 Jan-11 24 Guaraná Fantástica $4 12 5\% $43 $41 $2 Jan-11 59 Raclette Courdavault $44 6 5\% $264 $251 $13 Jan-11 10 Ikura $25 15 0\% $372 $372 $0 Jan-11 13 Konbu $5 10 0\% $48 $48 $0 Jan-11 28 Rössle Sauerkraut $36 20 0\% $728 $728 $0 Jan-11 62 Tarte au sucre $39 12 0\% $473 $473 $0 Jan-11 44 Gula Malacca $16 16 0\% $248 $248 $0 Jan-11 59 Raclette Courdavault $44 15 0\% $660 $660 $0 Jan-11 63 Vegie-spread $35 8 0\% $281 $281 $0 Jan-11 73 Röd Kaviar $12 25 0\% $300 $300 $0 Jan-11 17 Alice Mutton $31 15 25\% $468 $351 $117 Jan-11 24 Guaraná Fantástica $4 12 0\% $43 $43 $0 Jan-11 75 Rhönbräu Klosterbier $6 30 0\% $186 $186 $0 Jan-11 55 Pâté chinois $19 20 0\% $384 $384 $0 Jan-11 35 Steeleye Stout $14 4 0\% $58 $58 $0 Jan-11 19 Teatime Chocolate Biscuits $7 1 0\% $7 $7 $0 Jan-11 24 Guaraná Fantástica $4 6 0\% $22 $22 $0 Sample Order Reports Workbook Order ID 10282 10282 10283 10283 10283 10283 10284 10284 10284 10284 10285 10285 10285 10286 10286 10287 10287 10287 10288 10288 10289 10289 10290 10290 10290 10290 10291 10291 10291 10292 10293 10293 10293 10293 10294 10294 10294 10294 10294 10295 10296 10296 10296 10297 10297 10298 10298 10298 10298 10299 10299 10300 10300 10301 10301 10302 10302 10302 10303 10303 10303 10304 10304 10304 10305 10305 10305 10306 10306 10306 10307 10307 10308 10308 10309 10309 10309 10309 10309 10310 10310 10311 10311 10312 10312 10312 10312 10313 10314 10314 10314 10315 Page 2 Customer Name Alton Wareing Alton Wareing Breanna Bordeau Breanna Bordeau Breanna Bordeau Breanna Bordeau Erlinda Veltman Erlinda Veltman Erlinda Veltman Erlinda Veltman Pete Sproule Pete Sproule Pete Sproule Suzan Plock Suzan Plock Ed Heffelfinger Ed Heffelfinger Ed Heffelfinger Zoila Mccamey Zoila Mccamey Carlene Phegley Carlene Phegley Dominic Comisky Dominic Comisky Dominic Comisky Dominic Comisky Jayme Balli Jayme Balli Jayme Balli Damon Lochridge Leota Vonderheide Leota Vonderheide Leota Vonderheide Leota Vonderheide Erlinda Veltman Erlinda Veltman Erlinda Veltman Erlinda Veltman Erlinda Veltman Alton Wareing Geoffrey Kohlman Geoffrey Kohlman Geoffrey Kohlman Allan Strate Allan Strate Elissa Vandersloot Elissa Vandersloot Elissa Vandersloot Elissa Vandersloot Leota Vonderheide Leota Vonderheide Ericka Hoak Ericka Hoak Kelly Latorre Kelly Latorre Ed Hubley Ed Hubley Ed Hubley Bennie Schook Bennie Schook Bennie Schook Malcolm Potthoff Malcolm Potthoff Malcolm Potthoff Geoffrey Kohlman Geoffrey Kohlman Geoffrey Kohlman Avis Salomone Avis Salomone Avis Salomone Loren Villafranca Loren Villafranca Marco Trautmann Marco Trautmann Bennie Parziale Bennie Parziale Bennie Parziale Bennie Parziale Bennie Parziale Kisha Grauer Kisha Grauer Alton Wareing Alton Wareing Ed Hubley Ed Hubley Ed Hubley Ed Hubley Mathew Spake Elissa Vandersloot Elissa Vandersloot Elissa Vandersloot Suzan Plock Customer City Ann Arbor Ann Arbor Cincinatti Cincinatti Cincinatti Cincinatti Honolulu Honolulu Honolulu Honolulu Kansas City Kansas City Kansas City Pittsburgh Pittsburgh Honolulu Honolulu Honolulu New York New York Salt Lake City Salt Lake City New Orleans New Orleans New Orleans New Orleans Minneapolis Minneapolis Minneapolis Kansas City Philadelphia Philadelphia Philadelphia Philadelphia Honolulu Honolulu Honolulu Honolulu Honolulu Ann Arbor New Orleans New Orleans New Orleans Miami Miami Chattanooga Chattanooga Chattanooga Chattanooga Philadelphia Philadelphia Charleston Charleston Ann Arbor Ann Arbor Alexandria Alexandria Alexandria Providence Providence Providence Honolulu Honolulu Honolulu New Orleans New Orleans New Orleans Savannah Savannah Savannah Kansas City Kansas City Charleston Charleston Charleston Charleston Charleston Charleston Charleston Salt Lake City Salt Lake City Ann Arbor Ann Arbor Alexandria Alexandria Alexandria Alexandria Salt Lake City Chattanooga Chattanooga Chattanooga Pittsburgh Source Data Customer State MI MI OH OH OH OH HI HI HI HI MO MO MO PA PA HI HI HI NY NY UT UT LA LA LA LA MN MN MN MO PA PA PA PA HI HI HI HI HI MI LA LA LA FL FL TN TN TN TN PA PA SC SC MI MI VA VA VA RI RI RI HI HI HI LA LA LA GA GA GA MO MO SC SC SC SC SC SC SC UT UT MI MI VA VA VA VA UT TN TN TN PA Customer Status Platinum Platinum Silver Silver Silver Silver Gold Gold Gold Gold Platinum Platinum Platinum Silver Silver Silver Silver Silver Platinum Platinum Gold Gold Silver Silver Silver Silver Platinum Platinum Platinum Gold Platinum Platinum Platinum Platinum Gold Gold Gold Gold Gold Platinum Platinum Platinum Platinum Platinum Platinum Platinum Platinum Platinum Platinum Platinum Platinum Platinum Platinum Silver Silver Platinum Platinum Platinum Gold Gold Gold Platinum Platinum Platinum Platinum Platinum Platinum Gold Gold Gold Gold Gold Platinum Platinum Gold Gold Gold Gold Gold Silver Silver Platinum Platinum Platinum Platinum Platinum Platinum Silver Platinum Platinum Platinum Silver Order Product Date ID Product Jan-11 30 Nord-Ost Matjeshering Jan-11 57 Ravioli Angelo Jan-11 19 Teatime Chocolate Biscuits Jan-11 72 Mozzarella di Giovanni Jan-11 15 Genen Shouyu Jan-11 60 Camembert Pierrot Jan-11 44 Gula Malacca Jan-11 27 Schoggi Schokolade Jan-11 60 Camembert Pierrot Jan-11 67 Laughing Lumberjack Lager Jan-11 40 Boston Crab Meat Jan-11 1 Chai Jan-11 53 Perth Pasties Jan-11 62 Tarte au sucre Jan-11 35 Steeleye Stout Jan-11 34 Sasquatch Ale Jan-11 46 Spegesild Jan-11 16 Pavlova Jan-11 54 Tourtière Jan-11 68 Scottish Longbreads Jan-11 64 Wimmers gute Semmelknödel Jan-11 3 Aniseed Syrup Jan-11 49 Maxilaku Jan-11 5 Chef Antons Gumbo Mix Jan-11 29 Thüringer Rostbratwurst Jan-11 77 Original Frankfurter grüne Soße Jan-11 13 Konbu Jan-11 51 Manjimup Dried Apples Jan-11 44 Gula Malacca Jan-11 20 Sir Rodneys Marmalade Jan-11 63 Vegie-spread Jan-11 24 Guaraná Fantástica Jan-11 75 Rhönbräu Klosterbier Jan-11 18 Carnarvon Tigers Feb-11 17 Alice Mutton Feb-11 75 Rhönbräu Klosterbier Feb-11 60 Camembert Pierrot Feb-11 43 Ipoh Coffee Feb-11 1 Chai Feb-11 56 Gnocchi di nonna Alice Feb-11 11 Queso Cabrales Feb-11 69 Gudbrandsdalsost Feb-11 16 Pavlova Feb-11 39 Chartreuse verte Feb-11 72 Mozzarella di Giovanni Feb-11 2 Chang Feb-11 62 Tarte au sucre Feb-11 59 Raclette Courdavault Feb-11 36 Inlagd Sill Feb-11 19 Teatime Chocolate Biscuits Feb-11 70 Outback Lager Feb-11 68 Scottish Longbreads Feb-11 66 Louisiana Hot Spiced Okra Feb-11 40 Boston Crab Meat Feb-11 56 Gnocchi di nonna Alice Feb-11 43 Ipoh Coffee Feb-11 17 Alice Mutton Feb-11 28 Rössle Sauerkraut Feb-11 65 Louisiana Fiery Hot Pepper Sauce Feb-11 40 Boston Crab Meat Feb-11 68 Scottish Longbreads Feb-11 49 Maxilaku Feb-11 71 Fløtemysost Feb-11 59 Raclette Courdavault Feb-11 18 Carnarvon Tigers Feb-11 39 Chartreuse verte Feb-11 29 Thüringer Rostbratwurst Feb-11 53 Perth Pasties Feb-11 30 Nord-Ost Matjeshering Feb-11 54 Tourtière Feb-11 62 Tarte au sucre Feb-11 68 Scottish Longbreads Feb-11 70 Outback Lager Feb-11 69 Gudbrandsdalsost Feb-11 4 Chef Antons Cajun Seasoning Feb-11 43 Ipoh Coffee Feb-11 71 Fløtemysost Feb-11 6 Grandmas Boysenberry Spread Feb-11 42 Singaporean Hokkien Fried Mee Feb-11 16 Pavlova Feb-11 62 Tarte au sucre Feb-11 69 Gudbrandsdalsost Feb-11 42 Singaporean Hokkien Fried Mee Feb-11 53 Perth Pasties Feb-11 43 Ipoh Coffee Feb-11 75 Rhönbräu Klosterbier Feb-11 28 Rössle Sauerkraut Feb-11 36 Inlagd Sill Feb-11 62 Tarte au sucre Feb-11 32 Mascarpone Fabioli Feb-11 58 Escargots de Bourgogne Feb-11 70 Outback Lager Unit Extended Total Price Quantity Discount Full Price Price Discount $21 6 0\% $124 $124 $0 $16 2 0\% $31 $31 $0 $7 18 0\% $131 $131 $0 $28 3 0\% $83 $83 $0 $12 20 0\% $248 $248 $0 $27 35 0\% $952 $952 $0 $16 21 0\% $326 $326 $0 $35 15 25\% $527 $395 $132 $27 20 25\% $544 $408 $136 $11 5 25\% $56 $42 $14 $15 40 20\% $588 $470 $118 $14 45 20\% $648 $518 $130 $26 36 20\% $943 $755 $189 $39 40 0\% $1,576 $1,576 $0 $14 100 0\% $1,440 $1,440 $0 $11 20 0\% $224 $224 $0 $10 15 15\% $144 $122 $22 $14 40 15\% $556 $473 $83 $6 10 10\% $59 $53 $6 $10 3 10\% $30 $27 $3 $27 9 0\% $239 $239 $0 $8 30 0\% $240 $240 $0 $16 15 0\% $240 $240 $0 $17 20 0\% $340 $340 $0 $99 15 0\% $1,485 $1,485 $0 $10 10 0\% $104 $104 $0 $5 20 10\% $96 $86 $10 $42 2 10\% $85 $76 $8 $16 24 10\% $372 $335 $37 $65 20 0\% $1,296 $1,296 $0 $35 5 0\% $176 $176 $0 $4 10 0\% $36 $36 $0 $6 6 0\% $37 $37 $0 $50 12 0\% $600 $600 $0 $31 15 0\% $468 $468 $0 $6 6 0\% $37 $37 $0 $27 21 0\% $571 $571 $0 $37 15 0\% $552 $552 $0 $14 18 0\% $259 $259 $0 $30 4 0\% $122 $122 $0 $17 12 0\% $202 $202 $0 $29 15 0\% $432 $432 $0 $14 30 0\% $417 $417 $0 $14 60 0\% $864 $864 $0 $28 20 0\% $556 $556 $0 $15 40 0\% $608 $608 $0 $39 15 0\% $591 $591 $0 $44 30 25\% $1,320 $990 $330 $15 40 25\% $608 $456 $152 $7 15 0\% $110 $110 $0 $12 20 0\% $240 $240 $0 $10 20 0\% $200 $200 $0 $14 30 0\% $408 $408 $0 $15 10 0\% $147 $147 $0 $30 20 0\% $608 $608 $0 $37 12 0\% $442 $442 $0 $31 40 0\% $1,248 $1,248 $0 $36 28 0\% $1,019 $1,019 $0 $17 30 10\% $504 $454 $50 $15 40 10\% $588 $529 $59 $10 15 10\% $150 $135 $15 $16 30 0\% $480 $480 $0 $17 2 0\% $34 $34 $0 $44 10 0\% $440 $440 $0 $50 25 10\% $1,250 $1,125 $125 $14 30 10\% $432 $389 $43 $99 25 10\% $2,475 $2,228 $248 $26 10 0\% $262 $262 $0 $21 10 0\% $207 $207 $0 $6 5 0\% $30 $30 $0 $39 10 0\% $394 $394 $0 $10 3 0\% $30 $30 $0 $12 5 0\% $60 $60 $0 $29 1 0\% $29 $29 $0 $18 20 0\% $352 $352 $0 $37 20 0\% $736 $736 $0 $17 3 0\% $52 $52 $0 $20 30 0\% $600 $600 $0 $11 2 0\% $22 $22 $0 $14 10 0\% $139 $139 $0 $39 5 0\% $197 $197 $0 $29 7 0\% $202 $202 $0 $11 6 0\% $67 $67 $0 $26 20 0\% $524 $524 $0 $37 24 0\% $883 $883 $0 $6 10 0\% $62 $62 $0 $36 4 0\% $146 $146 $0 $15 12 0\% $182 $182 $0 $39 25 10\% $985 $887 $99 $26 40 10\% $1,024 $922 $102 $11 30 10\% $318 $286 $32 $12 30 0\% $360 $360 $0 Sample Order Reports Workbook Order ID 10315 10316 10316 10317 10318 10318 10319 10319 10319 10320 10321 10322 10323 10323 10323 10324 10324 10324 10324 10324 10325 10325 10325 10325 10325 10326 10326 10326 10327 10327 10327 10327 10328 10328 10328 10329 10329 10329 10329 10330 10330 10331 10332 10332 10332 10333 10333 10333 10334 10334 10335 10335 10335 10335 10336 10337 10337 10337 10337 10337 10338 10338 10339 10339 10339 10340 10340 10340 10341 10341 10342 10342 10342 10342 10343 10343 10343 10344 10344 10345 10345 10345 10346 10346 10347 10347 10347 10347 10348 10348 10349 10350 Page 3 Customer Name Suzan Plock Maricela Divis Maricela Divis Damon Vandenburg Tyrone Hine Tyrone Hine Valencia Aderhold Valencia Aderhold Valencia Aderhold Allan Lorentzen Marco Trautmann Clinton Goewey Kurt Bissonette Kurt Bissonette Kurt Bissonette Robin Balla Robin Balla Robin Balla Robin Balla Robin Balla Cathrine Delamater Cathrine Delamater Cathrine Delamater Cathrine Delamater Cathrine Delamater Christin Tillinghast Christin Tillinghast Christin Tillinghast Valencia Aderhold Valencia Aderhold Valencia Aderhold Valencia Aderhold Ellie Sittig Ellie Sittig Ellie Sittig Shayla Mcbath Shayla Mcbath Shayla Mcbath Shayla Mcbath Carlene Phegley Carlene Phegley Kisha Ciesla Pete Sproule Pete Sproule Pete Sproule Phillis Vawter Phillis Vawter Phillis Vawter Ed Heffelfinger Ed Heffelfinger Tyrone Hine Tyrone Hine Tyrone Hine Tyrone Hine Bennie Schook Clinton Goewey Clinton Goewey Clinton Goewey Clinton Goewey Clinton Goewey Ed Heffelfinger Ed Heffelfinger Ellie Sittig Ellie Sittig Ellie Sittig Avis Salomone Avis Salomone Avis Salomone Jayme Balli Jayme Balli Preston Mczeal Preston Mczeal Preston Mczeal Preston Mczeal Shayla Mcbath Shayla Mcbath Shayla Mcbath Jayme Crichlow Jayme Crichlow Preston Mczeal Preston Mczeal Preston Mczeal Lauretta Lucarelli Lauretta Lucarelli Portia Toenjes Portia Toenjes Portia Toenjes Portia Toenjes Kelvin Woodfolk Kelvin Woodfolk Cathrine Martensen Preston Mczeal Customer City Pittsburgh Alexandria Alexandria Rochester Pittsburgh Pittsburgh Charleston Charleston Charleston Miami Charleston Pittsburgh Miami Miami Miami Kansas City Kansas City Kansas City Kansas City Kansas City Philadelphia Philadelphia Philadelphia Philadelphia Philadelphia Tacoma Tacoma Tacoma Charleston Charleston Charleston Charleston Salt Lake City Salt Lake City Salt Lake City Canton Canton Canton Canton Salt Lake City Salt Lake City Chattanooga Kansas City Kansas City Kansas City Tacoma Tacoma Tacoma Honolulu Honolulu Pittsburgh Pittsburgh Pittsburgh Pittsburgh Providence Pittsburgh Pittsburgh Pittsburgh Pittsburgh Pittsburg ... Purchase answer to see full attachment