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.

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.
Expand
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 Answer

Want to see the step-by-step answer?

Check out a sample Q&A here.

Want to see this answer and more?

Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*

*Response times may vary by subject and question complexity. Median response time is 34 minutes for paid subscribers and may be longer for promotional offers.
Tagged in
Business
Accounting

Related Accounting Q&A

Find answers to questions asked by students like you.

Q: The following comment appeared in the financial press: “Inadequate financial disclosure, particularl...

A: Forecast: Any prediction or estimation is made for the events that is going to occur in the near fut...

Q: What are the major advantages of notes to the financial statements? What types of items are usually ...

A: The major advantages of notes to the financial statements are as follows:Additional information rela...

Q: Help with A,B,C, and D

A: (a) (1)Prepare journal entries for the purchase of raw materials, factory labor costs incurred, and ...

Q: In an effort to keep up with the rapidly changing global financial markets, the FASB issued standard...

A: Derivatives: Derivatives are some financial instruments which are meant for managing risk and safegu...

Q: At times, companies issue their shares for consideration other than cash. What is the measurement ob...

A: Issue of common stock for non-cash assets or services: Corporations often issue common stock for the...

Q: Balanced scorecard. Pineway Electric manufactures electric motors. It competes and plans to grow by ...

A:  

Q: Identify and briefly describe the two primary sources of shareholders’ equity.

A: Shareholders’ equity: Shareholders’ equity refers to the right the owner possesses over the resource...

Q: Cost allocation and decision making. Reidland Manufacturing has four divisions: Acme, Dune, Stark, a...

A: Cost Allocation:The process of assigning the cost to the cost object is cost allocation. The cost al...

Q: In 75 words or fewer, explain the difference between stock dividends and stock splits. Include the e...

A: Stock dividend: Dividends issued in form of additional shares is called stock dividend. Companies ha...

Q: At December 31, DePaul Corporation had a $16 million balance in its deferred tax asset account and a...

A: Multiple Temporary DifferenceIt is very unlikely to have a single temporary difference in any compan...

Q: Customer profitability in a manufacturing firm. Mississippi Manufacturing makes a component called B...

A: Customer Profitability Analysis: Customer profitability analysis is the process of ascertaining the ...

Q: For each of the following t-accounts, calculate the missing amount and write it in the space in the ...

A: Normal side of service revenue account is credit side. 

Q: Fantasy Fashions had used the LIFO method of costing inventories, but at the beginning of 2016 decid...

A:  

Q: Alcoa is the world’s leading producer of primary aluminum, fabricated aluminum, and alumina. The fol...

A: Explain the answer for the given requirements.

Q: Which of the following statements is true regarding correcting errors in previously issued financial...

A: IFRS: International Financial Reporting Standard is abbreviated as IFRS. The IFRS is set up to bring...

Q: Reporting earnings per share Return to the ABC data in Short Exercise S13-12. ABC had 8,000 shares o...

A: Income statement is a financial statement that shows the net income earned or net loss suffered by a...

Q: Identify the three common forms of business organization and the primary difference between the way ...

A: Three common forms of business organization are:Sole proprietorship: It is one form of simple busine...

Q: Johansen Corporation uses a predetermined overhead rate based on direct labor-hours to apply manufac...

A: Total estimated overheads.

Q: Bronson Industries reported a deferred tax liability of $8 million for the year ended December 31, 2...

A: Taxable Income The amount of adjusted gross income which is liable to be taxed is known as taxable i...

Q: The prescribed accounting treatment for stock dividends implicitly assumes that shareholders are foo...

A: Stock Dividends: It refers to the payment of dividends by a company to its existing shareholders, in...

Q: Indicate how the following items are recorded in the accounting records in the current year of Coron...

A: The adjustments to be made to the accounting records of Coronet CO for the current year would be bas...

Q: Accounting for cash dividends Java Company earned a net income of $85,000 during the year ended Dece...

A: Prepare the journal entry for the given transaction.

Q: A quasi reorganization is sometimes employed by a firm undergoing financial difficulties, but with f...

A: Quasi ReorganizationQuasi reorganization would be approved by the board of directors and shareholder...

Q: Airline pricing, considerations other than cost in pricing. Costal Airways is about to introduce a d...

A: 1.Determine the prices of tickets at different levels of sale.

Q: What is the indirect effect of a change in accounting principle? Briefly describe the reporting of t...

A: Change in an accounting principle: This change occurs when a company decides to change from an accou...

Q: Agee Storage issued 35 million shares of its $1 par common stock at $16 per share several years ago....

A: Retired stock: Buy back of shares from the shareholders by paying cash and obtaining the status of “...

Q: Customer profitability, distribution. Green Paper Delivery has decided to analyze the profitability ...

A: Customer Profitability Analysis: Customer profitability analysis is the process of ascertaining the ...

Q: At the end of the current year, Pociek Co. has prior servicecost of $9,150,000. Where should the pri...

A: Prior service cost: The change in the amount of projected benefit due to changes in the act or rules...

Q: Webster Products, Inc., adopted the dollar-value LIFO method of determining inventory costs for fina...

A: Inventory costing method:The costing method that is used to record the cost of goods sold, and endin...

Q: What are the major advantages of notes to the financialstatements? What types of items are usually r...

A: Notes to financial statements can be the information which is left out from the balance sheet and in...

Q: If it is discovered that an extraordinary repair in the previous year was incorrectly debited to rep...

A: Click to see the answer

Q: Journalizing a small stock dividend Element Water Sports has 13,000 shares of $1 par value common st...

A: Stock Dividends: It refers to the payment of dividends by a company to its existing shareholders, in...

Q: Balanced scorecard. Following is a random-order listing of perspectives, strategic objectives, and p...

A: Balanced Scorecard: Balanced scorecard is a commonly used strategic performance measurement tool. Th...

Q: What type of disclosure or accounting do you believe isnecessary for the following items?(a) Because...

A: Disclosures: The additional information which is attached to the entity's financial statements and u...

Q: Determining paid-in capital for a corporation Aruba Corporation recently organized. The company issu...

A: Capital Stock of CorporationCapital stock is issued by the corporation to raise funds from the inves...

Q: Target prices, target costs, activity-based costing. Snappy Tiles is a small distributor of marble t...

A: 1.Calculate S's operating income for 2016.

Q: King Cones leased ice cream-making equipment from Ace Leasing. Ace earns interest under such arrange...

A: Short term lease: It  is a one type of lease which has maximum lease period of 1 year or less than o...

Q: Stone Co. began operations in 2016 and reported $225,000 in income before income taxes for the year....

A: Click to see the answer

Q: Vulcan Company is a monthly depositor whose tax liability for March 20-- is $3,200. 1.  What is the ...

A: 1.The due date for the deposit of the taxes is April 15.

Q: Journalizing issuance of stock for assets other than cash Cedar Corporation issued 36,000 shares of ...

A: Valuation principle:  As per the principle, the  stock issued in exchange of assets other than cash,...

Q: In 2016, Borland Semiconductors entered into the transactions described below. In 2013, Borland had ...

A: Click to see the answer

Q: Cost-plus, time and materials, ethics. C & S Mechanical sells and services plumbing, heating, an...

A: Cost-plus pricing is a pricing mechanism where a certain % of mark-up value is added to the cost of ...

Q: Determine the meaning of the following terms.(a) Contributory plan.(b) Vested benefits.(c) Retroacti...

A: Plan assets: Assets which are created, maintained and planned for a specific purpose or benefit is t...