Question

In: Accounting

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 Order Processing Customer Support Other     Total
  Wages and salaries 10 % 30 % 20 % 40 % 100 %
  Other overhead costs 30 % 20 % 20 % 30 % 100 %

  

During the year, Silicon Optics completed an order for a special optical switch for a new customer, Indus Telecom. This customer did not order any other products during the year. Data concerning that order follow:

  

Data Concerning the Indus Telecom Order
  Selling price $ 270 per unit
  Units ordered 100 units
  Direct materials $ 254 per unit
  Direct labor-hours 0.5 DLH per unit
  Direct labor rate $ 27 per DLH

  

Required:
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.

Compute the overhead costs for the order from Indus Telecom, including customer support costs. (Round your intermediate calculations and final answers to 2 decimal places.)

     

4.

Prepare a report showing the customer margin for Indus Telecom. (Negative customer margins should be indicated by a minus sign. Round your intermediate calculations and final answers to 2 decimal places.)

     

Solutions

Expert Solution


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 $ 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...
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...
Feldpausch Corporation has provided the following data from its activity-based costing system: Activity Cost Pool Total...
Feldpausch Corporation has provided the following data from its activity-based costing system: Activity Cost Pool Total Cost Total Activity Assembly $ 1,471,965 60,500 machine-hours Processing orders $ 54,224 1,850 orders Inspection $ 152,154 2,140 inspection-hours The company makes 1,230 units of product W26B a year, requiring a total of 1,380 machine-hours, 103 orders, and 39 inspection-hours per year. The product's direct materials cost is $52.21 per unit and its direct labor cost is $17.15 per unit. The product sells for...
Petitte Corporation has provided the following data from its activity-based costing system: Activity Cost Pool Total...
Petitte Corporation has provided the following data from its activity-based costing system: Activity Cost Pool Total cost Total activity Assembly $612,560 31,000 machine hours Processing orders $35,451 1,300 orders Inspection $100,217 1,690 Inspection hours Data concerning the company's product K54A appear below: Selling price $150 per unit Annual production and sales 410 units Annual machine hours 700 machine hours Annual number of orders 30 orders Annual inspection hours 30 orders Direct materials cost $45.67 per unit Direct labor cost $31.24...
Paparo Corporation has provided the following data from its activity-based costing system: Activity Cost Pool Total...
Paparo Corporation has provided the following data from its activity-based costing system: Activity Cost Pool Total Cost Total Activity Assembly $ 794,300 47,000 machine-hours Processing orders $ 61,280 1,600 orders Inspection $ 109,681 1,430 inspection-hours Data concerning the company's product Q79Y appear below: Annual unit production and sales 500 Annual machine-hours 1,130 Annual number of orders 115 Annual inspection hours 20 Direct materials cost $ 42.00 per unit Direct labor cost $ 41.31 per unit According to the activity-based costing...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT