The following table presents the activities and activity drivers that LampPlus uses in manufacturing Product 1 and Product 2. Completethe table:ActivityDesignPreparationMachiningFinishingInspectionPackagingShippingCostActivity Driver$ 39,060 Design time$ 67,650 Labor hours105,200 Machine hours$BatchesUnitsOrders$ 12,720 PackagesDriver UsageProd. 18403,13020976Prod. 21,330 hourshours30056Activity Rate$$$$/hour/hour20 /hour50 /batch17 /unit302 /order/packageActivityCost:Prod. 1$$$$34,43031,200ActivityCost:Prod. 29,690 $12,986$19,7203,600

Cost allocation is used in analyzing or identifying the process to assign the cost to people, and…

The following table presents the activities and activity drivers that LampPlus uses in manufacturing Product 1 and Product 2. Complete the table: Activity Cost Activity Driver Design $ 39,060 Design time Preparation $ 67,650 Labor hours Machining $ 105,200 Machine hours Finishing Batches Inspection Packaging Shipping Units Orders $ 12,720 Packages Driver Usage Prod. 1 840 3,130 209 76 Prod. 2 1,330 hours hours 300 56 Activity Rate $ $ $ $ /hour /hour 20 /hour 50 /batch 17 /unit 302 /order /package Activity Cost:Prod. 1 $ $ $ $ 34,430 31,200 Activity Cost:Prod. 2 9,690 $ 12,986 $ 19,720 3,600

The following table presents the activities and activity drivers that LampPlus uses in manufacturing Product 1 and Product 2. Complete the table: Activity Cost Activity Driver Design $ 39,060 Design time Preparation $ 67,650 Labor hours Machining $ 105,200 Machine hours Finishing Batches Inspection Packaging Shipping Units Orders $ 12,720 Packages Driver Usage Prod. 1 840 3,130 209 76 Prod. 2 1,330 hours hours 300 56 Activity Rate $ $ $ $ /hour /hour 20 /hour 50 /batch 17 /unit 302 /order /package Activity Cost:Prod. 1 $ $ $ $ 34,430 31,200 Activity Cost:Prod. 2 9,690 $ 12,986 $ 19,720 3,600

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter4: Activity-based Costing

Section: Chapter Questions

Problem 26E: Nonunit-level drivers are prominent in activity-based coting systems. Which of the following is a...

See similar textbooks

Similar questions

A company makes a product R. which requires one each of two first-level components, 5 and T. Routing data for these items are as follows tem Operation No. Dept Work Center Run Time Per unit Setup Time Average Lot size No. No. Std hours) Std hours) R 10 12 0.80 1.50 20 10 12 16 0.50 0.60 40 20 14 1.20 2.00 40 10 16 1.00 0.40 40 20 14 0.30 1.20 40 (a) The Bill of Capacity for product R (in standard hours) at work center 12 is closest to:
Please show your computations through excel. 2. Using FIFO, compute for the total cost of units transferred out from Finishing Department.
Activity Levels and Cost Drivers Shroeder Machine Shop has the following activities:a. Machine operationb. Machine setupc. Production schedulingd. Materials receivinge. Research and developmentf. Machine maintenanceg. Product designh. Parts administrationi. Final inspection of a sample of productsj. Materials handlingRequired1. Classify each of the activities as a unit-level, batch-level, product-level, or facility-level activity.2. Identify a potential cost driver for each activity in requirement 1.
1. Assign Overhead Costs to Activity Cost Pools 国日 First-Stage Allocation to Activity Cost Pools - Excel Sign In FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri -A A 10 Paste BIU - A - Alignment Number Conditional Format as Cell Cells Formatting - Table - Styles - Clipboard Font Styles A1 fx A C E F G 1 == 2 Total costs and distribution of resource consumption across activity cost pools: 3 4 Activity Cost Pools Customer Product Customer Total Cost Orders Development Relations Other Total 6 Production Department: 7 Indirect factory wages $ 400,000 50% 30% 15% 5% 100% Factory equipment depreciation Factory utilities 10 Factory property taxes and insurance 8 150,000 55% 30% 0% 15% 100% 9 120,000 59% 34% 0% 7% 100% 75,000 57% 33% 0% 10% 100% 11 12 General Administrative Department: Administrative wages and salaries Office equipment depreciation 13 275,000 20% 10% 40% 30% 100% 14 40,000 32% 16% 15% 37% 100% 15 Administrative property taxes and insurance 60,000 0% 0% 0% 100%…
PR 18-4A Activity-Based Product Costing Obj. 4 Mello Manufacturing Company is a diversified manufacturer that manufactures three products (Alpha, Beta, and Omega) in a continuous production process. Senior management has asked the controller to conduct an activity-based costing study. The controller identified the amount of factory overhead required by the critical activities of the organization as follows: Activity Production Setup Materials handling Inspection Product engineering The activity bases identified for each activity are as follows: Activity Production Alpha Beta 3. Setup Materials handling Inspection Product engineering Total Omega Total Activity Base Machine hours Number of setups Number of parts The activity-base usage quantities and units produced for the three products were determined from corporate records and are as follows: Number of inspection hours Number of engineering hours Machine Hours 1,440 1,080 720 3,240 Number of Setups Activity Cost Pool $259,200 55,000…
An allocation base: a. can be units of output if the company has a single product O b. is determined before the period begins. O c. All the given answers are correct. O d. can be direct labor cost e. is a measure used to assign manufacturing overhead costs to products and services PAGE NEXT PAGE IZ TWO Jump CQURSE OUTLINE_SPRING2021 ► tv MacBook Air
4. Change the estimated total amount of the allocation base back to 83,000 machine-hours, so that the data area of you workshe looks exactly the same as in Requirement 2. Now change the actual manufacturing overhead cost from $637,900 to $633,100. Th data area of your worksheet should now look like this: A в 1 Chapter 3: Applying Excel 2. Data Allocation base Estimated manufacturing overhead cost Estimated total amount of the allocation base Actual manufacturing overhead cost Actual total amount of the allocation base 4 Machine-hours 655,700 83,000 machine-hours 7 $ 633,100 78,000 machine-hours 8 (a) By how much is the manufacturing overhead underapplied or overapplied? manufacturing overhead 3. 5. 6.
Please show your computations through excel. c. Using AVERAGE method, compute for the equivalent unit for casting department.
Required: 1. SupposeKeller uses a traditionalcosting system withmachine hours as the costdriver. Determine the amount of overheadassigned to each product line.
Activity Levels and Cost Drivers Shroeder Machine Shop has the following activities: Machine operation Machine setup Production scheduling Materials receiving Research and development Machine maintenance Product design Parts administration Final inspection of a sample of products Materials handling Required Classify each of the activities as a unit-level, batch-level, product-level, or facility-level activity. Identify a potential cost driver for each activity in requirement 1.
what is the labor-related activity cost pool per DLH what is the machine-related activity cost pool per MH what is the machine setups activity cost pool per seteup what is the production orders activity cost per order what is the product testing activity cost per test what is the packaging activity cost per package what is the general factory activity cost per DLH
Title Brahtz Company uses an activity-based costing system. It has the following manufacturing activity ar Description Brahtz Company uses an activity-based costing system. It has the following manufacturing activity areas, related cost drivers and cost allocation rates:ActivityCost DriverCost Allocation RateMachine setupNumber of setups$25.00Materials handlingNumber of parts0.25MachiningMachine hours13.00AssemblyDirect labor hours22.00InspectionNumber of finished units7.00During the month, 100 units were produced, with no defects, requiring three setups. Each unit consisted of 17 parts, 3 direct labor hours and 2.5 machine hours. Direct materials cost $50 per finished unit.What is the total manufacturing cost for inspections?$-0-$700$90$7