Yanbu ceramics has budgeted overhead costs of $706,000 it has allocated overhead on a plant wide basis to its two products: Italian ceramic u Spanish ceramic o The company has decided to experiment with Activity-Based Costing, o The company has created two activity cost pools and related activity cost drivers. o These two cost pools are: u Cutting (cost driver is machine hours) u Design (cost driver is number of setups) Overhead allocated to the cutting cost pool is $700.000 and $6.000 is allocated to the design cost pool Additional information related to these pools is as follows Italian Spanish Total Machine hours 150.000 100.000 250.000 Number of setuos 700 800 1 500 A. List the activity cost pools, activity cost drivers and their overhead Activity cost pools Cutting Design Cost drivers Machine hours Number of setups Estimated overhead $360,000 630,000 B. Calculate the activity-based overhead rates Activity cost pools Estimated Overhead Expected Use of Cost Activity-Based Driver per Activity Overhead Rates Machine hours 5360.000 Number of setups 630.000 Cutting Design Activity cost pools Cutting Design Estimated Overhead Expected Use of Cost Activity-Based Driver per Activity Overhead Rates Machine hours $360,000 Number of setups 530,000 C. Calculate the total overhead costs assigned for both Italian and Spanish Ceramics NE Cost Assigned Italian Activity cost pools Expected Use of Cost Activity-Based Overhead Driver per Activity Rates Cutting Machine hours $360,000 Design Number of setups 630.000 Design TOTAL OVERHEAD COST ASSIGNED C. Calculate the total overhead costs assigned for both Italian and Spanish Ceramics Cost Assigned Italian Activity cost pools Expected Use of Cost Activity-Based Overhead Driver per Activity Rates Cutting Machine hours $360,000 Design Number of setups 630,000 Design TOTAL OVERHEAD COST ASSIGNED Cost Assigned Spanish Activity cost pools Expected Use of Cost Driver Activity-Based Overhead per Activity Rates Cutting Machine hours $360.000 Design Number of setups 630,000 Design TOTAL OVERHEAD COST ASSIGNED Yanbu ceramics has budgeted overhead costs of $706,000 it has allocated overhead on a plant wide basis to its two products: Italian ceramic u Spanish ceramic o The company has decided to experiment with Activity-Based Costing, o The company has created two activity cost pools and related activity cost drivers. o These two cost pools are: u Cutting (cost driver is machine hours) u Design (cost driver is number of setups) Overhead allocated to the cutting cost pool is $700.000 and $6.000 is allocated to the design cost pool Additional information related to these pools is as follows Italian Spanish Total Machine hours 150.000 100.000 250.000 Number of setuos 700 800 1 500 A. List the activity cost pools, activity cost drivers and their overhead Activity cost pools Cutting Design Cost drivers Machine hours Number of setups Estimated overhead $360,000 630,000 B. Calculate the activity-based overhead rates Activity cost pools Estimated Overhead Expected Use of Cost Activity-Based Driver per Activity Overhead Rates Machine hours 5360.000 Number of setups 630.000 Cutting Design Activity cost pools Cutting Design Estimated Overhead Expected Use of Cost Activity-Based Driver per Activity Overhead Rates Machine hours $360,000 Number of setups 530,000 C. Calculate the total overhead costs assigned for both Italian and Spanish Ceramics NE Cost Assigned Italian Activity cost pools Expected Use of Cost Activity-Based Overhead Driver per Activity Rates Cutting Machine hours $360,000 Design Number of setups 630.000 Design TOTAL OVERHEAD COST ASSIGNED C. Calculate the total overhead costs assigned for both Italian and Spanish Ceramics Cost Assigned Italian Activity cost pools Expected Use of Cost Activity-Based Overhead Driver per Activity Rates Cutting Machine hours $360,000 Design Number of setups 630,000 Design TOTAL OVERHEAD COST ASSIGNED Cost Assigned Spanish Activity cost pools Expected Use of Cost Driver Activity-Based Overhead per Activity Rates Cutting Machine hours $360.000 Design Number of setups 630,000 Design TOTAL OVERHEAD COST ASSIGNED