Question
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 200,000
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 | 200,000 | ||
Total overhead costs | $ | 543,000 | |
Activity Cost Pool | Activity Measure | Total Activity | |
Direct labor support | Number of direct labor-hours | 8,000 | DLHs |
Order processing | Number of orders | 540 | orders |
Customer support | Number of customers | 120 | 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 | 20 | % | 30 | % | 20 | % | 30 | % | 100 | % |
Other overhead costs | 30 | % | 10 | % | 15 | % | 45 | % | 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 | $ | 265 | per unit |
Units ordered | 100 | units | |
Direct materials | $ | 259 | per unit |
Direct labor-hours | 0.3 | DLH per unit | |
Direct labor rate | $ | 25 | per DLH |
Required: | |
1. | Prepare a report showing the first-stage allocations of overhead costs to the activity cost pools. (Omit the "$" sign in your response.) |
Direct Labor Support | Order Processing | Customer Support | Other | Totals | |
Wages and salaries | $ | $ | $ | $ | $ |
Other overhead costs | |||||
Total cost | $ | $ | $ | $ | $ |
2. | Compute the activity rates for the activity cost pools. (Round your answers to 2 decimal places.Omit the "$" sign in your response.) |
Activity Cost Pools | Activity Rate | |
Direct labor support | $ | per DLH |
Order processing | $ | per order |
Customer support | $ | per customer |
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. Omit the "$" sign in your response.) |
Activity Cost Pool | ABC Cost |
Direct labor support | $ |
Order processing | |
Customer support | |
Total | $ |
4. | Prepare a report showing the customer margin for Indus Telecom. (Input all amounts as positive values except losses which should be indicated by a minus sign. Round your intermediate calculations and final answers to 2 decimal places. Omit the "$" sign in your response.) |
Indus Telecom Customer MarginABC Analysis | ||
(Click to select)ShippingDirect laborDirect labor support overheadCustomer support overheadOtherDirect materialsOrder processing overheadSales | $ | |
Costs: | ||
(Click to select)OtherDirect materialsSalesCustomer support overheadDirect labor support overheadOrder processing overheadDirect laborShipping | $ | |
(Click to select)Direct labor support overheadDirect materialsDirect laborOrder processing overheadSalesShippingCustomer support overheadOther | ||
(Click to select)Order processing overheadCustomer support overheadSalesDirect laborDirect labor support overheadOtherDirect materialsShipping | ||
(Click to select)ShippingDirect laborSalesDirect labor support overheadOrder processing overheadOtherCustomer support overheadDirect materials | ||
(Click to select)Direct laborDirect materialsDirect labor support overheadOtherShippingCustomer support overheadSalesOrder processing overhead | ||
Customer margin | $ | |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started