Communication
The controller of New Wave Sounds Inc. prepared the following product profitability report for management, using activity-based costing methods for allocating both the factory overhead and the marketing expenses. As such, the controller has confidence in the accuracy of this report.
Home Theater Speakers | Wireless Speakers | Wireless Headphones | Total | |
Sales | $ 1,500,000 | $1,200,000 | $900,000 | $3,600,000 |
Cost of goods sold | 1,050,000 | 720,000 | 810,000 | 2,580,000 |
Gross profit | $ 450,000 | $ 480,000 | $ 90,000 | $1,020,000 |
Marketing expenses | 600,000 | 120,000 | 72,000 | 792,000 |
Income from operations | $ (150,000) | $ 360,000 | $ 18,000 | $ 228,000 |
In addition, the controller interviewed the vice president of marketing, who provided the following insight into the company's three products:
∎ The home theater speakers are an older product that is highly recognized in the marketplace.
∎ The wireless speakers are a new product that was just recently bunched.
∎ The wireless headphones are a new technology that has no competition in the marketplace, and it is hoped that they will become an important future addition to the company’s product portfolio. Initial indications are that the product is well received by customers.
The controller believes that the
Based on the information provided:
1. Calculate the ratio of gross profit to sales and the ratio of income from operations to sales for each product.
2. Write a brief (one page) memo using the product profitability report and the calculations in (1) to make recommendations to management with respect to strategies for the three products.
Trending nowThis is a popular solution!
Chapter 18 Solutions
Financial & Managerial Accounting
- Activity-Based Costing and Customer Profitability Schneider 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 Activity Base Activity Rate Bid preparation Number of bid requests $400 per request Shipment Number of shipments $ 80 per shipment Support standard items Number of standard items ordered $ 25 per std. item Support nonstandard items Number of nonstandard items ordered $150 per nonstd. item Assume that the company had the following gross profit information for three representative customers: Customer 1 Customer 2 Customer 3 Revenues $120,000 $200,000 $160,000 Cost of goods sold 76,800 110,000 83,200 Gross profit…arrow_forwardROXY Tires the manufacturer and exported company of tires. The company uses an activity based costing system for its overhead costs. The company has provided the following data concerning its activity-based costing system. Activity Cost pool Activity Measure Annual Activity Supporting Direct Labor Direct labor Hour $28 per DLH Order Processing Order $285 per Order Custom design processing Custom design $185 per customer design Customer service customer $378 per customer Management would like an analysis of the profitability of a particular customer, Roxy Tires, which has ordered the following products over the last 12 months: Items…………………………….standard model……………….customer Design Number of Tires…………………20………………………………5 Number of orders……………….1……………………………….5 Number of customer designs……0………………………………5 Direct labor hour per Tires 26.5…………………………….28 Selling price per…arrow_forwardAllocating Selling and Administrative Expenses using Activity-Based CostingShrute Inc. manufactures office copiers, which are sold to retailers. The price and cost of goods sold for each copier are as follows: Price$1,110per unitCost of goods sold682 Gross profit$428per 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 activities: customer service, sales order processing, and advertising support. The advertising support is in the form of advertisements that are placed by Shrute Inc. to support the retailer's sale of Shrute copiers to consumers. The budgeted activity costs and activity bases associated with these activities are: ActivityBudgeted Activity Cost Activity BaseCustomer service$76,860Number of service requestsSales order processing25,920Number of sales…arrow_forward
- Activity-Based Costing and Customer Profitability Schneider 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 Activity Base Activity Rate Bid preparation Number of bid requests $400 per request Shipment Number of shipments $ 80 per shipment Support standard items Number of standard items ordered $ 25 per std. item Support nonstandard items Number of nonstandard items ordered $150 per nonstd. item Assume that the company had the following gross profit information for three representative customers: Customer 1 Customer 2 Customer 3 Revenues $120,000 $200,000 $160,000 Cost of goods sold 76,800 110,000 83,200 Gross profit…arrow_forwardMTI makes three types of lawn tractors: M3100, M4100, and M6100. In the past, it allocated overhead to products using machine-hours. Last year, the company produced 8,000 units of M3100, 17,500 units of M4100, and 10,000 units of M6100 and had the following revenues and costs: Sales revenue Direct costs Direct materials Direct labor Variable overhead Setting up machines Processing sales orders Warehousing Operating machines Shipping Contribution margin Plant administration Gross profit MTI Activity Setting up machines Processing sales orders Warehousing Operating machines. Income Statement M3100 $ 9,400,000 3,300,000 610,000 M4100 $ 15,700,000 Cost Driver Production runs 4, 800, 800 860, 000 M6100 $ 14,200,000 Sales orders received Units held in inventory Machine-hours 3,100,000 1,730, 000 MTI's controller has heard about activity-based costing and puts together an employee team to recommend cost allocation bases. The employee team recommends the following. M3100 9 170 90 6, 200 Total…arrow_forwardProduct Cost Method of Product Costing Voice Com, Inc., uses the product cost method of applying the cost-plus approach to product pricing. The costs of producing and selling 5,310 units of cell phones are as follows: Variable costs: Fixed costs: Direct materials $67 per unit Factory overhead $198,000 Direct labor 37 Selling and admin. exp. 71,400 Factory overhead 22 Selling and admin. exp. 18 Total variable cost per unit $144 per unit Voice Com desires a profit equal to a 16% rate of return on invested assets of $601,800. a. Determine the amount of desired profit from the production and sale of 5,310 units of cell phones. 2$ b. Determine the product cost per unit for the production of 5,310 of cell phones. If required, round your answer to nearest dollar. per unit c. Determine the product cost markup percentage (rounded to two decimal places) for cell phones. % d. Determine the selling price of cell phones. Round to the nearest dollar. Total Cost per unit Markup per unit Selling price…arrow_forward
- Assume a service company has implemented an activity-based costing system with five activities as shown below: Activity Cost Pool (Activity Measure) Customer deliveries (Number of deliveries) Manual order processing (Number of manual orders) Electronic order processing (Number of electronic orders) Line item picking (Number of line items picked) Other organization-sustaining costs (None) Total Cost Total Activity $ 400,000 $ 280,000 $ 150,000 $ 450,000 $ 300,000 8,000 deliveries 5,000 manual orders 15,000 electronic orders 375,000 line items The company serves numerous customers, two of which include Hospital A and Hospital B. The activity demands pertaining to these two customers are as follows: Activity Hospital A Hospital B Activity Measure Number of deliveries Number of manual orders Number of electronic orders Number of line items picked 8. 25 30 15 0. 115 250 How much total activity cost should be assigned to Hospital A for internal management purposes? Multiple Choice $785 <…arrow_forwardAs a new accountant of the company, you are provided with the following information related to KOKO: Product Annual production and sales unit Direct material cost per unit Direct labour cost per unit Machine hours per unit Selling price per unit Koko 5,500 RM50 RM35 3 hours RM150 The company is considering of changing the traditional method to the Activity Based Costing (ABC) method. In order to adopt ABC method the following information is required: Activity Cost Cost Driver Pool Expected overhead Expected use of drivers per product Other products 3,500 costs Коко (RM) No of purchase orders Machine hours Maintenance Maintenance hours Number of inspections Total Purchasing 4,000 37,500 Machining 16,500 8,000 1,500 147,000 43,000 3,500 Quality control 1900 1600 17,500 245,000 Required: a. If the company decided to use the Activity Based Costing (ABC) method, determine the cost per unit of KOKO. Based on your answer in (a), advise whether the company should change to ABC method. Support…arrow_forwardAssume you are the department B manager for Marley's Manufacturing. Marley's operates under a cost-based transfer structure. Assume you receive the majority of your raw materials from department A, which sells only to department B (they have no outside sales). After calculating the operating income in dollars and operating income in percentage, analyze the following financial information to determine costs that may need further investigation. Marley's ManufacturingIncome StatementMonth Ending August 31, 2018 Dept. A Dept. B Sales $21,000 $52,000 Cost of goods sold 9,870 27,040 Gross profit $11,130 $24,960 Expenses: Utility expenses $840 $3,120 Wages expense 5,040 10,920 Costs allocated from corporate 2,100 14,560 Total expenses $7,980 $28,600 Operating income/(loss) in dollars $fill in the blank 1 $fill in the blank 2 Operating income/(loss) in percentage fill in the blank 3 % fill in the blank 4 % Department B had…arrow_forward
- Objective: Consider that you are an analyst at Regeneron Pharmaceuticals. You need to decide how to allocate administrative overhead costs to Regeneron's main commercial products (Eylea, Dupixent, Kevzara and Praluent). Determine how to appropriately allocate the costs in the table below to each of the commercial products using an allocation methodology of your choice. Department2019 Annual Operating ExpenseTime spent supporting Commercial productsCommercial$200MM100%IT$100MM25%Facilities$150MM0%Finance$25MM20%Human Resources$75MM10% Use the supporting document Net Product Sales of REGN Products to facilitate your analysis. Provide a written summary of how you allocated the overhead costs to each product in an outline of no more than one page. As a starting point, it's recommended that you revisit the material we covered in Chapter 12. Guidance on calculations:Start off with Net Product Sales of REGN Products. Your objective pertains to 2019 expenses, so you should be reviewing 2019…arrow_forwardAssume you are the department B manager for Marley's Manufacturing. Marley's operates under a cost-based transfer structure. Assume you receive the majority of your raw materials from department A, which sells only to department B (they have no outside sales). After calculating the operating income in dollars and operating income in percentage, analyze the following financial information to determine costs that may need further investigation. Marley's ManufacturingIncome StatementMonth Ending August 31, 2018 Dept. A Dept. B Sales $23,000 $51,000 Cost of goods sold 11,040 26,520 Gross profit $11,960 $24,480 Expenses: Utility expenses $920 $2,550 Wages expense 5,980 10,710 Costs allocated from corporate 2,300 14,280 Total expenses $9,200 $27,540 Operating income/(loss) in dollars $fill in the blank 1 $fill in the blank 2 Operating income/(loss) in percentage fill in the blank 3 % fill in the blank 4 %arrow_forwardMetroid 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 Activity Base Activity Rate Bid preparation Number of bid requests $420 per request Shipment Number of shipments $90 per shipment Support standard items Number of standard items ordered $30 per std. item Support nonstandard items Number of nonstandard items ordered $180 per nonstd. item Assume that the company had the following gross profit information for three representative customers: Customer 1 Customer 2 Customer 3 Revenues $130,000 $210,000 $180,000 Cost of goods sold (81,900) (113,400) (90,000) Gross profit $48,100 $96,600 $90,000 Gross profit…arrow_forward
- Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub