LeisureLand, Inc. is an upscale furniture retailer specializing in outdoor furniture and accessories. Its dedicated store network of 89 company-owned stores is primarily located on the East and West Coasts, and in some southern states. Faced with pricing pressures in some areas of the country, the company is considering expanding its operations in regions in which it is most able to accommodate those pressures and cutting back or phasing out of other areas. The company Controller has amassed relevant data in Tableau to assist in the analysis. Sales, Gross Profit, & Gross Profit by State in 2021 United Mexico GP Ratio by State 30.7% 44.4% States Louisiana Maryland Massachuse... Mississippi Nevada New Hamps... New Jersey New Mexico New York North Caroli... Oregon Pennsylvania Rhode Island Tennessee Texas Utah 2021 Mapbox OpenStreetMap Sales & Gross Profit by Region in 2021 East 2019-2021 AVG GP% by Region Vermont Midwest Virginia Region Region Northeast Washington Midwest Northeast South West 45.0% East 38.52% Sales & GP by Region 300M 200M 100M 70,683,000 OM Total Sales Gross Profit 27,165,000 Total Sales 125,530,000 Gross Profit 54,730,000 198,915,750 38.73% 38.72% Total Sales Gross Profit 73,860,750 184,624,000 35.0% 45.0% (All) Midwest 40.0% 41.67% East 39.87% 38.43% Total Sales Gross Profit 69,424,000 45.0% 43.60% 42.45% Northeast 43.35% 35.0% 45.0% South 40.0% 37.34% 37.19% 37.13% 45.0% 41.12% West 40.22% 35.0% Avg. 2019 Avg. 2020 37.60% Avg. 2021 LLLLLLLLL Midwest Northeast South West GP Ratio by Region (All) East Midwest Northeast South +ableau Drawing from the data available, assess the following: Complete this question by entering your answers in the tabs below. Req 1 Req 2 Req 3 A1 Req 3 A2 Req 3B Req 4 Which region of the country appears to generate the highest gross profit ratio in 2021? East Midwest Northeast South Owest Drawing from the data available, assess the following: Complete this question by entering your answers in the tabs below. Req 1 Req 2 Req 3 A1 Req 3 A2 Req 3B Req 4 Which region's gross profit ratio is experiencing favourable growth over the period 2019-2021? East Midwest Northeast South Owest Drawing from the data available, assess the following: Complete this question by entering your answers in the tabs below. Req 1 Req 2 Req 3 A1 Req 3 A2 Req 3B Req 4 Sales revenue is highest in which region of the company's operations? East Midwest Northeast South West Drawing from the data available, assess the following: Complete this question by entering your answers in the tabs below. Req 1 Req 2 Req 3 A1 Req 3 A2 Req 3B Req 4 Within the region with the highest sales revenue determined in 3(a), which state contributes most to those sales? State with highest revenue contribution Drawing from the data available, assess the following: Complete this question by entering your answers in the tabs below. Req 1 Req 2 Req 3 A1 Req 3 A2 Req 3B Req 4 Within the region with the highest sales revenue, what is the amount of sales revenue for the state that contributes most to those sales? $32,010,000. $93,100,000. $108,100,000. Drawing from the data available, assess the following: Complete this question by entering your answers in the tabs below. Req 1 Req 2 Req 3 A1 Req 3 A2 Req 3B Req 4 Based on the evidence provided by the data, the company should investigate which region most closely for possible phasing out of operations? East Midwest Northeast South West Total Sales 41% $ 2,079,000.00 $ 5,049,000.00 39% $ 10,070,000.00 $25,970,000.00 Region State % Gross Profit Gross Profit West Washington East Virginia Northeast Vermont West Utah South Texas South Tennessee Northeast Rhode Island Midwest Pennsylvania West East Oregon North Carolina Northeast New York West New Mexico Northeast New Jersey Northeast New Hampshire Nevada West South Mississippi Northeast Massachusetts Maryland East South Louisiana South Kentucky Midwest Kansas Midwest lowa Midwest Indiana Midwest Illinois West Idaho South Georgia South Florida Northeast Delaware Northeast Connecticut Colorado West West California South Arkansas West Arizona South Alabama 44% $ 2,160,000.00 $ 4,860,000.00 40% $ 860,000.00 $ 2,150,000.00 38% $12,210,000.00 $ 32,010,000.00 40% $ 466,000.00 $ 1,165,000.00 43% $ 2,530,000.00 $ 5,830,000.00 40% $ 7,752,000.00 $ 19,380,000.00 41% $ 1,848,000.00 $ 4,488,000.00 39% $12,496,300.00 $ 32,227,300.00 43% $ 9,200,000.00 $ 21,200,000.00 39% $ 6,460,000.00 $ 16,660,000.00 43% $10,120,000.00 $ 23,320,000.00 43% $ 5,060,000.00 $ 11,660,000.00 39% $ 3,705,000.00 $ 9,405,000.00 31% $ 1,316,700.00 $ 4,286,700.00 44% $ 9,400,000.00 $ 21,400,000.00 39% $ 6,557,440.00 $ 17,021,440.00 37% $ 1,782,390.00 $ 4,803,390.00 34% $ 2,264,140.00 $ 6,563,140.00 39% $ 4,237,000.00 $ 10,927,000.00 39% $ 3,705,000.00 $9,405,000.00 37% $ 5,775,000.00 $ 15,675,000.00 37% $ 5,696,000.00 $ 15,296,000.00 39% $ 4,032,000.00 $ 10,332,000.00 36% $ 2,526,520.00 $ 7,092,520.00 39% $36,100,000.00 $ 93,100,000.00 43% $ 6,900,000.00 $ 15,900,000.00 44% $ 9,360,000.00 $ 21,360,000.00 40% $10,400,000.00 $ 26,000,000.00 36% $39,100,000.00 $108,100,000.00 34% $ 7,595,000.00 $ 22,295,000.00 39% $ 940,000.00 $ 2,440,000.00 35% $ 9,600,000.00 $ 27,600,000.00