Easily keep track of faculty spending with this easy to use, straight forward budget tracker. Produces graphs, reports and tables giving a clear view of where your budget is going and how much is left.
- Step 1 Go to the “Overall” sheet and in the total budget cell, input your allocated budget.
- Step 2 As orders come in, click on the appropriate subject tab, and list the resource, where it is from, who ordered it, the cost, how many are required and if there are any shipping costs. The results will update on the “Overall” both in the table, and graphically, giving you a visual of exactly where the money is being spent. Furthermore a short report is generated, that can be copied and pasted into an email, should you need to notify someone of the progress with the budget.
- Step 3 It should be noted, that although this excel sheet has been set up for a Head of Science Position, it could be easily adapted to suit other Faculties by changing the name of the sheets and the labels on the graph. To alter the report, simply click on the cell, and in the formula, wherever a faculty is listed, rewrite it with the appropriate replacement.
- pw to unlock cells is “schoolsoutforsummer”
Get this resource as part of a bundle and save up to 12%
A bundle is a package of resources grouped together to teach a particular topic, or a series of lessons, in one place.
Something went wrong, please try again later.
This resource hasn't been reviewed yet
To ensure quality for our reviews, only customers who have purchased this resource can review it
Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.
£1.00