Construct and Interpret a Product Profitability Report, Allocating Selling and Administrative Expenses Naper Inc. manufactures power...

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,796,440 $2,752,720 $4,549,160
Cost of goods sold 1,347,330 2,064,540 3,411,870
Gross profit $449,110 $688,180 $1,137,290
Selling and administrative expenses 246,690
Income from operations $890,600

The marketing management team was concerned that the selling and administrative expenses were not traced to the products. Marketing management believed that some products consumed larger amounts of selling and administrative expense than did other products. To verify this, the controller was asked to prepare a complete product profitability report, using activity-based costing.

The controller determined that selling and administrative expenses consisted of two activities: sales order processing and post-sale customer service. The controller was able to determine the A measure of activity that is related to changes in cost. Used in analyzing and classifying cost behavior. Activity bases are also used in the denominator in calculating the predetermined factory overhead rate to assign overhead costs to cost objects.activity base and The cost of an activity per unit of activity base, determined by dividing the activity cost pool by the activity base.activity rate for each activity, as shown below.

Activity Activity Base Activity Rate
Sales order processing Sales orders $90 per sales order
Post-sale customer service Service requests $270 per customer service request

The controller determined the following activity-base usage information about each product:

Generators Air Compressors
Number of sales orders 398 840
Number of service requests 67 434

a. Determine the activity cost of each product for sales order processing and post-sale customer service activities.

Sales Order Processing
Activities Cost Post-sale Customer Service
Activities Cost
Generators $ $
Air Compressors
Total $ $

b. Use the information in (a) to prepare a complete product profitability report dated for the year ended December 31. Calculate the gross profit to sales and the income from operations to sales percentages for each product. Round percentages to one decimal place. Enter all amounts as positive numbers.

Naper Inc.
Product Profitability Report
For the Year Ended December 31
Generators Air Compressors Total
Revenues $ $ $
Cost of goods sold
Gross profit $ $ $
Sales order processing $ $ $
Post-sale customer service
Total selling and administrative expense $ $ $
Income from operations $ $ $
Gross profit as a percentage of sales % %
Income from operations as a percentage of sales % %

c. Interpret the product profitability report.

The air compressors have the

higher
lower

income from operations to sales percentage because the product is a

light
heavy

user of Naper’s sales and service activities. Many factors cause the air compressors to have

less
more

income from operations as a percent of sales than generators

Solutions

Expert Solution

ekkarill92 answered 8 months ago

Next > < Previous

Related Solutions

Construct and Interpret a Product Profitability Report, Allocating Selling and Administrative Expenses Naper Inc. manufactures power...

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 $4,200,000 $3,000,000 $7,200,000 Cost of goods sold 2,940,000 2,100,000 5,040,000 Gross profit $1,260,000 $900,000 $2,160,000 Selling and administrative expenses 610,000 Income from operations $1,550,000 The marketing management team was concerned that...

Construct and Interpret a Product Profitability Report, Allocating Selling and Administrative Expenses Naper Inc. manufactures power...

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 $730 per unit Cost of goods sold 440 Gross profit $290 per unit In addition, the company incurs selling and administrative expenses of $232,160. 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 Arctic Air Inc. manufactures cooling units for commercial...

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 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$690 per unit Cost of goods sold(410) Gross profit$280 per unit In addition, the company incurs selling and administrative expenses of $263,410. 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...

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 $650 per unit Cost of goods sold 390 Gross profit $260 per unit In addition, the company incurs selling and administrative expenses of $276,980. 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...

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 $720 per unit Cost of goods sold (430) Gross profit $290 per unit In addition, the company incurs selling and administrative expenses of $226,570. 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...

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 $270,510. The company wishes to assign these costs to its three major retail customers, The Warehouse, Kosmo Co., and Supply Universe. These expenses are related...

Terrible Two's Inc. combines its operating expenses for budget purposes in a selling and administrative expenses...

Terrible Two's Inc. combines its operating expenses for budget purposes in a selling and administrative expenses budget. For the last six months of 2017, the following data are available: 1. Sales: 31,500 units in Quarter 3; 51,500 units in Quarter 4 2. Variable costs per dollar of sales; sales commissions 2.40%; delivery expenses 3.45%; and advertising 4.55% 3. Fixed costs per quarter: sales salaries $16,000; office salaries $3,050; depreciation $4,350; insurance $2,500; utilities $400, and repairs $250 4. Unit selling...

eBook Show Me How Calculator Print Item Allocating Selling and Administrative Expenses using Activity-Based Costing Shrute...

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 and cost of goods sold for each copier are as follows: Price $750 per unit Cost of goods sold 450 Gross profit $300 per unit In addition, the company incurs selling and administrative expenses of $226,700. The company wishes to assign these costs to its three major retail customers, The Warehouse, Kosmo Co.,...

Subjects