I haven't checked all the monetary columns but columns M to R you have formatted as currency (two decimal places). If you change the formatting of those columns you will see that the real values are somewhat different than what currency displays.
You are testing using values that you entered and not calculated values. That will certainly explain some of the differences. To find all of the differences, all the names would have to be converted to ranges to see what is happening. In addition, you are using percentages and that is another area where errors in precision can occur.
M N O P Q R 1 Super Insurances Payroll Tax Cost Margin Hourly Margin 2 2.850000 0.410625 1.626075 34.886700 4.103300 4.103300 3 61.750000 8.896875 48.754875 769.401750 180.598250 22.574781 4 2.850000 0.410625 1.790325 35.050950 7.889050 7.889050 5 3.325000 0.479063 2.088713 40.892775 7.107225 7.107225
Bookmarks