High Point Furniture Company (HPF) manufactures high-quality furniture for sale directly to exclusive hotels, interior designers, and select retail outlets throughout the world. HPF's products include upholstered furniture, dining tables, bedroom furniture, and a variety of other products, including end tables. Through attention to quality and design innovation, and by careful attention to changing consumer tastes, HPF has become one of the most successful furniture manufacturers worldwide. Hal Blin, the chief operating officer of HPF, is reviewing the most recent sales and profits report for the three best-selling end tables in HPF's product line-the Parker, Virginian, and Weldon end tables. Hal is concerned about the relatively poor performance of the Weldon line. He discusses the prospects for the line with HPF's marketing and sales vice-president, Joan Hunt. Joan notes that there has been no significant trend up or down in any of the end table lines, though the direction of consumer tastes would probably favor the Virginian and Parker lines. Hal and Joan agree that this may be the time for further analysis to determine whether the Weldon line should be discontinued..

Required

1. Using Excel or an equivalent spreadsheet, develop an analysis that can help Hal decide about the future of the Weldon line. Should the Weldon line be dropped? Why or why not?

2. Using the spreadsheet you developed in requirement 1, determine whether your answer would change if sales of Weldon are expected to fall by 80%.

3. Again using the spreadsheet in requirement 1, determine whether the Weldon line should be discontinued if the resources devoted to Weldon could be used to increase sales by 10% in each of the other two lines.

HPF Sales and Profits Report: End Tables

4. Again using the spreadsheet in requirement 1 and using Goal Seek in Excel or an equivalent, determine the sales increase (or decrease) in the sales of the Parker line that would be necessary to maintain the firm's overall profit determined in requirement 1 if the Weldon line were discontinued. For an illustration of Goal Seek, see Exhibit 9.5 in Chapter 9.
5. Given your answers to requirements 1 through 4 earlier, consider the overall competitive environment facing HPF and make your recommendations regarding the firm's strategic position and direction at this time?

Transcribed Image Text:

Parker Weldon Virginian Per Unit Per Unit Total Total Per Unit Total Total 150,000 Sales units Sales dollars 335,000 165,000 Factory Costs Labor Raw materials Power Repairs Factory equipment Other $ 459.00 S 68,850,000 S 365.00 S 122,275,000 S 248.00 S 40,920,000 S232,045,000 S 125.00 S 18,750,000 S 118.00 S 39,530,000 S 62.00 S10,230,000 S 68,510,000 5,226,000 8850 13,275,000 6600 22,110,000 23.50 12.25 33.50 14.00 78.00 13.80 12,870,000 2,277000 12.25 2,021,250 33.50 5,527.500 2,186 250 48,255,000 11,028,000 ,962,500 21,775,000 8,473,750 15.60 12.25 3,525,000 1,837,500 025,000 3350 11,222,500 2,100,000 4,103,750 12.50 4.187500 13.25 Total factory cost Selling and Administrative Expenses S 296.75 S 44,512,500 S 25785 S 86,379,750 S 21280 S 35,112,000S 166,004,250 Seling expense Office expense Administrative expense Other S 45.00 S 6,750,000 S36.00 S 12,060,000 S 25.00S4,125,000 S 22,935,000 5,628,000 9,212,500 2.177.500 6.80 27.50 6.50 392.55 2,520,000 4,125,000 975,000 58,882,500 16.80 27.50 6.50 344.65 15,457,750 16.80 27.50 6.50 288.60 2,772,000 537500 1,072,500 7,619,000 10,920,000 17,875,000 4,225,000 221,959,250 Total cost Operating profit (loss S 66.45 S 9,967,500 S 20.35 S 6,817 250 (40.60 S (6,699,000) 10,085,750