Question
You are an employee in the Corporate offices of a global resort management company, you were hired to assist in increasing profitability. You need to
You are an employee in the Corporate offices of a global resort management company, you were hired to assist in increasing profitability. You need to examine the retail operations of the company's resorts. Your first project is a destination resort in Florida. They are looking for a quick fix and are less concerned about changing the items and prices of those items currently for sale. Instead, your boss says your focus should be on use and allocation of the retail space in relation to revenues, profits and gross margin. A secondary focus could be helpful in the area of turnover and stock to sales ratios. Lastly, you may consider the physical layout of the store. There is no limit to the number of recommendations that you can make, but those recommendations must demonstrate your knowledge and appropriate application of the concepts, terminology and learning objectives from Retail - Module 8 with the highest points going to those related to Sales Analyses (space and revenue or profit or margin comparisons), followed by Inventory Management (turnover and stock to sales ratios), with Layout & Design being least important. You do not have to restrict your recommendations solely to one analysis - feel free to make recommendations related to Sales Analyses and/or Inventory Management and/or Layout & Design. However, any analysis or recommendation must be at the item-specific level. Sales Analyses and Inventory Management recommendations should include the appropriate calculations.
B D E F G H L M N 1 2 3 Category 4 Food 5 6 7 Item apples bananas bread frozen lemons limes prepared tomatoes 8 9 10 0.25 11 12 Beverage 13 beer creamer juice milk 14 15 16 17 soda 18 19 20 Apparell 21 22 23 24 25 26 27 28 29 Children sports drink water wine Bathing Suits Cover Ups Hats (Men) Hats (Women) Jewelry Scarves Sunglasses Tote bags T-shirts Bathing Suits Games Hats Stuffed Animals Tote bags Toys Totals Annual Numbers Space Allocated Sales Sq Feet % of Total Space Units Price Revenue % of Total Revenue Cost Profit 12 0.64% 23,510$ 0.75$ 17,632.50 0.86% $ 0.50 $ 5,877.50 12 0.64% 34,962 $ 0.80 $ 27,969.60 1.37% $ 0.40 $ 13,984.80 30 1.61% 27,354 $ 2.50 $ 68,385.00 3.35% $ 1.50 $ 27,354.00 42 2.25% 22,715$ 5.75$ 130,611.25 6.40% $ 2.00$ 85,181.25 6 0.32% 11,265 $ 1.00 $ 11,265.00 0.55% $ 0.50 $ 5,632.50 6 0.32% 10,865 $ 1.00 $ 10,865.00 0.53% $ 0.50 $ 5,432.50 60 3.21% 59,638$ 4.25$ 253,461.50 12.42% $ 3.50 $ 44,728.50 6 0.32% 9,976 $ 0.50 $ 4,988.00 0.24% $ 0.25$ 2,494.00 30 1.61% 59,638$ 4.50 $ 268,371.00 13.15% $ 4.00 $ 29,819.00 6 0.32% 11,265 $ 3.25$ 36,611.25 1.79% $ 2.00 $ 14,081.25 6 0.32% 22,684 $ 2.50 $ 56,710.00 2.78% $ 2.00 $ 11,342.00 6 0.32% 33,795$ 5.99$ 202,432.05 9.92% $ 4.00$ 67,252.05 42 2.25% 23,621 $ 1.25$ 29,526.25 1.45% $ 0.50 $ 17,715.75 60 3.21% 21,111 $ 1.25 $ 26,388.75 1.29% $ 0.50 $ 15,833.25 60 3.21% 46,851 $ 1.50$ 70,276.50 3.44% $ 1.00 $ 23,425.50 90 4.82% 19,511 $ 15.00$ 292,665.00 14.34% $ 9.00 $ 117,066.00 120 6.42% 250 $ 35.00 $ 8,750.00 0.43% $ 25.00 $ 2,500.00 90 4.82% 322 $ 25.00 $ 8,050.00 0.39% $ 15.00$ 3,220.00 60 3.21% 1,419 $ 10.00 $ 14,190.00 0.70% $ 5.00 $ 7,095.00 120 6.42% 2,120 $ 12.00 $ 25,440.00 1.25% $ 8.00 $ 8,480.00 30 1.61% 120$ 20.00 $ 2,400.00 0.12% $ 10.00 $ 1,200.00 120 6.42% 250 $ 15.00 $ 3,750.00 0.18% $ 5.00 $ 2,500.00 15 0.80% 762$ 25.00 $ 19,050.00 0.93% $ 10.00 $ 11,430.00 90 4.82% 54 $ 18.00 $ 972.00 0.05% $ 10.00 $ 432.00 90 4.82% 1,534 $ 22.00 $ 33,748.00 1.65% $ 5.00 $ 26,078.00 60 3.21% 384$ 20.00 $ 7,680.00 0.38% $ 10.00 $ 3,840.00 150 8.03% 51 $ 10.00 $ 510.00 0.02% $ 6.00 $ 204.00 30 1.61% 5,678$ 10.00 $ 56,780.00 2.78% $ 5.00 $ 28,390.00 90 4.82% 11,356 $28.00 $ 317,968.00 15.58% $ 15.00 $ 147,628.00 1301 6.96% 2,103 $ 12.00 $ 25,236.00 1.24% $ 3.00 $ 18,927.00 200 10.70% 567 $ 15.00 $ 8,505.00 0.42% $ 2.00 $ 7,371.00 1869 100.00% 465,731 $ 2,041,187.65 100.00% $ 756,514.85 Total Retail Sales per Square Foot -->$ 1,092.13 Profit Ratios % of Total Profit Gross Margin Turnover Stock to Sales 0.78% $ 0.25 52 .005:1 1.85% $ 0.40 52 .005:1 3.62% $ 1.00 52 .005:1 11.26% $ 3.75 6 2:1 0.74% $ 0.50 52 .005:1 0.72% $ 0.50 52 .005:1 5.91% $ 0.75 12 .005:1 0.33% $ 52 .005:1 3.94% $ 0.50 24 1:1 1.86% $ 1.25 52 .025:1 1.50% $ 0.50 52 .025:1 8.89% $ 1.99 52 .025:1 2.34% $ 0.75 12 1:1 2.09% $ 0.75 12 1:1 3.10% $ 0.50 12 1:1 15.47% $ 6.00 4 3:1 0.33% $ 10.00 2 3:1 0.43% $ 10.00 2 3:1 0.94% $ 5.00 1 3:1 1.12% $ 4.00 1 3:1 0.16% $ 10.00 1 4:1 0.33% $ 10.00 1 4:1 1.51% $ 15.00 1 4:1 0.06% $ 8.00 2 5:1 3.45% $ 17.00 2 5:1 0.51% $ 10.00 2 2:1 0.03% $ 4.00 1 6:1 3.75% $ 5.00 3 4:1 19.51% $ 13.00 5 5:1 2.50% $ 9.00 5 5:1 0.97% $ 13.00 3 4:1 37.06% 30 31 32 33 34 35 36 GIFT BREAD vel! CHIN AND MP CEREAL TUTE IS *** children retail.jpg Q Se I Rules for ...ber 4.pdf Draft 2 - ...h page 10 en Shot .. 16.48 AM B D E F G H L M N 1 2 3 Category 4 Food 5 6 7 Item apples bananas bread frozen lemons limes prepared tomatoes 8 9 10 0.25 11 12 Beverage 13 beer creamer juice milk 14 15 16 17 soda 18 19 20 Apparell 21 22 23 24 25 26 27 28 29 Children sports drink water wine Bathing Suits Cover Ups Hats (Men) Hats (Women) Jewelry Scarves Sunglasses Tote bags T-shirts Bathing Suits Games Hats Stuffed Animals Tote bags Toys Totals Annual Numbers Space Allocated Sales Sq Feet % of Total Space Units Price Revenue % of Total Revenue Cost Profit 12 0.64% 23,510$ 0.75$ 17,632.50 0.86% $ 0.50 $ 5,877.50 12 0.64% 34,962 $ 0.80 $ 27,969.60 1.37% $ 0.40 $ 13,984.80 30 1.61% 27,354 $ 2.50 $ 68,385.00 3.35% $ 1.50 $ 27,354.00 42 2.25% 22,715$ 5.75$ 130,611.25 6.40% $ 2.00$ 85,181.25 6 0.32% 11,265 $ 1.00 $ 11,265.00 0.55% $ 0.50 $ 5,632.50 6 0.32% 10,865 $ 1.00 $ 10,865.00 0.53% $ 0.50 $ 5,432.50 60 3.21% 59,638$ 4.25$ 253,461.50 12.42% $ 3.50 $ 44,728.50 6 0.32% 9,976 $ 0.50 $ 4,988.00 0.24% $ 0.25$ 2,494.00 30 1.61% 59,638$ 4.50 $ 268,371.00 13.15% $ 4.00 $ 29,819.00 6 0.32% 11,265 $ 3.25$ 36,611.25 1.79% $ 2.00 $ 14,081.25 6 0.32% 22,684 $ 2.50 $ 56,710.00 2.78% $ 2.00 $ 11,342.00 6 0.32% 33,795$ 5.99$ 202,432.05 9.92% $ 4.00$ 67,252.05 42 2.25% 23,621 $ 1.25$ 29,526.25 1.45% $ 0.50 $ 17,715.75 60 3.21% 21,111 $ 1.25 $ 26,388.75 1.29% $ 0.50 $ 15,833.25 60 3.21% 46,851 $ 1.50$ 70,276.50 3.44% $ 1.00 $ 23,425.50 90 4.82% 19,511 $ 15.00$ 292,665.00 14.34% $ 9.00 $ 117,066.00 120 6.42% 250 $ 35.00 $ 8,750.00 0.43% $ 25.00 $ 2,500.00 90 4.82% 322 $ 25.00 $ 8,050.00 0.39% $ 15.00$ 3,220.00 60 3.21% 1,419 $ 10.00 $ 14,190.00 0.70% $ 5.00 $ 7,095.00 120 6.42% 2,120 $ 12.00 $ 25,440.00 1.25% $ 8.00 $ 8,480.00 30 1.61% 120$ 20.00 $ 2,400.00 0.12% $ 10.00 $ 1,200.00 120 6.42% 250 $ 15.00 $ 3,750.00 0.18% $ 5.00 $ 2,500.00 15 0.80% 762$ 25.00 $ 19,050.00 0.93% $ 10.00 $ 11,430.00 90 4.82% 54 $ 18.00 $ 972.00 0.05% $ 10.00 $ 432.00 90 4.82% 1,534 $ 22.00 $ 33,748.00 1.65% $ 5.00 $ 26,078.00 60 3.21% 384$ 20.00 $ 7,680.00 0.38% $ 10.00 $ 3,840.00 150 8.03% 51 $ 10.00 $ 510.00 0.02% $ 6.00 $ 204.00 30 1.61% 5,678$ 10.00 $ 56,780.00 2.78% $ 5.00 $ 28,390.00 90 4.82% 11,356 $28.00 $ 317,968.00 15.58% $ 15.00 $ 147,628.00 1301 6.96% 2,103 $ 12.00 $ 25,236.00 1.24% $ 3.00 $ 18,927.00 200 10.70% 567 $ 15.00 $ 8,505.00 0.42% $ 2.00 $ 7,371.00 1869 100.00% 465,731 $ 2,041,187.65 100.00% $ 756,514.85 Total Retail Sales per Square Foot -->$ 1,092.13 Profit Ratios % of Total Profit Gross Margin Turnover Stock to Sales 0.78% $ 0.25 52 .005:1 1.85% $ 0.40 52 .005:1 3.62% $ 1.00 52 .005:1 11.26% $ 3.75 6 2:1 0.74% $ 0.50 52 .005:1 0.72% $ 0.50 52 .005:1 5.91% $ 0.75 12 .005:1 0.33% $ 52 .005:1 3.94% $ 0.50 24 1:1 1.86% $ 1.25 52 .025:1 1.50% $ 0.50 52 .025:1 8.89% $ 1.99 52 .025:1 2.34% $ 0.75 12 1:1 2.09% $ 0.75 12 1:1 3.10% $ 0.50 12 1:1 15.47% $ 6.00 4 3:1 0.33% $ 10.00 2 3:1 0.43% $ 10.00 2 3:1 0.94% $ 5.00 1 3:1 1.12% $ 4.00 1 3:1 0.16% $ 10.00 1 4:1 0.33% $ 10.00 1 4:1 1.51% $ 15.00 1 4:1 0.06% $ 8.00 2 5:1 3.45% $ 17.00 2 5:1 0.51% $ 10.00 2 2:1 0.03% $ 4.00 1 6:1 3.75% $ 5.00 3 4:1 19.51% $ 13.00 5 5:1 2.50% $ 9.00 5 5:1 0.97% $ 13.00 3 4:1 37.06% 30 31 32 33 34 35 36 GIFT BREAD vel! CHIN AND MP CEREAL TUTE IS *** children retail.jpg Q Se I Rules for ...ber 4.pdf Draft 2 - ...h page 10 en Shot .. 16.48 AMStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started