| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Revenue | Category | Details | $ Budgeted | Payments To Date | Balance | Status | Notes | Variance to Budget | |||||||||||||||||
2 | Required Vertical Raise | Group Fundraiser | $ 9,900.00 | $ 10,200.00 | $ 300.00 | Complete | $ 300.00 | |||||||||||||||||||
3 | Pizza Ranch * 2 | Group Fundraiser | Group Fundraiser (Elk River 11/6/2023 & Andover - 9/2023) | $ 1,000.00 | $ 1,136.11 | $ 136.11 | Complete | $ 136.11 | ||||||||||||||||||
4 | Nowthen Threshing Show | Group Fundraiser | Ticket Sales + Flea Market | $ 1,800.00 | $ 1,800.00 | $ - | Complete | $ - | ||||||||||||||||||
5 | State Fair Spoons | Group Fundraiser | Aug-23 | $ 1,000.00 | $ 1,000.00 | $ - | Complete | $ - | ||||||||||||||||||
6 | Pancake Breakfast | Group Fundraiser | 12/3/2023 Group Fundraiser (Meals + ALL fundraisers except $10 raffle) | $ 2,000.00 | $ 1,507.00 | $ (493.00) | In Process | Have not received invoice for Legion yet | ||||||||||||||||||
7 | Raffle Tickets Split with Vocalocity | Group Fundraiser | $10 Raffel tickets, Split 10K each vocalocity and BSS (cost 120.77each) | $ 9,880.34 | $ 2,900.00 | $ (6,980.34) | on track | current cash turned in as of 12/17 | ||||||||||||||||||
8 | Show Choir Preview Show Revenue | Group Fundraiser | 1/6/2024 w/Spagetti Dinner 15 adult tickets, $12 Kid) | $ 5,000.00 | $ (5,000.00) | Future | ||||||||||||||||||||
9 | Show Choir Showcase Revenue | Group Fundraiser | 2/29/2024 Post Show | $ 3,000.00 | $ (3,000.00) | Future | ||||||||||||||||||||
10 | Other Booster Fundraisers | Group Fundraiser | Group Fundraiser | $ 5,000.00 | $ 211.00 | $ (4,789.00) | In Process | Raise Right group profit | ||||||||||||||||||
11 | Corporate Sponsorships | Donation | Letters sent and distributed to members | $ 5,000.00 | $ 1,000.00 | $ (4,000.00) | In Process | |||||||||||||||||||
12 | BSS Singer/Dancer Fees Includes Volunteer Hour requirement | Student Fees | 33 @ $1200 (7 month season with 10 hour minimum volunteer hrs) | $ 39,600.00 | $ 19,427.45 | $ (20,172.55) | On Track | 5 Students have quit | $ (2,100.00) | |||||||||||||||||
13 | Show Band Fees (Includes Achieving Dreams Expectations) | Student Fees | 9 @ $600 | $ 5,400.00 | $ (5,400.00) | Delayed | only 2 band members | $ (4,200.00) | ||||||||||||||||||
14 | Crew Only Fees | Student Fees | 5 @ $300 | $ 1,500.00 | $ (1,500.00) | on track | Crew signup occurring December | |||||||||||||||||||
15 | Costume Sales | Group Fundraiser | (estimated @ 1/3 cost) | $ 5,040.00 | $ 493.00 | $ (4,547.00) | Delayed | |||||||||||||||||||
16 | Booster Contribution | Donation | Approve additional funds as requested | $ 864.49 | $ 864.49 | $ - | On Track | |||||||||||||||||||
17 | TOTAL | $ 95,984.83 | $ 40,539.05 | $ (55,445.78) | Variance to Budget | $ (5,863.89) | ||||||||||||||||||||
18 | ||||||||||||||||||||||||||
19 | Expenses | Category | Details/Description | $ Budgeted | Payments To Date | Balance | Status | Notes | Variance to Budget | |||||||||||||||||
20 | Choreography | Professional Fees | Jeremiah Lewis Walker hrly and travel | $ 6,000.00 | $ 4,000.00 | $ (2,000.00) | On Track | Per invoice: ? January, and Febuary? | ||||||||||||||||||
21 | Bridge Street Director / Manager | Professional Fees | Ian Stillmunks Monthly (9, 10, 11 paid) | $ 6,000.00 | $ 3,000.00 | $ (3,000.00) | On Track | Final 3 Payments Due 12/15, 1/15 , 2/15 | ||||||||||||||||||
22 | BSS Assistant Director | Professional Fees | Olivia Steffl Pay da y 12/20,1/17, 2/14, 3/6 @ $500 each | $ 2,000.00 | $ (2,000.00) | On Track | 4 Payments Plan 12/15, 1/17, 2/15, 3/6 | |||||||||||||||||||
23 | Show Band Director | Professional Fees | Ian Stillmunks | $ 3,000.00 | $ (3,000.00) | On Track | 3 Payments Plan 1/17 , 2/15, 3/10 | |||||||||||||||||||
24 | Showchoir Interns | Professional Fees | NA | $ - | $ - | |||||||||||||||||||||
25 | Show Choir Accompanist | Professional Fees | May need to hire, approval will be needed | $ - | $ - | |||||||||||||||||||||
26 | Clinitians/Specialists | Professional Fees | anticipate redistribution - choreo and acompanist with approval | $ 4,000.00 | $ (4,000.00) | |||||||||||||||||||||
27 | Transportation | Transportation | EST from Holt-Peterson (Lorenze 2655 more overall) | $ 25,000.00 | $ 2,142.62 | $ (22,857.38) | In process | Total season ESTIMATE $7240 favorable to budget. Plus canceled overnight SD +$250 | $ 7,590.00 | |||||||||||||||||
28 | Trailer rental/gas | Transportation | Will only need gas, have trailer. | $ 2,000.00 | $ (2,000.00) | |||||||||||||||||||||
29 | Hotel Stays | Papillion (NE)/ Sioux Falls,SD | $ 5,000.00 | $ (5,000.00) | NE est $2000 Making SD a day trip to save $. | $ 3,000.00 | ||||||||||||||||||||
30 | Competition Entrance Fees | Competition Fees | 7 of 7 paid | $ 3,000.00 | $ 2,250.00 | $ (750.00) | Complete | Favorable to budget by $750 | $ 750.00 | |||||||||||||||||
31 | Costumes | Costumes | $7178 Dance Sophisticates | $ 12,375.00 | $ 12,345.81 | $ (29.19) | In Process | multiple returns in process | ||||||||||||||||||
32 | Music | Music Compsositin and Licensing | Arrangement 5 songs @ $600ea plus licensing Mary Ann Sims | $ 5,500.00 | $ 5,860.00 | $ 360.00 | Complete | Unfavorable to budget by $360 | $ (360.00) | |||||||||||||||||
33 | SpiritWear | Costumes | T-shirts w/names | $ 825.00 | $ (825.00) | In process | ||||||||||||||||||||
34 | Sets/props | Props | Construction. Repairs | $ 1,500.00 | $ 546.37 | $ (953.63) | In process | |||||||||||||||||||
35 | Instrumental Replacement | Supply Expense | $ 500.00 | $ (500.00) | ||||||||||||||||||||||
36 | Sewing Supplies | Supply Expense | $ 500.00 | $ (500.00) | ||||||||||||||||||||||
37 | Student Supplies | Supply Expense | $ 250.00 | $ (250.00) | ||||||||||||||||||||||
38 | Retreat Meals | Student Meals | Boosters to provide | $ - | $ 864.49 | $ 864.49 | In process | |||||||||||||||||||
39 | Miscellaneous | Other | $ 1,000.00 | $ (1,000.00) | ||||||||||||||||||||||
40 | Space Rental/Custodial Fees | Space Rental Fees | $ 5,000.00 | $ 47.50 | $ (4,952.50) | In process | ||||||||||||||||||||
41 | TOTAL EXPENSES | $ 83,450.00 | $ 31,056.79 | $ (52,393.21) | Current Variance of Expenses to Budget | $ 10,980.00 | ||||||||||||||||||||
42 | Current Variance of Revenue to Budget | $ (5,863.89) | ||||||||||||||||||||||||
43 | As of 12/17/2023 | Show Choir Budget | Current Projection is favorable to budget | $ 5,116.11 | ||||||||||||||||||||||
44 | ||||||||||||||||||||||||||
45 | INDIVIDUAL STUDENT FUNDRAISERS THIS SEASON TO DATE | BANK ACCOUNTS | BALANCE | |||||||||||||||||||||||
46 | Fundraiser | Total Made to date | Notes | Choir Booster Account: | AS OF 12/16/23 | |||||||||||||||||||||
47 | Football Concessions | $2,292.03 | Total profits divided by total hours worked for $/hr rate. Student earnings attributed to students by hours worked. 9 total students worked. | Booster Account is for Booster dollars made by group fundraisers, also contributes and consists of dollars related to Madrigal Choir expenses and revenue. Expenses paid must be on approved budget or approved by boosters. | $ 11,916.02 | |||||||||||||||||||||
48 | Raise Right Gift Cards | $90.61 | based on student sales | Show Choir Account | ||||||||||||||||||||||
49 | Cub Foods - Bag Groceries | 1507.94 | 3 events. Each event total made divided by hours worked, students receive $/hour worked. AVG $100 per kid per event | Show Choir Financials Only. Expenses for showchoir paid must be on approved budget or approved by boosters. Revenue from show choir also received into this account. | $ 3,951.82 | |||||||||||||||||||||
50 | Texas Road House | $420 | event complete - check coming | Student Accounts: | ||||||||||||||||||||||
51 | Achieving Dreams | Unknown | Totals kept with Achieving dreams students can make 90-180+ per event. | Treasurer Jill Manners manages the actual bank account. No individual student balances. Individual Student account balances are managed by Shelly Mattison. Student raised funds via individual fundraisers kept here. Balance can be carried over throughout High Shool Years. Funds can be utilized toward any curricular choir, showchoir, madrigals fees, field trips, choir banquet etc. | $ 16,316.37 | |||||||||||||||||||||
52 | ||||||||||||||||||||||||||
53 | ||||||||||||||||||||||||||
54 | ||||||||||||||||||||||||||
55 | ||||||||||||||||||||||||||
56 | ||||||||||||||||||||||||||
57 | ||||||||||||||||||||||||||
58 | ||||||||||||||||||||||||||
59 | ||||||||||||||||||||||||||
60 | ||||||||||||||||||||||||||
61 | ||||||||||||||||||||||||||
62 | ||||||||||||||||||||||||||
63 | ||||||||||||||||||||||||||
64 | ||||||||||||||||||||||||||
65 | ||||||||||||||||||||||||||
66 | ||||||||||||||||||||||||||
67 | ||||||||||||||||||||||||||
68 | ||||||||||||||||||||||||||
69 | ||||||||||||||||||||||||||
70 | ||||||||||||||||||||||||||
71 | ||||||||||||||||||||||||||
72 | ||||||||||||||||||||||||||
73 | ||||||||||||||||||||||||||
74 | ||||||||||||||||||||||||||
75 | ||||||||||||||||||||||||||
76 | ||||||||||||||||||||||||||
77 | ||||||||||||||||||||||||||
78 | ||||||||||||||||||||||||||
79 | ||||||||||||||||||||||||||
80 | ||||||||||||||||||||||||||
81 | ||||||||||||||||||||||||||
82 | ||||||||||||||||||||||||||
83 | ||||||||||||||||||||||||||
84 | ||||||||||||||||||||||||||
85 | ||||||||||||||||||||||||||
86 | ||||||||||||||||||||||||||
87 | ||||||||||||||||||||||||||
88 | ||||||||||||||||||||||||||
89 | ||||||||||||||||||||||||||
90 | ||||||||||||||||||||||||||
91 | ||||||||||||||||||||||||||
92 | ||||||||||||||||||||||||||
93 | ||||||||||||||||||||||||||
94 | ||||||||||||||||||||||||||
95 | ||||||||||||||||||||||||||
96 | ||||||||||||||||||||||||||
97 | ||||||||||||||||||||||||||
98 | ||||||||||||||||||||||||||
99 | ||||||||||||||||||||||||||
100 | ||||||||||||||||||||||||||