break even analysis
pinepinney
unding_forcast.xlsxSheet1
| Funding Forcast | |||
| Funding Source | 2015 | 2016 | 2017 |
| United Way | 22,000 | 24,000 | 26,000 |
| Federal Government Grant | 100,000 | 100,000 | 100,000 |
| State Grant | 35,000 | 35,000 | 35,000 |
| VAWA | 35,000 | 35,000 | 35,000 |
| Fundraisers | 15,000 | 15,000 | 15,000 |
| Corporate Grants | 8,000 | 8,000 | 8,000 |
| Private Contributions | 6,000 | 8,000 | 10,000 |
| Total Funding | 223015 | 227016 | 231017 |
| Expenses for Business Activities | |||
| Fixed Costs | |||
| Salaries | 168,000 | 168,000 | 168,000 |
| Mortgage | 28,800 | 28,800 | 28,800 |
| Utilities | 6,000 | 6,000 | 6,000 |
| Security System/Monitoring | 2,400 | 2,400 | 2,400 |
| Adminsitration Supplies | 2,200 | 2,200 | 2,200 |
| Cleaning Supplies | 1,200 | 1,200 | 1,200 |
| Total Fixed Costs | 208,600 | 208,600 | 208,600 |
| Variable Costs | |||
| United Food Bank |
