EXCEL HOMEWORK HELP
dtg05
ch.3_excel.xlsxExpenses
| City of Pacifica Bay | ||||||
| Summary of Annual Expenses | ||||||
| Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Annual Total | Percent of Total | |
| Salaries and Benefits | $ 721,216 | $ 810,451 | $ 785,960 | $ 788,657 | ||
| Machinery and Equipment | 325,723 | 289,430 | 254,638 | 336,354 | ||
| Materials and Supplies | 445,420 | 398,675 | 348,642 | 254,233 | ||
| Professional Services | 563,243 | 689,243 | 542,683 | 976,245 | ||
| Miscellaneous | 227,126 | 224,876 | 228,238 | 223,827 | ||
| Totals by Quarter | ||||||
| Expenses 5-Year Forecast | ||||||
| Forecasted Increase | 3.5% | |||||
| Year | 2016 | 2017 | 2018 | 2019 | 2020 | |
| Projected Expenses |
Projected Decrease
| City of Pacifica Bay | ||
| Projected Decrease in Expenses | ||
| Annual Total | Percent of Total | |
| Salaries and Benefits | $ - 0 | |
| Machinery and Equipment | - 0 | |
| Materials and Supplies | - 0 | |
| Professional Services | - 0 | |
| Miscellaneous | - 0 | |
| Totals by Quarter | $ - 0 | |
| Goal: Decrease Professional Services to 25% | ||
| Goal Amount |
