Profit model
≈ 8 min read
Names in other languages
No names in other languages are held for this entry yet.
Article bodies are English and are not machine-translated. A name in another language is not a translation of the article.
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. This enables them to run deterministic simulations or 'what if' modelling to see the impact of price, cost or quantity changes on profitability.
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. This enables them to run deterministic simulations or 'what if' modelling to see the impact of price, cost or quantity changes on profitability.
Basic model
\pi = pq - (F_n+wq) \, where: is profit p is sales price F n is fixed costs w is variable costs per unit sold q is quantity sold For an expansion of the model see below. Sales revenue = pq = price × quantity sold Cost of sales = wq = unit cost × quantity sold Administration, selling, engineers, personnel etc. = Fn = fixed post-manufacturing overheads Profit = π Thus the profit can be calculated from: \pi = pq - (F_n + wq) \qquad\qquad (1) Notice that w (average unit production cost) includes the fixed and variable costs. The square brackets contain the cost of goods sold, wq not cost of good made wx where x = cost of good sold. To show cost of good sold, the opening and closing finished goods stocks need to be included The profit model would then be: Opening stock = g o w = opening stock quantity × unit cost Cost of stock = g 1 w = closing stock quantity × unit cost Cost of production = wx = unit production cost × quantity made: \pi = pq - [F_n + wx + g_0 w - g_1 w] \qquad\qquad (2) Presenting the profit calculation in this form immediately demands that some of the costs be more carefully defined. w = \frac{F_m + vx}{x} \qquad\qquad (3) where F m = manufacturing fixed costs; v = variable costs per unit; x = production quantity. The introduction of this separation 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 wx in (equation 2) and making F = F n + F m : \pi = pq - [F + vx + g0w - g1w] \qquad \qquad (4) 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 overhead cost of sales = nq 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, mx = md 0 + mb - md 1 ………… (equation 6) where d = material stock quantity, 0 = opening, 1 = closing, b = quantity of material purchased m = the amount of material in one unit of finished goods x = quantity used in production 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 d + (mμ + lλ + n + n d )q].......... (equation 8) where, nd = usage (as q) based depreciation and π = annual profit. Should w = v or as (3) w = (Fm + v x)/x. (i) Under marginal costing: w = v. Inserting in (4), π = pq- [F + v x + g 0 w 0 - g 1 w 1 ] Becomes π = pq- [F + v x + g 0 w 0 - g 1 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 - [F n + F m + v q + F m /x p * (q-x 1 )]………..(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/x p * (q-x 1 ) 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/x p • (g 0 —g 1 ) The model form with 'q' and 'x' in place of' g 0 and g 1 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. Fixed losses, (quantity) = δf, Variable losses (%) = δv, Material losses = mδ, Production losses = pδ The model, with all these losses together will look like, π = v q – [F + μ * mδf + {mμ(1 + mδv) + lλ+n) * (1+ pδ* (q +pδf)]........ (equation 11) Note that labour and variable overhead losses could also have been included. π = pq —(F +vq) becomes π = (pa *qa +pb *qb) - [F + va*qa + vb *qb] All fixed costs have been combined in F Therefore, for multiple products π = Σ(pq) - [F + Σ(vq)].... (equation 12) Where Σ = the sum of. Which can be drafted as a vector or matrix in a spreadsheet or π = Σpq - [F + Σ(Σmμ +Σlλ + Σn)q]..... (equation 13) π = p c *q c - [F c + (mμ c + lλ c + n c )q c ] The planned data model will be (using equation 8): π = p p *q p - [F p + (mμ p + lλ p + n p )q p ] The standard data model will be (using equation 8): π = p p *q c - [F p + (mμ p + lλ p + n p )q c ] Operating variances are obtained by subtracting the actual model from the standard model. l = r * q −b where r = average time. b = learning rate. q = quantity. Inserting into equation 8 π = pq - [F + (mμ + rq −b λ + n)q] This equation is best solved by trial and error, the Newton Raphson method or graphing. Like depreciation within the model, the adjustment for learning does provide a form of non-linear sub-modelling. The notation used below is of attaching a % sign to variables to indicate the change of that variable, for example, p% = 0.10 if the selling price is assumed to change by 10%, Let x = q and C = contribution Starting with the absolute form of the contribution model (equation (9) rearranged): π + F = C = (p — v)q. The increase in the contribution which results from an increase in p, v and/or q can be calculated thus: C(l + C%) = [p(l+p%)- v(l + v%)]q(l+q%) rearranging and using α = (p — v)/p, C% = ((l+q%)/α)[p%-(l - α)v%]+q%...... (equation 18) This model might look messy but it is very powerful. It makes very few demands on data, especially if some of the variables do not change. It is possible to develop most of the models presented above in this percentage change format.
Text derived from https://en.wikipedia.org/w/index.php?oldid=1365924988 under CC BY-SA 4.0; modifications have been made.