Using the Cigar Box CB 1 Profit calculations

Using the Cigar Box® CB 1: Profit calculations made easy by Olivier van Lieshout Global Facts www. globalfacts. nl 1

Contents 1. 2. The five profit parameters Using CB 1 2

Part 1 The five profit parameters Learning objectives: 1. There are only five basic parameters. 2. But these have many components. 3. Know the difference between variable and fixed costs. 3

Profit parameters There are ONLY FIVE parameters l P Price (per unit) l VC Variable cost (per unit) l q Quantity (in units period) l FC Fixed cost (per period) l T Tax % of profit (per period) Note: q, FC, T must always refer to the same period. But… 4

Profit parameters: Price There are ONLY FIVE parameters, but… with many components! Price 5

Profit parameters: VC & FC There are ONLY FIVE parameters but with many components! VC FC Where to obtain correct data ? 6

Profit parameters: quantity There are ONLY FIVE parameters but with many components! l q = actual quantity sold period l q. CAP = quantity at full capacity utilization quantity/hour * hours/day * days/year (harvest season) 3 ton/hour * 22 hours/day * 90 days/yr = 5940 ton/year l q. BE 0 = break-even quantity, where profit = 7

Recognize costs - exercise Are the following Variable or Fixed costs? 1. 2. 3. 4. 5. 6. 7. 8. Ingredients Road tax Labels Bank charges Machine repair Raw material transport Depreciation Social tax 9. 10. 11. 12. 13. 14. 15. Diesel for the boiler Electricity in the factory Electricity in the office Casual labor Management salary Detergents and gloves Interest on loans 8

Profit parameters (repetition) There are ONLY FIVE parameters l P Price (per unit) l VC Variable cost (per unit) l q Quantity (in units period) l FC Fixed cost (per period) l Tax % of profit (per period) Not more! 9

Part 2 Using CB 1 Learning objectives: to be able to 1. fill in the Cigar Box with five parameters; 2. analyze the results; 3. see the importance of capacity utilization. 10

P profit FC VC P-VC profit per unit q contribution Break-even Capacity Utilization 11

Sales price P l l l Sales Price = Amount per unit, INCO-term City. Tomato paste price = USD 1000 per ton, DDP Moscow. DDP = delivered, duties paid. Delivered to Moscow in this case. The import duties in Russia are 10% or USD 100 per ton. Transport and commission amount to USD 144 per ton. Hence the Price EXW = 1000 -144 = USD 756 per ton. 12

Variable cost VC Three types of variable cost: l VC 1, cost of everything which is consumed: raw material and ingredients. l VC 2, cost of processing raw material into the finished product: energy, steam, casual labor, detergents, diesel, gas. l VC 3, cost of primary (jar, cap, label) and secondary (carton box, shrink wrap, pallet) packing material. 13

Raw material & ingredients VC 1 l l l The price of the raw material, delivered to the factory = 71/ton. The processing ratio is the quantity of raw material needed for one unit of finished good. Here: 6 kg tomato for 1 kg of paste. Raw material cost = 71 * 6 = 429 The higher the losses, the higher the processing ratio, the more costly the good. Calculate the cost of all other ingredients in the recipe: 12 VC 1 = 429 + 12 = 441. 14

Processing cost VC 2 l l l l l Calculating VC 2 is not easy. Processing cost are calculated per hour. And divided by the production volume in units per hour. To arrive at the processing cost per unit. One must measure the use of steam, electricity, casual labor. Not just guess it! And measure the output per hour. Not just guess it! Get the correct data! After that, calculation is easy: 124 / 2 = 62 15

Packing cost VC 3 l Packing cost are calculated per sales unit: l l Other examples of sales units: l l l 24 bottles per carton = 24*(bottle + cap + label) + 1 box + 1 sticker; 10 sachets per bag = 10*sachet + 1 bag + 1 adhesive sticker Calculate the number of sales units per unit of calculation: l l 1 aseptic bag in 1 steel drum = 3. 2 + 18. 6 = 21. 8; unit of calculation is ton = 1000 kg 4. 4 drums of 225 kg per ton: 1000 / 225 = 4. 4 add the packing losses, say 2. 2%, multiply 4. 4 by 102. 2% = 4. 5 VC 3 = cost of packing * number of packs per unit = 21. 8 * 4. 5 = 99 16

Total variable cost VC l l VC = VC 1 + VC 2 + VC 3 Finished good losses l l Warehouse losses, theft, pilferage, etc…. If there are 2% losses, enter 2% in FG losses % box. VC = (VC 1 + VC 2 + VC 3) * (1+ FG losses %) VC = (441 + 62 + 99) * 1. 02 = 614 17

Margin P–VC l l Margin, or gross margin, is expressed per unit: Margin = P(EXW) – VC = 756 – 614 = 142 18

Margin % (P–VC) / P * 100% l l l Margin % = Margin / P(EXW) * 100% = 142 / 756 = 19% Margin % helps us to evaluate, if a margin is risky or not. Usual risk levels in food processing and manufacturing are: 19

Contribution (P–VC) * q l l The volume, or quantity sold is expressed in units period. In this example, 3600 ton of tomato based are sold. Contribution is expressed period: Contribution = Margin per unit * quantity period = = 142 * 3600 = 511, 623 20

Fixed costs Three types of fixed cost: l FC 1, cost of investments: depreciation. l FC 2, cost of debts: interest. l FC 3, cost of all overheads. l Salaries, social taxes, pensions, etc. . l Repairs, maintenance l Office & transport cost l Marketing l Etc…. . 21

Depreciation FC 1 l l l Use a realistic value for the productive assets. For a tomato processing company this is about 1. 8 million. Use a realistic depreciation rate. Here: the replacement period of the factory is 12. 8 years. The depreciation = 1 / 12. 8 * 100% = 7. 8% FC 1 = Asset value * depreciation % = 1, 800, 000 * 7. 8% = 140, 000 22

Interest FC 2 l l l Use the real amount of the debts, with a minimum of 40% of the asset value. For this company this is about 720, 000 Use a realistic interest rate. Here: 18. 7% per year. FC 2 = Debt value * interest rate = 720, 000 * 18. 7% = 134, 400 23

Overhead FC 3 l Enter the number of full-time equivalent staff (FTE) l l l 10 workers, working 6 months per year = 10 * 6/12 = 5 FTE 10 workers, working 4 months per year = 10 * 4/12 = 3. 3 FTE Calculate their salaries, incl. all taxes and emoluments: 50, 000 Calculate one lump sum amount for all other overheads: 20, 000 FC 3 = salaries + all other overhead = 50, 000 + 20, 000 = 70, 000 24

Total fixed costs FC l l l FC = FC 1 + FC 2 + FC 3 FC = 140, 000 + 134, 400 + 70, 000 = 344, 400 The contribution of tomato paste must exceed these costs. In case more than 1 product is produced, FC must be shared. Calculate FC % attributed to product and enter in the box: 100% FC (attributed to product) = FC * FC % attributed to product 25

Profit Two methods l l l Cost accounting method: Profit = Contribution – Fixed costs Bookkeeping method: Profit = Total revenues – Total costs Result is the same! 26

Summary Cost price l Cost price = total cost per unit 27

Break-even l Break-even point is where the profit is zero. l Revenues – Cost = 0 or Contribution – Fixed cost = 0 Why calculating the break-even quantity? l When Price, VC and FC are known and q is unknown l How many drums can be sold per year? l BE volume (sales) = minimum volume needed to sell to make a profit. l BE volume (raw material) = minimum volume needed to process. l How much raw material do we need to buy? 28

Capacity l q = quantity sold = 3, 600 tons of paste per year l q. CAP = quantity produced at full capacity utilization quantity/hour * hours/day * days/year (harvest season) 2 ton/hour * 22 hours/day * 110 days/yr = 4, 840 ton/year l utilization = q / q. CAP * 100% = 3, 600 / 4, 840 = 74. 4% 29

Capacity utilization l How does capacity utilization affect the Cost Price? l l the higher the utilization %, the higher the q (sales). the higher the q, the lower the FC/q, VC does not change, hence the lower the cost price. How does capacity utilization affect the Profit? l l l the higher the capacity utilization, the more the units sold and the lower the cost price, thus the higher the profit per unit. Profit = profit per unit * units sold At 74% utilization: = 46. 5 * 3600 = 167, 400 At 91% utilization: = 63. 8 * 4400 (+22%) = 280, 920 (+67%) Conclusion: with 22% increase in sales volume, the profit increases by 67%!! 30

Let’s practice! Each person with own laptop. Sample Cigar Boxes can be downloaded from www. globalfacts. nl 31