Caldwell Home Appliances Inc. is estimating the activity cost associated with producing ovens and refrigerators. The indirect labor can be traced into four separate activity pools, based on time records provided by the employees. The budgeted activity cost and activity-base information are provided as follows:
Activity |
Activity Pool Cost |
Activity Base |
|||
Procurement |
$12,600 |
Number of purchase orders |
|||
Scheduling |
90,000 |
Number of production orders |
|||
Materials handling |
11,000 |
Number of moves |
|||
Product development |
50,000 |
Number of engineering changes |
|||
Total cost |
$163,600 |
The estimated activity-base usage and unit information for two product lines was determined as follows:
Number of Purchase Orders |
Number of Production Orders |
Number of Moves |
Number of Engineering Change Orders |
Units |
||||||||||||
Ovens |
400 |
800 |
300 |
80 |
1,000 |
|||||||||||
Refrigerators |
300 |
400 |
200 |
120 |
500 |
|||||||||||
Totals |
700 |
1,200 |
500 |
200 |
1,500 |
a. Determine the activity rate for each activity cost pool.
Procurement (per purchase order) |
$ |
Scheduling (per production order) |
$ |
Materials handling (per move) |
$ |
Product development (per engineering change order) |
$ |
b. Determine the activity-based cost per unit of each product. Round the per unit rates to the nearest cent.
Ovens |
$ per unit |
Refrigerators |
$ per unit |
Please show calculations
a.) | Activity rate for each activity pool | Amount $ | |
Procurement (per purchase order) | 18 | =12600/700 | |
Scheduling (per production order) | 75 | =90000/1200 | |
Materials handling (per move) | 22 | =11000/500 | |
Product development (per engineering change order) | 250 | =50000/200 | |
b.) | Amount $ | ||
Ovens | Refrigerators | ||
Procurement | 7,200 | 5,400 | |
Scheduling | 60,000 | 30,000 | |
Materials handling | 6,600 | 4,400 | |
Product development | 20,000 | 30,000 | |
Total activity cost allocated | 93,800 | 69,800 | |
Activity based cost per unit of each product | |||
Ovens | $ 93.80 | =93800/1000 | |
Refrigerators | $ 139.60 | =69800/500 | |
Working: | ||
Amount $ | ||
Ovens | Refrigerators | |
Procurement | =18*400 | =18*300 |
Scheduling | =75*800 | =75*400 |
Materials handling | =22*300 | =22*200 |
Product development | =250*80 | =250*120 |
Total activity cost allocated | 93,800 | 69,800 |
Caldwell Home Appliances Inc. is estimating the activity cost associated with producing ovens and refrigerators. The...
Caldwell Home Appliances Inc. is estimating the activity cost associated with producing ovens and refrigerators. The indirect labor can be traced into four separate activity pools, based on time records provided by the employees. The budgeted activity cost and activity-base information are provided as follows: Activity Activity Pool Cost Activity Base Procurement $12,600 Number of purchase orders Scheduling 90,000 Number of production orders Materials handling 11,000 Number of moves Product development 50,000 Number of engineering changes Total cost $163,600 The...
Activity Cost Pools, Activity Rates, and Product Costs using Activity-Based Costing Caldwell Home Appliances Inc. is estimating the activity cost associated with producing ovens and refrigerators. The indirect labor can be traced into four separate activity pools, based on time records provided by the employees. The budgeted activity cost and activity-base information are provided as follows: Activity Activity Pool Cost Activity Base Procurement $145,410 Number of purchase orders Scheduling 10,560 Number of production orders Materials handling 28,400 Number of moves...
Create Activity Tables for Ovens and Refrigerators.
Hipster Home Appliances Inc. is estimating the activity cost associated with producing ovens and refrigerators. The indirect labor can be traced into four separate activity pools, based on time records provided by the employees. The budgeted activity cost and activity-base information are provided as follows: Activity Activity Pool Cost Activity Base Procurement 66,000.00 Number of purchase orders 12000 Number of production orders 3,28000 Number of moves 3 Scheduling Materials handling Product development Total...
EX 18-12 Activity Cost Pools, Activity Rates, and Product Costs Using Activity-Based Costing Obj. 4 Caldwell Home Appliances Inc. is estimating the activity cost associated with producing ovens and refrigerators. The indirect labor can be traced into four separate activity pools, based on time records provided by the employees. The budgeted activity cost and activity-base information are provided as follows: Activity Pool Cost Activity Activity Base Procurement Scheduling Materials handling Product development Total cost $ 12,600 90,000 11,000 50,000 $163,600...
EX 4-12 Activity cost pools, activity rates, and product costs using Obj. 4 activity-based costing B. Ovens, $93.80 Caldwell Home Appliances Inc. is estimating the activity cost associated with producing ovens per unit and refrigerators. The indirect labor can be traced into four separate activity pools, based on time records provided by the employees. The budgeted activity cost and activity-base informa- tion are provided as follows: Activity Pool EXCEL TEMPLATE Activity Cost Activity Base Procurement Scheduling Materials handling Product development...
Panamint Systems Corporation is estimating activity costs associated with producing disk drives, tapes drives, and wire drives. The indirect labor can be traced to four separate activity pools. The budgeted activity cost and activity base data by product are provided below. Activity Cost Activity Base Procurement $329,900 Number of purchase orders Scheduling 223,700 Number of production orders Materials handling 426,300 Number of moves Product development 762,500 Number of engineering changes Production 1,434,200 Machine hours Number of Purchase Orders Number of...
Panamint Systems Corporation is estimating activity costs associated with producing disk drives, tapes drives, and wire drives. The indirect labor can be traced to four separate activity pools. The budgeted activity cost and activity base data by product are provided below. Procurement Scheduling Materials handling Product development Activity Cost Activity Base $366,100 Number of purchase orders 244,900 Number of production orders 414,000 Number of moves 720,800 Number of engineering changes 1,584,700 Machine hours Production Number of Engineering Changes Number ol...
ABC, Inc. is estimating activity costs associated with producing disk drives, tapes drives, and wire drives. The indirect labor can be traced to five separate activity pools. The budgeted activity cost and activity base data by product are provided below. Activity Cost Activity Base Number of purchase orders Procurement $ 370,000 Number of production orders Scheduling 250,000 Number of moves Materials handling 500,000 Number of engineering changes Product development 730,000 Machine hours Production 1,500,000 Number of Number of Purchase Orders...
Panamint Systems Corporation is estimating activity costs associated with producing disk drives, tapes drives, and wire drives. The indirect labor can be traced to four separate activity pools. The budgeted activity cost and activity base data by product are provided below. Activity Cost Activity Base Procurement $370,000 Number of purchase orders Scheduling 250,000 Number of production orders Materials handling 500,000 Number of moves Product development 730,000 Number of engineering changes Production 1,500,000 Machine hours Number of Number of Number of...
Panamint Systems Corporation is estimating activity costs associated with producing disk drives, tapes drives, and wire drives. The indirect labor can be traced to four separate activity pools. The budgeted activity cost and activity base data by product are provided below. Procurement Scheduling Materials handling Product development Production Activity Cost Activity Base $302,500 Number of purchase orders 248,300 Number of production orders 496,300 Number of moves 772,900 Number of engineering changes 1,560,800 Machine hours Number of Engineering Changes 10 Number...