Profit model

Profit model

The Profit model is the linear, deterministic algebraic model used implicitly by most cost accountants. Starting with, profit equals sales minus costs, it provides a structure for modeling cost elements such as materials, losses, multi-products, learning, depreciation etc. It provides a mutable conceptual base for spreadsheet modelers.

The basic model is: π = pq — [Fn + wq]

Background

The justification for modelling profit is given by Mattessich in 1961.

'To some operations analysts the mere translation of accounting models into mathematical :terminology, without a calculus for determining an optimum, might appear to be a rather :pedestrian task. We are convinced, however, that as long as accounting methods are acceptable :to the industry the mere change to a mathematical formulation will be advantageous for :several reasons: (1) it can be considered a prerequisite for applying electronic data :processing to certain accounting problems, (2) it articulates the structure of the accounting :models and illuminates accounting methods from a new point of view, revealing many facets so :far neglected or unobserved, (3) it enables a general and hence more scientific presentation :of many accounting methods, (4) it facilitates the exploration of new areas, thereby :accelerating the advancement of accounting, (5) it leads to more sophisticated methods and :might help to lay the foundations for close cooperation of accounting with other areas of :management science.'

Most of the definitions in cost accounting are in an unclear narrative form, not readily associated with other definitions of accounting calculations. For example, preparing a comparison of fixed cost variances in stock under different stock valuation methods can be confusing. Another example is modelling labour variances with learning curve corrections and stock level changes. With the absence of a basic profit model in an algebraic form, confident development of such models is difficult.

The development of spreadsheets has lead to a decentralisation of financial modelling. This has often resulted in model builders lacking training in model construction. Before any professional model is built it is usually considered wise to start by developing a mathematical model for analysis. The profit model provides a general framework plus some specific examples of how such an a priori profit model might be constructed.

The presentation of a profit model in an algebraic form is not new. Mattessich's model (1), while large, does not include many costing techniques such as learning curves and different stock valuation methods. Also, it was not presented in a form that most accountants were willing or able to read. This paper presents a more extended model analysing profit but it does not, unlike Mattessich, extend to the balance sheet model. Its form, of starting with the basic definition of profit and becoming more elaborate, may make it more accessible to accountants.

Most cost accounting textbooks explain basic Cost Volume Profit modeling in an algebraic form, but then revert to an 'illustrative' approach. This 'illustrative' approach uses examples or narrative to explain management accounting procedures. This format, though useful when communicating with humans, can be difficult to translate into an algebraic form, suitable for computer model building. Mepham extended the algebraic, or deductive, approach to cost accounting to cover many more techniques. He develops his model to integrate with the optimizing models in operations research. The profit model comes out of Mephams work, extending it but only in a descriptive, linear form.

Model basics

Using:

• Sales revenue = p * q = price x quantity sold
• Opening stock = go * wo = opening stock quantity * unit cost
• Cost of stock = g1 * w1 — closing stock quantity * unit cost
• Cost of production = w * x = unit production cost * quantity made
• Cost of sales = w * q = unit cost * quantity sold
• Administration, selling, engineers, personnel etc. = Fn = Fixed post manufacturing overheads
• Profit = π

Thus the profit can be calculated from:

π = pq — [Fn + wq]............ (equation 1)

Notice that v (average unit production cost) includes the fixed and variable costs.

The square brackets contain the cost of goods sold, that is 'q' is present.

If the stock adjustment and cost of goods made (x) is to be used, then the model will look like

π = pq-[Fn + w x + gowo – g1w1].......... (equation 2)

Whilst this basic model could be simplified it will be left in the traditional form profit equals sales less costs.

Presenting the profit calculation in this form immediately demands that some of the costs be more carefully defined.

Production costs

The first step in elaborating the model will be to further analyse the production costs (w x), using:

w = (Fm + v x)/x ……… (equation 3)

where

• Fm = manufacturing fixed costs;
• v = variable costs per unit;
• x = production quantity.

The introduction of this definition of ‘w’ allows for consideration of the behaviour of costs for different levels of production. A linear cost curve is assumed here, divided between the constant (F) and its slope (v).

If the modeller has access to the details of non-linear cost curves then 'w' will need to be defined by the appropriate function.

Replacing w * x in (equation 2) and making F = Fn+Fm

π = p q - [F + v x + g0 w - g1 w] ………(equation 4)

The finished goods stock unit cost will be discussed later.

Variable cost elements

Moving on to other extensions of the basic model, the cost elements such as direct materials, direct labour and variable overheads can be included. If a non-linear function is available and thought useful such functions can be substituted for the functions used here.

The material cost of sales = m * µ * q, where

m is the amount of material in one unit of finished goods.

µ is the cost per unit of the raw material.

The labour cost of sales = l * λ *q, where

• l is the amount of labour hours required to make one unit of finished goods
• λ is the labour cost (rate) per hour.

The variable cost of sales = n q where ‘n’ is the variable overhead cost per unit.

This is not here subdivided between quantity per finished goods units and cost per unit.

Thus the variable cost v * q can now be elaborated into:

π = pq - [F+(mµ q + l λq + nq)] …………..(equation 5)

If the production quantity is required the finished goods stock will need to be added.

In a simple case two materials can be accommodated in the model by simply adding another m * µ. In more realistic situations a matrix and a vector will be necessary (see later).

If material cost of purchases is to be used rather than material cost of production it will be necessary to adjust for material stocks. That is,

m * µ * x = µd0 + µb - µd1………… (equation 6)

where

• d = material stock quantity,
• 0 = opening, 1 = closing,
• b = quantity of material purchased.

Depreciation

All depreciation rules can be stated as equations representing their curve over time. The reducing balance method provides one of the more interesting examples.

Using c = cost, t = time, L = life, s = scrap value, Fd = time based depreciation:

Depr/yr = Fd = c (s/c)(t-L)/L * [L(s/c)1/L] …………… (equation 7)

This equation is better known as the rule: Depreciation per year = Last year's written down value multiplied by a constant %

The limits are 0 < t < L, and the scrap value has to be greater than zero. (For zero use 0.1).

Remembering that time-based depreciation is a fixed cost and usage-based depreciation can be a variable cost, depreciation can easily be added into the model (equation 5).

Thus, the profit model becomes:

π = pq - [F + Fd + (mµ + lλ + n + nd)q].......... (equation 8)

where, nd = usage (as q) based depreciation and π = annual profit.

Stock valuation

In the above, the value of the unit finished goods cost ‘w' was left undefined. There are numerous alternatives to how stock (w) is valued but only two will be compared here.

The marginal versus absorption costing debate, includes the question of the valuation of stock (w).

Should w = v or as (3) w = (Fm + v x)/x.

(i) Under marginal costing: w = v. Inserting in (4),

π = pq- [F + v x + g0w0 - g1 w1]

Becomes

π = pq- [F + v x + g0w0 - g1 v]

This can be simplified by taking v out and noting, opening stock quantity + production - closing stock quantity = sales quantity (q) so,

π = p q - [F + v q]………….. (equation 9)

Note, v q = variable cost of goods sold.

(ii) Using full (absorption) costing Using (equation 3), where xp = planned production, x1 = period production w = (Fm + v xp)/xp = Fm/xp + v. This can be shown to result in:

π = p q - [Fn + Fm + v q + Fm/xp * (q-x1)]………..(equation 10)

Note the strange presence of 'x' in the model. Notice also that the absorption model (equation 10) is the same as the marginal costing model (equation 9) except for the end part:

F/xp * (q-x1)

This part represents the fixed costs in stock. This is better seen by remem¬bering q — x= go—g1 so it could be written

F/xp • (g0—g1)

The model form with 'q' and 'x' in place of' g0 and g1 allows profits to be calculated when only the sales and production figures are known.

A spreadsheet could be prepared for a company with increasing then decreasing levels of sales and constant production. It could have another column showing profit under increasing sales and constant production. Thus the effects of carrying fixed costs in stock can be simulated. Such modelling thus provides a very useful tool in the marginal versus full costing debate.

Modelling for losses

more here soon

See also

• Cost accounting
• Income statement
• Management accounting