Note:  The budget forms now have a discount formula.  Enter the original unit price and enter a percent in the discount column for the discounted total to calculate.

Below are the electronic forms for the budget submissions.

2009-2010 Budget Submission Form (Excel)

2009-2010 Budget Summary Page (Excel)

General directions for using the excel submission form (Word)

2009-2010 Budget Prep Information (Word)

Budget Form Completion Example (Excel)

Account Code Explanation (Excel)

General information for using the excel documents:

The budget submission form and summary sheet have been designed to help automate the task of completing your yearly budget.  Totals for line items, pages, and grand total will be automatically calculated. General information (name, department, vendor, building…) completed on “Page1” will be automatically completed for you on pages 2, 3, and 4.  As in any Excel spreadsheet, to add information, click on the cell and key in the information. The tab key can be used to move easily from cell-to-cell.

Opening and Saving:

The file you are using is read-only, which means that you cannot change it from it’s original form.  For each vendor, you will need to open the read-only form and save as a new file name.

Deleting Extra Pages:

If you do not need all four pages for a vendor, you can right mouse click on the page tab at the bottom of the screen and choose delete.  Deleting unnecessary pages is helpful to avoid printing those pages and providing the correct page number information in the footer.   If more than four pages are needed for a vendor contact Tom Stauffer (tom_stauffer@solanco.k12.pa.us) with your request.

Printing:

If you are printing more than “Page1” for a vendor, use file > print and select the entire workbook.  By selecting entire workbook the correct page numbers will be inserted automatically into the footer.

If you only need “Page1” you can use the printer icon.