Exercise 17-19 (Algo) Activity-based costing to compute activity rates, overhead cost per unit,and product cost per unit LO P3Northwest Company produces two types of glass shelving: rounded edge and squared edge. The company reports thefollowing cost data.Rounded Edge Squared Edge$ 34,80011,60041,400$ 87,800$ 46,80031,20079,400$ 157,400Total$ 81,60042,800120,800$ 245,200Direct materialsDirect laborOverhead (using plantwide rate)Total product costUnits produced11,600$ 7.5715,600$ 10.09Product cost per unitNorthwest's controller wants to apply activity-based costing to allocate the $120,800 of overhead cost to the two productsto see whether product cost per unit would change markedly from that above. The company's budgeted activity usageequals its actual activity usage for the period. The following additional information is collected.Activity UsageSquared Edge471 orders1,500 hours210 setupsRounded EdgeActivityPurchasingDepreciation of machinerySetupBudgeted Cost$ 6,20063,00051,600$ 120,800Activity Cost DriverPurchase ordersMachine hoursSetups149 orders500 hours2,40 setupsTotalRequired:1. Compute the activity rate for each activity using activity-based costing.2. Compute overhead cost per unit for each of the two products using activity-based costing.3. Determine product cost per unit for each of the two products using activity-based costing.X Answer is complete but not entirely correct.Complete this question by entering your answers in the tabs below.Required 1Required 2Required 3Determine product cost per unit for each of the two products using activity-based costing. (Round intermediatecalculations and final answers to 2 decimal places.)DirectMaterialsProduct Cost perUnitPer UnitDirect LaborOverheadRounded Edge$ 34,800.00 X $11,600.00 X $25,496.00 X $6.20Squared Edge46,800.00 X31,200.0095,304.0011.11< Required 2Required 3 >

The overhead rate is calculated as estimated overhead cost divided by estimated activity base units.…

Exercise 17-19 (Algo) Activity-based costing to compute activity rates, overhead cost per unit, and product cost per unit LO P3 Northwest Company produces two types of glass shelving: rounded edge and squared edge. The company reports the following cost data. Rounded Edge Squared Edge $ 46,800 31,200 79,400 $ 157,400 15,600 $ 10.09 $ 34,800 11,600 41,400 $ 87,800 Total $ 81,600 42,800 120,800 $ 245,200 Direct materials Direct labor Overhead (using plantwide rate) Total product cost Units produced Product cost per unit 11,600 $ 7.57 Northwest's controller wants to apply activity-based costing to allocate the $120,800 of overhead cost to the two products to see whether product cost per unit would change markedly from that above. The company's budgeted activity usage equals its actual activity usage for the period. The following additional information is collected.

Exercise 17-19 (Algo) Activity-based costing to compute activity rates, overhead cost per unit, and product cost per unit LO P3 Northwest Company produces two types of glass shelving: rounded edge and squared edge. The company reports the following cost data. Rounded Edge Squared Edge $ 46,800 31,200 79,400 $ 157,400 15,600 $ 10.09 $ 34,800 11,600 41,400 $ 87,800 Total $ 81,600 42,800 120,800 $ 245,200 Direct materials Direct labor Overhead (using plantwide rate) Total product cost Units produced Product cost per unit 11,600 $ 7.57 Northwest's controller wants to apply activity-based costing to allocate the $120,800 of overhead cost to the two products to see whether product cost per unit would change markedly from that above. The company's budgeted activity usage equals its actual activity usage for the period. The following additional information is collected.

Financial & Managerial Accounting

14th Edition

ISBN:9781337119207

Author:Carl Warren, James M. Reeve, Jonathan Duchac

Publisher:Carl Warren, James M. Reeve, Jonathan Duchac

Chapter18: Activity-Based Costing

Section: Chapter Questions

Problem 18.3TIF: Communication The controller of New Wave Sounds Inc. prepared the following product profitability...

See similar textbooks

Similar questions

Activity-based and department rate product costing and product cost distortions Black and Blue Sports Inc. manufactures two products: snowboards and skis. The factory overhead incurred is as follows: Indirect labor 507,000 Cutting Department 156,000 Finishing Department 192,000 Total 855,000 The activity hase associated with the two production departments is direct labor hours. The indirect labor can be assigned to two different activities as follows: Activity Budgeted Activity Cost Activity Base Production control 237,000 Number of production runs Materials handling 270,000 Number of moves Total 507,000 The activity-base usage quantities and units produced for the two products follow: Number o Production Runs Number of Moves Direct Labor HoursCutting Direct Labor HoursFinishing Units Produced Snowboards 430 5,000 4,000 2,000 6,000 Skis _70 2,500 2,000 4,000 6,000 Total 500 7,500 6,000 6,000 12,000 Instructions 1. Determine the factory overhead rates under the multiple production department rate method. Assume that indirect labor is associated with the production departments, so that the total factory overhead is 315,000 and 540,000 for the Cutting and finishing departments, respectively. 2. Determine the total and per-unit factory overhead costs allocated to each product, using the multiple production department overhead rates in (1). 3. Determine the activity rates, assuming that the indirect labor is associated with activities rather than with the production departments. 4. Determine the total and per-unit cost assigned to each product under activity-based costing. 5. Explain the difference in the per-unit overhead allocated to each product under the multiple production department factory overhead rate and activity-based costing methods.
Identifying activity bases in an activity-based cost system Select Foods Inc. uses activity-based costing to determine product costs. For each activity listed in the left column, match an appropriate activity base from the right column. You may use items in the activity-base list more than once or not at all. Activity Activity Base Accounting reports Engineering change orders Customer return processing Kilowatt hours used Electric power Number of accounting reports Human resources Number of customers Inventory control Number of customer orders Invoice and collecting Number of customer returns Machine depreciation Number of employees Materials handling Number of inspections Order shipping Number of inventory transactions Payroll Number of machine hours Production control Number of material moves Production setup Number of payroll checks processed Purchasing Number of production orders Quality control Number of purchase orders Sales order processing Number of sales orders Number of setups
Activity-based department rate product costing and product cost distortions Big Sound Inc. manufactures two products: receivers and loud-speakers. The factory overhead incurred is as follows: Indirect labor 400,400 Cutting Department 198,800 Finishing Department 114,800 Total 714,000 The activity base associated with the two production departments is direct labor hours. The indirect labor can be assigned to two different activities as follows: Activity Budgeted Activity Cost Activity Base Setup 138,600 Number of setup Quality Control 261,800 Number of inspections Total 400,400 The activity-base usage quantities and units produced for the two products follow: Number o Setup Number of Inspections Direct Labor HoursSubassembly Direct Labor HoursFinal Assembly Units Produced Snowboards 430 5,000 4,000 2,000 6,000 Skis _70 2,500 2,000 4,000 6,000 Total 500 7,500 6,000 6,000 12,000 Instructions 1. Determine the factory overhead rates under the multiple production department rate method. Assume that indirect labor is associated with the production departments, so that the total factory overhead is 5420,000 and 294,000 for the Subassembly and Final Assembly departments, respectively. 2. Determine the total and per-unit factory overhead costs allocated to each product, using the multiple production department overhead rates in (1). 3. Determine the activity rates, assuming that the indirect labor is associated with activities rather than with the production departments. 4. Determine the total and per-unit cost assigned to each product under activity-based costing. 5. Explain the difference in the per-unit overhead allocated to each product under the multiple production department factory overhead rate and activity-based costing methods.
Activity-based and department rate product costing and product cost distortions Black and Blue Sports Inc. manufactures two products: snowboards and skis. The factory overhead incurred is as follows: Indirect labor 507,000 Cutting Department 156,000 Finishing Department 192,000 Total 855,000 The activity hase associated with the two production departments is direct labor hours. The indirect labor can be assigned to two different activities as follows: Activity Budgeted Activity Cost Activity Base Production control 237,000 Number of production runs Materials handling 270,000 Number of moves Total 507,000 The activity-base usage quantities and units produced for the two products follow: Number o Production Runs Number of Moves Direct Labor HoursCutting Direct Labor HoursFinishing Units Produced Snowboards 430 5,000 4,000 2,000 6,000 Skis _70 2,500 2,000 4,000 6,000 Total 500 7,500 6,000 6,000 12,000 Instructions 1. Determine the factory overhead rates under the multiple production department rate method. Assume that indirect labor is associated with the production departments, so that the total factory overhead is 315,000 and 540,000 for the Cutting and finishing departments, respectively. 2. Determine the total and per-unit factory overhead costs allocated to each product, using the multiple production department overhead rates in (1). 3. Determine the activity rates, assuming that the indirect labor is associated with activities rather than with the production departments. 4. Determine the total and per-unit cost assigned to each product under activity-based costing. 5. Explain the difference in the per-unit overhead allocated to each product under the multiple production department factory overhead rate and activity-based costing methods.
Activity-based costing in an insurance company Umbrella Insurance Company carries three major lines of insurance: auto, workers' compensation, and homeowners. The company has prepared the following report for 20Y2: Management is concerned that the administrative expenses may make some of the insurance lines unprofitable. However, the administrative expenses have not been allocated to the insurance lines. The controller has suggested that the administrative expenses could be assigned to the insurance lines using activity-based costing. The administrative expenses are comprised of five activities. The activities and their rates are as follows: Activity-base usage data for each line of insurance were retrieved from the corporate records and are shown below. a.Complete the product profitability report through the administrative activities. b.Determine the underwriting income as a percent of premium revenue. C.Determine the Operating income as a percent of premium revenue, rounded to one decimal place. d.Interpret the report.
Appendix Absorption costing income statement On June 30, the end of the first month of operations, Tudor Manufacturing Co. prepared the following income statement, based on the variable existing concept: Sales (420,000 units) 7,450,000 Variable cost of goods sold: Variable cost of goods manufactured (500,000 units x 14 per unit) 7,000,000 Less ending inventory (80,000 units x 14 per unit) 1,120,000 Variable cost of goods sold 5,880,000 Manufacturing margin 1,570,000 Variable selling and administrative expenses 80,000 Contribution margin 1,490,000 Fixed costs: Fixed manufacturing costs 160,000 Fixed selling and administrative expenses 75,000 235,000 Income from operations 1,255,000 a. Prepare an absorption costing income statement. b. Reconcile the variable costing income from operations of 1,255,000 with the absorption costing income from operations determined in (a).
Identifying activity bases in an activity-based cost system Select Foods Inc. uses activity-based costing to determine product costs. For each activity listed in the left column, match an appropriate activity base from the right column. You may use items in the activity-base list more than once or not at all. Activity Activity Base Accounting reports Engineering change orders Customer return processing Kilowatt hours used Electric power Number of accounting reports Human resources Number of customers Inventory control Number of customer orders Invoice and collecting Number of customer returns Machine depreciation Number of employees Materials handling Number of inspections Order shipping Number of inventory transactions Payroll Number of machine hours Production control Number of material moves Production setup Number of payroll checks processed Purchasing Number of production orders Quality control Number of purchase orders Sales order processing Number of sales orders Number of setups
Analyzing manufacturing cost accounts Fire Rock Company manufactures designer paddle boards in a wide variety of sizes and styles. The following incomplete ledger accounts refer to transactions that are .summarized for June: Matenals In addition, the following information is available: A. Materials and direct labor were applied to six jobs in June: Job No. Style Quantity Direct Materials Direct Labor 201 T100 550 55,000 41,250 202 T200 1,100 93,500 71,500 203 T400 550 38,500 22,000 204 S200 660 82,500 69,300 20S T300 480 60,000 48,000 206 S100 380 22,000 12,400 Total 3,720 351,500 264,450 B. Factory overhead is applied to each job at a rate of 140% of direct Libor cost. C. The June 1 Work Process balance consisted of two jobs, as follow Work in Process, Job No. Style June 1 201 T100 16,500 202 T200 44,000 Total 60,500 D. Customer jobs completed and units sold in June were at follows Job Mo. Style Completed In June Units Sold in June 201 T100 X 440 202 T200 X 880 203 T400 0 204 S200 X 570 20S T300 X 420 206 S100 0 Instructions 1. Determine the missing amounts associated with each letter. Provide supporting calculations by completing a table with the following headings: Job No Quantity June 1 Work in Process Direct Materials Direct Labor Factory Overhead Total Cost Unit Cost Units Sold Cost of Goods Sold 2. Determine the June 30 balances for each of the inventory accounts and factory overhead.