Chapter 7 Cost Volume-Profit Analysis Problem 7-48 Condensed monthly income data for Thurber Book Stores are presented in the following table for CVP Relationships Retail November 20x1. (Ignore income taxes.) (LO 7-1, 7-4) 317 Sales Less: Variable expenses Contribution margin Less: Fixed expenses Operating income Additional Information: Mall Store $80,000 Downtown Store 32,000 $120,000 84,000 Total $200,000- 2. Decrease in operating income: $1,400) $48,000 $ 36,000 116,000 $ 84,000 20,000 40,000 60,000 $28,000 $ (4,000) $ 24,000 Management estimates that closing the downtown store would result in a 10 percent decrease in mall store sales, while closing the mall store would not affect downtown store sales. One-fourth of each store's fixed expenses would continue through December 31, 20x2, if either store were closed. The operating results for November 20x1 are representative of all months. Required: 1. Calculate the increase or decrease in Thurber's monthly operating income during 20x2 if the downtown store is closed. 2. The management of Thurber Book Stores is considering a promotional campaign at the downtown store that would not affect the mall store. Annual promotional expenses at the downtown store would be increased by $60,000 in order to increase downtown store sales by 10 percent. What would be the effect of this promotional campaign on the company's monthly operating income during 20x2? 3. One-half of the downtown store's dollar sales are from items sold at their variable cost to attract customers to the store. Thurber's management is considering the deletion of these items, a move that would reduce the downtown store's direct fixed expenses by 15 percent and result in the loss of 20 percent of the remaining downtown store's sales volume. This change would not affect the mall store. What would be the effect on Thurber's monthly operating income if the items sold at their variable cost are eliminated? 4. Build a spreadsheet: Construct an Excel spreadsheet to solve all of the preceding requirements. Show how the solution will change if the following information changes: the downtown store's sales amounted to $126,000 and its variable expenses were $86,000. (CMA, adapted)