Louise Newman operates Interiors by Louise, an interior design consulting and window treatment fabrication business. Her business is made up of two different distribution channels, a consulting business in which Louise serves two architecture firms (Adams and Betz) and a commercial window treatment business in which Louise designs and constructs window treatments for three commercial clients (Chatham, Dedham, and Elm). Louise would like to evaluate the profitability of her two architecture firm clients and three commercial window treatment clients, as well as evaluate the profitability of each of the two channels and the business as a whole. Information about her most recent quarter follow:

Overhead costs total $340,400. Louise has determined that 25% of her overhead costs relate directly to her architectural business, 40% relate directly to her window treatment business, and the remainder are corporate overhead costs. On the revenues indicated above, Louise gave a 10% discount to Adams in order to lure it away from a competitor and gave a 5% discount to Elm for advance payment in cash.
Required:
1. Prepare a customer-cost hierarchy report for Interiors by Louise, using the format in Exhibit 14-6.
2. Prepare a customer-profitability analysis for the five customers, using the format in Exhibit 14-4.
3. Comment on the results of the preceding reports. What recommendations would you give Louise?

Transcribed Image Text:

AdamsBetz Chatham DedhamElm $234,000 $188,800 $357,380 $147,840 $73,200 Gross revenue Customer-level costs 147,000 117,200 218,580 15,720 57,040