ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Create Website Budget in this worksheet. Helpful instructions on how to use this worksheet are in cells in this column. Arrow down to get started.
2
Enter Company Name in cell at right.
Woodland PTO
3
Title of this worksheet is in cell at right.
Annual Planning Budget Worksheet for 7/1/2022-6/30/2023 Fiscal Year
4
Enter Date in cell at right.
7/8/2026
5
6
*Deducted 21/22 gross by 20% for these column
7
Enter details in Benefits table starting in cell at right. Next instruction is in cell A24.
IncomeActual Revenue 2021/22Actual Expense 2021/22Estimated Revenue 2022/23
Estimated Expense 2022/23
8
Checking balance as of 9/10/2022$30,884.98
9
Savings balance as of 9/10/2022$59,638.32
10
Total Balance$90,523.30
11
12
 FundraisersRevenue 21-22Expense 21-22 *Estimated Revenue 22-23
Estimated Expense 22-23
13
Book Fair$886.44 ($790.00)$709.15 ($632.00)
14
Butter Braid & Pizza Sales - Fall$3,083.74 ($219.74)$2,466.99 ($175.79)
15
Carnival & Raffle$7,205.75 ($1,200.00)$5,764.60 ($960.00)
16
Family Dance $416.52 ($887.00)$333.22 ($709.60)
17
Food Trucks$890.00 $0.00 $712.00 $0.00
18
Fun Run (September)$31,907.41 ($2,936.09)$25,525.93 ($2,348.87)
19
Holiday Shop$2,642.50 ($1,745.81)$2,114.00 ($1,396.65)
20
Monthly Family Dinners$1,471.02 $0.00 $1,176.82 $0.00
21
Paint A Tile$955.85 ($757.60)$764.68 ($606.08)
22
Readathon$747.00 ($659.84)$597.60 ($527.87)
23
Enter details in Costs table starting in cell at right. Values are auto calculated in cells containing formulae. Next instruction is in cell A32.
School Supply Kits$435.00 $0.00 $348.00 $0.00
24
T-Shirt Sponsorships$4,150.00 ($4,252.50)$3,320.00 ($3,402.00)
25
Turkey Bingo & Silent Auction$8,962.65 ($3,111.15)$7,170.12 ($2,488.92)
26
STEM/STEAM night$0.00 $0.00 $0.00 ($900.00)
$1,400 total estimated cost for free event. $900 expense (possbly fundraise for the rest). Osseo Lions Club Chck for $500 applied
27
Total Fundraising$63,753.88 ($16,559.73)$51,003.10 ($14,147.78)
28
 Grants
29
Walmart$500.00 $0.00 $500.00 $0.00
30
Brooklyn Park American Legion$1,500.00 $0.00 $1,500.00 $0.00
31
Kwik Trip$2,500.00 $0.00 $1,500.00 $0.00
32
Total Grants$4,500.00 $0.00 $3,500.00 $0.00
33
Total Income$68,253.88 ($16,559.73)$54,503.10 ($14,147.78)
34
35
36
37
38
39
Expenses
Actual Expense 2021/22 (% of total)
Actual Expense 2021/22
Estimated Expense 2022/23 (% of total)
Estimated Expense 2022/23
40
Funds for Staffing
41
Values are auto calculated in Totals table starting in cell at right. Next instruction is in cell A49.
ESP & Volunteer Coordinator0% 19,448.00 100% 10,350.00
42
23%Total Funds for Staffing0% 19,448.00 100% 10,350.00 10,350.00 -
43
Funds for Fun
44
Brooklyn Middle School Panel0% 50.00 1% 87.00
45
Basketball Hoops0% 11,271.00 0% -
46
Ice Cream Social0% 200.00 1% 200.00
47
Movie Night0% 125.00 1% 125.00
48
Staff Appreciation0% 1,500.00 19% 2,500.00
49
Other Remaining0% - 78% 10,588.00
50
30%Total Funds for Fun0% 13,146.00 100% 13,500.00 13,500.00 -
51
Funds for the Future
52
Other Remaining0% - 100% 5,400.00
53
12%Total Funds for the Future0% - 100% 5,400.00 5,400.00 -
54
Funds for Projects & Requests (to now include Woodland requests)
55
5th grade to BMS orientation0% - 2% 250.00
56
Choir 0% - 6% 1,000.00
57
PTO Expenses (paid to Woodland)10% 600.00 3% 400.00
58
Reading Program 13% 800.00 4% 600.00
59
Teacher Supplies48% 2,990.00 20% 3,200.00
60
5th Grade commemoration8% 500.00 3% 500.00
61
School Patrol - end of year event5% 300.00 2% 250.00
62
School Wide Enrichment/Curriculum16% 1,000.00 0% -
63
Funds for Staff Survey Results0% 1.00 3% 500.00
64
 IXL (interactive online learning) 0% - 51% 8,000.00
Approved $10K, *already paid this came in at $8,000
Kindergarten and First Grades made their choices instead of IXL. Kindergarten chose Starfall and First Grade chose Reading A-Z. All told, the amount to the school for those choices and IXL for grades 2-5 should be $8000. Will you be able to cut a check to the school this week so that we can order before the end of
65
Other Remaining0% - 7% 1,050.00
66
35%Total Funds for Projects & Requests100% 6,191.00 100% 15,750.00 15,750.00 (0.00)
67
Total Expense 38,785.00 $45,000.00
68
 PTO OperationExpense 21-22 (% of total) Expense 21-22
Estimated Expense 22-23 (% of total)
Estimated Expense 22-23
69
Required Carryover 1 1/2 X Budget - Per Bylaws
70
Bank Charges0% - 0% -
71
Directories0% - 22% 500.00
co that does it for free? Fun2Raise
72
Paper & Copy Charges0% - 13% 300.00
73
Postage0% - 4% 100.00
74
Marketing Materials0% - 9% 200.00
75
Donation to Police Reserves-4 Events100% 300.00 13% 300.00
$75 per event, need to increase to $300 (TB, Holiday, Carnival, Family Dance). Paid $600 on 10/19 to cover 2022/2023 event coveragre $75X8 = $600
76
Other Supplies0% - 0% -
77
Insurance0% - 0% -
78
Zoom Software0% - 5% 104.93
Approved $200, Actuals - $104.93 (30% discount), will renew annually in Sept
79
Meeting Materials (meeting treats, new family welcome, etc.)0% - 22% 500.00
80
Volunteer Recognition0% - 4% 100.00
81
Evaluation Metrics are auto calculated in Metrics table starting in cell at right.
Appreciation Rewards0% - 4% 100.00
82
Leadership Education (PTO Today Membership, Expo)0% - 4% 100.00
83
Total Operations100% 300.00 100% 2,304.93
84
Total Costs 39,085.00 $47,304.93
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100