50.1K

Verified Solution

Link Copied!

Hello, I need help with this question please Thank you

Apps Ch 18 Exercises eBook Calculator Print Item 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 Compressors Total Revenue Generators $1,139,160 854,370 Cost of goods sold $1,611,400 1,208,550 $102,850 $2,750,560 2,062,920 $687,640 Gross profit $284,790 Selling and administrative expenses 147,040 Income from operations $540,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 activity base and activity rate for each activity, as shown below. Activity Activity Base Activity Rate Sales order processing Sales orders 550 per sales order Post-sale customer service Service requests $190 per customer service request The controller determined the following activity-base usage infomation about each products Generators Air Compressors 8:35 PM i Apps Ch 18 Exercises eBook Calculate Air Compressors Print Item Generators 376 Number of sales orders Number of service requests 699 410 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 1 For the Year Ended December 31 Gerators Air Compresor Total Revenues Cost of goods sold Gross profit Sales order processing 3:36 PM 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 XS Cost of goods sold Gross profit X 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 les c. Interpret the product profitability report user of Naper's sales and service activities. Many factors cause the air The air compressors have the lower income from operations to sales percentage because the product is a heavy compressors to have less income from operations as a percent of sales than generators

Answer & Explanation Solved by verified expert

See Answer