$360 per order$15 per case$560 per rush order$50 per unitOrder takingProduct handlingRush-order processingExchange and repair costsInformation about Mississippi's five biggest customers follows:ABDNumber of units purchased4,4008,1005,4001,80010%1,200Discounts given10%10%10% on half the unitsNumber of orders816502018Number of cases810540180120440Number of rush orders28Number of units exchanged/repaired200187013 All customers except E ordered units in the same order size. Customer E's order quantity varied, so E got adiscount part of the time but not all the time.Calculate the customer-level operating income for these five customers. Use the format in Exhibit 14-3.Prepare a customer-profitability analysis by ranking the customers from most to least profitable, as inExhibit 14-4.Required1.2. Discuss the results of your customer-profitability analysis. Does Mississippi have unprofitable customers?Is there anything Mississippi should do differently with its five customers?

Question
Asked Jan 24, 2020
2 views

Customer profitability in a manufacturing firm. Mississippi Manufacturing makes a component called B2040. This component is manufactured only when ordered by a customer, so Mississippi keeps no inventory of B2040. The list price is $112 per unit, but customers who place “large” orders receive a 10% discount on price. The customers are manufacturing firms. Currently, the salespeople decide whether an order is large enough to qualify for the discount. When the product is finished, it is packed in cases of 10. If the component needs to be exchanged or repaired, customers can come back within 14 days for free exchange or repair.

The full cost of manufacturing a unit of B2040 is $95. In addition, Mississippi incurs customer-level costs. Customer-level cost-driver rates are:

 

$360 per order
$15 per case
$560 per rush order
$50 per unit
Order taking
Product handling
Rush-order processing
Exchange and repair costs
Information about Mississippi's five biggest customers follows:
A
B
D
Number of units purchased
4,400
8,100
5,400
1,800
10%
1,200
Discounts given
10%
10%
10% on half the units
Number of orders
8
16
50
20
18
Number of cases
810
540
180
120
440
Number of rush orders
2
8
Number of units exchanged/repaired
200
18
70
13
help_outline

Image Transcriptionclose

$360 per order $15 per case $560 per rush order $50 per unit Order taking Product handling Rush-order processing Exchange and repair costs Information about Mississippi's five biggest customers follows: A B D Number of units purchased 4,400 8,100 5,400 1,800 10% 1,200 Discounts given 10% 10% 10% on half the units Number of orders 8 16 50 20 18 Number of cases 810 540 180 120 440 Number of rush orders 2 8 Number of units exchanged/repaired 200 18 70 13

fullscreen
All customers except E ordered units in the same order size. Customer E's order quantity varied, so E got a
discount part of the time but not all the time.
Calculate the customer-level operating income for these five customers. Use the format in Exhibit 14-3.
Prepare a customer-profitability analysis by ranking the customers from most to least profitable, as in
Exhibit 14-4.
Required
1.
2. Discuss the results of your customer-profitability analysis. Does Mississippi have unprofitable customers?
Is there anything Mississippi should do differently with its five customers?
help_outline

Image Transcriptionclose

All customers except E ordered units in the same order size. Customer E's order quantity varied, so E got a discount part of the time but not all the time. Calculate the customer-level operating income for these five customers. Use the format in Exhibit 14-3. Prepare a customer-profitability analysis by ranking the customers from most to least profitable, as in Exhibit 14-4. Required 1. 2. Discuss the results of your customer-profitability analysis. Does Mississippi have unprofitable customers? Is there anything Mississippi should do differently with its five customers?

fullscreen
check_circle

Expert Answer

Step 1

Customer Profitability Analysis: 

Customer profitability analysis is the process of ascertaining the amount of revenue earned from the customers and the cost incurred by the company to earn that revenue.

The company can do this analysis to see whether the product is profitable or not.

Step 2

1.

To compute: The customer level operating income for each customer, rank the customer according to the profitability and prepare customer profitability analysis.

Statement that shows the calculation of customer level operating income is,

Accounting homework question answer, step 2, image 1
fullscreen
Step 3

Spreadsheet calc...

Accounting homework question answer, step 3, image 1
fullscreen

Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in

Business

Accounting

Other

Related Accounting Q&A

Find answers to questions asked by student like you
Show more Q&A
add
question_answer

Q: Jackson Health Foods has 8,000 shares of $2 par common stock outstanding, which were issued at $15 p...

A: Owners’ equity: The claims of owners on a company’s resources, after the liabilities are paid off, a...

question_answer

Q: What account is used to record the premium when issuing common stock? What type of account is this?

A: Determine the account used to record the premium when issuing common stock.The issue of common stock...

question_answer

Q: The balance sheet reports the balances of shareholders’ equity accounts. What additional information...

A: Balance sheet: This financial statement reports a company’s resources (assets) and claims of credito...

question_answer

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

question_answer

Q: Help with the income statement

A: Income statement: The financial statement which reports revenues and expenses from business operatio...

question_answer

Q: When is a gain or a loss from a cash flow hedge reported in earnings?

A: Cash flow hedge: If a company uses any derivative to cover the risk due to cash flow changes to asse...

question_answer

Q: Millington Materials is a leading supplier of building equipment, building products, materials & tim...

A: 1. 

question_answer

Q: Hamilton Boats issued 175,000 shares of its no par common stock to Sudoku Motors in exchange for 1,0...

A: Common stock: These are the ordinary shares that a corporation issues to the investors in order to r...

question_answer

Q: Explain how the amount of cash payments to suppliers is computed under the direct method.

A: Statement of cash flows: The statement of cash flows is a statement which includes all transactions ...