Contemporary Trends sells paint and paint supplies, carpet, and wallpaper at a single-store location in suburban Baltimore. Although the company has been very profitable over the years, management has seen a significant decline in wallpaper sales and earnings. Much of this decline is attributable to the Internet and to companies that advertise deeply discounted prices in magazines and offer customers free shipping and toll-free telephone numbers. Recent figures follow.

Management is studying whether to drop wallpaper because of the changing market and accompanying loss. If the line is dropped, the following changes are expected to occur:

• The vacated space will be remodeled at a cost of $6,200 and will be devoted to an expanded line of high-end carpet. Sales of carpet are expected to increase by $60,000, and the line’s overall contribution margin ratio will rise by five percentage points.
• Contemporary Trends can cut wallpaper’s fixed costs by 40 percent. Remaining fixed costs will continue to be incurred.
• Customers who purchased wallpaper often bought paint and paint supplies. Sales of paint and paint supplies are expected to fall by 20 percent.
• The firm will increase advertising expenditures by $12,500 to promote the expanded carpet line.
  
  Required:
  1. Should Contemporary Trends close its wallpaper operation? Show your computations.
  2. Assume that Contemporary Trends’ wallpaper inventory at the time of the closure decision amounted to $11,850. How would you have treated this additional information in making the decision?
  3. What advantages might Internet- and magazine-based firms have over Contemporary Trends that would allow these organizations to offer deeply discounted prices—prices far below what Contemporary Trends can offer?
  4. Construct an Excel spreadsheet to solve requirement (1) above. Show how the solution will change if the following information changes: sales were $200,000, $225,000, and $65,000, for paint and supplies, carpeting, and wallpaper,respectively.

Transcribed Image Text:

Paint and Supples $190,000 $114,000 28,000 $142,000 $ 48,000 Carpeting $230,000 $161,000 37.500 $198,500 31,500 Wallpaper $70,000 $56,000 22,500 $78,500 $ (8,500) Sales Variable costs Fixed costs Total costs Operating income (loss)