Question

In: Accounting

Cancico Communications has supplied the following data for use in its ABC system: Overhead Costs   Wages...

Cancico Communications has supplied the following data for use in its ABC system:

Overhead Costs
  Wages and salaries $ 300,000
  Other overhead costs 165,000
  Total overhead costs $ 465,000
  Activity Cost Pool Activity Measure Total Activity
  Direct labour support   Number of direct labour-hours 12,300 DLHs
  Order processing   Number of orders 500 orders
  Customer support   Number of customers 180 customers
  Other   These costs are not allocated
     to products or customers
NA
Distribution of Resource Consumption
across Activity Cost Pools
Direct
Labour
Support
Order
Processing
Customer
Support
Other Total
  Wages and salaries 15 % 40 % 35 % 10 % 100 %
  Other overhead costs 10 % 25 % 25 % 40 % 100 %

During the year, Cancico Communications completed an order for special telephone equipment for a new customer, HurnTel. This customer did not order any other products during the year. Data concerning that order follow:

  Selling price $ 217 per unit
  Units ordered 190 units
  Direct materials $ 196 per unit
  Direct labour-hours 0.6 DLH per unit
  Direct labour rate $ 26 per DLH

1. Prepare a report showing the first-stage allocations of overhead costs to the activity cost pools.

2. Compute the activity rates for the activity cost pools. (Round your answers to 2 decimal places.)

3. Prepare a report showing the overhead costs for the order from HurnTel, including customer support costs. (Round your answers to 2 decimal places.)

4. Prepare a report showing the customer margin for HurnTel. (Round your answers to 2 decimal places.)

Solutions

Expert Solution

1. Prepare a report showing the first-stage allocations of overhead costs to the activity cost pools

Direct
Labour
Support
Order processing Customer support Other Total
Wages and salaries 45000 120000 105000 30000 300000
Other overhead costs 16500 41250 41250 66000 165000
Total 61500 161250 146250 96000 465000

2. Compute the activity rates for the activity cost pools. (Round your answers to 2 decimal places.)

Activity rate
Direct labour support (61500/12300) 5 per labour hour
Order processing (161250/500) 322.50 per order
Customer support (146250/180) 812.50 per customer

3. Prepare a report showing the overhead costs for the order from HurnTel, including customer support costs. (Round your answers to 2 decimal places.)

Overhead
Direct labour support 190*.6*5 = 570
Order processing 322.50
Customer support 812.50
Total overhead 1705

4. Prepare a report showing the customer margin for HurnTel. (Round your answers to 2 decimal places.)

Sales (190*217) 41230
Direct material (190*196) 37240
Direct labour (190*.6*26) 2964
Overhead 1705
Customer margin -679

Related Solutions

Cancico Communications has supplied the following data for use in its ABC system: Overhead Costs   Wages...
Cancico Communications has supplied the following data for use in its ABC system: Overhead Costs   Wages and salaries $ 312,500   Other overhead costs 170,000   Total overhead costs $ 482,500   Activity Cost Pool Activity Measure Total Activity   Direct labour support   Number of direct labour-hours 5,675 DLHs   Order processing   Number of orders 500 orders   Customer support   Number of customers 160 customers   Other   These costs are not allocated      to products or customers NA                Distribution of Resource Consumption across Activity Cost Pools Direct...
Cancico Communications has supplied the following data for use in its ABC system: Overhead Costs Wages...
Cancico Communications has supplied the following data for use in its ABC system: Overhead Costs Wages and salaries $ 300,000 Other overhead costs 165,000 Total overhead costs $ 465,000 Activity Cost Pool Activity Measure Total Activity Direct labour support Number of direct labour-hours 12,300 DLHs Order processing Number of orders 500 orders Customer support Number of customers 180 customers Other These costs are not allocated to products or customers NA Distribution of Resource Consumption across Activity Cost Pools Direct Labour...
Cancico Communications has supplied the following data for use in its ABC system: Overhead Costs   Wages...
Cancico Communications has supplied the following data for use in its ABC system: Overhead Costs   Wages and salaries $ 312,500   Other overhead costs 170,000   Total overhead costs $ 482,500   Activity Cost Pool Activity Measure Total Activity   Direct labour support   Number of direct labour-hours 5,675 DLHs   Order processing   Number of orders 500 orders   Customer support   Number of customers 160 customers   Other   These costs are not allocated      to products or customers NA                Distribution of Resource Consumption across Activity Cost Pools Direct...
Cancico Communications has supplied the following data for use in its ABC system: Overhead Costs   Wages...
Cancico Communications has supplied the following data for use in its ABC system: Overhead Costs   Wages and salaries $ 267,500   Other overhead costs 152,000   Total overhead costs $ 419,500   Activity Cost Pool Activity Measure Total Activity   Direct labour support   Number of direct labour-hours 7,630 DLHs   Order processing   Number of orders 450 orders   Customer support   Number of customers 110 customers   Other   These costs are not allocated      to products or customers NA Distribution of Resource Consumption across Activity Cost Pools Direct Labour...
Cancico Communications has supplied the following data for use in its ABC system: Overhead Costs   Wages...
Cancico Communications has supplied the following data for use in its ABC system: Overhead Costs   Wages and salaries $ 305,000   Other overhead costs 167,000   Total overhead costs $ 472,000   Activity Cost Pool Activity Measure Total Activity   Direct labour support   Number of direct labour-hours 12,490 DLHs   Order processing   Number of orders 500 orders   Customer support   Number of customers 180 customers   Other   These costs are not allocated      to products or customers NA Distribution of Resource Consumption across Activity Cost Pools Direct Labour...
Silicon Optics has supplied the following data for use in its activity-based costing system:      Overhead...
Silicon Optics has supplied the following data for use in its activity-based costing system:      Overhead Costs   Wages and salaries $ 343,000   Other overhead costs 194,000   Total overhead costs $ 537,000      Activity Cost Pool Activity Measure Total Activity   Direct labor support Number of direct labor-hours 12,000 DLHs   Order processing Number of orders 570 orders   Customer support Number of customers 100 customers   Other This is an organization-sustaining activity Not applicable    Distribution of Resource Consumption Across Activities Direct Labor Support...
CR Black has supplied the following data for use in its activity based costing system: Overhead...
CR Black has supplied the following data for use in its activity based costing system: Overhead Costs: Wages and Salaries $ 700,000 Other Overhead Costs $ 400,000 Total Overhead Costs $1,100,000 Activity Cost Pool: Direct Labor Support Order Processing Customer Support Other Activity Measure: Number of direct labor-hours Number of orders Number of Customers This is an organizationSustaining activity Total Activity: 10,000 DLHs 500 Orders 100 customers Not applicable Selling Price $700 per unit Units Ordered 100 units Direct materials...
Equally Accurate Reduced ABC System Silven Company has identified the following overhead activities, costs, and activity...
Equally Accurate Reduced ABC System Silven Company has identified the following overhead activities, costs, and activity drivers for the coming year: Activity Expected Cost Activity Driver Activity Capacity Setting up equipment $126,000 Number of setups 150 Ordering materials 18,000 Number of orders 900 Machining 126,000 Machine hours 10,500 Receiving 30,000 Receiving hours 1,250 Silven produces two models of cell phones with the following expected activity demands: Model X Model Y Units completed 5,000 10,000 Number of setups 100 50 Number...
Bennette Corporation has provided the following data concerning its overhead costs for the coming year:  ...
Bennette Corporation has provided the following data concerning its overhead costs for the coming year:     Wages and salaries $ 440,000 Depreciation   170,000 Rent   190,000 Total $ 800,000   The company has an activity-based costing system with the following three activity cost pools and estimated activity for the coming year: Activity Cost Pool Total Activity Assembly 30,000 labor-hours Order processing 550 orders Other Not applicable   The Other activity cost pool does not have a measure of...
ABC Corporation has provided the following data concerning manufacturing overhead for May:
ABC Corporation has provided the following data concerning manufacturing overhead for May: Actual manufacturing overhead incurred                               Rs. 66,000Manufacturing overhead applied to Work in Process             Rs. 62,000The Corporation's gross profit was Rs. 225,000 prior to closing out its Manufacturing Overhead account. The Corporation closes out its Manufacturing Overhead account to Cost of Goods Sold. What would be the gross profit after closing manufacturing overhead account:
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT