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

Managerial Accounting
15th Edition
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:Carl Warren, Ph.d. Cma William B. Tayler
Chapter4: Activity-based Costing
Section: Chapter Questions
Problem 5PB: Allocating selling and administrative expenses using activity-based costing Shrute Inc. manufactures...
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
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning