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

 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COMPANY COMBINED
 |  | Month
 |  |  |  |  |  |  |  |  |  | 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 |  |  |  |  |  |  | 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 | 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
 |  |  |  |  |  |  | DETAIL
 |  |  |  |  |  |  | RONDEBOSCH - MARCEL'S
 |  |  |  |  |  |  | WORCESTER - MARCEL'S
 |  |  |  |  |  |  | WATERFRONT - MARCEL'S
 |  |  |  |  |  |  | TYGERVALLEY - MARCEL'S
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | SOMERSET WEST - MARCEL'S
 |  |  |  |  |  |  | BAY WEST - MARCEL'S
 |  |  |  |  |  |  | ZEVENWACHT - MARCEL'S
 |  |  |  |  |  |  | MOJO - MARCEL'S
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | TABLE BAY - MARCEL'S
 |  |  |  |  |  |  | EIKESTAD - MARCEL'S
 |  |  |  |  |  |  | FACTORY - STELLENBOSCH
 |  |  |  |  |  |  | PAUL ROOS - MARCEL'S
 |  |  |  |  |  |  | CAMPS BAY - MARCEL'S
 |  |  |  |  |  |  | CAVENDISH - MARCEL'S
 |  |  |  |  |  |  | SEA POINT - MARCEL'S
 |  |  |  |  |  |  | ROSEBANK - MARCEL'S
 |  |  |  |  |  |  | TOTAL MONTH COMBINED
 |  |  |  |  |  |  | DETAIL
 |  |  |  |  |  |  | SPAR - YZERFONTEIN
 |  |  |  |  |  |  | SPAR - STARWOOD
 |  |  |  |  |  |  | TOTAL MONTH COMBINED
 |  |  |  |  |  |  | DETAIL
 |  |  |  |  |  |  | OSUMO - SEA POINT
 |  |  |  |  |  |  | OSUMO - CAVENDISH
 |  |  |  |  |  |  | TOTAL MONTH COMBINED