14-20 Customer profitability, service company. Instant Service (IS) repairs printers and photocopiers for five multisite companies in a tristate area. IS’s costs consist of the cost of technicians and equipment that are directly traceable to the customer site and a pool of office overhead. Until recently, IS estimated customer profitability by allocating the office overhead to each customer based on share of revenues. For 2017, IS reported the following results: Abby Costa, IS’s new controller, notes that office overhead is more than 10% of total costs, so she spends a couple of weeks analyzing the consumption of office overhead resources by customers. She collects the following information: Activity Area                                                          Cost Driver Rate Service call handling                              $85.00      Per service call  Parts ordering                                        $80.00      per Web-based parts order Billing and collection                             $50.00      per bill (or reminder)                                                                         Avery         Okie         Wizard        Grainger         Duran Number of service calls                                  225          360             60                 180                270 Number of web-based parts orders               180           315            90                 225                225  Number of bills (or reminders)                        45             135          135                  90                180   1. Compute customer-level operating income using the new information that Costa has gathered. 2.  Prepare exhibits for IS and comment on the results. 3. What options should IS consider, with regard to individual customers, in light of the new data and analysis of office overhead?

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

14-20 Customer profitability, service company. Instant Service (IS) repairs printers and photocopiers for five multisite companies in a tristate area. IS’s costs consist of the cost of technicians and equipment that are directly traceable to the customer site and a pool of office overhead. Until recently, IS estimated customer profitability by allocating the office overhead to each customer based on share of revenues. For 2017, IS reported the following results:

Abby Costa, IS’s new controller, notes that office overhead is more than 10% of total costs, so she spends a couple of weeks analyzing the consumption of office overhead resources by customers. She collects the following information:

Activity Area                                                          Cost Driver Rate

Service call handling                              $85.00      Per service call 

Parts ordering                                        $80.00      per Web-based parts order

Billing and collection                             $50.00      per bill (or reminder)

 

                                                                      Avery         Okie         Wizard        Grainger         Duran

Number of service calls                                  225          360             60                 180                270

Number of web-based parts orders               180           315            90                 225                225 

Number of bills (or reminders)                        45             135          135                  90                180

 

1. Compute customer-level operating income using the new information that Costa has gathered.

2.  Prepare exhibits for IS and comment on the results.

3. What options should IS consider, with regard to individual customers, in light of the new data and analysis of office overhead?

 

Home
Page Layout
Insert
Formulas
Data
Review
View
A
B
D
E
F
G
Wizard Grainger
Avery
$390,000 $300,000 $483,000 $183,000 $318,000 $1,674,000
1
Okie
Duran
Total
2 Revenues
3 Technician and equipment cost
4 Office overhead allocated
5 Operating income
273,000
262,500
337,500
160,500
267,000
1,300,500
38,967
47,789
$ 69,211 $
36,760
740 $ 86,314 | $
59,186
22,423
77 $ 12,033 $ 168,375
205,125
Transcribed Image Text:Home Page Layout Insert Formulas Data Review View A B D E F G Wizard Grainger Avery $390,000 $300,000 $483,000 $183,000 $318,000 $1,674,000 1 Okie Duran Total 2 Revenues 3 Technician and equipment cost 4 Office overhead allocated 5 Operating income 273,000 262,500 337,500 160,500 267,000 1,300,500 38,967 47,789 $ 69,211 $ 36,760 740 $ 86,314 | $ 59,186 22,423 77 $ 12,033 $ 168,375 205,125
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Knowledge Booster
Costing Systems
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
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