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 three major
nonmanufacturing activities: customer service, project bidding, and
engineering support. The engineering support is in the form of
engineering changes that are placed by the customer to change the
design of a product. The budgeted activity costs and activity bases
associated with these activities are:
Activity | Budgeted Activity Cost | Activity Base | ||||
Customer service | $31,500 | Number of service requests | ||||
Project bidding | 74,000 | Number of bids | ||||
Engineering support | 120,750 | Number of customer design changes | ||||
Total activity cost | $226,250 |
Activity-base usage and unit volume information for the three
customers is as follows:
Gough Industries | Breen Inc. | The Martin Group | Total | ||||||
Number of service requests | 36 | 28 | 116 | 180 | |||||
Number of bids | 50 | 40 | 95 | 185 | |||||
Number of customer design changes | 18 | 35 | 108 | 161 | |||||
Unit volume | 30 | 16 | 4 | 50 |
Required:
1. Determine the activity rates for each of the three nonmanufacturing activity pools. Round to the nearest whole dollar.
Activity Rate | ||
Customer Service | $ per serv. req. | |
Project Bidding | $ per bid | |
Engineering Support | $ per design changes |
2. Determine the activity costs allocated to the three customers, using the activity rates in (1).
Activity Costs | |
Gough Industries | $ |
Breen Inc. | $ |
The Martin Group | $ |
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 operating income associated with each customer.
Arctic Air Inc. | |||
Customer Profitability Report | |||
For the Year Ended December 31 | |||
Gough Industries | Breen Inc. | The Martin Group | |
Revenues | $ | $ | $ |
Cost of goods sold | |||
Gross profit | $ | $ | $ |
Selling and administrative activities: | |||
Customer service | $ | $ | $ |
Project bidding | |||
Engineering support | |||
Total selling and administrative activities | $ | $ | $ |
Operating income (loss) | $ | $ | $ |
Activity Rate = Overhead costs/Estimated Driver | |||
Customer Service | 175 | per serv. req. | |
Project Bidding | 400 | per bid | |
Engineering Support | 750 | per design changes | |
Activity costs allocated = Activity Rate*Driver consumed | |||
Activity Costs | |||
Gough Industries | 39,800 | ||
Breen Inc. | 47,150 | ||
The Martin Group | 139,300 | ||
Arctic Air Inc. |
|||
Customer Profitability Report | |||
For the Year Ended December 31 | |||
Gough Industries | Breen Inc. | The Martin Group | |
Revenues | 1,800,000 | 960,000 | 240,000 |
Cost of goods sold | 840,000 | 448,000 | 112,000 |
Gross profit | 960,000 | 512,000 | 128,000 |
Selling and administrative activities: | |||
Customer service | 6,300 | 4,900 | 20,300 |
Project bidding | 20,000 | 16,000 | 38,000 |
Engineering support | 13,500 | 26,250 | 81,000 |
Total selling and administrative activities | 39,800 | 47,150 | 139,300 |
Operating income (loss) | 920,200 | 464,850 | (11,300) |
Allocating Selling and Administrative Expenses using Activity-Based Costing Arctic Air Inc. manufactures cooling units for commercial...
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...
HEY if it is possible may you show your formulas?? Thank youuuu Arctic Air Inc. manufactures cooling units for commercial buildings. The price and cost of goods sold for each unit are as follows: 1 Price per unit $74,900.00 per unit 2 Cost of goods sold 60,550.00 3 Gross profit per unit $14,350.00 per unit In addition, the company incurs selling and administrative expenses of $233,998. The company wishes to assign these costs to its three major customers, Gough Industries,...
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...
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...
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...
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...
Activity-Based Costing and Customer Profitability Metroid Electric manufactures power distribution equipment for commercial customers, such as hospitals and manufacturers Activity-based costing was used to determine customer profitability. Customer service activities were assigned to individual customers, using the following assumed customer service activities, activity base, and activity rate: Customer Service Activity Bid preparation Shipment Activity Base Activity Rate Number of bid requests $420 per request Number of shipments $90 per shipment Number of standard items ordered $30 per std. item Number...