Spreadsheet: 828350d1683430649-financial-dash-board-copy-of-dash-board
Sheet: Budget Data

Bin | Year | Store Name | Item | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Budget | 2018 | [NAME] | Revenue | 650000 | 700000 | 580000 | 560000 | 325000 | 295000 | 270000 | 267500 | 310000 | 350000 | 312500 | 375000
Budget | 2018 | [NAME] | [NAME] | 225000 | 242500 | 199000 | 194000 | 112500 | 99500 | 93500 | 92750 | 106000 | 121250 | 108750 | 128750
Budget | 2018 | [NAME] | Base Rent | 72000 | 72000 | 72000 | 72000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000
Budget | 2018 | [NAME] | Rent Related Expenses | 2420 | 2420 | 2420 | 2420 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000
Budget | 2018 | [NAME] | Salaries & Commission | 48000 | 48000 | 48000 | 48000 | 36000 | 36000 | 36000 | 36000 | 36000 | 36000 | 36000 | 36000
Budget | 2018 | [NAME] | Marketing | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000
Budget | 2018 | [NAME] | Other operaing | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000
Budget | 2018 | [NAME] | HQ Cross Charge | 137729 | 138980 | 127727 | 132586 | 140685 | 127153 | 132195 | 130338 | 131372 | 140641 | 133554 | 153078
Budget | 2018 | [NAME] | Depreciation | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Budget | 2018 | [NAME] | Interest | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Budget | 2018 | [NAME] | Other Income
Budget | 2018 | [NAME] | Revenue | 250000 | 260000 | 250000 | 154000 | 85000 | 100000 | 85000 | 90000 | 110000 | 110000 | 105000 | 85000
Budget | 2018 | [NAME] | [NAME] | 109500 | 114000 | 103500 | 67200 | 36750 | 40500 | 36750 | 37500 | 42750 | 46500 | 41250 | 36750
Budget | 2018 | [NAME] | Base Rent | 79650 | 79650 | 79650 | 79650 | 46025 | 46025 | 46025 | 46025 | 46025 | 46025 | 46025 | 46025
Budget | 2018 | [NAME] | Rent Related Expenses | 2400 | 2400 | 2400 | 2400 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000
Budget | 2018 | [NAME] | Salaries & Commission | 34000 | 34000 | 34000 | 34000 | 28000 | 28000 | 28000 | 28000 | 28000 | 28000 | 28000 | 28000
Budget | 2018 | [NAME] | Marketing | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000
Budget | 2018 | [NAME] | Other operaing | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000
Budget | 2018 | [NAME] | HQ Cross Charge | 52973 | 51621 | 55055 | 47352 | 47616 | 53878 | 48961 | 48725 | 52973 | 44202 | 53422 | 40821
Budget | 2018 | [NAME] | Depreciation | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Budget | 2018 | [NAME] | Interest | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Budget | 2018 | [NAME] | Other Income
Budget | 2018 | [NAME] | Revenue | 185000 | 200000 | 210000 | 190000 | 190000 | 220000 | 180000 | 190000 | 210000 | 225000 | 190000 | 190000
Budget | 2018 | [NAME] | [NAME] | 72500 | 78000 | 80000 | 74000 | 74000 | 83000 | 70000 | 74000 | 80000 | 84500 | 74000 | 74000
Budget | 2018 | [NAME] | Base Rent | 80910 | 80910 | 80910 | 80910 | 80910 | 80910 | 80910 | 80910 | 80910 | 80910 | 80910 | 80910
Budget | 2018 | [NAME] | Rent Related Expenses | 1800 | 1800 | 1800 | 1800 | 1800 | 1800 | 1800 | 1800 | 1800 | 1800 | 1800 | 1800
Budget | 2018 | [NAME] | Salaries & Commission | 26000 | 26000 | 26000 | 26000 | 26000 | 26000 | 26000 | 26000 | 26000 | 26000 | 26000 | 26000
Budget | 2018 | [NAME] | Marketing | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000
Budget | 2018 | [NAME] | Other operaing | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000
Budget | 2018 | [NAME] | HQ Cross Charge | 39200 | 39709 | 46246 | 44985 | 41123 | 47413 | 44065 | 46288 | 44497 | 45206 | 40600 | 38780
Budget | 2018 | [NAME] | Depreciation | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Budget | 2018 | [NAME] | Interest | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Budget | 2018 | [NAME] | Other Income
Budget | 2018 | The Best Store | Revenue | 95000 | 100000 | 95000 | 105000 | 95000 | 100000 | 100000 | 100000 | 100000 | 100000 | 105000 | 105000
Budget | 2018 | The Best Store | [NAME] | 28500 | 31500 | 28500 | 33000 | 28500 | 31500 | 31500 | 30750 | 31500 | 31500 | 33000 | 33000
Budget | 2018 | The Best Store | Base Rent | 15530 | 15530 | 15530 | 15530 | 15530 | 15530 | 15530 | 15530 | 20700 | 20700 | 20700 | 20700
Budget | 2018 | The Best Store | Rent Related Expenses | 925 | 925 | 925 | 925 | 925 | 925 | 925 | 925 | 925 | 925 | 925 | 925
Budget | 2018 | The Best Store | Salaries & Commission | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000
Budget | 2018 | The Best Store | Marketing | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000
Budget | 2018 | The Best Store | Other operaing | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000
Budget | 2018 | The Best Store | HQ Cross Charge | 20130 | 19854 | 20921 | 24860 | 20562 | 21551 | 24481 | 24362 | 21189 | 20092 | 22437 | 21431
Budget | 2018 | The Best Store | Depreciation | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Budget | 2018 | The Best Store | Interest | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Budget | 2018 | The Best Store | Other Income
Budget | 2018 | Outlet Stores | Revenue | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000
Budget | 2018 | Outlet Stores | [NAME] | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500
Budget | 2018 | Outlet Stores | Base Rent | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000
Budget | 2018 | Outlet Stores | Rent Related Expenses | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600
Budget | 2018 | Outlet Stores | Salaries & Commission | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000
Budget | 2018 | Outlet Stores | Marketing | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500
Budget | 2018 | Outlet Stores | Other operaing | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600
Budget | 2018 | Outlet Stores | HQ Cross Charge | 2119 | 1985 | 2202 | 2368 | 2164 | 2155 | 2448 | 2436 | 2119 | 2009 | 2137 | 2041
Budget | 2018 | Outlet Stores | Depreciation | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Budget | 2018 | Outlet Stores | Interest | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Budget | 2018 | Outlet Stores | Other Income
Budget | 2018 | Trunk Stores | Revenue | 0 | 0 | 300000 | 250000 | 120000 | 300000 | 0 | 300000 | 250000 | 120000 | 410000 | 250000
Budget | 2018 | Trunk Stores | [NAME] | 0 | 0 | 105000 | 100000 | 42000 | 105000 | 0 | 105000 | 87500 | 42000 | 143500 | 100000
Budget | 2018 | Trunk Stores | Base Rent | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Budget | 2018 | Trunk Stores | Rent Related Expenses | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Budget | 2018 | Trunk Stores | Salaries & Commission | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Budget | 2018 | Trunk Stores | Marketing | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Budget | 2018 | Trunk Stores | Other operaing | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Budget | 2018 | Trunk Stores | HQ Cross Charge | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Budget | 2018 | Trunk Stores | Depreciation | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Budget | 2018 | Trunk Stores | Interest | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Budget | 2018 | Trunk Stores | Other Income
Budget | 2018 | Others | Revenue | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Budget | 2018 | Others | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Budget | 2018 | Others | Base Rent | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Budget | 2018 | Others | Rent Related Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Budget | 2018 | Others | Salaries & Commission | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Budget | 2018 | Others | Marketing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Budget | 2018 | Others | Other operaing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Budget | 2018 | Others | HQ Cross Charge | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Budget | 2018 | Others | Depreciation | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Budget | 2018 | Others | Interest | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Budget | 2018 | Others | Other Income
Budget | 2018 | Group | Revenue | 1190000 | 1270000 | 1445000 | 1269000 | 825000 | 1025000 | 645000 | 957500 | 990000 | 915000 | 1132500 | 1015000
Budget | 2018 | Group | [NAME] | 443000 | 473500 | 523500 | 475700 | 301250 | 367000 | 239250 | 347500 | 355250 | 333250 | 408000 | 380000
Budget | 2018 | Group | Base Rent | 254090 | 254090 | 254090 | 254090 | 155465 | 155465 | 155465 | 155465 | 160635 | 160635 | 160635 | 160635
Budget | 2018 | Group | Rent Related Expenses | 8145 | 8145 | 8145 | 8145 | 7325 | 7325 | 7325 | 7325 | 7325 | 7325 | 7325 | 7325
Budget | 2018 | Group | Salaries & Commission | 138000 | 138000 | 138000 | 138000 | 120000 | 120000 | 120000 | 120000 | 120000 | 120000 | 120000 | 120000
Budget | 2018 | Group | Marketing | 25500 | 25500 | 25500 | 25500 | 25500 | 25500 | 25500 | 25500 | 25500 | 25500 | 25500 | 25500
Budget | 2018 | Group | Other operaing | 7600 | 7600 | 7600 | 7600 | 7600 | 7600 | 7600 | 7600 | 7600 | 7600 | 7600 | 7600
Budget | 2018 | Group | HQ Cross Charge | 252151 | 252149 | 252151 | 252151 | 252150 | 252150 | 252150 | 252149 | 252150 | 252150 | 252150 | 256151
Budget | 2018 | Group | Depreciation | 14000 | 14000 | 14000 | 14000 | 14000 | 14000 | 14000 | 14000 | 14000 | 14000 | 14000 | 14000
Budget | 2018 | Group | Interest | 16000 | 16000 | 16000 | 16000 | 16000 | 16000 | 16000 | 16000 | 16000 | 16000 | 16000 | 16000
Budget | 2018 | Group | Other Income | 4206 | 4206 | 4206 | 8412 | 8412 | 8412 | 8412 | 8412 | 8412 | 8412 | 8412 | 8412