Allocating Selling and Administrative Expenses using Activity-Based CostingShrute Inc. manufactures office copiers, which are sold to retailers. The price and cost of goods sold for each copier are as follows: Price$1,110per unitCost of goods sold682 Gross profit$428per unit In addition, the company incurs selling and administrative expenses of $414,030. The company wishes to assign these costs to its three major retail customers, The Warehouse, Kosmo Co., and Supply Universe. These expenses are related to its three major nonmanufacturing activities: customer service, sales order processing, and advertising support. The advertising support is in the form of advertisements that are placed by Shrute Inc. to support the retailer's sale of Shrute copiers to consumers. The budgeted activity costs and activity bases associated with these activities are: ActivityBudgeted Activity Cost Activity BaseCustomer service$76,860Number of service requestsSales order processing25,920Number of sales ordersAdvertising support311,250Number of ads placedTotal activity cost$414,030 Activity-base usage and unit volume information for the three customers is as follows: The WarehouseKosmo Co.Supply UniverseTotalNumber of service requests6234025427Number of sales orders3006401401,080Number of ads placed2518044249Unit volume8108108102,430 Required:1. Determine the activity rates for each of the three nonmanufacturing activities. Round to the nearest whole dollar.Activity RateCustomer Service$ per serv. req.Sales Order Processing$ per sls. orderAdvertising Support$ per ad2. Determine the activity costs allocated to the three customers, using the activity rates in (1).Activity CostsThe Warehouse$Kosmo Co.$Supply Universe$3. Construct customer profitability reports for the three customers, dated for the year ended December 31, using the activity costs in (2). The reports should disclose the gross profit and income from operations associated with each customer. Enter all amounts as positive numbers. Shrute Inc.Customer Profitability ReportFor the Year Ended December 31 The WarehouseKosmo Co.Supply UniverseRevenues$$$Cost of goods sold   Gross profit$$$Selling and administrative activities:   Customer service cost$$$Sales order processing cost   Advertising support cost   Total selling and administrative$$$Income from operations$$$

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
100%

Allocating Selling and Administrative Expenses using Activity-Based Costing
Shrute Inc. manufactures office copiers, which are sold to retailers. The price and cost of goods sold for each copier are as follows:

Price
$1,110
per unit
Cost of goods sold
682

Gross profit
$428
per unit

In addition, the company incurs selling and administrative expenses of $414,030. The company wishes to assign these costs to its three major retail customers, The Warehouse, Kosmo Co., and Supply Universe. These expenses are related to its three major nonmanufacturing activities: customer service, sales order processing, and advertising support. The advertising support is in the form of advertisements that are placed by Shrute Inc. to support the retailer's sale of Shrute copiers to consumers. The budgeted activity costs and activity bases associated with these activities are:

Activity
Budgeted Activity Cost

Activity Base
Customer service

$76,860


Number of service requests
Sales order processing

25,920


Number of sales orders
Advertising support

311,250


Number of ads placed

Total activity cost

$414,030


Activity-base usage and unit volume information for the three customers is as follows:


The Warehouse
Kosmo Co.
Supply Universe
Total
Number of service requests
62


340

25

427

Number of sales orders
300


640

140

1,080

Number of ads placed
25


180

44

249

Unit volume
810


810

810

2,430

Required:
1. Determine the activity rates for each of the three nonmanufacturing activities. Round to the nearest whole dollar.

Activity Rate

Customer Service
$ per serv. req.
Sales Order Processing
$ per sls. order
Advertising Support
$ per ad
2. Determine the activity costs allocated to the three customers, using the activity rates in (1).

Activity Costs
The Warehouse
$
Kosmo Co.
$
Supply Universe
$
3. Construct customer profitability reports for the three customers, dated for the year ended December 31, using the activity costs in (2). The reports should disclose the gross profit and income from operations associated with each customer. Enter all amounts as positive numbers.
Shrute Inc.
Customer Profitability Report
For the Year Ended December 31

The Warehouse
Kosmo Co.
Supply Universe
Revenues
$
$
$
Cost of goods sold

 

Gross profit
$
$
$
Selling and administrative activities:

 

Customer service cost
$
$
$
Sales order processing cost

 

Advertising support cost

 

Total selling and administrative
$
$
$
Income from operations
$
$
$

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 6 steps with 5 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