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
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
Fundamentals Of Cost Accounting (6th Edition)
- 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_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 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_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 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_forwardMethod 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_forward
- Using 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_forwardUsing 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_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
- Mission Company is preparing its annual profit plan. As part of its analysis of the profitability of individual products, the controller estimates the amount of overhead that should be allocated to the individual product lines from the information provided below (CMA adapted) Multiple Choice Units produced Material moves per product line Direct labor-hours per product line Budgeted material handling costs: $594,000 Under a traditional costing system that allocates overhead on the basis of direct labor-hours, the materials handling costs allocated to one unit of Wall Mirrors would be O $1000 $1.350 $5,400 Wall Mirrors 210 5 1,050 $22.000 Specialty Nindows 25 46arrow_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_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_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