Home Insert Page Layout Formulas Data Review View D Okie Wizard Duran Total Grainger $390,000 $300,000 $483,000| $183,000 337,500 160,500 22,423 740 $ 86,314| $ Avery 2 Revenues 3 Technician and equipment cost 4 Office overhead allocated 5 Operating income $318,000 $1,674,000 267,000 1,300,500 205,125 38,967 77 $ 12,033 $ 168,375 273,000 262,500 47,789 59,186 36,760 $ 69,211| $ 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: Home Insert Page Layout Formulas Data Review Cost Driver Rate $85 per service call $80 per Web-based parts order $50 per bill (or reminder) Activity Area 2 Service call handling 3 Parts ordering 4 Billing and collection Home Insert Page Layout Formulas Data Review View A B Avery Okie Wizard Grainger Duran 9 Number of service calls 10 Number of Web-based parts orders 11 Number of bills (or reminders) 225 360 60 180 270 180 315 90 225 225 45 135 135 90 180 1. Compute customer-level operating income using the new information that Costa has gathered. 2. Prepare exhibits for IS similar to Exhibits 14-4 and 14-5. 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? Required

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

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:

Home
Insert
Page Layout
Formulas
Data
Review
View
D
Okie
Wizard
Duran
Total
Grainger
$390,000 $300,000 $483,000| $183,000
337,500 160,500
22,423
740 $ 86,314| $
Avery
2 Revenues
3 Technician and equipment cost
4 Office overhead allocated
5 Operating income
$318,000 $1,674,000
267,000
1,300,500
205,125
38,967
77 $ 12,033 $ 168,375
273,000
262,500
47,789
59,186
36,760
$ 69,211| $
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:
Home
Insert
Page Layout
Formulas
Data
Review
Cost Driver Rate
$85 per service call
$80 per Web-based parts order
$50 per bill (or reminder)
Activity Area
2 Service call handling
3 Parts ordering
4 Billing and collection
Transcribed Image Text:Home Insert Page Layout Formulas Data Review View D Okie Wizard Duran Total Grainger $390,000 $300,000 $483,000| $183,000 337,500 160,500 22,423 740 $ 86,314| $ Avery 2 Revenues 3 Technician and equipment cost 4 Office overhead allocated 5 Operating income $318,000 $1,674,000 267,000 1,300,500 205,125 38,967 77 $ 12,033 $ 168,375 273,000 262,500 47,789 59,186 36,760 $ 69,211| $ 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: Home Insert Page Layout Formulas Data Review Cost Driver Rate $85 per service call $80 per Web-based parts order $50 per bill (or reminder) Activity Area 2 Service call handling 3 Parts ordering 4 Billing and collection
Home
Insert
Page Layout
Formulas
Data
Review
View
A
B
Avery Okie Wizard Grainger Duran
9 Number of service calls
10 Number of Web-based parts orders
11 Number of bills (or reminders)
225
360
60
180
270
180
315
90
225
225
45
135
135
90
180
1. Compute customer-level operating income using the new information that Costa has gathered.
2. Prepare exhibits for IS similar to Exhibits 14-4 and 14-5. 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?
Required
Transcribed Image Text:Home Insert Page Layout Formulas Data Review View A B Avery Okie Wizard Grainger Duran 9 Number of service calls 10 Number of Web-based parts orders 11 Number of bills (or reminders) 225 360 60 180 270 180 315 90 225 225 45 135 135 90 180 1. Compute customer-level operating income using the new information that Costa has gathered. 2. Prepare exhibits for IS similar to Exhibits 14-4 and 14-5. 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? Required
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 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
  • 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