Spokes-N-Wheels, Inc. markets bicycles and bicycle-related products through the mail. Their market consists of serious cyclists throughout the United States. They compete successfully by offering upscale specialized equipment at competitive prices and giving exceptional customer service. Spokes-N-Wheels offers a complete line of cycling products. Complete bicycles are the largest contributor to both revenue and profit; however, they carry other cycling-related products in their catalog. Some items are carried even though they are marginally profitable since Spokes- N-Wheels wants to be able to meet all the customers' cycling needs. They do not want a customer to go to a competitor for a unique item because most mail-order customers prefer to deal with a single company. If customers order one item from a competitor, they are likely to order other items as well. Spokes-N-Wheels products are divided into four product lines: + Bicycles: Complete bicycles + Components: Frames, wheels, gears, etc., that customers use to construct, enhance, or maintain their own bicycles + Accessories: Helmets, water bottles, etc. + Clothing: Cycling apparel Each product line has a product manager. Spokes-N-Wheels publishes four catalogs per year. Each product manager wants to get as much display space (measured in square inches) in the catalog as possible. Although they have never analyzed it, they believe that the more display space devoted to an item, the more sales generated by the item. By coding orders, they are able to identify from which issue of the catalog the customer is ordering. Recently, Spokes-N-Wheels President and Chairman have become concerned about an apparent drop in sales. Sales from the last catalog were at a 3-year low. They do not know whether this is a one-time fluke or a trend. To boost sales, they have been increasing the amount of display space devoted to complete bicycles, their largest revenue linebut this does not seem to be enough Bikes Comp. Access. Total Sales Cloth. Access. Sales Period Catalog Comp. Sales Cloth. Sales Year 5. In 59. in. 54.in sq. in. 1 2 3 4 5 6 7 8 9 10 11 12 1988 1988 1988 1988 1989 1989 1989 1989 1990 1990 1990 1990 1 2 3 4 1 2 3 4 1 2 3 4 5,575 6,140 5,915 6,925 6,220 5,980 6,190 6,710 5,890 5,780 5,220 4,840 500 460 630 680 620 570 420 720 760 690 840 920 Bikes Sales 2,875 2,530 3,030 4,290 2,780 2,370 1,750 3,550 2,380 2,560 2,260 1.800 360 630 420 340 430 430 550 370 370 420 320 300 1,560 2,700 1,995 1,580 2,490 2,590 3,380 2,300 2,670 2,370 2,240 2,380 380 320 270 470 340 360 420 230 320 350 280 240 720 660 510 880 640 680 750 550 440 270 360 190 290 320 290 360 230 220 240 420 250 380 175 310 340 310 310 210 210 190 230 630 640 530 430 220 The table shows sales figures and the number of square inches devoted to each product line by catalog for the last 3 years. Using appropriate decision making tools what conclusions can you draw? Do the data indicate only a onetime fluke, or do they suggest that a serious problem exists? Your task is to explain current market dynamics affecting Spokes-N-Wheels and to recommend possible marketing decisions based on an exploration of these data. Your recommendations should focus on the amount of advertising space that should be allocated to each product. Should some receive more space? Should some receive less? Show all your workings to earn more credit. Spokes-N-Wheels, Inc. markets bicycles and bicycle-related products through the mail. Their market consists of serious cyclists throughout the United States. They compete successfully by offering upscale specialized equipment at competitive prices and giving exceptional customer service. Spokes-N-Wheels offers a complete line of cycling products. Complete bicycles are the largest contributor to both revenue and profit; however, they carry other cycling-related products in their catalog. Some items are carried even though they are marginally profitable since Spokes- N-Wheels wants to be able to meet all the customers' cycling needs. They do not want a customer to go to a competitor for a unique item because most mail-order customers prefer to deal with a single company. If customers order one item from a competitor, they are likely to order other items as well. Spokes-N-Wheels products are divided into four product lines: + Bicycles: Complete bicycles + Components: Frames, wheels, gears, etc., that customers use to construct, enhance, or maintain their own bicycles + Accessories: Helmets, water bottles, etc. + Clothing: Cycling apparel Each product line has a product manager. Spokes-N-Wheels publishes four catalogs per year. Each product manager wants to get as much display space (measured in square inches) in the catalog as possible. Although they have never analyzed it, they believe that the more display space devoted to an item, the more sales generated by the item. By coding orders, they are able to identify from which issue of the catalog the customer is ordering. Recently, Spokes-N-Wheels President and Chairman have become concerned about an apparent drop in sales. Sales from the last catalog were at a 3-year low. They do not know whether this is a one-time fluke or a trend. To boost sales, they have been increasing the amount of display space devoted to complete bicycles, their largest revenue linebut this does not seem to be enough Bikes Comp. Access. Total Sales Cloth. Access. Sales Period Catalog Comp. Sales Cloth. Sales Year 5. In 59. in. 54.in sq. in. 1 2 3 4 5 6 7 8 9 10 11 12 1988 1988 1988 1988 1989 1989 1989 1989 1990 1990 1990 1990 1 2 3 4 1 2 3 4 1 2 3 4 5,575 6,140 5,915 6,925 6,220 5,980 6,190 6,710 5,890 5,780 5,220 4,840 500 460 630 680 620 570 420 720 760 690 840 920 Bikes Sales 2,875 2,530 3,030 4,290 2,780 2,370 1,750 3,550 2,380 2,560 2,260 1.800 360 630 420 340 430 430 550 370 370 420 320 300 1,560 2,700 1,995 1,580 2,490 2,590 3,380 2,300 2,670 2,370 2,240 2,380 380 320 270 470 340 360 420 230 320 350 280 240 720 660 510 880 640 680 750 550 440 270 360 190 290 320 290 360 230 220 240 420 250 380 175 310 340 310 310 210 210 190 230 630 640 530 430 220 The table shows sales figures and the number of square inches devoted to each product line by catalog for the last 3 years. Using appropriate decision making tools what conclusions can you draw? Do the data indicate only a onetime fluke, or do they suggest that a serious problem exists? Your task is to explain current market dynamics affecting Spokes-N-Wheels and to recommend possible marketing decisions based on an exploration of these data. Your recommendations should focus on the amount of advertising space that should be allocated to each product. Should some receive more space? Should some receive less? Show all your workings to earn more credit