Seligram, Inc.: Electronic Testing Operations - Costs of the Five Components
Essay by asselkan • July 15, 2018 • Case Study • 1,147 Words (5 Pages) • 1,489 Views
Essay Preview: Seligram, Inc.: Electronic Testing Operations - Costs of the Five Components
Discussion Questions: Seligram, Inc.: Electronic Testing Operations
Question 2. Calculate costs of the five components described in Exhibit 6 as reported by:
a. Costs of the five components as reported by the existing system:
Burden rate = Total Burden / Direct Labor
Total Burden = $4,713,982
Direct Labor = $3,260,015
Burden rate = 144.60%
Effective rate = 145%, which means gor every dollar of direct labor cost we add $1.45 of overhead.
Product | Direct Labor $ | Overhead | Total Costs |
ICA | $ 917 | $ 1,329.65 | $ 2,247 |
ICB | $ 2,051 | $ 2,973.95 | $ 5,025 |
CAPACITOR | $ 1,094 | $ 1,586.30 | $ 2,680 |
AMPLIFIER | $ 525 | $ 761.25 | $ 1,286 |
DIODE | $ 519 | $ 752.55 | $ 1,272 |
b. Costs of the five components as reported by the accounting manager:
The division accountant proposes to directly trace burden to two cost pools:
- Burden related to the administrative and technical functions which is charged on a rate per DL$
- All other burden costs charged based on machine hours
As per Exhibit 5:
- Effective machine-hour rate = $80
- Effective burden rate per direct labor $ = 20%
Product | Overhead 1 | Overhead 2 | Total Overhead | Total Cost |
ICA | 183.40 | 1,480 | 1,663.40 | $ 2,580.40 |
ICB | 410.20 | 3,200 | 3,610.20 | $ 5,661.20 |
CAPACITOR | 218.80 | 600 | 818.80 | $ 1,912.80 |
AMPLIFIER | 105.00 | 400 | 505.00 | $ 1,030.00 |
DIODE | 103.80 | 960 | 1,063.80 | $ 1,582.80 |
Total | 7,661.20 | $ 12,767.20 |
c. Costs of the five components as reported by the system proposed by the consultant:
Consultant recommended to implement a three-burden-pool system utilizing separate burden centers for each test room and a common technical and administrative pool. Burden would be directly traced to each of the three burden pools. Burden costs in the test rooms would be allocated on a machine-hour basis. Technical and administrative costs would continue to be charged on a rate per direct labor dollar.
We first find burden rates for each of three profit pools by dividing overhead of each test room to machine hours of that room and divide technical and administrative costs to total direct labor to find third rate.
Category | Costs | Machine hours | Machine hour rates ($) | Burden rate for Tech and Adm costs |
Direct Labor | 3,260,015 | |||
Electronic test room | 2,103,116 | 33,201 | 63 | |
Main test room | 1,926,263 | 17,103 | 113 | |
Technical and administrative | 684,603 | 21% | ||
Total overhead | 4,713,982 | |||
Total cost | 7,973,997 |
Then to find overhead of each product, we multiply machine hour rates to working hours of each product and burden rate for technical and administrative costs multiply by direct labor of each product.
Main Test Room | Mech Test Room | Per DL$ | ||
Product | Overhead 1 | Overhead 2 | Overhead 3 | Total Costs |
ICA | $ 535.5 | $ 1,130.0 | $ 183.4 | $ 2,766 |
ICB | $ 882.0 | $ 2,938.0 | $ 410.2 | $ 6,281 |
CAPACITOR | $ 189.0 | $ 508.5 | $ 218.8 | $ 2,010 |
AMPLIFIER | $ 252.0 | $ 113.0 | $ 105.0 | $ 995 |
DIODE | $ 441.0 | $ 565.0 | $ 103.8 | $ 1,629 |
Total | $ 2,300 | $ 5,255 | $ 1,021 | $ 13,681 |
...
...