Construct and Interpret a Product Profitability Report, Allocating Selling and Administrative Expenses Naper Inc. manufactures power...
Fantastic news! We've Found the answer you've been seeking!
Question:
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: Revenue Cost of goods sold Gross profit Selling and administrative expenses Income from operations Generators Air Compressors $4,200,000 (2,940,000) $1,260,000 Activity Sales order processing Post-sale customer service $3,000,000 (2,100,000) $900,000 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 follows: Number of sales orders Number of service requests Total $7,200,000 (5,040,000) $2,160,000 (610,000) $1,550,000 Activity Base Activity Rate Sales orders $65 per sales order Service requests $200 per customer service request The controller determined the following activity-base usage information about each product: Generators Air Compressors 3,000 4,000 225 550 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 two decimal places. Enter all amounts as positive numbers. Naper Inc. Product Profitability Report For the Year Ended December 31 Generators 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 % % Air Compressors % $ Total c. Interpret the product profitability report. The air compressors have the activities. Many factors cause the air compressors to have income from operations to sales percentage because the product is a income from operations as a percent of sales than generators. user of Naper's sales and service 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: Revenue Cost of goods sold Gross profit Selling and administrative expenses Income from operations Generators Air Compressors $4,200,000 (2,940,000) $1,260,000 Activity Sales order processing Post-sale customer service $3,000,000 (2,100,000) $900,000 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 follows: Number of sales orders Number of service requests Total $7,200,000 (5,040,000) $2,160,000 (610,000) $1,550,000 Activity Base Activity Rate Sales orders $65 per sales order Service requests $200 per customer service request The controller determined the following activity-base usage information about each product: Generators Air Compressors 3,000 4,000 225 550 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 two decimal places. Enter all amounts as positive numbers. Naper Inc. Product Profitability Report For the Year Ended December 31 Generators 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 % % Air Compressors % $ Total c. Interpret the product profitability report. The air compressors have the activities. Many factors cause the air compressors to have income from operations to sales percentage because the product is a income from operations as a percent of sales than generators. user of Naper's sales and service 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: Revenue Cost of goods sold Gross profit Selling and administrative expenses Income from operations Generators Air Compressors $4,200,000 (2,940,000) $1,260,000 Activity Sales order processing Post-sale customer service $3,000,000 (2,100,000) $900,000 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 follows: Number of sales orders Number of service requests Total $7,200,000 (5,040,000) $2,160,000 (610,000) $1,550,000 Activity Base Activity Rate Sales orders $65 per sales order Service requests $200 per customer service request The controller determined the following activity-base usage information about each product: Generators Air Compressors 3,000 4,000 225 550 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 two decimal places. Enter all amounts as positive numbers. Naper Inc. Product Profitability Report For the Year Ended December 31 Generators 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 % % Air Compressors % $ Total c. Interpret the product profitability report. The air compressors have the activities. Many factors cause the air compressors to have income from operations to sales percentage because the product is a income from operations as a percent of sales than generators. user of Naper's sales and service 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: Revenue Cost of goods sold Gross profit Selling and administrative expenses Income from operations Generators Air Compressors $4,200,000 (2,940,000) $1,260,000 Activity Sales order processing Post-sale customer service $3,000,000 (2,100,000) $900,000 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 follows: Number of sales orders Number of service requests Total $7,200,000 (5,040,000) $2,160,000 (610,000) $1,550,000 Activity Base Activity Rate Sales orders $65 per sales order Service requests $200 per customer service request The controller determined the following activity-base usage information about each product: Generators Air Compressors 3,000 4,000 225 550 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 two decimal places. Enter all amounts as positive numbers. Naper Inc. Product Profitability Report For the Year Ended December 31 Generators 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 % % Air Compressors % $ Total c. Interpret the product profitability report. The air compressors have the activities. Many factors cause the air compressors to have income from operations to sales percentage because the product is a income from operations as a percent of sales than generators. user of Naper's sales and service 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: Revenue Cost of goods sold Gross profit Selling and administrative expenses Income from operations Generators Air Compressors $4,200,000 (2,940,000) $1,260,000 Activity Sales order processing Post-sale customer service $3,000,000 (2,100,000) $900,000 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 follows: Number of sales orders Number of service requests Total $7,200,000 (5,040,000) $2,160,000 (610,000) $1,550,000 Activity Base Activity Rate Sales orders $65 per sales order Service requests $200 per customer service request The controller determined the following activity-base usage information about each product: Generators Air Compressors 3,000 4,000 225 550 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 two decimal places. Enter all amounts as positive numbers. Naper Inc. Product Profitability Report For the Year Ended December 31 Generators 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 % % Air Compressors % $ Total c. Interpret the product profitability report. The air compressors have the activities. Many factors cause the air compressors to have income from operations to sales percentage because the product is a income from operations as a percent of sales than generators. user of Naper's sales and service 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: Revenue Cost of goods sold Gross profit Selling and administrative expenses Income from operations Generators Air Compressors $4,200,000 (2,940,000) $1,260,000 Activity Sales order processing Post-sale customer service $3,000,000 (2,100,000) $900,000 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 follows: Number of sales orders Number of service requests Total $7,200,000 (5,040,000) $2,160,000 (610,000) $1,550,000 Activity Base Activity Rate Sales orders $65 per sales order Service requests $200 per customer service request The controller determined the following activity-base usage information about each product: Generators Air Compressors 3,000 4,000 225 550 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 two decimal places. Enter all amounts as positive numbers. Naper Inc. Product Profitability Report For the Year Ended December 31 Generators 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 % % Air Compressors % $ Total c. Interpret the product profitability report. The air compressors have the activities. Many factors cause the air compressors to have income from operations to sales percentage because the product is a income from operations as a percent of sales than generators. user of Naper's sales and service
Expert Answer:
Answer rating: 100% (QA)
a Generators Air Compressors Total b Naper Inc Product Profitabilit... View the full answer
Related Book For
Financial and Managerial Accounting
ISBN: 978-1285078571
12th edition
Authors: Carl S. Warren, James M. Reeve, Jonathan Duchac
Posted Date:
Students also viewed these accounting questions
-
The schedule on the following page was prepared by the controller of World Manufacturing, Inc., for use by the independent auditors during their examination of Worlds year- end financial statements....
-
The following statement was prepared by Maloney Corporations accountant. The following additional information relating to Maloney Corporation is available for the year ended September 30, 2014. 1....
-
The following statement was prepared by Maloney Corporation's accountant. Maloney Corporation STATEMENT OF SOURCES AND USES OF CASH FOR THE YEAR ENDED SEPTEMBER 30, 2019 Sources of cash Net...
-
Two kilograms of water, initially saturated liquid at 10 kPa, are heated to saturated vapor while the pressure is maintained constant. Determine the work and the heat transfer for the process, each...
-
A $1,000 bond has a 4 percent coupon and currently sells for $900. The bond matures after five years. What is the bonds anticipated yield? Compare this return with the answer to the previous problem.
-
Ben is a single taxpayer with no dependents and is 32 years old. What is the minimum amount of income that he must have to be required to file a tax return for 2022? a. $4,300 b. $12,400 c. $12,550...
-
In 2016, the median annual salary of a marketing account executive was $68,232. Determine whether the number is a parameter or a statistic. Explain your reasoning.
-
Scrapper Elevator Company has 20 sales representatives who sell its product throughout the United States and Canada. The number of units sold last month by each representative is listed below. Assume...
-
Outback Outfitters sells recreational equipment. One of the company's products, a small camp stove, sells for $100 per unit. Variable expenses are $70 per stove, and fixed expenses associated with...
-
? ?? ? ? Assume that Alpha and Omega compete in the same four-digit SIC code industry and offer comparable products and services. The following table contains their reported financial performance and...
-
2. Imagine two light spheres suspended near each other at the same height, each by a flexible string. Predict what will happen to the spheres if you blow a jet of air through the gap between them....
-
Show that \(2 x^{2}\) is an antiderivative of \(4 x\).
-
Table 18.5 shows the gross national product (GNP) in trillions of dollars for the years 1960-2012. Find the average yearly rate of change of the GNP for the requested years in Problems 19-26. Table...
-
Show that \(x^{2}\) is an antiderivative of \(2 x\).
-
In Problems 21-38, guess the requested limits. \(\lim _{n ightarrow \infty} \frac{2 n}{n+4}\)
-
In Problems 21-38, guess the requested limits. \(\lim _{n ightarrow \infty} \frac{n+1,500}{n+21,300}\)
-
New equipment used to control the thickness of fibre cement sheet cladding is being developed. It is estimated to sell for $130,000 more than the current design. Based on present product data, the...
-
Classify each of the following activities as proper or prohibited under the various consumer statutes you have studied. a. Calling a hospital room to talk to a debtor who is a patient there. b....
-
On December 31, 2014, the balances of the accounts appearing in the ledger of Wyman Company are as follows: Instructions 1. Does Wyman Company use a periodic or perpetual inventory system? Explain....
-
The prepaid insurance account had a balance of $12,000 at the beginning of the year. The account was debited for $18,000 for premiums on policies purchased during the year. Journalize the adjusting...
-
A summary of cash flows for Sentinel Travel Service for the year ended August 31, 2014, is shown below. Cash receipts: Cash received from customers ............$734,000 Cash received from issuing...
-
A construction engineer has to inspect 5 construction sites in a 2-day inspection schedule. He may or may not be able to visit these sites in two days. He will not visit any site more than once. (a)...
-
An explosion in an LNG storage tank in the process of being repaired could have occurred as the result of static electricity, malfunctioning electrical equipment, an open flame in contact with the...
-
What conditions for the binomial distribution, if any, fail to hold in the following situations? (a) For each of a company's eight production facilities, record whether or not there was an accident...
Study smarter with the SolutionInn App