Spreadsheet: 868029d1714735460-mapping-formula-help-test1
Sheet: ACT24

Test |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 months
Profit & Loss Account |  | 2024 |  |  |  |  |  |  |  |  |  |  |  |  | Act 23 | Act 22 | Act 21 | Act 20 | Act 19 | Act18 |  | Month | YTD | proj 19 | proj 18
 |  | Actual | Actual | Actual | Projections | Projections | Projections | Projections | Projections | Projections | Projections | Projections | Projections
 |  | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00 | 2024-04-30 00:00:00 | 2024-05-31 00:00:00 | 2024-06-30 00:00:00 | 2024-07-31 00:00:00 | 2024-08-31 00:00:00 | 2024-09-30 00:00:00 | 2024-10-31 00:00:00 | 2024-11-30 00:00:00 | 2024-12-31 00:00:00 | Total |  |  |  |  |  | Total
 |  | £ | £ | £ | £ | £ | £ | £ | £ | £ | £ | £ | £ | £ |  |  |  | £ | £
Turnover
Management & Supervision |  | 78353.04000000001 | 153139.39 | 230569 | 112911.75 | 95042.92 | 139815.45 | 54507.5 | 66398.8 | 144003.05 | 66459.61 | 49927.5 | 188704.25 |  |  |  |  |  |  |  |  |  |  |  |  | TUR001
Forest Planning & FSC Certification |  | 1250 | 4265 | 1114 | 20570 | 37205 | 17095.93 | 19748 | 14691 | 13670 | 8520 | 12343.75 | 12910 |  |  |  |  |  |  |  |  |  |  |  |  | TUR002
Restock Planting |  | 0 | 0 | 0 | 84778.4 | 206722.06 | 38160.22 | 0 | 0 | 3500 | 0 | 66575 | 91048.4 |  |  |  |  |  |  |  |  |  |  |  |  | TUR003
New Planting |  | 6652.8 | 9690.3 | 131528 | 423362 | 137262 | 3500 | 0 | 250000 | 250000 | 293685 | 262491 | 694548.64 |  |  |  |  |  |  |  |  |  |  |  |  | TUR004
Establishment, Maintenance & Protection |  | 0 | 0 | 0 | 110586.82 | 212121.25 | 178303.73 | 98070 | 334640.8987200001 | 165751.72 | 127545.7 | 97726.7 | 262005.7 |  |  |  |  |  |  |  |  |  |  |  |  | TUR005
Cost+ Tender Contracts |  | 525664.8910000001 |  |  | 23998 | 32470 | 16800 | 0 | 58890 | 29263 | 23275 | 2910 | 3740 |  |  |  |  |  |  |  |  |  |  |  |  | TUR006
Commission on Sales |  | 562 | 0 | 0 | 6500 | 0 | 0 | 4000 | 7018 | 710 | 20470 | 10000 | 1935 |  |  |  |  |  |  |  |  |  |  |  |  | TUR007
Tree Safety & Consultancy |  | 41710.46 | 40647.92 | 72193 | 6265 | 17138.06 | 15961.06 | 12008.06 | 15523.06 | 10310.06 | 1500 | 1500 | 1500 |  |  |  |  |  |  |  |  |  |  |  |  | TUR008
Mileage |  | 42188.39 | 7526.35 | 19484 | 537.5 | 787.5 | 2241.25 | 587.5 | 487.5 | 2281.25 | 387.5 | 387.5 | 2500 |  |  |  |  |  |  |  |  |  |  |  |  | TUR009
Roads & New Fencing |  | 0 | 0 |  | 425150 | 70000 | 10000 | 10300 | 368760 | 9050 | 16150 | 0 | 19600 |  |  |  |  |  |  |  |  |  |  |  |  | TUR010
Additional Turnover |  | 0 | 0 |  | 425125.3125942113 | 624900.1949028817 | 159002.3695919513 | 219072.0683273549 | 0 | 319557.4196681749 | 535240.1669384196 | 857750.2675275191 | 397319.1239216164 |  |  |  |  |  | 0 | 0 | 3829321 |  |  |  |  | TUR011
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2746563
Cost of Sales
Purchases |  | 997.46 | 90 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | COS001
Restocking |  | 0 | 0 | 0 | 72328.96876173312 | 318538.0626845271 | 30774.37096774194 | 0 | 0 | 3058.608058608058 | 0 | 54064.59259259259 | 75387.97116861634 |  |  |  |  |  |  |  |  |  |  |  |  | COS002
New Planting |  | 0 | 0 | 25515 | 349337.0077291129 | 126450.303030303 | 2592.592592592593 | 0 | 211290.3225806452 | 207057.5906688537 | 246822.8496865667 | 237090.0903444381 | 569181.0528400994 |  |  |  |  |  |  |  |  |  |  |  |  | COS003
Establishment, Maintenance & Protection |  | 0 | 0 | 0 | 92588.20518022073 | 108782.715627048 | 145349.1394561023 | 82031.8401968402 | 319190.6952180793 | 150056.6520044902 | 113681.3560795032 | 85480.66250817954 | 218066.2013304491 |  |  |  | 0 |  |  |  |  |  |  |  |  | COS004
Cost+ Tender Contracts |  | 345222.4899999999 | 636836.4099999999 | 849319 | 19598.33333333334 | 20513.0607966457 | 16662.72727272727 | 990 | 54513.0607966457 | 23543.91304347826 | 17500 | 2745.283018867925 | 1937.823834196891 |  |  |  | 0 |  |  |  |  |  |  |  |  | COS005
Roads & New Fencing |  | 0 | 0 | 0 | 377760.4255319149 | 63636.36363636363 | 8000 | 10071.18644067797 | 300615.4838709678 | 6644.405594405594 | 14550 | 0 | 19600 |  |  |  |  |  |  |  |  |  |  |  |  | COS006
Additional COS |  | 22015.8 | 0 | 15977 | 213819.9904180747 | 308364.5029568278 | 70790.9034352197 | 114228.8491866623 | 0 | 162612.118514422 | 277200.0864571592 | 438250.1366877707 | 202610.2326845257 |  |  |  |  |  |  |  | 2333285 |  |  |  |  | COS007
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1373625
Gross Profit
Gross Profit
Gross Profit %
Other Income |  |  |  |  |  |  | 0