Budgeting, Costing & Estimating
Budgeting, Costing & Estimating
Budgeting, Costing & Estimating
Methods of Costing
Having defined and discussed some of the more commonly used costing and accountancy terms, we are now in a position to investigate the major types of costing systems used in manufacturing industry. When a company is deciding the prices it is going to charge for its products, it has to have a basis on which to compute these. There are three essential requirements for such a system: it must ensure that all costs are recovered; it must include the required element of profit; and it must be competitive. Whatever system is used it should reflect how easy or difficult the product is to make and take account of any extra requirements like secondary operations (e.g., hot foil stamping/annealing) or special packaging and so on. There are several different methods of costing and each company will have its own preferences. The actual method used is not as important as whether the chosen system works. The simpler the system is, the easier it will be to understand and implement. However, there are four main costing systems that we will now examine in detail: Standard costing Absorption costing Marginal costing Machine hourly costing. 33
It gives a stable platform for taking major management decisions like: - - product pricing for new or existing lines; and production capacity assessment.
It provides a standardised system for developing future growth plans. For new products, the initial standard cost will have to be based on previous experience with other similar products and subsequently developed and refined as more accurate costs become known. It is essential that each company has a clearly defined meaning for its standard costing system and ensures that it is completely understood and implemented properly. The following guidelines would be typical of a manufacturing business based on allowable expenditure for: direct material costs; direct labour costs; and 34
Methods of Costing production overhead costs (including depreciation allowances). Additionally it must be based on manufacturing at a standard level of production and achieve the following: the required quality level; the required rate of production; the necessary functional performance; and the designated level of efficiency (not an optimum goal). Example. This example illustrates a standard costing analysis for a typical product. Table 3.1 gives the ABC standard costing for an industrial pump per unit. From this table, the standard costing for this item is 1016p. If these products were produced in high quantities, small variations in any of the individual costs can affect the profitability of the project quite significantly. This is why it is so important to ensure that all individual cost components accurately reflect realistic performance levels and not targets. Standard costings based on overoptimistic targets frequently lead to reduced profitability. This effect will be amplified in high-quantity production.
36 Source O/head cost per unit (p) 80 62 15 45 20 25 18 12 215 35 139 105 597 62 53 80 38 97 270 167 1,016 50 87 112 Total cost per unit (p) ABC ABC Ext ABC ABC Ext ABC Ext ABC ABC 301.5 12 280 11 1 27 185 1 Nil 55 Nil 2 85 Nil 17 1 12 8
Part
Pump body
Pump lid
Seal
Lever arm
Float
Counter weight
Table 3.1 Standard costing example Standard Quantity Material Labour unit time per unit cost per cost per (s) unit (p) unit (p) 20 1 20 12 15.5 1 16 9 Nil 2 35 Nil 18 1 12 5 35 1 18 15 Nil 1 55 Nil
Switch housing
Switch
Assembly
Packaging
Totals
Notes: 1. Entries listed ext are bought out items from external suppliers and hence have no
labour content. However, they attract an overhead charge to cover purchasing and processing costs, etc. 2. The following activities have been included in the costing: design drawings; inspection and quality control; an allowance for wastage and rejects; amortised tool costs where applicable; plant and equipment used; purchasing costs; storage costs. 3. Labour costs are based on standard times established through work study analysis. 4. Overheads used are those allocated per cost centre. (Note that these could also be based on a standard overall (global) cost allocation.)
Methods of Costing 4. Allocate all the indirect costs to individual service departments. 5. Re-allocate the costs from production support services to production departments. 6. Establish an accurate overhead rate. 7. Absorb all direct and indirect overhead costs into each product.
37
This relationship can now be used to determine individual product costings (Table3.3). In this case, there is a relationship between direct material costs and the manufacturing overhead cost. However, any other cost may be used as a base for a similar relationship like the labour or total costs. If a global relationship like this can be established, it clearly makes for a simpler method. If such a relationship cannot be established then each product would include its own individual overhead allocation as previously explained. Table 3.3 shows the basic absorption of manufacturing overhead costs. This shows the product costing for manufacturing overheads but there are other overheads that have to be added to these. Examples are selling and distribution costs which may be a mixture of direct and indirect costs and advertising campaigns for specific products or global advertising. These non-specific costs are usually absorbed in one of the following ways: as a percentage of the selling price; as a rate per unit; and as a percentage of the manufacturing costs.
Table 3.3 Basic absorption costing for three typical products Category Product A () Product B () Product C () Materials 25 35 15 Labour 20 38 12 Expenses 15 12 5 Total cost 60 85 32 Works overhead 20 (25 80%) 28 (35 80%) 12 (15 80%) Total works cost 80 113 44
38
Methods of Costing
Table 3.4 Absorption of selling and distribution costs Sales Local dealer National Online sales force (%) (%) distributor (%) (%) List price 100 100 100 100 Discount 12 40 45 30 Total sales revenue 88 60 55 75 Sales and distribution 40 12 7 27 costs Production cost + profit 48 48 48 48
39
Table 3.5 Absorption of selling and distribution costs on rate per unit basis Category Product A Product B Product C Fixed costs 10,000 20,000 50,000 Sales volume 15,000 40,000 100,000 Fixed cost per unit 0.67 0.50 0.50 Variable costs per unit Nil Packing costs 0.35 0.30 0.40 Delivery costs 0.25 0.30 0.20 Commissions 0.30 0.30 0.35 Sales and distribution cost per unit 1.57 1.40 1.45
Table 3.6 Absorption by adding percentage of the manufacturing cost Standard cost from Table 3.1 10.16 Distribution costs 3.50 Administration and selling costs at 12% 12.19 Total 12.54
40
Methods of Costing
Table 3.7 Cost analysis for 160,000 units Category Total () Fixed costs () Variable costs () Sales (160,000 units) 200,000 Costs Direct materials 40,000 Nil 40,000 Direct labour 35,000 19,000 16,000 Production overheads 20,000 20,000 Nil Sales and marketing 30,500 22,000 8,500 Development 20,000 20,000 Nil Administration 15,500 15,500 Nil Distribution 12,000 9,000 3,000 Total costs 173,000 105,500 67,500 Net prot 27,000
41
The results from this analysis reveal an important point. That is, if more than 160,000 products are sold, the profit will increase as the fixed costs cannot change. Hence for each additional product sold, the profit on a marginal basis is equal to the contribution in this case 0.83. These results can also be demonstrated on a graph that gives a convenient method for viewing the effect of varying different parameters (Figure 3.1). This clearly demonstrates how increasing output, and hence sales, increases the profit. It also shows the break-even point, which is simply the point at which the number of items sold is sufficient to make the sales revenue equal to the total costs. In this case this figure is around 127,000 items sold which corresponds to 159,000 of sales. If more items than this are sold, a profit will result. If less than this number is sold, a loss will result where the costs exceed the sales revenue. Figure 3.2 shows how the basic graph is constructed. 1. Establish a table similar to Table 3.8 based on your figures. 2. Draw the axes for the sales/costs and number of item sold. 3. Draw a line from point A horizontally across the graph representing the budgeted sales in this case 200,000. 4. Draw a line vertically upwards to represent the number of items sold in this case 160,000. 5. These two lines will intersect at point C. 6. Draw a line from the origin through point C and continue it a little further. 42
Methods of Costing
7. Draw another line horizontally from point B at a distance up the sales/costs axis representing the total costs (variable + fixed costs) in this case 173,000. Where this line intersects the vertical line already drawn we obtain point D. 8. Now draw a line from point F through point D and extend it a little further. 9. The break-even point is the intersection of these two lines at E. The figures obtained from the graph give a reasonable estimate but, of course, will depend upon the accuracy with which the graph has been drawn and interpreted. For 43
Figure 3.2 Basic construction of break even graph for data in Table 38
those who prefer a more accurate graphical method, a Microsoft Excel spreadsheet may be used (Figure 3.3). A better visual result is obtained by altering the row and column sizes to suit the figure involved. An alternative algebraic approach gives an accurate result and can be put into program form in a computer for added convenience. Using basic algebra, the break-even point can be established by the following equation where all figures have been taken from Table 3.8: 44
Methods of Costing
Sales/Costs () A 200,000 190,000 180,000 170,000 160,000 150,000 140,000 130,000 120,000 110,000 100,000 90,000 80,000 70,000 60,000 50,000 40,000 30,000 20,000 10,000 0 10 20 30 40 50 60 70 80 90 100 110 120 130 140 150 160 170 180 Fixed costs F Break even point E Variable costs D B Profit Sales C
SB V B = +F N N
(3.1)
where S = sales value, V = variable costs, F = fixed costs, N = number of items sold and B = number of items required to be sold to break even. We can simplify and transpose Equation (3.1) to give
B=
NF S V
(3.2) 45
Budgeting, Costing and Estimating for the Injection Moulding Industry If we now substitute the values from Table 3.8 in Equation (3.2), we get
which corresponds to 127,396 1.25 = 159,245 of sales. Looking again at the graph in Figure 3.1 we can also see that we can determine the profit as the sales or the number of items sold increases. For example, if 200,000 parts were sold we could expect the profit to increase to approximately 60,000. We can similarly arrive at an equation to determine this algebraically:
P=
S Nv V Nv F N N
(3.3)
where P = profit and Nv = different number of items sold, chosen for the analysis. On simplification this gives:
P=
(S V ) N v F N
(3.4)
Note that Equations (3.2) and (3.4) are powerful results allowing other variables to be established once the break-even condition is known, for example establishing what the variable cost will be for a given level of profit. Another useful result is writing:
C = S V
where C is the contribution since C = sales minus variable costs. Hence, Equation (3.4) may be written as: 46
Methods of Costing
P=
C Nv F N
(3.5)
Budgeting, Costing and Estimating for the Injection Moulding Industry This is where analysis of past performance is extremely valuable. From such information we should know: the invoiced sales; the total cost of all moulding materials used; the energy costs; all other direct and indirect costs. In fact by analysing the figures from several previous years, a trend can be established without too much difficulty. For example, previous labour costs can be projected forward, as can energy and several other costs. There may well be a variation from year to year but these can be averaged out. Example. To illustrate this we will re-introduce our fictitious injection moulding company, ABC Products Ltd (ABC). The board of ABC has decided the performance for the forthcoming year: Invoiced sales: 10,000,000. Profit required: 15%. This is based on previous years figures given in Table 3.9, in which the material usage factor is defined as
Table 3.9 Analysis of previous years gures Year 1 Year 2 Invoiced sales 6,000,000 7,000,000 Materials used 1,740,000 2,170,000 Material usage factor 29% 31%
48
Methods of Costing invoiced sales: 10,000,000 less profit (15%): 1,500,000 = 8,500,000 less materials used (30%): 3,000,000 = 5,500,000.
This means that all remaining costs will have to fall within 5,500,000 The accountant and production manager have established to support this level of sales that all remaining costs (except material costs) amount to 5,000,000. This is less than the projected surplus of 5,500,000 and leaves a factor of safety of 500,000 a 10% margin on costs in case the actual costs are higher than expected. ABC works a 125-hour week, 50-week year, giving a utilisation of 6,250 hours per year a UF of 74.5%. From similar analyses of previous years performance it is known the efficiency factor is 80%. With this information, we can now establish the average MHR for one (virtual) machine. If we can imagine for a moment that ABC does have only one machine, all the costs of all work processed on it would be charged out in two basic parts: 1. The cost for the material. 2. A charge to cover all other costs. The material cost would depend on the size of the parts, the runner system and the price of the material the costs varying from job to job. Hence, these costs would have to be charged separately. The machine charge would have to cover all the remaining costs. In order to do this we have to predict how many hours per year the machine is going to be actually producing parts and divide this figure into these costs. This gives us a machine rate per hour. Dividing this by 3,600 would give the machine cost per second. If we then estimate the cycle of a job, we can determine how much we should charge per shot by multiplying the cycle by the machine cost per second. This gives a machine cost for the shot. Adding this cost to the material cost for the shot gives us the total cost for producing one shot. Dividing this figure by the number of impressions in the shot will give the cost per part. To illustrate this procedure we will establish the MHR for one machine for the company ABC as follows: Total number of hours worked = 6,250
49
Budgeting, Costing and Estimating for the Injection Moulding Industry Productive hours worked = 5,000 (6,250 80%) per year Total costs to be recovered = 5,500,000 Therefore average MHR = 5,500,000/5,000 = 1,100.
Clearly it would be an understatement to say achieving a turnover of 10,000,000 with one machine with an MHR of 1,100 would be difficult! We will now assume that ABC has 14 machines ranging from 25 tonne lock to 350 tonne lock and that its policy is to depreciate all machines over five years on a straightline basis. The details of these machines are given in Table 3.10. All that remains now is to apportion the MHR of 1,100 for this single machine over all the machines the company has. There are several methods used to achieve this but we will concentrate on four: capital cost method; machine lock method; book value method; and kVA (kilovolt ampere see appendix) rating method.
Table 3.10 ABC machine details M/C No. Age Original Total cost Depreciation Book Total lock (years) cost () each/year () value book each () () value () 25 2 2 25,000 50,000 5,000 15,000 30,000 50 1 1 35,000 35,000 7,000 28,000 28,000 50 2 1 40,000 80,000 8,000 32,000 64,000 100 3 3 70,000 210,000 14,000 28,000 84,000 250 1 4 150,000 150,000 30,000 30,000 30,000 250 2 1 210,000 420,000 42,000 168,000 336,000 350 2 2 375,000 750,000 75,000 225,000 450,000 350 1 4 150,000 150,000 30,000 30,000 30,000 Totals 14 1,845,000 1,052,000
50
Methods of Costing
Original capital cost of machine 1,100 Total capital cost of all machines
MHR
MHR
25 1,100 2,300 = 12 =
Book value of each machine 1,100 Total book value of all machines
MHR
Table 3.11 gives the capital cost, machine lock and book value MHRs for all machines.
No. of M/C
Lock
25
50
50
100
250
250
350
350
14
1425
Table 3.11 MHRs according to machine lock, capital cost and book value methods Total Original Total Book Total DepreTotal Capital Machine Book lock cost per original value book ciation deprecost lock value M/C cost per per M/C value per per M/C ciation MHR MHR MHR M/C M/C per M/C 50 25,000 50,000 15,000 30,000 5,000 10,000 15 12 16 50 35,000 35,000 28,000 28,000 7,000 7,000 21 24 29 100 40,000 80,000 32,000 64,000 8,000 16,000 24 24 33 300 70,000 210,000 28,000 84,000 14,000 42,000 42 48 29 250 150,000 150,000 30,000 30,000 30,000 30,000 89 120 31 500 210,000 420,000 168,000 336,000 42,000 84,000 125 120 176 700 375,000 750,000 225,000 450,000 75,000 150,000 224 167 235 350 150,000 150,000 30,000 30,000 30,000 30,000 89 167 31 2300 1,845,000 1,052,000 369,000
Methods of Costing
53
Budgeting, Costing and Estimating for the Injection Moulding Industry Another compelling factor is that electricity suppliers normally base their charges on the maximum kVA requirement for each factory. This is because they have to ensure they can supply the maximum amount of power at all times in case it is needed. A further case for the kVA method is that moulding machine manufacturers are now marketing machines with all-electric drives, thus eliminating the traditional hydraulic motor driven by a pump. This is designed to increase the operating efficiency and therefore reduce the power requirements substantially. However, the cost of these machines is up to 50% more than the cost of the equivalent hydraulic machines. Hence it may take several years before the savings in power costs offset the extra capital expenditure. We re-list in Table 3.12 all the ABC machines with their kW ratings to establish the kVA MHR. The difference between kVA and kW depends on the power factor of the installed electrical supply and is discussed in the appendix in further detail.
Table 3.12 kVA MHR method Locking force (tonnes) Rating (kW) 25 8 25 10 50 15 50 15 50 16 100 18 100 19 100 19 250 50 250 53 250 56 350 63 350 65 350 67 Total 474
MHR () 18.57 23.21 34.81 34.81 37.13 41.77 44.09 44.09 116.03 123.00 130.00 146.20 150.84 155.48
54
Methods of Costing The same procedure is used to establish the MHRs for each machine as in the previous examples. Taking the first machine in Table 3.12, we have:
kVA MHR =
kVA rating of each machine 8 1,100 = 1,100 = 18.57 Total kVA rating of all machines 474
It can be seen from this analysis that there are some significant differences between the machine lock MHRs listed in table 3.11 and those obtained using the kVA method shown in Table 3.12.
Methods of Costing book value of the machines; and machine kVA rating. As we have mentioned, the actual method selected to use would depend upon the nature of the work a company undertakes.
Budgeting, Costing and Estimating for the Injection Moulding Industry This is often applied as a percentage on cost on top of the MHR. For example, if the normal MHR for a difficult job on the best machine was 100, then for this situation an on cost of 25% may be warranted, giving a new MHR of 125. Each case is considered on its merits and charged out accordingly.
3.6 Discussion
In practice each company will adopt its own customised costing procedure which reflects the nature of the type of work it processes. This can take the form of completely different MHR systems for different categories of work being run on the same machines: for example, one MHR for straightforward standard products and another for general trade work. Companies that specialise in a particular field may apply a wide range of modified MHRs to cover the varying job requirements within that field. If, for example, a company does a large amount of assembly work as well as moulding, the running costs may well be split into two cost groups: one for the assembly and one for the moulding. Each of these groups may have separate hourly charging systems for each process. In these cases the same approach may be taken by dividing the appropriate costs for each activity by the expected number of productive hours.
3.6.2 Observation
Although, the examples presented above are based on injection moulding, the same approach may be used with blow moulding (based on machine size) and with extrusion processes (based on machine size or plasticising capacity). 58
Methods of Costing
3.8 Observation
MHR figures are rarely checked frequently enough to guarantee their accuracy. If each job makes a profit there should be an overall profit at the end of the year.
3.9 Summary
3.9.1 Standard Costing
A widely used method for manufacturing industries. Must be based on realistic, achievable performance. Must not be based on targets or goals. Can cover a wide range of labour-based and machine-based production. Often used for a combination of both. Provides a standard to compare company performance and competitiveness. 59
Non-specific overhead or other costs may be added as follows: - - - as a percentage of the selling price as a rate per unit as a percentage of the manufacturing costs.
Methods of Costing number of productive hours worked in the financial year. This is further refined depending on the requirements of each company. The most commonly used MHR systems are based on: - - - - capital costs of the machines machine locking groups machine book values kVA machine power ratings.
MHR systems may vary or be combined depending on the nature of the business. Whatever MHR system is used, it must ensure all costs (other than material costs) are recovered. The MHR must be checked frequently to check its accuracy. Figure 3.4 shows a summary of the different MHR methods. All the above analyses are based on charging out the material cost as a separate cost to the MHR due to the widely varying types and costs number of materials. There is, however, an important exception to charging the material cost separately. If a company is using a single material only for all its products then it is easier to include this in the MHR. For example, a company producing, say, disposable tableware comprising cups, saucers, cutlery, beakers and so on all in high-impact polystyrene, the material cost would be included in the MHR.
Budgeting, Costing and Estimating for the Injection Moulding Industry printing; electrical subassembly; and final assembly.
In this case, the costing system may look like that shown in Figure 3.5. If a company were making several standard products all of which use injection moulded parts made from the same material, the costing model may change. In such cases, the company will try to minimise the number of machine locking groups it has for maximum versatility and economy to ensure:
62
Methods of Costing interchangeability of mould tools between several machines in the same locking group; purchasing advantages in buying several machines of the same locking group at the same time; and standardisation of support equipment on identical moulding machines. For example, this operation may be based on just three locking groups, say 10 of each of 50, 150 and 250 tonne machines. With large production volumes, the material would be stored in silos and delivered automatically to the moulding machines thus eliminating contamination and labour costs.
63
Budgeting, Costing and Estimating for the Injection Moulding Industry Such an operation is a prime candidate for the standard costing model since: only one moulding material is being used for the moulding operations; the moulding machine costs should be well known as relatively few mould tools are being used; and all the other operating costs and material costs will be accurately known through continual reassessment. Frequently, companies will develop their own custom costing methods that consist of a combination of the methods previously discussed. Costing systems will naturally evolve to suit the type of business and the markets each company is serving. As market trends change, costing systems may have to change to stay in tune with that particular market.
64