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: Air Generators Compressors Total Revenue $1,431,000 $2,094,800 $3,525,800 Cost of goods sold 1,073,250 1,571,100 2,644,350 Gross profit $357,750 $523,700 $881,450 Selling and administrative expenses 189,650 Income from operations $691,800 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 activity base and activity rate for each activity, as shown below. Activity Activity Base Activity Rate Sales order processing Sales orders $60 per sales order Post-sale customer service Service requests $230 per customer service request The controller determined the following activity-base usage information about each product: Generators Air Compressors Number of sales orders 413 720 Number of service requests 79 450 a. Determine the activity cost of each product for sales order processing and post-sale customer service activities. Sales Order Processing Post-sale Customer Service Activities Cost 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 pasitive numbers. Naper Inc. Product Profitability Report For the Year Ended December 31 Generators Air Compressors Total Revenues 1,431,000 2,094,800 3,525,800 Cost of goods sold 7,073,250 1,571,100 2,644,350 Gross profit 357,750 523,700 881,450 Sales order pracessing Post-sale customer service Total selling and administrative expense 189,650 Income from operations 691,800 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 income from operations to sales percentage because the product is a user of Naper's sales and service activities. Many factors cause the air compressors to have income from operations as a percent of sales than generators.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
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:
Air
Generators Compressors
Total
Revenue
$1,431,000
$2,094,800
$3,525,800
Cost of goods sold
1,073,250
1,571,100
2,644,350
Gross profit
$357,750
$523,700
$881,450
Selling and administrative expenses
189,650
Income from operations
$691,800
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 detemine the activity base and activity
rate for each activity, as shown below.
Activity
Activity Base
Activity Rate
Sales order processing
Sales orders
$60 per sales order
Post-sale customer service
Service requests
$230 per customer service request
The controller determined the following activity-base usage information about each product:
Generators
Air Compressors
Number of sales orders
413
720
Number of service requests
79
450
a. Determine the activity cost of each product for sales order processing and post-sale customer service activities.
Sales Order Processing Post-sale Customer Service
Activities Cost
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
1,431,000
2,094,800
3,525,100
Cost of goods sold
7,073,250
1,571,100
2,644,350
Gross profit
357,750
523,700
881,450
Sales order processing
Post-sale customer service
Total selling and administrative expense
189,650
Income from operations
691,800
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
income from operations to sales percentage because the product is a
user of Naper's sales and service activities. Many factors cause the air
compressors to have
income from operations as a percent of sales than generators.
Transcribed Image Text: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: Air Generators Compressors Total Revenue $1,431,000 $2,094,800 $3,525,800 Cost of goods sold 1,073,250 1,571,100 2,644,350 Gross profit $357,750 $523,700 $881,450 Selling and administrative expenses 189,650 Income from operations $691,800 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 detemine the activity base and activity rate for each activity, as shown below. Activity Activity Base Activity Rate Sales order processing Sales orders $60 per sales order Post-sale customer service Service requests $230 per customer service request The controller determined the following activity-base usage information about each product: Generators Air Compressors Number of sales orders 413 720 Number of service requests 79 450 a. Determine the activity cost of each product for sales order processing and post-sale customer service activities. Sales Order Processing Post-sale Customer Service Activities Cost 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 1,431,000 2,094,800 3,525,100 Cost of goods sold 7,073,250 1,571,100 2,644,350 Gross profit 357,750 523,700 881,450 Sales order processing Post-sale customer service Total selling and administrative expense 189,650 Income from operations 691,800 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 income from operations to sales percentage because the product is a user of Naper's sales and service activities. Many factors cause the air compressors to have income from operations as a percent of sales than generators.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Compensation and Benefits
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