Solution for Classic Pen
Case Study: Classic Pen Company
1- Cost of production of the pens according to ABC method:
INDIRECT FINGE BENEFICT
INDIRECT LABOR
TOTAL indirect Labor
Indirect Labor
Computer System
Other Overhead
Total overhead
Quantity
Overhear Rate
8,000
20,000
28,000
Production Runs
Setup Time Administration Run Machines
14,000
11,200
2,800
8,000
2,000
14,000
22,000
11,200
4,800
14,000
150
526
4
10,000
146.67
21.29
1,200.00
1.40
Total
28,000
10,000
14,000
52,000
Overhead distribution among the cost Pool
Amount of overhead
22,000.00
11,200.00
4,800.00
14,000.00
52,000.00
100,000
Quantity
150
526
4
10,000
Rate
Amount of overhead
8,000
100,000
0.08
Quantity
100,000
Blue
Production Runs
Setup Time
Administration
Run Machines
Total Overhead by pen
Quantity of pen
Overhead by unit of pen
Black
0.50
0.20
0.08
0.38
1.16
Blue
7,333.33
4,258.56
1,200.00
7,000.00
19,791.89
50,000
0.40
Black
7,333.33
1,064.64
1,200.00
5,600.00
15,197.97
40,000
0.38
Red
5,573.33
4,854.75
1,200.00
1,260.00
12,888.09
9,000
1.43
Purple
1,760.00
1,022.05
1,200.00
140.00
4,122.05
1,000
4.12
Blue
4,000.00
50,000
0.08
Black
3,200.00
40,000
0.08
Red
720.00
9,000
0.08
Purple
80.00
1,000
0.08
Direct Fringe Benefit distribution among pen
Direct Fringe Benefit
Quantity of pen
Direct Fringe Benefit by pen
Cost of Production
Material Cost
Direct Labor
Direct Fringe Benefit
Overhead Cost
Cost of Production
0.50
0.20
0.08
0.40
1.18
Red
0.52
0.20
0.08
1.43
2.23
Purple
0.55
0.20
0.08
4.12
4.95
2- Actions that will be taken by Classic Pen Company
As shown by the table below, the traditional cost shows the company is realizing benefit for all its pens.
Blue
Material Cost
Direct Labor
Overhead Cost
Cost of Production
Quantity of pen
Cost of Production according to the Traditionnal
Actual Unit Selling Price
1- Cost of production of the pens according to ABC method:
INDIRECT FINGE BENEFICT
INDIRECT LABOR
TOTAL indirect Labor
Indirect Labor
Computer System
Other Overhead
Total overhead
Quantity
Overhear Rate
8,000
20,000
28,000
Production Runs
Setup Time Administration Run Machines
14,000
11,200
2,800
8,000
2,000
14,000
22,000
11,200
4,800
14,000
150
526
4
10,000
146.67
21.29
1,200.00
1.40
Total
28,000
10,000
14,000
52,000
Overhead distribution among the cost Pool
Amount of overhead
22,000.00
11,200.00
4,800.00
14,000.00
52,000.00
100,000
Quantity
150
526
4
10,000
Rate
Amount of overhead
8,000
100,000
0.08
Quantity
100,000
Blue
Production Runs
Setup Time
Administration
Run Machines
Total Overhead by pen
Quantity of pen
Overhead by unit of pen
Black
0.50
0.20
0.08
0.38
1.16
Blue
7,333.33
4,258.56
1,200.00
7,000.00
19,791.89
50,000
0.40
Black
7,333.33
1,064.64
1,200.00
5,600.00
15,197.97
40,000
0.38
Red
5,573.33
4,854.75
1,200.00
1,260.00
12,888.09
9,000
1.43
Purple
1,760.00
1,022.05
1,200.00
140.00
4,122.05
1,000
4.12
Blue
4,000.00
50,000
0.08
Black
3,200.00
40,000
0.08
Red
720.00
9,000
0.08
Purple
80.00
1,000
0.08
Direct Fringe Benefit distribution among pen
Direct Fringe Benefit
Quantity of pen
Direct Fringe Benefit by pen
Cost of Production
Material Cost
Direct Labor
Direct Fringe Benefit
Overhead Cost
Cost of Production
0.50
0.20
0.08
0.40
1.18
Red
0.52
0.20
0.08
1.43
2.23
Purple
0.55
0.20
0.08
4.12
4.95
2- Actions that will be taken by Classic Pen Company
As shown by the table below, the traditional cost shows the company is realizing benefit for all its pens.
Blue
Material Cost
Direct Labor
Overhead Cost
Cost of Production
Quantity of pen
Cost of Production according to the Traditionnal
Actual Unit Selling Price