Question
14-33 Customer-cost hierarchy, customer profitability. Louise Newman operates Interiors by Louise, an interior design consulting and window treatment fabrication business. Her business is made
14-33 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: Gross revenue Customer-level costs Adams $234,000 147,000 Betz Chatham Dedham Elm $188,800 117,200 $357,380 218,580 $147,840 $73,200 115,720 57,040 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. 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?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started