Page tree

I - Cost of Sales: Specific points

1. Example of the calculation of non-proportional production costs for a multi-products workshop

1.1. Assumptions

At the end of 2004, a production line shows an average net OEE of 81%.

It is used to produce the 5 following products with the following maximum daily capacities (MDC) and sales breakdown in 2004:

 

MDC

Sales breakdown in 2004

MAB

160 T

60%

DAP

220 T

14%

DSP

140 T

14%

TSP

140 T

7%

MKP

130 T

5%

Total production in the workshop during the year was 33,700T.

The non-proportional costs of the workshop amounted to:

 

kEUR

Labor

16.908

Maintenance

3.029

Other

2.928

TOTAL

22.865

For simplification purposes it is assumed in this example that:

  • The direct labor costs are proportional to the activity,
  • Every product uses as much direct labor as the others,
  • Maintenance costs are allocated to:
 

kEUR

Costs varying with activity

2.000

Costs not varying with activity

1.029

  • Other costs are allocated to:
 

kEUR

Costs varying with activity

2.000

Costs not varying with activity

1.029

Non-proportional costs will be allocated to each product on the basis of the usage of the workshop.

1.2. Calculation of the standardized production of a multi-products workshop

The maximum daily capacity of each product considers that only this product uses the workshop. 

However, in order to calculate the workshop’s standardized production, it is necessary to weight the standardized production of each product by its sales.

Product

Maximum daily capacity

Net OEE

Standardized daily production

Saturation

Product mix

Standardized production

(a)

(b)

(c)=(a)*(b)

(d)=(c)* 365

(e)

(f)=(d)*(e)

MAP 

160

81%

129.6

47,304

60%

28,382

DAP 

220

81%

178.2

65,043

14%

9,106

DSP

140

81%

113.4

41,391

14%

5,795

TSP 

140

81%

113.4

41,391

7%

2,897

MKP

130

81%

105.3

38,435

5%

1,922

Total

 

 

 

 

100%

48,102

Thus, while this workshop produced 33,700 T, it could have produced 48,102 T had there not been for a lack of sales.

1.3. Simulation of non-proportional costs at standardized production

It requires the variable portion of the non-proportional costs to be increased so as to reflect what the costs would be if the workshop operated at standardized production.

Reminder: the actual production was 33,700 T and the standardized production 48,102 T. The ratio between the two (r) is thus 1.43.

Cost type 

Actual production cost

Non-proportional cost

Variable cost portion

Variable portion of standardized production

Standardized production cost

(a)

(b)

(c)

(d)=(c)*(r)

(e)=(b)+(d)

Direct labor

16,908

0

16,908

24,134

24,134

Maintenance

3,029

1,029

2

2,855

3,884

Other

2,928

2,628

300

428

3,056

Total

 

3,657

19,208

27,417

31,074

1.4. Calculation of non-proportional unit costs of each product

Amount of simulated non-proportional costs per day (m) of standardized production = 31,074 / 365 = 85.1 kEUR.

Product

Standardized daily production (T)

Semi- standard cost (EUR/T)

(see 1.2.)

(a)

(m)*(a)

MAP 

129.6

657

DAP 

178.2

478

DSP

113.4

751

TSP 

113.4

751

MKP

105.3

808