Improving Decision Making: Using a Spreadsheet to Create a Town Budget

Software skills: Spreadsheet charts, formulas, assumptions

Business skills: Preparing a town budget

$2-9$ In this exercise, you will learn how to use spreadsheet software to improve management decisions about a budget and budget projections, in this case for a town. The town of ClearSkies with a population of $9,042,$ is located in Oklahoma. Each November the town manager works with the mayor and the board of trustees to develop the town$$s budget for the forthcoming year. The town$$s main source of revenue is the local property tax, but it also receives some aid from the state government and some revenue from miscellaneous licenses and fees.