Adams Betz Chatham Dedham Elm Gross revenue $234,000 S188,800 $357,380 $147,840 $73,200 Customer-level costs 57,040 147,000 117,200 218,580 115,720 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 corpo- rate 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. Prepare a customer-cost hierarchy report for Interiors by Louise, using the format in Exhibit 14-6. Prepare a customer-profitability analysis for the five customers, using the format in Exhibit 14-4. Comment on the results of the preceding reports. What recommendations would you give Louise? Required 1. 2. 3.
Customer-cost hierarchy, customer profitability. 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:
Trending now
This is a popular solution!
Step by step
Solved in 6 steps with 3 images