Spreadsheet: 38048d1236175665-incorrect-calculations-budgets2
Sheet: Period 1

Week 1 |  | 2009-03-22 00:00:00 |  |  |  |  |  | Week 2 |  | 2009-03-29 00:00:00
Weekly Target |  | 1140763.98 |  |  |  |  |  | Weekly Target |  | 1097878.37
Actual Takings |  | 1019657.85 |  |  |  |  |  | Actual Takings |  | 1010312.24
 | Participation | Total | Target | [NAME] |  |  |  |  | Participation | Total | Target | [NAME]
Department A | 0 |  | 0 | 0 |  |  |  | Grocery | 0 |  | 0 | 0
Department B | 0 |  | 0 | 0 |  |  |  | Health & Beauty | 0 |  | 0 | 0
Department C | 0 |  | 0 | 0 |  |  |  | BWS | 0 |  | 0 | 0
Department D | 0 |  | 0 | 0 |  |  |  | [NAME] | 0 |  | 0 | 0
Department E | 0 |  | 0 | 0 |  |  |  | Fresh Foods | 0 |  | 0 | 0
Department F | 0 |  | 0 | 0 |  |  |  | Produce | 0 |  | 0 | 0
Department G | 0 |  | 0 | 0 |  |  |  | Counters | 0 |  | 0 | 0
Department H | 0 |  | 0 | 0 |  |  |  | Bakery | 0 |  | 0 | 0
Department I | 0 |  | 0 | 0 |  |  |  | JSR | 0 |  | 0 | 0
Department J | 0 |  | 0 | 0 |  |  |  | Pharmacy | 0 |  | 0 | 0
Department K | 0.08039670365897737 | 81977.13 | 91261.1184 | -9283.988400000002 |  |  |  | GM | 0.08077311821937345 | 81606.07 | 88679.05937050303 | -7072.989370503026
Department L | 0 |  | 0 | 0 |  |  |  | Foyer | 0 |  | 0 | 0
Department M | 0 |  | 0 | 0 |  |  |  | Clothing | 0 |  | 0 | 0
Department N | 0 |  | 0 | 0 |  |  |  | [NAME] | 0 |  | 0 | 0
Total |  |  |  | -9283.988400000002 |  |  |  | Total |  |  |  | -7072.989370503026
Week 3 |  | 2009-04-05 00:00:00 |  |  |  |  |  | Week 4 |  | 2009-04-12 00:00:00
Weekly Target |  | 1163781.66 |  |  |  |  |  | Weekly Target |  | 1164787.01
Actual Takings |  | 1080554.83 |  |  |  |  |  | Actual Takings |  | 1088380.78
 | Participation | Total | Target | [NAME] |  |  |  |  | Participation | Total | Target | [NAME]
Grocery | 0 |  | 0 | 0 |  |  |  | Grocery | 0 |  | 0 | 0
Health & Beauty | 0 |  | 0 | 0 |  |  |  | Health & Beauty | 0 |  | 0 | 0
BWS | 0 |  | 0 | 0 |  |  |  | BWS | 0 |  | 0 | 0
[NAME] | 0 |  | 0 | 0 |  |  |  | [NAME] | 0 |  | 0 | 0
Fresh Foods | 0 |  | 0 | 0 |  |  |  | Fresh Foods | 0 |  | 0 | 0
Produce | 0 |  | 0 | 0 |  |  |  | Produce | 0 |  | 0 | 0
Counters | 0 |  | 0 | 0 |  |  |  | Counters | 0 |  | 0 | 0
Bakery | 0 |  | 0 | 0 |  |  |  | Bakery | 0 |  | 0 | 0
JSR | 0 |  | 0 | 0 |  |  |  | JSR | 0 |  | 0 | 0
Pharmacy | 0 |  | 0 | 0 |  |  |  | Pharmacy | 0 |  | 0 | 0
GM | 0.08595157545128922 | 92875.39 | 100028.8671583166 | -7153.4771583166 |  |  |  | GM | 0.07346372838373716 | 79956.51 | 85569.59652754533 | -5613.08652754534
Foyer | 0 |  | 0 | 0 |  |  |  | Foyer | 0 |  | 0 | 0
Clothing | 0 |  | 0 | 0 |  |  |  | Clothing | 0 |  | 0 | 0
[NAME] | 0 |  | 0 | 0 |  |  |  | [NAME] | 0 |  | 0 | 0
Total |  |  |  | -7153.4771583166 |  |  |  | Total |  |  |  | -5613.08652754534
Peroid Target |  | 4567211.02
Actual Takings |  | 4198905.7
 | AVG Participation | Total for period | Target for period | Variance on budget | Variance on last period
Grocery | 0 | 0 | 0 | 0 | N/A
Health & Beauty | 0 | 0 | 0 | 0 | N/A
BWS | 0 | 0 | 0 | 0 | N/A
[NAME] | 0 | 0 | 0 | 0 | N/A
Fresh Foods | 0 | 0 | 0 | 0 | N/A
Produce | 0 | 0 | 0 | 0 | N/A
Counters | 0 | 0 | 0 | 0 | N/A
Bakery | 0 | 0 | 0 | 0 | N/A
JSR | 0 | 0 | 0 | 0 | N/A
Pharmacy | 0 | 0 | 0 | 0 | N/A
GM | 0.0801462814283443 | 336415.1 | 365538.641456365 | -29123.54145636497 | N/A
Foyer | 0 | 0 | 0 | 0 | N/A
Clothing | 0 | 0 | 0 | 0 | N/A
[NAME] | 0 | 0 | 0 | 0 | N/A
Total |  |  |  | -29123.54145636497 | N/A
Comments on period - I.e. issues, promos, management changes, refits etc…