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.

Cornerstones of Cost Management (Cornerstones Series)
4th Edition
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Don R. Hansen, Maryanne M. Mowen
Chapter3: Cost Behavior
Section: Chapter Questions
Problem 10E: SmokeCity, Inc., manufactures barbeque smokers. Based on past experience, SmokeCity has found that...
icon
Related questions
Question

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:

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.
Transcribed Image Text: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.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 6 steps with 3 images

Blurred answer
Knowledge Booster
Compensation and Benefits
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning