### Overhead Cost Allocation Example This example demonstrates how to allocate overhead costs to products using Activity-Based Costing (ABC). Below are the steps and details required:#### Overhead Cost Category**Activity Cost Pools:**- Supervision- Depreciation of machinery- Assembly line preparation**Drivers:**- **Supervision:** Direct labor cost ($)- **Depreciation of machinery:** Machine hours- **Assembly line preparation:** Setups (number)#### Usage Data| Driver | Rounded Edge | Squared Edge | Total ||---------------------|--------------|--------------|--------|| Direct labor cost ($)| $6,000 | $12,000 | $18,000 || Machine hours | 200 hours | 600 hours | 800 hours || Setups | 30 times | 95 times | 125 times |#### Required Steps1. **Assign these three overhead cost pools to each of the two products using ABC:** **Overhead Cost Allocation Table:** | Activity | Overhead Cost | Activity Drivers | Activity Rate | % | |----------------------------|---------------|------------------------|---------------|------| | Supervision | | Direct labor cost | | | | Depreciation of machinery | | Machine hours | | | | Assembly line preparation | | Setups | | | **Rounded edge allocation:** | Activity | Activity rate | Activity driver incurred | Overhead assigned | |-----------------------------|---------------|--------------------------|-------------------| | Supervision | % | | | | Depreciation of machinery | 0 | | | | Assembly line preparation | 0 | | | **Squared edge allocation:** | Components | Activity rate | Activity driver incurred | Overhead assigned | |-----------------------------|---------------|--------------------------|-------------------| | Supervision | % | | | | Depreciation of machinery | 0 | | | | Assembly line preparation | 0 | | |2. **Determine the average cost per foot for each of the two products using ABC:** **Cost per Foot Analysis:** | | Rounded edge | ### Glassworks Inc. Cost Analysis**Product Lines: Rounded Edge and Squared Edge Glass Shelving**Glassworks Inc. produces two types of glass shelving, rounded edge and squared edge, on the same production line. For the current period, the company reports the following data:#### Cost Data Summary| Cost Components | Rounded Edge | Squared Edge | Total ||--------------------------|--------------|--------------|---------|| Direct materials | $9,500 | $21,400 | $30,900 || Direct labor | $6,000 | $12,000 | $18,000 || Overhead (300% of direct labor cost) | $18,000 | $36,000 | $54,000 || **Total cost** | $33,500 | $69,400 | $102,900|| Other Information | | | ||--------------------------|--------------|--------------|---------|| Quantity produced | 10,500 ft. | 14,200 ft. | || Average cost per ft. (rounded) | $3.19 | $4.89 | |The controller at Glassworks Inc. aims to apply activity-based costing (ABC) to allocate the $54,000 of overhead costs between the two product lines to determine if the cost per foot would change. The following additional information was collected:#### Overhead Cost Information| Overhead Cost Category (Activity Cost Pool) | Cost ||---------------------------------------------|--------|| Supervision | $2,160 || Depreciation of machinery | $28,840|| Assembly line preparation | $23,000|| **Total overhead** | $54,000|#### Usage DataThe following data indicates the usage of cost drivers for each category and each product line:| Overhead Cost Category (Activity Cost Pool) | Driver | Usage ||---------------------------------------------|---------------------------|-----------------|| | | Rounded Edge | Squared Edge | Total ||---------------------------------------------|---------------------------|-----------------|----------------|----------|| Supervision | Direct labor cost ($) | $6,000 | $12,000 | $18,000 || Depreciation of machinery | Machine hours | 200 hours | 600 hours

calculation of above requirement are as follows.

Overhead Cost Category (Activity Cost Pool) Supervision Driver Depreciation of machinery Assembly line preparation Direct labor cost ($) Machine hours Setups (number) Required: 1. Assign these three overhead cost pools to each of the two products using ABC. Activity Overhead Cost Activity Drivers Supervision Direct labor cost Depreciation of machinery Machine hours Setups Assembly line preparation Rounded edge Activity rate Supervision Depreciation of machinery Assembly line preparation % 0 0 0 Rounded Edge $6.000 200 hours 30 times Squared Edge $12,000 600 hours 95 times Activity Rate Activity driver incurred % Total 800 hours 125 times Overhead assigned $18,000

Overhead Cost Category (Activity Cost Pool) Supervision Driver Depreciation of machinery Assembly line preparation Direct labor cost ($) Machine hours Setups (number) Required: 1. Assign these three overhead cost pools to each of the two products using ABC. Activity Overhead Cost Activity Drivers Supervision Direct labor cost Depreciation of machinery Machine hours Setups Assembly line preparation Rounded edge Activity rate Supervision Depreciation of machinery Assembly line preparation % 0 0 0 Rounded Edge $6.000 200 hours 30 times Squared Edge $12,000 600 hours 95 times Activity Rate Activity driver incurred % Total 800 hours 125 times Overhead assigned $18,000

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Answer all parts correctly and completely in text form with steps explanation computation remember answer all or skip
< overhead and direct labor hours. Painting Dept. Finishing Dept. Totals ring moving to a multiple department rate system for allocating overhead. The Direct Overhead Labor Hours (dlh) Product A $241,200 83,700 $324,900 10,800 dlh 10,100 20,900 dlh 7 dlh 3 10 dlh Product B 11 dlh 7 18 dlh Using a single plantwide rate, the factory overhead allocated per unit of Product B is Oa. $15.55 O b. $279.90 Oc. $155.50 O d. $156.33
(b) Question 1 Tika Bhd has three production departments, Dept A, B, C, and service department canteen for workers. Each job must go through all the three departments. Overheads for forth coming moth is as follows: (a) Allocated Overhead Maintenance cost: Common cost Rental Depreciation Supervision costs Dept A Dept B Dept Canteen Required: Dept A Dept B Dept C Canteen Information related to all departments given as follows: Machine Machinery Floor Area hours value 20,000 RM12,000 15,000 RM10,000 5,000 RM 3,000 nil nil (m²) 5,000 RM 1,000 2,000 2,500 500 6,000 3,000 1,000 Depreciation Supervision costs Canteen cost (reallocation) 12,000 2,400 4,000 No. of Operators 30 50 20 nil Prepare an overhead analysis sheet using the apportionment method below to assign the common cost: Rental Floor area Machine value No of operators No of operators Note: All calculation must be to the nearest RM (No decimal point) Calculate departmental overhead absorption rates based on machine hours. Note: All…
Activity Clerical support Facility services Client consultations Activity usage for each service follows. Activity Cost Driver Documents Billable hours Court dates Budgeted Cost Required 1 Required 2 $ 57,600 20,160 72,800 Activity Clerical support Facility services Client consultations Budgeted Activity Usage 360 documents 2,520 billable hours 28 court dates Activity Usage Litigation 210 920 20 Mediation 150 1,600 8 Required: 1. Compute an activity rate for each activity using activity-based costing. 2. Compute overhead cost per unit (case) for both litigation and mediation using activity-based Total 360 2,520 28 Complete this question by entering your answers in the tabs below. Compute an activity rate for each activity using activity-based costing. (Round "Activity rate" to 2 c Budgeted Cost Budgeted Activity Usage Activity Rate
of 3 bok nt ant ences Required information Gable Company uses three activity pools. Each pool has a cost driver. Information for Gable Company follows: Activity Pools Machining Designing costs Setup costs Number of machine hours Number of design hours. Number of batches Total Cost of Pool $ 222,420 55,900 72,726 Product A Product B Product C Cost Driver Number of machine hours Number of design hours Number of batches Suppose that Gable Company manufactures three products, A. B, and C. Information about these products follows: Product A 24,000 Product C 9,400 2,600 60 2,400 265 Total Overhead Assigned Product B 34,000 1,500 180 Required: 1. Using activity proportions, determine the amount of overhead assigned to each product. Note: Do not round your intermediate calculations. Round your final answers to nearest whole number. Estimated Cost Driver 67,400 6,500
Required information Skip to question Greenwood Company manufactures two products—15,000 units of Product Y and 7,000 units of Product Z. The company uses a plantwide overhead rate based on direct labor-hours. It is considering implementing an activity-based costing (ABC) system that allocates all of its manufacturing overhead to four cost pools. The following additional information is available for the company as a whole and for Products Y and Z: Activity Cost Pool Activity Measure Estimated Overhead Cost Expected Activity Machining Machine-hours $ 227,700 11,000 MHs Machine setups Number of setups $ 153,900 270 setups Production design Number of products $ 91,000 2 products General factory Direct labor-hours $ 257,000 10,000 DLHs Activity Measure Product Y Product Z Machining 8,700 2,300 Number of setups 60 210 Number of products 1 1 Direct labor-hours 8,700 1,300 2. Using the plantwide overhead rate, how much manufacturing overhead cost is…
Concord Company manufactures two products, Mini A and Maxi B. Concord's overhead costs consist of setting up machines- $860000; machining- $2020000; and inspecting- $570000. Information on the two products is: Direct labour hours Machine setups Machine hours Inspections Mini A Maxi B $1324000. $1660400. $1690400. O $2542105. 10000 600 24000 800 28000 400 26000 700 Overhead applied to Maxi B using activity-based costing is
Compute the cost that is assigned to the car wheels and truck wheels product lines using an activity-based costing system, given the following information. Use of Cost Drivers per Product Car Truck Number of setups 200 800 Direct labor hours 43,000 45,000 Number of inspections 100 1,100 Car Wheels Setting up machines SA $ Assembling $ Truck Wheels $ $ SA Inspection $ SA $ Total cost assigned $ SA $ SUPPORT
ps//camdenccinstructure.com/courses/3788/assignmen LU Tidwell Industries has the following overhead costs and cost drivers. Direct labor hours are estimated at 100000 for the year. Cost Driver Activity Cost Pool Ordering and Receiving Orders Est. Overhead $ 130000 Machine Setup Setups 306000 Machining Machine hours 1537500 Assembly Parts 1220000 Inspection 310000 Inspections If overhead is applied using traditional costing based on direct labor hours, the overhead application rate is O $35.04. O $12.20. O $9.89. O $15.38. ip
Required information Skip to question Greenwood Company manufactures two products-15, 000 units of Product Y and 7,000 units of Product Z. The company uses a plantwide overhead rate based on direct labor - hours. It is considering implementing an activity - based costing (ABC) system that allocates all of its manufacturing overhead to four cost pools. The following additional information is available for the company as a whole and for Products Y and Z: Activity Cost Pool Activity Measure Estimated Overhead Cost Expected Activity Machining Machine - hours $ 213,400 11,000 MHs Machine setups Number of setups $ 61,600 140 setups Production design Number of products $ 78,000 2 products General factory Direct labor-hours $244,000 10,000 DLHS Activity Measure Product Y Product Z Machining 7,400 3,600 Number of setups 60 80 Number of products 1 1 Direct labor-hours 7,400 2,600 2. Using the plantwide overhead rate, how much manufacturing overhead cost is allocated to Product Y and Product Z?…
Rex Industries has identified three different activities as cost drivers: machine setups, machine hours, and inspections. The overhead and estimated usage are: Compute the overhead rate for each activity. Round your answers to two decimal places. Overhead Overhead Annual Rate per Activity per Activity Usage Activity Machine Setups $157,850 4,100 $ Machine Hours 324,622 14,114 2$ Inspections 119,000 3,400
None