Comparative Income Statements and Management Analysis
Pepper’s Products manufactures and sells two types of chew toys for pets, Squeaky and Silent. In May, Pepper’s Products had the following costs and revenues:
Pepper’s Products currently uses labor costs to allocate all overhead but is considering implementing an activity-based costing system. After interviewing the sales and production staff, management decides to allocate administrative costs on the basis of direct labor costs but to use the following bases to allocate the remaining overhead:
Required
- a. Complete the income statement using the preceding activity bases.
- b. Write a report indicating how management might use activity-based costing to reduce costs.
- c. Restate the income statement for Pepper’s Products using direct labor costs as the only overhead allocation base.
- d. Write a report to management stating why product line profits differ-using activity based costing compared to the traditional approach. Indicate whether activity-based costing provides more accurate information and why (if you believe it does provide more accurate information). Indicate in your report how the use of labor-based overhead allocation could cause management at Pepper’s Products to make suboptimal decisions.
a.
Complete the income statement using preceding activity bases.
Explanation of Solution
Activity-based costing:
Activity-based costing refers to the method of costing where the overhead cost is assigned to various products. This costing method identifies the relationship between the manufacturing overhead costs and the activities. This relationship is then used to allocate indirect costs to the products.
Complete the income statement using preceding activity bases:
Particulars | Squeaky | Silent | Total |
Sales revenue | $43,200 | $48,000 | $91,200 |
Direct materials | $4,000 | $4,000 | $8,000 |
Direct labor | $9,600 | $14,400 | $24,000 |
Overhead costs: | |||
Add: Administration | $2,400 | $3,600 | $6,000 |
Add: Production setup | $8,000 | $4,000 | $12,000 |
Add: Quality control | $4,500 | $1,500 | $6,000 |
Add: Distribution | $1,920 | $2,880 | $4,800 |
Total overhead costs | $16,820 | $11,980 | $28,800 |
Operating profit | $12,780 | $17,620 | $30,400 |
Table: (1)
Working note 1:
Compute the percentage of direct labor applicable:
Working note 2:
Compute the rate per setup:
Working note 3:
Compute the rate per inspection:
Working note 4:
Compute the shipping cost per unit:
b.
Write a brief report indicating how management could use activity-based costing to reduce costs
Explanation of Solution
Activity-based costing:
Activity-based costing (ABC) refers to the method of costing where the overhead cost is assigned to various products. This costing method identifies the relationship between the manufacturing overhead costs and the activities. This relationship is then used to allocate indirect costs to the products.
ABC method for reducing the cost:
Reduction in the cost of activities may not be the direct result of implementing the ABC method of costing, but it can highlight the activities where the cost reduction can be made. Reducing the setup costs or other overhead costs specifically from the perspective of cost reduction can be identified using the ABC method of costing.
c.
Restate the income statement according to the information given in the question.
Explanation of Solution
Recompute the income statement according to the information given in the question:
Particulars | Squeaky | Silent | Total |
Sales revenue | $43,200 | $48,000 | $91,200 |
Direct materials | $4,000 | $4,000 | $8,000 |
Direct labor | $9,600 | $14,400 | $24,000 |
Overhead costs | $11,520 | $17,280 | $28,800 |
Operating profit | $18,080 | $12,320 | $30,400 |
Table: (2)
Working note 5:
d.
Write a report to management stating why product line profits differ using activity-based costing compared to the traditional approach. Indicate whether activity-based costing provides more accurate information and provide a reason for the same.
Explanation of Solution
Purpose of the report:
To explain the difference between the implementation of ABC costing and traditional labor-based costing method for the computation of the product line profits.
The implication of both the methods:
Direct costs do not differ in both the methods implemented. While using the labor-based method, all the overhead costs are computed under one single head and while using ABC the bifurcation of cost drivers is relevant to their respective cost of allocation
Result using the traditional labor-based method of costing:
The result shows that the product Squeaky has made a profit of $18,080 which is 41% percent of the sales revenue. And the product Silent has attained a profit of $12,320 which is 25% of sales revenue.
Result using the ABC method of costing:
The result shows that the product Squeaky has attained a profit of $12,780 which is 30% percent of the sales revenue. And the product Silent has incurred the loss of $17,620 which is 36% of sales revenue.
Conclusion:
The choice of a method adapted should be ABC costing as the results computed from the traditional labor-based method are fluctuating.
Want to see more full solutions like this?
Chapter 9 Solutions
FUNDAMENTAL'S OF COST ACCOUNTING LL
- The Chocolate Baker specializes in chocolate baked goods. The firm has long assessed the profitability of a product line by comparing revenues to the cost of goods sold. However, Barry White, the firms new accountant, wants to use an activity-based costing system that takes into consideration the cost of the delivery person. Following are activity and cost information relating to two of Chocolate Bakers major products: Using activity-based costing, which of the following statements is correct? a. The muffins are 2,000 more profitable. b. The cheesecakes are 75 more profitable. c. The muffins are 1,925 more profitable. d. The muffins have a higher profitability as a percentage of sales and, therefore, are more advantageous.arrow_forwardVentana Window and Wall Treatments Company provides draperies, shades, and various window treatments. Ventana works with the customer to design the appropriate window treatment, places the order, and installs the finished product. Direct materials and direct labor costs are easy to trace to the jobs. Ventanas income statement for last year is as follows: Ventana wants to find a markup on cost of goods sold that will allow them to earn about the same amount of profit on each job as was earned last year. Required: 1. What is the markup on cost of goods sold (COGS) that will maintain the same profit as last year? (Round the percentage to two significant digits.) 2. A customer orders draperies and shades for a remodeling job. The job will have the following costs: What is the price that Ventana will quote given the markup percentage calculated in Requirement 1? (Round the price to the nearest dollar.) 3. What if Ventana wants to calculate a markup on direct materials cost, since it is the largest cost of doing business? What is the markup on direct materials cost that will maintain the same profit as last year? (Round the percentage to two significant digits.) What is the bid price Ventana will use for the job given in Requirement 2 if the markup percentage is calculated on the basis of direct materials cost? (Round to the nearest dollar.)arrow_forwardConstruct and interpret a product profitability report, allocating selling and administrative expenses Naper Inc. manufactures power equipment. Naper has two primary productsgenerators and air compressors. The following report was prepared by the controller for Napers senior marketing management for the year ended December 31: 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: The controller determined the following activity-base usage information about each product: Determine the activity cost of each product for sales order processing and post-sale customer service activities. Use the information in (A) to prepare a complete product profitability report dated for the year ended December 31. Compute the gross profit to sales and the operating income to sales percentages for each product. (Round to two decimal places.) Interpret the product profitability report. How should management respond to the report?arrow_forward
- Assume 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 Manufacturing Income Statement Month ending August 31, 2019 Dept. A Dept. B Sales $22,000 $51,000 Cost of Goods Sold 10,560 26,520 Gross profit $11,440 $24,480 Utility expenses 1,000 3,200 Wages expense 5,500 10,200 Costs allocated from Corporate 2,200 15,000 Total expenses $8,700 $28,400 Operating Income/(loss) $ ? ? Operating income/(loss) % ? ? Which of these costs may need further…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_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
- Method of Least Squares, Predicting Cost for Different Time Periods from the One Used to Develop a Cost Formula Farnsworth Company has gathered data on its overhead activities and associated costs for the past 10 months. Tracy Heppler, a member of the controller's department, has convinced management that overhead costs can be better estimated and controlled if the fixed and variable components of each overhead activity are known. One such activity is receiving raw materials (unloading incoming goods, counting goods, and inspecting goods), which she believes is driven by the number of receiving orders. Ten months of data have been gathered for the receiving activity and are as follows: Month Receiving Orders Receiving Cost 1 1,000 $18,000 2 700 $15,000 3 1,500 $28,000 4 1,200 $17,000 5 1,300 $25,000 6 1,100 $21,000 7 1,600 $29,000 8 1,400 $24,000 9 1,700 $27,000 10 900 $16,000 Assume that Tracy…arrow_forwardUsing variable costing, service company Divine Pool Cleaning Service provides pool cleaning services to residential customers. The company has three employees, each assigned to specific customers The company considers each employee’s territory as a business segment The company incurs variable costs that include the employees’ wages, pool chemicals, and gas for the service vans. Fixed costs include depreciation on the service vans. Following is the income statement for the month of August: Requirements Calculate the contribution margin ratio for each business Segment. The business segments had the following number of customers Byson, 80; Moore, 50; and Freeman, 110. Compute the service revenue per customer variable cost per customer, and contribution margin per customer for each business segment. Which business segment was most profitable? List some possible reasons why this segment was most profitable. How might the various reasons affect the company in the long term?arrow_forward9-45. Activity-Based versus Traditional Costing-Ethical Issues Cathedral City Services (CCS) is a not-for-profit organization offering two services in a mid-sized city. The services are "Elder Meals" and "Jobs4U." Elder Meals is a meals-on-wheels type program that delivers meals on a scheduled basis to seniors who are house-bound. Jobs4U is a jobs-training program focused on youth or adults who are looking to change careers. Participants in the program are sponsored by a local government agency, a charitable organization, or a local business. CCS charges a $240 fee per hour for each service. The revenues and costs for the year are shown in the following income statement: Revenue. Expenses:.. General office costs. Required The following data have been collected concerning activities at CCS: CATHEDRAL CITY SERVICES Income Statement Travel and transportation. Equipment lease and maintenance Operating profit...... Activity General office costs.... Travel and transportation Equipment lease…arrow_forward
- Using variable costing, service company Professional Pool Cleaning Service provides pool cleaning services to residential customers. The company has three employees, each assigned to specific customers. The company considers each employees territory as a business segment. The company incurs variable costs that include the employees’ Wages, pool chemicals, and gas for the service vans. Fixed costs include depreciation on the service vans. Following is the income statement for the month of July: Requirements Calculate the contribution margin ratio for each business segment. The business segments had the following numbers of customers: Birman, 60; Meech, 70; and Frond, 40. Compute the service revenue per customer, variable cost per customer, and contribution margin per customer for each business segment. Which business segment was most profitable? List some possible reasons why this segment was most profitable. How might the various reasons affect the company in the long term?arrow_forwardUsing variable costing, service company Paradise Pool Cleaning Service provides pool cleaning services to residential customers. The company has three employees, each assigned to specific customers. The company considers each employee's territory as a business segment. The company incurs variable costs that include the employees' wages, pool chemicals, and gas for the service vans. Fixed costs include depreciation on the service vans. Following is the income statement for the month of July: Paradise Pool Cleaning Service Income Statement for the month Ended July 31, 2020 Benton McMillian Faulkner Total Service Revenue $ 4,000 $ 3,000 $ 3,500 $ 10,500 Variable Costs 1,600 1,500 2,100 5,200 Contribution Margin 2,400 1,500 1,400 5,300 Fixed Costs 3,000 Operating Income $ 2,300 Requirements 1. Calculate the contribution margin ratio for each business segment. 2. The business segments had the following numbers of customers: Benton, 80; McMillian, 60; and Faulker, 70. Compute the service…arrow_forwardThe controller at Wesson Company's manufacturing plant has provided you with the following information for the first quarter's operations: Direct materials Fixed manufacturing overhead costs Sales price Variable manufacturing overhead Direct labor Fixed marketing and administrative costs Units produced and sold during the quarter Variable marketing and administrative costs Required: a. Prepare a gross margin income statement. b. Prepare a contribution margin income statement. Complete this question by entering your answers Required A Required B Prepare a contribution margin income statement. Contribution Margin Income Statementarrow_forward
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning