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 | $670 | per unit |
Cost of goods sold | 400 | |
Gross profit | $270 | per unit |
In addition, the company incurs selling and administrative expenses of $290,680. 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 | $29,400 | Number of service requests | |||
Sales order processing | 21,580 | Number of sales orders | |||
Advertising support | 239,700 | Number of ads placed | |||
Total activity cost | $290,680 |
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 | 40 | 10 | 160 | 210 | |||||
Number of sales orders | 230 | 100 | 500 | 830 | |||||
Number of ads placed | 20 | 20 | 130 | 170 | |||||
Unit volume | 640 | 640 | 640 | 1,920 |
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 bid |
Advertising Support | $ | per customer design change |
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, 2016, 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, except for a negative income from operations.
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 | $ | $ | $ |
Sales order processing | |||
Advertising support | |||
Total selling and administrative activities | $ | ||
Income (loss) from operations | $ | $ | $ |
1 | Activity Rates; | ||||
Activity | Budgeted Activity Cost ($ ) | Activity Base | Activity Rate ($) | ||
Customer Service | 29,400 | Number of service request | 210 | $ 140 per Service request | |
Sales Order Processing | 21,580 | Number of Sales Order | 830 | $ 26 per sale order | |
Advertising Support | 239,700 | Number of ads placed | 170 | $ 1,410 per ad placed | |
2 | Activity costs allocated to three customers | ||||
Customers: | The Warehouse ($ ) | Kosmo Co. ($ ) | Supply Universe($ ) | ||
Customer Service | 5,600 | 1,400 | 22,400 | ||
Sales Order Processing | 5,980 | 2,600 | 13,000 | ||
Advertising Support | 28,200 | 28,200 | 183,300 | ||
Total selling and administrative expenses | 39,780 | 32,200 | 218,700 | ||
3 | Shrute Inc. | ||||
Customer Profitability Report | |||||
For the year ended December 31 | |||||
The Warehouse ($ ) | Kosmo Co. ($ ) | Supply Universe($ ) | |||
Revenues | 428,800 | 428,800 | 428,800 | ||
Less: Cost of goods sold | (256,000) | (256,000) | (256,000) | ||
Gross Profit | 172,800 | 172,800 | 172,800 | ||
Selling and Administrative Activities; | |||||
Customer Service | 5,600 | 1,400 | 22,400 | ||
Sales Order Processing | 5,980 | 2,600 | 13,000 | ||
Advertising Support | 28,200 | 28,200 | 183,300 | ||
Total selling and administrative Activities | 39,780 | 32,200 | 218,700 | ||
Income (Loss ) from operations | 133,020 | 140,600 | (45,900) |
Allocating Selling and Administrative Expenses using Activity-Based Costing Shrute Inc. manufactures office copiers, which are sold...
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 $710 per unit Cost of goods sold 430 Gross profit $280 per unit In addition, the company incurs selling and administrative expenses of $233,460. The company wishes to assign these costs to its three major retail customers, The Warehouse, Kosmo Co., and Supply Universe. These expenses are related...
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 $700 per unit Cost of goods sold 420 Gross profit $280 per unit In addition, the company incurs selling and administrative expenses of $284,420. The company wishes to assign these costs to its three major retail customers, The Warehouse, Kosmo Co., and Supply Universe. These expenses are related...
U W Calculator Printem 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 Cost of goods sold $1,110 per unit 682 Gross profit $428 per unit In addition, the company incurs selling and administrative expenses of 5414.030. The company wishes to assign these costs to its three major retail customers. The Warehouse, Komo com and Supply Universe....
eBook Show Me How Calculator Print Item Allocating Selling and Administrative Expenses using Activity-Based Costing Shrute Inc. manufactures office copiers, which are sold to retailers. The price Price 1.110 per un Cost of goods sold Gross profit $420 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...
Single Plantwide Factory Overhead Rate Spotted Cow Dairy Company manufactures three products—whole milk, skim milk, and cream—in two production departments, Blending and Packing. The factory overhead for Spotted Cow Dairy is $241,500. The three products consume both machine hours and direct labor hours in the two production departments as follows: Direct Labor Hours Machine Hours Blending Department Whole milk 220 620 Skim milk 240 560 Cream 200 220 660 1,400 Packing Department Whole milk 310 340 Skim milk 490 420...
Allocating Selling and Administrative Expenses using Activity-Based Costing Arctic Air Inc. manufactures cooling units for commercial buildings. The price and cost of goods sold for each unit are as follows: Price $60,000 per unit Cost of goods sold (28,000) Gross profit $32,000 per unit In addition, the company incurs selling and administrative expenses of $226,250. The company wishes to assign these costs to its three major customers, Gough Industries, Breen Inc., and The Martin Group. These expenses are related to...
Allocating selling and administrative expenses using activity based costing Labels and Amount Descriptions Activity rates Activity Costs Customer Profitability Report Suced ceils have feedback 3. Construct customer profitability reports for the three customers, dated for the year ended December 31, using the activity costs in (). The reports should disclose the gross profit and income from operations associated with each customer Refer to the list of Lisbets and Amount Descriptions for the exact wording of the answer choices for text...
9. Construct and Interpret a Product Profitability Report, Allocating Selling and Administrative Expenses Naper Inc. manufactures power equipment. Naper has two primary products—generators and air compressors. The following report was prepared by the controller for Naper's senior marketing management for the year ended December 31: Generators Air Compressors Total Revenue $1,458,240 $2,004,720 $3,462,960 Cost of goods sold 1,093,680 1,503,540 2,597,220 Gross profit $364,560 $501,180 $865,740 Selling and administrative expenses 184,140 Income from operations $681,600 The marketing management team was concerned...
Construct and Interpret a Product Profitability Report, Allocating Selling and Administrative Expenses Naper Inc. manufactures power equipment. Naper has two primary products—generators and air compressors. The following report was prepared by the controller for Naper's senior marketing management for the year ended December 31: Generators Air Compressors Total Revenue $1,140,040 $2,064,240 $3,204,280 Cost of goods sold 855,030 1,548,180 2,403,210 Gross profit $285,010 $516,060 $801,070 Selling and administrative expenses 178,770 Income from operations $622,300 The marketing management team was concerned that...
Construct and Interpret a Product Profitability Report, Allocating Selling and Administrative Expenses Volt-Gear Inc. manufactures power equipment. Volt-Gear has two primary products—generators and air compressors. The following report was prepared by the controller for Volt-Gear senior marketing management for the year ended December 31: Generators Air Compressors Total Revenue $2,000,000 $1,400,000 $3,400,000 Cost of goods sold 1,400,000 980,000 2,380,000 Gross profit $600,000 $420,000 $1,020,000 Selling and administrative expenses 353,000 Income from operations $667,000 The marketing management team was concerned that...