Spreadsheet: 868172d1714923081-public-holidays-adjustment-in-automated-daily-targets-dsr-2024-marcels
Sheet: April

 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COMPANY COMBINED
 |  | Month | April
 |  |  |  |  |  |  |  |  |  |  |  | Turnover | Food Cost | GP% |  |  |  | Turnover | Food Cost | GP% |  |  |  | Turnover | Food Cost | GP% |  |  |  | Turnover | Food Cost | GP% |  |  |  | Turnover | Food Cost | GP% |  |  |  | Turnover | Food Cost | GP% |  |  |  | Turnover | Food Cost | GP% |  |  |  | Turnover | Food Cost | GP% |  |  |  | Turnover | Food Cost | GP% |  |  |  | Turnover | Food Cost | GP% |  |  |  | Turnover | Food Cost | GP% |  |  |  | Turnover | Food Cost | GP% |  |  |  | Turnover | Food Cost | GP% |  |  |  | Turnover | Food Cost | GP% |  |  |  | Turnover | Food Cost | GP% |  |  |  | Turnover | Food Cost | GP% |  |  |  | Turnover | Food Cost | GP% |  |  |  | Turnover | Food Cost | GP% |  |  |  |  | Turnover | Food Cost | GP% |  |  |  | Turnover | Food Cost | GP% |  |  |  |  | Turnover | Food Cost | GP% |  |  |  | Turnover | Food Cost | GP% |  |  |  |  | Turnover | Food Cost | GP%
 |  | Year | 2024 |  |  |  |  |  |  |  | Last Year |  |  |  |  |  | Last Year |  |  |  |  |  | Last Year |  |  |  |  |  | Last Year |  |  |  |  |  | Last Year |  |  |  |  |  | Last Year |  |  |  |  |  | Last Year |  |  |  |  |  | Last Year |  |  |  |  |  | Last Year |  |  |  |  |  | Last Year |  |  |  |  |  | Last Year |  |  |  |  |  | Last Year |  |  |  |  |  | Last Year |  |  |  |  |  | Last Year |  |  |  |  |  | Last Year |  |  |  |  |  | Last Year |  |  |  |  |  | Last Year |  |  |  |  |  | Last Year |  |  |  |  |  |  | Last Year |  |  |  |  |  | Last Year |  |  |  |  |  |  | Last Year |  |  |  |  |  | Last Year |  |  |  |  |  |  | Last Year
 |  |  |  |  |  |  |  |  |  |  | Budget |  |  |  |  |  | Budget |  |  |  |  |  | Budget |  |  |  |  |  | Budget |  |  |  |  |  | Budget |  |  |  |  |  | Budget |  |  |  |  |  | Budget |  |  |  |  |  | Budget |  |  |  |  |  | Budget |  |  |  |  |  | Budget |  |  |  |  |  | Budget |  |  |  |  |  | Budget |  |  |  |  |  | Budget |  |  |  |  |  | Budget |  |  |  |  |  | Budget |  |  |  |  |  | Budget |  |  |  |  |  | Budget |  |  |  |  |  | Budget |  |  |  |  |  |  | Budget |  |  |  |  |  | Budget |  |  |  |  |  |  | Budget |  |  |  |  |  | Budget |  |  |  |  |  |  | Budget
 |  | Start Date |  |  |  |  |  |  |  |  | Actual |  |  |  |  |  | Actual |  |  |  |  |  | Actual |  |  |  |  |  | Actual |  |  |  |  |  | Actual |  |  |  |  |  | Actual |  |  |  |  |  | Actual |  |  |  |  |  | Actual |  |  |  |  |  | Actual |  |  |  |  |  | Actual |  |  |  |  |  | Actual |  |  |  |  |  | Actual |  |  |  |  |  | Actual |  |  |  |  |  | Actual |  |  |  |  |  | Actual |  |  |  |  |  | Actual |  |  |  |  |  | Actual |  |  |  |  |  | Actual |  |  |  |  |  |  | Actual |  |  |  |  |  | Actual |  |  |  |  |  |  | Actual |  |  |  |  |  | Actual |  |  |  |  |  |  | Actual
 |  |  |  |  |  |  |  |  |  |  | % of LY |  |  |  |  |  | % of LY |  |  |  |  |  | % of LY |  |  |  |  |  | % of LY |  |  |  |  |  | % of LY |  |  |  |  |  | % of LY |  |  |  |  |  | % of LY |  |  |  |  |  | % of LY |  |  |  |  |  | % of LY |  |  |  |  |  | % of LY |  |  |  |  |  | % of LY |  |  |  |  |  | % of LY |  |  |  |  |  | % of LY |  |  |  |  |  | % of LY |  |  |  |  |  | % of LY |  |  |  |  |  | % of LY |  |  |  |  |  | % of LY |  |  |  |  |  | % of LY |  |  |  |  |  |  | % of LY |  |  |  |  |  | % of LY |  |  |  |  |  |  | % of LY |  |  |  |  |  | % of LY |  |  |  |  |  |  | % of LY
 |  | End Date |  |  |  |  |  |  |  |  | % of Target |  |  |  |  |  | % of Target |  |  |  |  |  | % of Target |  |  |  |  |  | % of Target |  |  |  |  |  | % of Target |  |  |  |  |  | % of Target |  |  |  |  |  | % of Target |  |  |  |  |  | % of Target |  |  |  |  |  | % of Target |  |  |  |  |  | % of Target |  |  |  |  |  | % of Target |  |  |  |  |  | % of Target |  |  |  |  |  | % of Target |  |  |  |  |  | % of Target |  |  |  |  |  | % of Target |  |  |  |  |  | % of Target |  |  |  |  |  | % of Target |  |  |  |  |  | % of Target |  |  |  |  |  |  | % of Target |  |  |  |  |  | % of Target |  |  |  |  |  |  | % of Target |  |  |  |  |  | % of Target |  |  |  |  |  |  | % of Target
 |  |  |  |  |  |  |  |  |  |  | Projection |  |  |  |  |  | Projection |  |  |  |  |  | Projection |  |  |  |  |  | Projection |  |  |  |  |  | Projection |  |  |  |  |  | Projection |  |  |  |  |  | Projection |  |  |  |  |  | Projection |  |  |  |  |  | Projection |  |  |  |  |  | Projection |  |  |  |  |  | Projection |  |  |  |  |  | Projection |  |  |  |  |  | Projection |  |  |  |  |  | Projection |  |  |  |  |  | Projection |  |  |  |  |  | Projection |  |  |  |  |  | Projection |  |  |  |  |  | Projection |  |  |  |  |  |  | Projection |  |  |  |  |  | Projection |  |  |  |  |  |  | Projection |  |  |  |  |  | Projection |  |  |  |  |  |  | Projection
 |  | Total Days |  |  |  | Sl.No | Day | Date | Last Year | Daily Target | Actual (Incl) | Turnover(Excl) | Food Cost | GP% | Last Year | Daily Target | Actual (Incl) | Turnover(Excl) | Food Cost | GP% | Last Year | Daily Target | Actual (Incl) | Turnover(Excl) | Food Cost | GP% | Last Year | Daily Target | Actual (Incl) | Turnover(Excl) | Food Cost | GP% | Last Year | Daily Target | Actual (Incl) | Turnover(Excl) | Food Cost | GP% | Last Year | Daily Target | Actual (Incl) | Turnover(Excl) | Food Cost | GP% | Last Year | Daily Target | Actual (Incl) | Turnover(Excl) | Food Cost | GP% | Last Year | Daily Target | Actual (Incl) | Turnover(Excl) | Food Cost | GP% | Last Year | Daily Target | Actual (Incl) | Turnover(Excl) | Food Cost | GP% | Last Year | Daily Target | Actual (Incl) | Turnover(Excl) | Food Cost | GP% | Last Year | Daily Target | Actual (Incl) | Turnover(Excl) | Food Cost | GP% | Last Year | Daily Target | Actual (Incl) | Turnover(Excl) | Food Cost | GP% | Last Year | Daily Target | Actual (Incl) | Turnover(Excl) | Food Cost | GP% | Last Year | Daily Target | Actual (Incl) | Turnover(Excl) | Food Cost | GP% | Last Year | Daily Target | Actual (Incl) | Turnover(Excl) | Food Cost | GP% | Last Year | Daily Target | Actual (Incl) | Turnover(Excl) | Food Cost | GP% | Last Year | Daily Target | Actual (Incl) | Turnover(Excl) | Food Cost | GP% | Last Year | Daily Target | Actual (Incl) | Turnover(Excl) | Food Cost | GP% |  | Last Year | Daily Target | Actual (Incl) | Turnover(Excl) | Food Cost | GP% | Last Year | Daily Target | Actual (Incl) | Turnover(Excl) | Food Cost | GP% |  | Last Year | Daily Target | Actual (Incl) | Turnover(Excl) | Food Cost | GP% | Last Year | Daily Target | Actual (Incl) | Turnover(Excl) | Food Cost | GP% |  | Last Year | Daily Target | Actual (Incl) | Turnover(Excl) | Food Cost | GP%
 |  |  |  |  |  | 1
 |  | Total Sat |  |  |  | 2
 |  | Total Sun |  |  |  | 3
 |  |  |  |  |  | 4
 |  | Marcel's |  |  |  | 5
 |  | Last Year |  |  |  | 6
 |  | Budget |  |  |  | 7
 |  | Actual |  |  |  | 8
 |  |  |  |  |  | 9
 |  | Spar |  |  |  | 10
 |  | Last Year |  |  |  | 11
 |  | Budget |  |  |  | 12
 |  | Actual |  |  |  | 13
 |  |  |  |  |  | 14
 |  | Osumo |  |  |  | 15
 |  | Last Year |  |  |  | 16
 |  | Budget |  |  |  | 17
 |  | Actual |  |  |  | 18
 |  |  |  |  |  | 19
 |  | Total Last Year |  |  |  | 20
 |  | Total Budget |  |  |  | 21
 |  | Total Actual |  |  |  | 22
 |  |  |  |  |  | 23
 |  | Growth on LY |  |  |  | 24
 |  |  |  |  |  | 25
 |  | Variance to Budget |  |  |  | 26
 |  | % to Budget |  |  |  | 27
 |  |  |  |  |  | 28
 |  | Highest Trade Day |  |  |  | 29
 |  | Lowest Trade Day |  |  |  | 30
 |  |  |  |  |  | 31
 |  | Target Achieved |  |  |  |  | Total
 |  | January | 2024 |  |  |  |  |  | DETAIL
 |  | February | 2025 |  |  |  |  |  | RONDEBOSCH - MARCEL'S |  | 69565.24571304348
 |  | March | 2026 |  |  |  |  |  | WORCESTER - MARCEL'S |  | 58987.36386086958
 |  | April | 2027 |  |  |  |  |  | WATERFRONT - MARCEL'S |  | 600000
 |  | May | 2028 |  |  |  |  |  | TYGERVALLEY - MARCEL'S |  | 280000
 |  | June | 2029 |  |  |  |  |  | [NAME] |  | 665773.4329173913
 |  | July | 2030 |  |  |  |  |  | SOMERSET WEST - MARCEL'S |  | 118133.1478260869
 |  | August | 2031 |  |  |  |  |  | BAY WEST - MARCEL'S |  | 60269.70456521739
 |  | September | 2032 |  |  |  |  |  | ZEVENWACHT - MARCEL'S |  | 96141.67444347826
 |  | October | 2033 |  |  |  |  |  | MOJO - MARCEL'S |  | 112533.7143434783
 |  | November | 2034 |  |  |  |  |  | [NAME] |  | 116626.8891130435
 |  | December | 2035 |  |  |  |  |  | TABLE BAY - MARCEL'S |  | 87327.32266956521
 |  |  | 2036 |  |  |  |  |  | EIKESTAD - MARCEL'S |  | 68930.9103869565
 |  |  | 2037 |  |  |  |  |  | FACTORY - STELLENBOSCH |  | 51689.22152173913
 |  |  | 2038 |  |  |  |  |  | PAUL ROOS - MARCEL'S |  | 20573.35580869565
 |  |  | 2039 |  |  |  |  |  | CAMPS BAY - MARCEL'S |  | 110000
 |  |  | 2040 |  |  |  |  |  | CAVENDISH - MARCEL'S |  | 51939.83586956523
 |  |  | 2041 |  |  |  |  |  | SEA POINT - MARCEL'S |  | 25000
 |  |  | 2042 |  |  |  |  |  | ROSEBANK - MARCEL'S |  | 63826.30341304348
 |  |  | 2043 |  |  |  |  |  | TOTAL MONTH COMBINED
 |  |  | 2044
 |  |  | 2045 |  |  |  |  |  | DETAIL
 |  |  | 2046 |  |  |  |  |  | SPAR - YZERFONTEIN |  | 60000
 |  |  | 2047 |  |  |  |  |  | SPAR - STARWOOD |  | 30000
 |  |  | 2048 |  |  |  |  |  | TOTAL MONTH COMBINED
 |  |  | 2049
 |  |  | 2050 |  |  |  |  |  | DETAIL
 |  |  | 2051 |  |  |  |  |  | OSUMO - SEA POINT |  | 100000
 |  |  | 2052 |  |  |  |  |  | OSUMO - CAVENDISH |  | 110000
 |  |  | 2053 |  |  |  |  |  | TOTAL MONTH COMBINED
 | 7 Day per Trading
 | 2 | Mon | 0.1
 | 3 | Tue | 0.11
 | 4 | Wed | 0.11
 | 5 | Thu | 0.13
 | 6 | Fri | 0.15
 | 7 | Sat | 0.23
 | 1 | Sun | 0.17
 | 6 Day per Trading
 | 2 | Mon | 0.13
 | 3 | Tue | 0.13
 | 4 | Wed | 0.15
 | 5 | Thu | 0.17
 | 6 | Fri | 0.26
 | 7 | Sat | 0.16
 | 1 | Sun | 0