Clevity Blog - Assessing Your Profit Risk Due to Volatility

Assessing Your Profit Risk Due to Volatility Written by Greg Olson on July 21, 2016 .

Oftentimes in business, we are forced to live with uncertainty.  Really, nothing is certain, but even moreso certain volatile costs like gasoline, produce and currency exchange rates.  For example, a quick look at the following price of regular gas (credit: GasBuddy.com) shows some pretty heavy fluctuations between \$1.70 and \$2.80 per gallon for 2015 and 2016 YTD.

While this causes mixed feelings at the pump, imagine the headache that major businesses face when an upward or downward trend can make the difference between a more or less profitable year.  Clearly, volatility is not something that can be reasonably dealt with on intuition alone.  As an executive, it is easy to say that gas will float below \$2.00 per gallon once again and profits will soar.  But what are the odds that \$2.00 will actually happen?

Most of us don’t enjoy math, but we all do love food, so I will attempt to explain volatility risk with pizza.

Imagine you are an executive at a large pizza chain.  Your best selling pizza (for simplicity purposes) is a medium cheese pizza.  Also for simplicity, your material costs to make the pizza consist of dough, cheese, and sauce.

Let’s assume that dough and cheese costs rarely fluctuate up or down.  In fact, dough and cheese costs remained at \$4.00 and \$2.00 respectively for all of 2015 and are expected to remain the same for all of 2016.

Pizza sauce, however, is as volatile as gasoline, and fluctuated between \$4.00 and \$5.00 per pizza in 2015, with a definite upward trend heading into 2016.  At a sales price of \$25 per pizza, this amounts to a total material profit of \$15 (60%) at the beginning of 2015 dropping to \$14 (56%) by the end of 2016 for a decrease of 4%.  At about 160,000 pizzas sold, this amounted to profits of almost \$100,000 less than expected.

Your colleagues are very optimistic that pizza sauce prices will level out to begin 2016, following the unprecedented increase of 2016.  Therefore, they are forecasting your material margin to remain at 56% for January 2016.  However, given the upward trend, this does not settle well with you and you want to assess the risk associated with this assumption.  What can you do?

One approach would be to perform a Monte Carlo simulation to determine the likelihood that your margins exceed a given percent based on the likely fluctuations in pizza sauce.  Simply put, we can run a simulation of hundreds or thousands of possible outcomes of margin percentage given the likely fluctuations in pizza sauce.

In 2015, we saw our pizza sauce costs increase monthly by an average of 2.6%, with a standard deviation of 0.05.  Assuming a normal distribution, we generated 1,000 random possible outcomes for pizza sauce increases (or decreases) in January 2016.  As you can see from the below distribution, there were in fact numerous outcomes where margin did, in fact, reach your colleagues’ estimate of 56.0%.  To be exact, 476 of the 1000 outcomes reached 56.0% or higher margin.

However, let’s look at this another way. In the below chart, we have rearranged the data to show the percent likelihood of each threshold.  In this view, we see that we only have a 48% chance of reaching our forecasted 56.0% margin.  However, we can say with 84% certainty that we will reach a 55.0% margin, and with 94% certainty that we will reach 54.5% margin.

Using this method, you are now armed with the ammunition you need to contest the 56.0% margin forecast.  As an executive, do you feel comfortable betting your company on 48% odds?  Or would you rather work with 90% or better odds while focusing on other pieces of your business that are more under your control?

The answer is different for all types and sizes businesses, but the key takeaway is that you should not move forward with decisions without understanding the risk.

Pingbacks are open.

1. ฝ้ากระผิวคล้ำหมอง on 03/01/2017 7:52 a.m. #

Clevity

2. ครีมรักษาฝ้า on 03/01/2017 9:40 p.m. #

Clevity

3. birthday wishes for sister on 03/03/2017 6:24 a.m. #

Clevity

4. Visit Us on 03/04/2017 6:39 p.m. #

Clevity

5. รับทำ seo on 03/04/2017 9:30 p.m. #

Clevity

6. 4rx pharmacy on 03/05/2017 5:01 a.m. #

Clevity

7. psychic reader online free on 03/05/2017 7:43 a.m. #

Clevity

8. phone psychic reading on 03/05/2017 8:13 a.m. #

Clevity

9. stripper barcelona on 03/07/2017 8:09 a.m. #

Clevity

10. Ben Davies Jersey on 03/09/2017 10 a.m. #

Clevity

11. mouse click the next article on 03/10/2017 2:30 p.m. #

Clevity

12. like this on 03/10/2017 3:42 p.m. #

Clevity

13. please click the up coming post on 03/10/2017 9:05 p.m. #

Clevity

14. additional resources on 03/12/2017 7:20 a.m. #

Clevity

15. marketing digital de performance on 03/18/2017 10:17 a.m. #

Clevity

16. encontrar mais informações on 03/19/2017 3:22 a.m. #

Clevity

17. whatattractswomenlpage.wallinside.com on 03/20/2017 2:17 a.m. #

Clevity

18. oceanside california postal code on 03/31/2017 6:51 p.m. #

Clevity

19. minicab harrow on 04/03/2017 8:14 p.m. #

Clevity

20. Landing page hosting on 04/05/2017 3:05 a.m. #

Clevity

21. make money online fast from home on 04/08/2017 2:16 p.m. #

Clevity

22. swiss.cx on 04/08/2017 9:03 p.m. #

Clevity

23. Thorsten on 04/10/2017 6:58 a.m. #

Clevity

24. http://duphotogallery.com/archives/567 on 04/15/2017 4:03 p.m. #

Clevity

Clevity

26. מסגריות בפתח תקווה on 04/15/2017 9:47 p.m. #

Clevity

27. free standing child gate on 04/16/2017 3:05 a.m. #

Clevity

28. heparin and xarelto together on 04/16/2017 7:52 a.m. #

Clevity

29. download Sahasra (2013) Telugu film songs on 04/16/2017 8:14 a.m. #

Clevity

30. Jim on 04/16/2017 4:08 p.m. #

Clevity

31. concert tickets minneapolis on 04/16/2017 7:58 p.m. #

Clevity

32. xarelto uses and side effects on 04/17/2017 1:53 a.m. #

Clevity

33. Size: large on 04/17/2017 9:18 p.m. #

Clevity

34. http://psychicreadingsbyphonedoctor36.blog5.net/ on 04/18/2017 11:25 a.m. #

Clevity

35. cheap trazodone on 04/22/2017 7:48 p.m. #

Clevity

36. sell house fast Austin texas on 04/24/2017 6:23 p.m. #

Clevity

Clevity

38. tham xop on 04/28/2017 7:44 p.m. #

Clevity

39. magasin bio en ligne on 05/10/2017 5:25 p.m. #

Clevity

40. check out here on 05/11/2017 9:05 p.m. #

Clevity

41. http://104.131.73.223:8080/profile.php?id=298544 on 05/12/2017 12:45 p.m. #

Clevity

42. strizheus on 05/13/2017 5:04 a.m. #

Clevity

43. http://www.bluesandheritagefest.com/2016 on 05/14/2017 1:32 a.m. #

Clevity

44. fitness model body on 05/20/2017 12:14 p.m. #

Clevity

45. tour 2016 okc on 05/28/2017 7:09 a.m. #

Clevity

Clevity

47. wheels on the bus on 08/24/2017 4:06 a.m. #

Clevity

48. mobile legends bang bang apk on 10/19/2017 9:29 p.m. #

Clevity