You will try to figure out how to maximize profits for a manufacturing company.It may be a good idea to eliminate certain products, or examine how one region is different from the other regions.Are any of the VistaBeans visualization helpful to your purposes?Show me what you would do with this data.

The Fletcher Company is a fictitious conglomerate with divisions in the retailing, manufacturing, and insurance industries. The retailing division consists of a chain of office supply stores known as Super Depot. Each student should assume the role of the divisional controller of SuperDepot. Pricing and product-line strategy decisions at SuperDepot are made by the CEO with input from the Vice President of Marketing. Fletcher's Vice President of Marketing has just resigned and the CEO wants to reevaluate the pricing and product-line strategy decisions for each division. Fletcher's CFO is out on an extended medical leave and has asked the divisional controller to complete assignment for SuperDepot without her assistance. For the purpose of making a decision about pricing and product line strategy at SuperDepot, provide Fletcher's CEO with an interactive report presenting the sales and profits of SuperDepot for the last four years.

Clipboard Formatting * Table . Good Font Alignment Number A2 X v fi 65 A B C D E F G H J K L 1 Order ID Status M N 2 65 Returned 3 69 Returned 4 134 Returned 5 135 Returned 6 230 Returned 7 324 Returned 8 359 Returned 9 612 Returned 10 614 Returned 11 678 Returned 12 710 Returned 13 740 Returned 14 775 Returned 15 833 Returned 16 902 Returned 17 928 Returned 18 930 Returned 19 1060 Returned 20 1127 Returned 21 1285 Returned 22 1317 Returned 23 1382 Returned 24 1538 Returned 25 1665 Returned 26 1921 Returned 27 2050 Returned 28 2052 Returned 29 2055 Returned 30 2146 Returned 31 2213 Returned 32 2240 Returned 32 2500 Returned Orders Returns Users + Ready e C wPaste Neutral Clipboard Font Alignment P11 fix Unit Price - Customer Name . Customer State - Zip Code Region - Product Category - Product Sub Category Ship Da 3 38,94 Muhammed Macintyrew Jersey 7514 East Office Supplies 6.24 5,98 2,08 Ruben Dart New York East Office Supplies Scissors, Rulers and Trimmers 32 15.7.2013 15 143,82 56,00 8,46 Liz Pelletier Computer Peripherals 32 24 Ohio 23 481,61 70,89 Liz Pelletier 32 159.8 154,93 7,99 Liz Pelletie Ohio Technology Telephones and Communication 32 26 2795,78 07,53 Liz Pelletier Ohio Central Furniture Office Furnishings 137,74 9,11 Julie Creighton Michigan Central Office Supplies Pens & Art Supplies 155,99 Julie Creighton Michigan Central Technology Telephones and Communication 10 36 2.11.2013 46 -959,79 65,99 Sample Company A Connecticut 6074 East Technology Telephones and Communication 65 32 3821,07 15,79 Tamara Dahlen East Technology Computer Peripherals 12 66 41 2,88 Arthur Gainer North Carolina South Office Supplies Pens & Art Supplies 13 69 4.6.2011 624,40 30,93 Jonathan Doherty 28 43567 Office Supplies 46 7827,62 27006 16 70 48 89,28 Rubber Bands 96 17.4.2011 37 4157,67 125,99 Keith Dawkins Texas Central Telephones and Communication 18 29.1.2012 26 75,14 -2.27 2,89 Craig Yedwab 85354 West Office Supplies Labels 129 6,48 Pauline Chand Connecticut East Office Supplies 29 569,1 Paper 130 8.5.2014 441,04 150,98 Roy Collins Florida 32003 Office Machines 130 8.5.2014 23 233,04 9,71 Roy Collins 32003 South Office Supplies Storage & Organization 132 10.6.2012 Maryland 30 Maryland South 1.5.2014 11 151,88 95,99 Michael Dominguez Colorado 81221 West 26 135 20.10.2013 25 124.5 -12,51 Ohio Central Computer Peripherals 166 11.9.2013 10 593,91 295,36 65,99 Valerie Takahito Utah West Telephones and Communication 193 7.8.2012 14 85231 West Office Supplies 327.6 74,04 7.28 Maria Zettner Georgia 30002 Office Furnishings 30 18,84 8.50 3.14 Maria Zettner 30002 Office Supplies Scissors, Rulers and Trimmers 27.12.2012 34 1315.8 6,09 36,55 Brad Thomas Connecticut East 31 195 Office Supplies Pens & Art Supplies 6.4.2013 Scissors, Rulers and Trimmers 7.38 Bart Folk Connecticut 6439 Furniture 33 -74,71 15,42 Bart Folk Connecticu 6439 East Office Supplies Storage & Organization East 35 18.6.2011 44 269.1 5,98 Bart Folk Connecticut 24.5.2013 24 128.34 North Carolina 27801 South Pens & Art Supplies 38 24 598,08 -32,37 Georgia 39901 South Office Supplies Binders and Binder Accessories 39 28.12.2012 46 581.44 12,64 Matt Abelman East 40 26.10.2012 46 2023,08 Texas Texas Technology Telephones and Communication 42 29.9.2011 363,25 Sean Braxton Illinois 62999 Office Supplies 43 28 12.2012 10 209 2 28.87 20,98 Liz Willingham 27010 South 44 North Carolina South Office Supplies Paper 45 6,54 Liz Willingham North Carolina 27010 South Office Supplies Binders and Binder Accessories 46 261 28.6.2012 40 140,99 Sonia Sunley Michigan Technology Telephones and Communication 25 135 -47.24 5.4 Paul Lucas California West 263 South e gGeneral Paste Copy MS Sans Serif * 10 AA = Wrap Text Format Painter BIU- - LA- = = 2 Merge & Center . - % " Conditional Form Clipboard Font Formatting - Ta Alignment Number A2 X V fx 65 A B C D E F G 1 Order ID Status H K M 22 1317 Returned 23 1382 Returned 24 1538 Returned 25 1665 Returned 26 1921 Returned 27 2050 Returned 28 2052 Returned 29 2055 Returned 30 2146 Returned 31 2213 Returned 32 2240 Returned 33 2500 Returned 34 2503 Returned 35 2562 Returned 36 2823 Returned 37 2915 Returned 38 3300 Returned 39 3456 Returned 40 3525 Returned 41 3589 Returned 42 3687 Returned 43 3777 Returned 44 3783 Returned 45 4006 Returned 46 4037 Returned 47 4230 Returned 48 4261 Returned 49 4391 Returned 50 4610 Returned 51 4738 Returned 52 4864 Returned 53 4960 Returned Orders Returns Users Readyala Review View Tell me what you want to do. 8 Cut Wrap Text General Paste Copy MS Sans Serif - 10 - A A Format Painter BIU- - -A- E= Merge & Center 100 Conditional Fo Formatting ~ Tz Clipboard Font Alignment Number A2 XY 65 A B C D E F G H J K L 1 Order ID Status 32 2240 Returned 33 2500 Returned 34 2503 Returned 35 2562 Returned 36 2823 Returned 37 2915 Returned 38 3300 Returned 39 3456 Returned 40 3525 Returned 41 3589 Returned 42 3687 Returned 43 3777 Returned 44 3783 Returned 45 4006 Returned 46 4037 Returned 47 4230 Returned 48 4261 Returned 49 4391 Returned 50 4610 Returned 51 4738 Returned 52 4864 Returned 53 4960 Returned 54 5028 Returned 55 5059 Returned 56 5061 Returned 57 5189 Returned 58 5381 Returned 59 5414 Returned 60 5511 Returned 61 5699 Returned 62 6054 Returned 63 6241 Returned Orders Returns Users Ready THIHHSuperDepotSales 2011-2014 - Excel Page Layout Formulas Data Review ? Tell me what you want to do. Cut Wrap Text Normal 2 Normal Bad Merge & Center ~ Formatting . Table - Font Styles P11 X fx Order Quantity Sales Unit Price . Customer Name .|Customer State . Zip Code 10.7.2013 25 19 1899,75 East Technology 82 487 206,9 58,30 45999 Central 9.8.2011 19.5.2010 19.5.2013 52 308,4 512 225,53 South Office Supplies Storage & Organization 36 5432.0 West 30.4.2010 85 515 18 392.0 Appliances 30.8 2009 87 28.8.2012 45.85 Central Office Furnishings 88 31 200,88 South Carolina 29941 South 22.9.2008 42 129,70 3,08 Sung Chung South Carolina 29941. Labels 22.9.2008 89 548 831,26 29941 South Technology Telephones and Communication 90 548 13.7.2014 30 1168.2 Washington 98390 West 92 549 6,48 Ken Brennan 98390 Paper West Office Supplies 93 549 14 24.02 Paper 610 1.8.2013 42 280,56 77037 Central Paper 29.1.2009 95 74, 19 17.7 Arthur Prichep 91188 Central Office Supplies Paper 96 50 264 612 Nebraska 68155 Centra 97 38 98 8,18 Michigan Storage & Organization 613 97,96 208.95 3330 Texas 78702 100 614 630.96 497,23 14,34 Dave Hallsten Texas Furniture 3.12.2011 East Furniture 102 640 3046,91 East 103 640 24.3.2013 20 2762,8 138, 14 Monica Federle New Jersey 3989 East 25.3.2010 643 1604.9 28633 South Furniture Chairs & Chairmats 105 644 556,85 Michigan 19810 Scissors, Rulers and Trimmers 107 646 19 58,92 East Office Supplies Delaware 19895 East 10.9.2010 108 678 109 706 8.9.2013 43 5,68 -27.79 1,76 Sarah Jordon Mass 1441 Office Supplies 4.1.2009 110 710 324,32 710 2.1.2012 29 705.57 45.45 Susan Mackendrick Ohio 45 161.1 10,17 3,58 Susan Mackendrick Ohio Office Supplies Binders and Binder Accessories Central Office Supplies 2.3.2009 112 29 187.92 Ohio 13 19 Ohio 43567 1.3.2012 8112 West Office Supplies 15.7.2010 115 Office Machines 116 769 1.6.2012 37 18 291,63 59,25 15,99 Roy French Delaware South Office Supplies 117 89.64 Nebraska Office Supplies Appliances 18.4.2009 118 16.4 2012 34 19.82 7,52 Pamela Stobb 119 16.4.2012 218,31 31 1189.29 65,99 Helen Abelman Michigan 49822 Technology Telephones and Communication East Office Supplies 5.12.2010 3.12.2013 28 -49, 14 Connecticut 6703 121 California 94404 19.3.2010 17.3.2013 29,82 -178 4,26 Peter McVee California 94404 West Office Supplies Pens & Art Supplies 123 124 Technology 125 31,98 -15.14 15,99 Kean Nguyen Maryland 21794 South 6.1 2010 374.4 Maryland 21794 South Office Supplies Binders and Binder Accessories 4.97 Toby Swindell Florida South 127 Orders Users ReadySuperDepotSales 2011-2014 - Excel Home Insert Page Layout Formulas of Cut Wrap Text Normal 2 Normal Bad Conditional Format as Good Font Styles 33985 X 13 10.2012 215,74 38,94 Muhammed Macintyrew Jersey 7514 Storage & Organization 5.98 15 New York 1045 East Office Supplies Scissors, Rulers and Trimmers 14197 35 70,89 Liz Pelletier Ohio 14197 Tables 16.7.2010 15.7.2013 154,93 17.7.2010 32 23 26 35 30 291,52 137,74 07,53 Liz Pelletier Ohio 14197 Office Furnishings 9,11 Julie Creighton Michigan 49822 Office Supplies 35 22. 10 2013 14 -246,68 Technology 36 46 Michigan Central 2507,62 821,07 137,44 65,99 Sample Company A Connecticut 6074 elephones and Communication 211.2010 65 Delaware 19936 East 18.3.2010 66 2,88 Arthur Gainer Office Supplies Pens & Art Supplies 69 42 0,93 Jonathan Doherty 43567 6.6.2008 69 28 Ohio 13567 Office Supplies 70 South Technology Telephones and Communication 70 48 86,32 1,86 Helen Wasserman North Carolina Rubber Bands 22.12.2009 96 37 4157,67 26,1 Texas 73301 97 26 -2.27 2,89 Craig Yedwab West Office Supplies Labels 129 20,97 29 6,48 Pauline Chand Connecticut 6439 28.11.2011 130 8.5.2014 569,1 18,97 Roy Collins 32003 Office Supplies 141.04 50,98 Roy Collins Office Machines 233,04 14,46 9,71 Roy Collins Florida 32003 South Office Supplies 132 10.6.2012 Maryland 21290 30 -28,01 30,98 Emily Phan South Furniture Bookcases 1.5.2014 11 532,27 95,99 Michael Dominguez Colorado West Office Supplies Storage & Organization 25 124.5 -12.51 4,98 Anne Pryor Ohio Central 65,99 Valerie Takahito Utah West Technolog Telephones and Communication 13.9.2010 193 7.8.2012 14 8523 West Office Supplies Storage & Organization 9.8.2009 194 5.4.2014 49 327,6 -74,04 7,28 Maria Zettner Georgi 30002 Furniture 7.4.2011 8.50 3,14 Maria Zettner Georgia South 195 34 1315,8 6,09 36.55 Brad Thomas Connecticut ;074 Office Supplies 28.12.2009 197 12,98 Penelope Sewall 45999 Scissors, Rulers and Trimmers 25 184,5 107,22 7,38 Bart Folk Connecticut 6439 East Office Furnishings 19.6.2008 224 224 18.6.2011 18.6.2011 33 524,28 -74,71 Connecticut 6439 East 269,1 5,98 Bart Folk 6439 East Office Supplies Paper 19.6.2008 119.50 North Carolina South Office Supplies Pens & Art Supplies 19,84 Karen Ferguson Office Supplies 28.12.2009 28.12.2012 24 46 598,08 32,37 24,92 Peter Fuller 28.12.2012 581,44 12,64 Matt Abelman Mass 2139 East Office Furnishings 30.12.2009 26.10.2012 46 2023,08 43,98 Erin Creighton Central Office Supplies Pens & Art Supplies 28. 10.2009 -341,04 125,99 Erin Creighton Texas Central Telephones and Communication 363,25 Sean Braxton Illinois 6299 Office Supplies 258 28.12.2012 10 209.8 North Carolina 24 -33,98 South Office Supplies Paper 258 28.12.2012 30.12.2009 258 28. 12.2012 215,82 -61, 13 6,54 Liz Willingham North Carolina Office Supplies Binders and Binder Accessories 5639.6 Michigan Telephones and Communication 261 28.6.2012 263 25 135 47.24 6061 West 1.1.2011 South Returns Users +C61 X Y fx A B C D E F 1 Region Manager 2 Central Chris 3 East Erin 4 South Sam 5 West William 6 West Pat 7 Central Pat 8 East Pat 9 South Pat 10 11 12 13 14 15 16 17 10