Question

In: Accounting

The following table lists out the overhead cost: Activity cost pool Overhead cost (£) Additional Notes...

The following table lists out the overhead cost:

Activity cost pool

Overhead cost (£)

Additional Notes

Job-order set up

25,000

Procurement and placement

350,000

Installation of winding system   

170,000

An auto winding system is fitted with every watch

Quality inspection (machine)

70,000

Quality inspection (manual)

24,000

Finishing

160,000

Hand-made finishing

Packaging and delivery

44,250

The company packages and delivers watches in batches containing 10 watches per batch. On an average, the packaging and delivery cost is the same for all batches (10 watches= 1 batch)

Factory cleaning services

30,000

A cost that is not consumed by any of the products

2. The company pays £8 per direct labour hour

3. The following table lists out some key figures for this firm:

Description

Quantity

Number of watches

1,500 units

Direct labour hours

7,000 hours

Machine hours

14,000 hours

Number of job orders

110

Inspection hours using machine

800 hours

Number of cycles for procurement and placement

2,400 times

Required:

a) Calculate the manufacturing overhead absorption rate using the traditional absorption costing system                                                                      

  

b) What would be the sales price of the following two products using the ABC system if the company adds 30% mark-up on total allocated costs?

Model

Luxury

Sports

Category

Female

Male

Job order number

LF-340 & LF-341

SM-119 & SM-120

Number of units

40

60

Direct materials (£ per unit)

85

55

Direct labour hours

200

250

Machine hours

225

750

Inspection hours using machine

12

40

Number of cycles for procurement and placement

50

80

                                                                               

Solutions

Expert Solution

Manufacturing overhead absorption rate

Activity cost pool Overhead
Job Order Setup 25000
Procurment and replacement 350000
Installation of winding system 170000
Quality Inspection(Machine) 70000
Quality Inspection(Manual) 24000
Finishing 160000
Packaging and delivery 44250
Factory Cleaning Service 30000
Total Overhead 873250

Total overhead / Total machine Hours  

= 873250/14000 = 62.375 per machine hours

Calculation of selling price with ABC

Activity cost pool Basis Overhead basis Rate
Job Order Setup no of job orders 25000 110 227.27
Procurment and replacement no of procurment 350000 2400 145.83
Installation of winding system no of watch 170000 1500 113.33
Quality Inspection(Machine) inspection hours 70000 800 87.50
Quality Inspection(Manual) Labour Hours 24000 7000 3.43
Finishing Labour Hours 160000 7000 22.86
Packaging and delivery no of batch of watches 44250 150 295.00
Factory Cleaning Service machine hours 30000 14000 2.14
Total Overhead 873250
Cost name luxury female Total cost Sports male Total cost
job order setup 2 454.55 2 454.55
Procurment Cost 50 7291.67 80 11666.67
Installation 40 4533.33 60 6800.00
Quality Inspection 12 1050.00 40 3500.00
Quality manual 200 686.00 250 857.50
Finishing 200 4572.00 250 5715.00
Packaging and delivery 4 batch 1180.00 6 batch 1770.00
factory cleaning 225 481.50 750 1605.00
Total overheads 20249.05 32368.71
Total overhead per unit 506.23 539.48
Cost per unit Luxury Female Sports Male
Direct Material 85 55
Direct labour 40 33.3
Overheads 506.2 539.5
Total Cost 631.2 627.8
Marck up 189.4 188.3
Selling price 820.6 816.2

Related Solutions

1. The following table lists out the overhead cost: Activity cost pool Overhead cost (£) Additional...
1. The following table lists out the overhead cost: Activity cost pool Overhead cost (£) Additional Notes Job-order set up 33,000 Procurement and placement 360,000 Installation of winding system   195,000 An auto winding system is fitted with every watch Quality inspection (machine) 60,000 Quality inspection (manual) 21,000 Finishing 140,000 Hand-made finishing Packaging and delivery 44,250 The company packages and delivers watches in batches containing 10 watches per batch. On an average, the packaging and delivery cost is the same for...
Compute the ABC rates based on the following information: Activity Cost Pool (a) Estimated Overhead Cost...
Compute the ABC rates based on the following information: Activity Cost Pool (a) Estimated Overhead Cost (b) Expected Activity Labor related........................... $ 5,200 800 DLHs Machine related....................... 1,500 2,000 MHs Machine setups........................ 4,200 100 setups Production orders..................... 1,800 50 orders Product testing........................ 4,800 200 tests Packaging............................... 7,000 500 packages General factory........................ 108,800 800 DLHs Compute the single overall predetermined overhead rate based entirely on direct labor-hours: Compute the cost for completing 100,000 widgets if the direct materials cost was $45,000...
In activity-based costing, each major activity has its own overhead cost pool, its own activity measure,...
In activity-based costing, each major activity has its own overhead cost pool, its own activity measure, and its own overhead rate. True or False TrueFalse
Texas Co. established the following overhead cost pools and cost drivers: Budgeted Estimated Overhead Cost Pool...
Texas Co. established the following overhead cost pools and cost drivers: Budgeted Estimated Overhead Cost Pool Overhead Cost Driver Cost Driver Level Quality controls $780,000 # of inspections 26,000 inspections Machine setups $720,000 # of setups 12,000 setups Other overhead costs $900,000 # of machine hrs 50,000 machine hrs Total overhead costs $2,400,000 A recent order for sailboats used: Quality inspections 750 inspections Machine setups 500 setups Machine hours (MHs) 2,400 machine hours Required: a. What is the overhead rate...
an activity-cost pool a. a measure of the activity performed serves as the cost allocation base....
an activity-cost pool a. a measure of the activity performed serves as the cost allocation base. b. the costs have a cause-and-effect relationship with the cost-allocation base for that activity. c. the cost pools are homogeneous over time. d. costs in a cost pool can always be traced directly to products. e. each pool pertains to a narrow and focused set of costs. Answer the following question(s) using the information below. Peter’s Printers has contracts to complete weekly supplements required...
  In activity-based costing, the activity rate for an activity cost pool is computed by dividing...
  In activity-based costing, the activity rate for an activity cost pool is computed by dividing the total overhead cost in the activity cost pool by:   Multiple Choice the total activity for the activity cost pool. the direct labor-hours required by the product. the machine-hours required by the product. the total direct labor-hours for the activity cost pool.
Activity rates are determined by a. dividing the actual cost for each activity pool by the...
Activity rates are determined by a. dividing the actual cost for each activity pool by the estimated activity base for that pool. b. dividing the cost budgeted for each activity pool by the actual activity base in that pool. c. dividing the cost budgeted for each activity pool by the estimated activity base for that pool. d. dividing the actual cost for each activity pool by the actual activity base for that pool.
Question 5 The extra cost that results from carrying out one additional unit of an activity...
Question 5 The extra cost that results from carrying out one additional unit of an activity is the _____ of the activity. ⦁   marginal benefit ⦁   reservation cost ⦁   marginal cost ⦁   opportunity cost Question 7 The demand for a good is said to be elastic with respect to price if the absolute value of its price elasticity is ____________ than 1. A.    smaller as well as greater B.    greater C.    smaller D.    equal to and...
Chipman Inc. produces water pumps. Overhead costs have been identified as follows: Activity Pool Cost Material...
Chipman Inc. produces water pumps. Overhead costs have been identified as follows: Activity Pool Cost Material handling$80,437.50 Material maintenance$108,300.00 Setups$77,931.00 Activity DriverActivity Number of moves495 Number of machine hours36,100 Number of production runs63 Chipman makes 3 models of pumps with the following details: EconomyStandardPremium Units produced10,11021,6003,525 Number of moves186134175 Machine hours9,10020,4006,600 Production runs201033 Required: a. Calculate the activity rate for each activity. (Round your answers to 2 decimal places.) b. Determine the amount of indirect costs assigned to each of...
Vanguard Corporation has provided the following data from its activity-based costing system: Activity Cost Pool Total...
Vanguard Corporation has provided the following data from its activity-based costing system: Activity Cost Pool Total Cost Total Activity Assembly $ 1,078,920 74,000 machine-hours Processing orders $ 76,560 1,650 orders Inspection $ 119,616 1,680 inspection-hours The company makes 400 units of product O37W a year, requiring a total of 630 machine-hours, 50 orders, and 10 inspection-hours per year. The product's direct materials cost is $36.92 per unit and its direct labor cost is $30.06 per unit. According to the activity-based...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT