$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 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?

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

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

Trending now

This is a popular solution!

steps

Step by step

Solved in 7 steps with 5 images

Blurred answer
Knowledge Booster
Inventory Management
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
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education