Insert Title
EDD/731 v8
Budget Worksheet and Template
EDD/731 v8
Page 3 of 3
Budget Worksheet and Template
Use this sheet to calculate prior year (PY) and cu
ent year (CY) revenue, expenditures, fund balances, operational balances, and budget balance. You may move or add items as necessary.
No. of students (__) x ($_______ / student) = State foundation funding = _____________
Local Taxes
Amount
Quantity of maintenance and operation mills
Quantity of debt service mills
Quantity of capital outlay mills
Total millage
Assessed valuation
Bonded debt
Fund 1: Salary
Category
PY Actual
CY Budget
Beginning balance
0.00
0.00
Total revenue
0.00
0.00
Total expenditure
Total transfers
Ending balance
Full-time equivalents
1,815
Average teacher salary
45,897
Fund 2: Operating
Category
PY Actual
CY Budget
Beginning balance
Total revenue
Total expenditure
Total transfers
Ending balance
Fund 3: Building and Construction
Category
PY Actual
CY Budget
Beginning balance
Total revenue
Total expenditure
Total transfers
Ending balance—building and construction is part of capital outlay
Fund 4: Debt Service
Category
PY Actual
CY Budget
Beginning balance
Total revenue
Total expenditure
Total transfers
Ending balance
Fund 5: Capital Outlay
Category
PY Actual
CY Budget
Beginning balance
Total revenue
Total expenditure
Total transfers
Ending balance
Fund 6: Federal Grants
Category
PY Actual
CY Budget
Beginning balance
Total revenue
Total expenditure
Total transfers
Ending balance
Fund 7: Activity
Category
PY Actual
CY Budget
Beginning balance
Total revenue
Total expenditure
Total transfers
Ending balance
Fund 8: Food Service
Category
PY Actual
CY Budget
Beginning balance
Total revenue
Total expenditure
Total transfers
Ending balance
Fund 9: Fixed Assets
Category
PY Actual
CY Budget
Beginning balance
Total revenue
Total expenditure
Total transfers
Ending balance
Copyright 2020 by University of Phoenix. All rights reserved.
Copyright2020 by University of Phoenix. All rights reserved.
Insert Title
EDD/731 v8
Personal Planning Document
EDD/731 v8
Page 2 of 2
Personal Planning Document
Use this document as a time-management tool to organize your work andserve as a checklist for a budget proposal. The tasks and milestones in the table below should be completed in a 3-month period.Use the information provided in the textbook readings to guide your completion dates.
Tasks and Milestones
Due Date for Completion
Administrator seeks input from the board, faculty, the community, andother administrators about needs for the upcoming year’s budget.
Administrator discusses needs for upcoming year’s budget with other administrators.
Administrator analyzes the cu
ent year’s (CY) performance and ending balances of projects.
Administrator discusses projected CYending balances with the school board.
Milestone: Administrator completes the administrative analysis of the prior fiscal year’s ending balances and of the anticipated needs for the upcoming fiscal year.
Administrator assembles pertinent state aid notices, debt service schedules, and other supportive documents from the prior year fromthe bank or fiscal agent.
Milestone: Administrator completes the budget template in draft form.
Administrator makes modifications to the revenues and expenditures on the draft form of the budget to make it balance.
Bookkeeper or treasurer enters revenue, expenditures, and debt service items from the budget—coding items according to federal and state guidelines—into an electronic database or network.
Bookkeeper submits paper copies of the electronic budget proposal to the administrator for review.
Administrator performs the final review of the proposed budget draft.
Milestone: Preliminary draft of the budget is copied and mailed to board members for review.
Must be 30 days before proposal presentation.
Administrator prepares a Microsoft®PowerPoint® presentation for the school board.
Milestone: Administrator presents budget proposal to the board of education or the trustees for approval.
Treasurer submits final board-approved budget electronically to the state education agency before the legal deadline for submission.
Technology Director posts board-approved budget on the district’s or college’s website.
Copyright 2020 by University of Phoenix. All rights reserved.
Copyright2020 by University of Phoenix. All rights reserved.
Insert Title
EDD/731 v8
Budget Goals Worksheet
EDD/731 v8
Page 2 of 2
Budget Goals Worksheet
Use this worksheet as a planning tool to establish financial goals for each category.
Fund 1: Teacher Salary
Budget Goals
1.
2.
3.
Fund 2: Operating
Budget Goals
1.
2.
3.
Fund 3: Building and Construction
Budget Goals
1.
2.
3.
Fund 4: Debt Service
Budget Goals
1.
2.
3.
Fund 5: Capital Outlay
Budget Goals
1.
2.
3.
Fund 6: Federal Grants
Budget Goals
1.
2.
3.
Fund 7: Activity
Budget Goals
1.
2.
3.
Fund 8: Food Service
Budget Goals
1.
2.
3.
Fund 9: Fixed Assets
Budget Goals
1.
2.
3.
Copyright 2020 by University of Phoenix. All rights reserved.
Copyright2020 by University of Phoenix. All rights reserved.
F-195 TABLE OF CONTENTS
Fiscal Year XXXXXXXXXX
Detail of Outstanding Bonds DS4
Revenue Worksheet: Local Excess Levies and Timber Excise Tax DS3
Summary of Capital Projects Fund CP1
Capital Projects Fund Budget
Revenues and Other Financing Sources DS2
Summary of Associated Student Body Fund ASB1
Long-Term Financing: Condition Sales Contract TVF4
Summary of Debt Service Fund DS1
Debt Service Fund Budget
Transportation Vehicle Fund Budget
Long-Term Financing: Conditional Sales Contracts CP9
Revenue Worksheet: Local Excess Levies and Timber Excise Tax TVF3
Summary of Transportation Vehicle Fund TVF1
Salary Exhibit: Classified Employees CP8
Revenue Worksheet: Local Excess Levies and Timber Excise Tax CP5
Revenues and Other Financing Sources CP3
Salary Exhibt: Certificated Employees CP7
Description of Projects CP6
Summary of General Fund GF2
Enrollment and Staff Counts GF1
Expenditure by Program GF8
Revenues and Other Financing Sources GF4
Financial Summary Budget Summary
Budget and Excess Levy Certification Certification Page
Associated Student Body Fund Budget
General Fund Budget
Budget and Excess Levy Summary Fund Summary
Revenue Worksheet: Local Excess Levies and Timber Excise Tax GF13
Activity Summary GF11
Certificated/Classified Staff Counts by Activity GF15
Long-Term Financing: Conditional Sales Contract GF14
Objects of Expenditure GF10
Program Matrices GF9-XX
Program Summary by Object of Expenditure GF9
Salary Exhibits: Classified Employees GF9-301-XX
Salary Exhibits: Certificated Employees GF9-201-XX
REPORT TITLE PAGE NUMBER
Run: 7/10/2018 12:52:28 PM
Port Townsend School District No.050
FY XXXXXXXXXX
Form F-195 Fund SummaryPage 1 of 1
002,750,000XXXX3,880,000
00000
00003,880,000
63,500543,1531,535,309340,7901,039,030
213,0008,229,0001,270,000328,0001,200,000
-149,500-7,685,847265,30912,790-160,970
000XXXX0
0117,8750XXXX0
250,0008,229,0002,556,075268,61018,004,826
100,500661,0282,821,384281,40017,843,856
Net excess levy amount for 2019 collection
after rollback
Rollback mandated by school district Board
of Directors 1
Excess levies approved by voters for 2019
collection
Ending Total Fund Balance
Beginning Total Fund Balance
Excess of Revenues/Other Financing Sources
Ove
(Under) Expenditures and Other
Financing Uses
Other Financing Uses (G.L. 535)
Other Financing Uses--Transfers Out (G.L.
536)
Total Appropriation (Expenditures)
Total Revenues and Other Financing Sources
Transportation
Vehicle Fund
Capital
Projects Fund
Debt Service
Fund
Associated
Student Body
FundGeneral Fund
BUDGET AND EXCESS LEVY SUMMARY
1/ Rollback of levies needs to be certified pursuant to RCW XXXXXXXXXXPlease do NOT include such resolution as part of this document.
Run: 7/10/2018 12:52:29 PM
Port Townsend School District No.050
GENERAL FUND FINANCIAL SUMMARY
FY XXXXXXXXXX
Form F-195 Budget SummaryPage 1 of 2
16.112,899, XXXXXXXXXX,435, XXXXXXXXXX,393,474
36.596,588, XXXXXXXXXX,084, XXXXXXXXXX,386,871
XXXXXXXXXX,004, XXXXXXXXXX,417, XXXXXXXXXX,056,597
8.831,590, XXXXXXXXXX,502, XXXXXXXXXX,347,364
4.08734, XXXXXXXXXX, XXXXXXXXXX,253
15.882,859, XXXXXXXXXX,323, XXXXXXXXXX,344,071
9.191,655, XXXXXXXXXX,280, XXXXXXXXXX,446,486
62.0111,164, XXXXXXXXXX,570, XXXXXXXXXX,214,424
XXXXXXXXXX,004, XXXXXXXXXX,417, XXXXXXXXXX,056,597
23.874,296, XXXXXXXXXX,608, XXXXXXXXXX,490,307
0.0814, XXXXXXXXXX, XXXXXXXXXX,625
4.61830, XXXXXXXXXX,395, XXXXXXXXXX,292
7.031,265, XXXXXXXXXX, XXXXXXXXXX,864
XXXXXXXXXX
3.06550, XXXXXXXXXX, XXXXXXXXXX,437
16.472,965, XXXXXXXXXX,718, XXXXXXXXXX,593,015
XXXXXXXXXX
44.898,082, XXXXXXXXXX,364, XXXXXXXXXX,348,057
1,039,030667,009913,035
1,200,000775,000750,431
18,004,82616,417,83215,056,597
17,843,85616,309,84115,219,201
XXXXXXXXXX
XXXXXXXXXX
1,158.001,113.801,147.42
Classified Salaries
Certificated Salaries
EXPENDITURE SUMMARY BY OBJECTS
Total - Activity Groups
Central Administration
Building Administration
Other Supportive Activities
Teaching Support
Teaching Activities
EXPENDITURE SUMMARY BY
ACTIVITY GROUPS
Total - Program Groups
Support Services
Community Services
Other Instructional Programs
Compensatory Education
Skill Center Instruction
Vocational Instruction
Special Education Instruction
Federal Stimulus
Regular Instruction
EXPENDITURE SUMMARY BY PROGRAM
GROUPS
Total Ending Fund Balance
Total Beginning Fund Balance
Total Expenditures
Total Revenues and Other
Financing Sources
FINANCIAL SUMMARY
FTE Classified Employees
FTE Certificated Employees
Total K-12 FTE Enrollment
Counts
ENROLLMENT AND STAFFING
SUMMARY
Run: 7/10/2018 12:52:29 PM
Port Townsend School District No.050
GENERAL FUND FINANCIAL SUMMARY
FY XXXXXXXXXX
Form F-195 Budget SummaryPage 2 of 2
XXXXXXXXXX,004, XXXXXXXXXX,417, XXXXXXXXXX,056,597
0.91164, XXXXXXXXXX, XXXXXXXXXX,633
0.2138, XXXXXXXXXX, XXXXXXXXXX,855
18.453,322, XXXXXXXXXX,261, XXXXXXXXXX,978,244
5.46983, XXXXXXXXXX, XXXXXXXXXX,702
22.264,008, XXXXXXXXXX,545, XXXXXXXXXX,352,819
Total - Objects
Capital Outlay
Travel
Purchased Services
Supplies, Instructional
Resources and Noncapitalized
Items
Employee Benefits and Payroll
Taxes
Run: 7/10/2018 12:52:30 PM
Port Townsend School District No.050
FY XXXXXXXXXX
Form F-195 GF1Page 1 of 1
XXXXXXXXXX
XXXXXXXXXX
1,158.001,113.801,147.42
XXXXXXXXXX
XXXXXXXXXX
XXXXXXXXXX
1,056.001,011.801,044.11
XXXXXXXXXX
XXXXXXXXXX
XXXXXXXXXX
XXXXXXXXXX
XXXXXXXXXX
XXXXXXXXXX
XXXXXXXXXX
XXXXXXXXXX
XXXXXXXXXX
XXXXXXXXXX
XXXXXXXXXX
XXXXXXXXXX
XXXXXXXXXX
2. General Fund FTE Classified Employees /4
1. General Fund FTE Certificated Employees /4
B. STAFF COUNTS (calculate to three decimal places)
18. TOTAL K-12
17. ALE Enrollment
16. Dropout Reengagement Enrollment
15. Running Start
14. SUBTOTAL
13. Grade 12 (excluding Running Start)
12. Grade 11 (excluding Running Start)
11. Grade 10
10. Grade 9
9. Grade 8
8. Grade 7
7. Grade 6
6. Grade 5