Question

In: Finance

Consider the following data for a clinical laboratory: Activity Annual Costs Cost Driver Test A Test...

Consider the following data for a clinical laboratory:

Activity Annual Costs Cost Driver Test A Test B Test C Test D Total Units Allocation
Receive specimen $             10,000 Number of tests 2,000 1,500 1,000 500 5,000 $            2.00
Equipment set-up                  25,000 Number of minutes per test 5 5 10 10 30 $      833.33
Run test               100,000 Number of minutes per test 1 5 10 20 36 $ 2,777.78
Record results                  10,000 Number of minutes per test 2 2 2 4 10              1,000
Transmit results                     5,000 Number of minutes per test 3 3 3 3 12           416.67
Total $          150,000
Test Value $ per test
Activity Allocation Test A Test B C D Tot
Receive specimen $                   2.00 $                        2.00
Equipment set-up $             833.33 $             4,166.67
Run test $         2,777.78 $             2,777.78
Record results
Transmit results
Total $             6,946.44
Total for all $13,892,888.89 $      13,892,889

a. Using ABC techniques, determine the allocation rate for each activity. (I think I did it correctly above, but I'd like a double check).

b. Now, using this allocation rate, estimate the total cost of performing each test.

c. Verify that the total annual costs aggregated from individual test costs equal the total annual costs of the laboratory given in the table above.

PLEASE SHOW ALL WORK.

Solutions

Expert Solution

Total Cost
Test A Test B Test C Test D
Receiving Specimen 4,000 (2,000*2) 3,000 (1,500*2) 2,000 (1,000*2) 1,000 (500*2)
Set up Equipment 7,700 (2,000*5*.77) 5,775 (1,500*5*.77) 7,700 (1,000*10*.77) 3,850 (500*10*.77)
Run Test 6,780 (2,000*1*3.39) 25,425 (1,500*5*3.39) 33,900 (1,000*10*3.39) 33,900 (500*20*3.39)
Record Results 3,640 (2,000*2*.91) 2,730 (1,500*2*.91) 1,820 (1,000*2*.91) 1,820 (500*4*,91)
Transmit Results 1,980 (2,000*3*.33) 1,485 (1,500*3*.33) 990 (1,000*3*.33) 495 (500*3*.33)
Total Cost $24,100 $38,415 $46,410 $41,065


Related Solutions

Use the following information regarding Musketeer Novelties: Activity Activity Costs Cost driver Product design $212,000 1,500...
Use the following information regarding Musketeer Novelties: Activity Activity Costs Cost driver Product design $212,000 1,500 design hours Product scheduling $180,000 400 Set ups Machining $600,000 5,000 machine hours Material Handling $160,000 4,000 Pallet moved Cost and activity with procuring 2,000 units of a Blueblob Bobblehead are as follows: Direct Materials: $5,400 Direct Labor: $1,200 Design Hours: 5 Set-Ups: 3 Labor Hours 40 Machine Hours 18 Pallets Moved 10 United produced 400 1.) Develop activity rates for each of the...
Use the following information regarding Musketeer Novelties: Activity Activity Costs Cost driver Product design $212,000 1,500...
Use the following information regarding Musketeer Novelties: Activity Activity Costs Cost driver Product design $212,000 1,500 design hours Product scheduling $180,000 400 Set ups Machining $600,000 5,000 machine hours Material Handling $160,000 4,000 Pallet moved Cost and activity with procuring 2,000 units of a Blueblob Bobblehead are as follows: Direct Materials: $5,400 Direct Labor: $1,200 Design Hours: 5 Set-Ups: 3 Labor Hours 40 Machine Hours 18 Pallets Moved 10 United produced 400 1.) Develop activity rates for each of the...
27) A preliminary stage cost driver links costs of resources consumed in an activity center to:...
27) A preliminary stage cost driver links costs of resources consumed in an activity center to: 1. batch-level activities 2. products 3. cost functions 4. focused factories 5. other activity centers 28)In the step method of service center allocation, the number of allocation steps equals the number of: 1. activities performed in all operating departments. 2. service centers. 3. operating departments. 4. service centers plus operating departments. 5. activities performed in all service centers. 30)Activity based costing: 1. uses fewer...
Activity Driver Driver Frequency Cost of Activity Direct Labor Direct Labor Hours                   50,000 $ 1,250,000.00...
Activity Driver Driver Frequency Cost of Activity Direct Labor Direct Labor Hours                   50,000 $ 1,250,000.00 Vacuuming Machine Hours                      2,000 $       62,000.00 Set-up Job                      5,000 $     200,000.00 Testing Tests made                      5,000 $       60,000.00 Customer service Orders taken                      1,200 $       30,000.00 Invoicing Invoices mailed                      2,400 $       48,000.00 Total $ 1,650,000.00 Activity Pool Opening Pump Repair Pool Cleaning Materials 350 1000 50 Direct Labor Hours 15 40 2 Vacuuming 3 0 2 Set-up 1 1 1 Testing...
Using activity analysis, AAA Company has identified the appropriate cost driver for maintenance costs in a...
Using activity analysis, AAA Company has identified the appropriate cost driver for maintenance costs in a factory as the number of machine hours. The maintenance costs have been observed as follows within the relevant range of 5,000 to 8,000 machine-hours. Month Maintenance Cost Machine Hours January $7,100 5,600 February $8,500 7,100 March $7,400 5,000 April $8,200 6,500 May $9,950 7,300 June $9,800 8,000 July $7,800 6,200 Using the high-low method, determine the variable maintenance cost per machine hour and the...
The following budgeted information is available for Zeta Company: Activity Budgeted Cost Activity Driver Consumption of...
The following budgeted information is available for Zeta Company: Activity Budgeted Cost Activity Driver Consumption of Drivers for Zeta’s Product Lines Total Activity Driver Product A Product B Processing & Testing Developing test programs $400,000 Engineering hours 10,000 2,500 7,500 Making probe cards 58,750 Development hours 4,000 400 3,600 Testing products 300,000 Test hours 20,000 2,000 18,000 Setups 40,000 Number of batches 100 55 45 Engineering design 80,000 Number of change orders 60 9 51 Handling lots 90,000 Number of...
Al Fagira Farm produces oranges and mangoes. The annual fixed costs are $40,000. The cost driver...
Al Fagira Farm produces oranges and mangoes. The annual fixed costs are $40,000. The cost driver for variable costs is pints of fruit produced. The variable cost is $1.25 per pint of mango and 1.15 per pint of orange. Mangoes sell for $1.65 per pint, Oranges for 1.40 per pint. 3 pints of oranges are produced for every pint of mangoes. Required: 1. Compute the number of pints of mangoes and oranges produced and sold at the break-even point. 2....
The following annual per unit cost data at an activity level of 4,000 units has been...
The following annual per unit cost data at an activity level of 4,000 units has been provided below. The company produces and sells only one product.: $ Per Unit Sales 400.00 Direct labor 18.00 Direct material 22.00 Variable manufacturing overhead 4.00 Fixed manufacturing overhead 20.00 Variable selling expenses 2.00 Fixed selling expenses 5.00 Fixed administrative expenses 3.00 The relevant range is 2,500 - 5,500 units. You will be given facts for three different options. Using the facts given, calculate amounts...
Assuming activity-cost pools are used, what are the activity-cost driver rates for design changes, setups, and...
Assuming activity-cost pools are used, what are the activity-cost driver rates for design changes, setups, and inspections cost pools? a. $200 per change, $64 per setup, $5 per inspection b. $180 per change, $76 per setup, $4 per inspection c. $150 per change, $64 per setup, $4 per inspection d. $180 per change, $76 per setup, $5 per inspection e. $200 per change, $5 per setup, $64 per inspection Short Answer The following costs are attributed to the Quilt Company:...
Activity cost pool Machine setup Materials handling Machine depreciation Activity cost driver Number of setups Number...
Activity cost pool Machine setup Materials handling Machine depreciation Activity cost driver Number of setups Number of parts Machine hours (mh) Cost assigned to pool 260000 580000 600000 Standard product 60 setups 14000 parts 2 mh per product Custom product 40 setups 12000 parts 4mh per product the company produced 14 000 basic products and 10000 custom product. compute the activity overhead rate for each cost pool using ABC.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT