| 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 | AA | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Must Fund | Total Cost | Running Cost | Cost Per Scout | Popcorn Sales | Popcorn Sales Per Scout | Award Cost | Cost Per Award | Required # | Elective # | Cost of Required Awards | Cost of Elective Awards | 75% of Electives Cost | Total Cost Per Scout | Total Cost Per Scout 75% Electives | ||||||||||||
2 | Checks Reorder | $20.00 | $20.00 | $0.74 | $57.14 | $2.12 | Lion | $2.19 | 6 | 16 | $13.14 | $35.04 | $23.36 | $48.18 | $36.50 | ||||||||||||
3 | Popcorn Expenses | $75.00 | $95.00 | $2.78 | $271.43 | $10.05 | Tiger | $2.19 | 6 | 20 | $13.14 | $43.80 | $29.20 | $56.94 | $42.34 | ||||||||||||
4 | Prizes (Popcorn) | $750.00 | $845.00 | $27.78 | $2,414.29 | $89.42 | Wolf | $2.19 | 6 | 20 | $13.14 | $43.80 | $29.20 | $56.94 | $42.34 | ||||||||||||
5 | Gift Cards (Popcorn) | $750.00 | $1,595.00 | $27.78 | $4,557.14 | $168.78 | Bear | $2.19 | 6 | 20 | $13.14 | $43.80 | $29.20 | $56.94 | $42.34 | ||||||||||||
6 | WEBELOS | $2.79 | 6 | 20 | $16.74 | $55.80 | $37.20 | $72.54 | $53.94 | ||||||||||||||||||
7 | Base Scouting | AOL | $2.79 | 6 | 16 | $16.74 | $44.64 | $29.76 | $61.38 | $46.50 | |||||||||||||||||
8 | Leader Dues for Recharter | $880.00 | $2,475.00 | $32.59 | $7,071.43 | $261.90 | |||||||||||||||||||||
9 | Pack Meetings | $100.00 | $2,575.00 | $3.70 | $7,357.14 | $272.49 | Den Budgets | Allocated | Spent | Remaining | |||||||||||||||||
10 | Den Budgets | $1,290.00 | $3,865.00 | $47.78 | $11,042.86 | $408.99 | |||||||||||||||||||||
11 | Health and Safety Supplies | $0.00 | $3,865.00 | $0.00 | $11,042.86 | $408.99 | Lion Den, $20/Scout | $20.00 | $0.00 | $20.00 | |||||||||||||||||
12 | Patches | $168.75 | $4,033.75 | $6.25 | $11,525.00 | $426.85 | Tiger, $50+ $20/Scout | $150.00 | $0.00 | $150.00 | |||||||||||||||||
13 | Belt Loops, Pins | $1,231.02 | $5,264.77 | $45.59 | $15,042.20 | $557.12 | Wolf, $100+ $20/Scout | $140.00 | $0.00 | $140.00 | |||||||||||||||||
14 | AOL Ceremony & Awards | $271.50 | $5,536.27 | $10.06 | $15,817.91 | $585.85 | Bear, $150+ $20/Scout | $330.00 | $0.00 | $330.00 | |||||||||||||||||
15 | Rank Advancement Ceremony | $445.83 | $5,982.10 | $16.51 | $17,091.71 | $633.03 | Webelos, $200+ $20/Scout | $340.00 | $0.00 | $340.00 | |||||||||||||||||
16 | Recruiting & Norton Night | $25.00 | $6,007.10 | $0.93 | $17,163.14 | $635.67 | AOL, $250+ $20/Scout | $310.00 | $0.00 | $310.00 | |||||||||||||||||
17 | Den Yearly Startup Restock | $0.00 | $6,007.10 | $0.00 | $17,163.14 | $635.67 | Total | $1,290.00 | $0.00 | $1,290.00 | |||||||||||||||||
18 | Blue & Gold Party | $500.00 | $6,507.10 | $18.52 | $18,591.71 | $688.58 | |||||||||||||||||||||
19 | Printing and Supplies | $50.00 | $6,557.10 | $1.85 | $18,734.57 | $693.87 | |||||||||||||||||||||
20 | Service Projects | $150.00 | $6,707.10 | $5.56 | $19,163.14 | $709.75 | Patches | Quantity | Cost | Total | |||||||||||||||||
21 | |||||||||||||||||||||||||||
22 | Nice to Fund | Pinewood Derby | 27 | $2.50 | $67.50 | ||||||||||||||||||||||
23 | Pinewood Derby Event | $150.00 | $6,857.10 | $5.56 | $19,591.71 | $725.62 | Winter Campout | 14 | $2.50 | $33.75 | |||||||||||||||||
24 | Space Derby | $75.00 | $6,932.10 | $2.78 | $19,806.00 | $733.56 | Rocket Derby | 14 | $2.50 | $33.75 | |||||||||||||||||
25 | Fishing Derby | $75.00 | $7,007.10 | $2.78 | $20,020.29 | $741.49 | Raingutter Regatta? | 14 | $2.50 | $33.75 | |||||||||||||||||
26 | Raingutter Regatta | $75.00 | $7,082.10 | $2.78 | $20,234.57 | $749.43 | $0.00 | $0.00 | |||||||||||||||||||
27 | Pinewood Derby Kits | $9.00 | $7,091.10 | $0.33 | $20,260.29 | $750.38 | $0.00 | $0.00 | |||||||||||||||||||
28 | Space Derby Kits | $10.00 | $7,101.10 | $0.37 | $20,288.86 | $751.44 | Total | 68 | $10.00 | $168.75 | |||||||||||||||||
29 | Raingutter Regatta Kits | $0.00 | $7,101.10 | $0.00 | $20,288.86 | $751.44 | |||||||||||||||||||||
30 | Fall Campout | $300.00 | $7,401.10 | $11.11 | $21,146.00 | $783.19 | |||||||||||||||||||||
31 | Winter Campout (Dunkin Lodge) | $600.00 | $8,001.10 | $22.22 | $22,860.29 | $846.68 | AOL Awards/Ceremony | Quantity | Cost | Total | |||||||||||||||||
32 | Spring Campout | $400.00 | $8,401.10 | $14.81 | $24,003.14 | $889.01 | |||||||||||||||||||||
33 | 4th of July Parade | $250.00 | $8,651.10 | $9.26 | $24,717.43 | $915.46 | Arrow | 3 | $50.00 | $150.00 | |||||||||||||||||
34 | Popcorn Party | $200.00 | $8,851.10 | $7.41 | $25,288.86 | $936.62 | Thread | 3 | $3.00 | $9.00 | |||||||||||||||||
35 | Kittan District Day Camp | $1,687.50 | $10,538.60 | $62.50 | $30,110.29 | $1,115.20 | Stickers | 0 | $0.00 | $0.00 | |||||||||||||||||
36 | WEBELOS Camp | $0.00 | $10,538.60 | $0.00 | $30,110.29 | $1,115.20 | BSA Book | 3 | $25.00 | $75.00 | |||||||||||||||||
37 | Class B Shirts | $0.00 | $10,538.60 | $0.00 | $30,110.29 | $1,115.20 | BSA Book Cover | 3 | $12.50 | $37.50 | |||||||||||||||||
38 | Scholarship | $0.00 | $10,538.60 | $0.00 | $30,110.29 | $1,115.20 | $0.00 | $0.00 | |||||||||||||||||||
39 | Scout Dues for Recharter | $0.00 | $10,538.60 | $0.00 | $30,110.29 | $1,115.20 | Total | $90.50 | $271.50 | ||||||||||||||||||
40 | |||||||||||||||||||||||||||
41 | |||||||||||||||||||||||||||
42 | Number of Scouts | 27 | Event/Item | Cost | Advancement | Quantity | Cost | Total | |||||||||||||||||||
43 | Number of Leaders | 11 | Pinewood Derby Kit | $9.00 | |||||||||||||||||||||||
44 | Den Leaders | 9 | Space Derby Kit | $8.00 | Rank Patches | 27 | $3.29 | $88.83 | |||||||||||||||||||
45 | Number of Dens | 6 | Raingutter Kit | $6.00 | Neckerchief (Lion-Bears) | 17 | $13.00 | $221.00 | |||||||||||||||||||
46 | Kittan Day Camp | $125.00 | Slides (Lion-Bears) | 17 | $8.00 | $136.00 | |||||||||||||||||||||
47 | Lion Scouts | 1 | WEBELOS Camp | $130.00 | |||||||||||||||||||||||
48 | Tiger Scouts | 5 | Recharter Scout | $135.00 | Total | $24.29 | $445.83 | ||||||||||||||||||||
49 | Wolf Scouts | 2 | Recharter Leader | $80.00 | |||||||||||||||||||||||
50 | Bear Scouts | 9 | Den Leader Guide Book | $0.00 | |||||||||||||||||||||||
51 | WEBELOS Scouts | 7 | Rank Advancement Chart | $0.00 | |||||||||||||||||||||||
52 | AOL Scouts | 3 | Pillow Case For Flags | $0.00 | |||||||||||||||||||||||
53 | |||||||||||||||||||||||||||
54 | Funding | Per Scout | Popcorn Sales | Popcorn Sales Per Scout | |||||||||||||||||||||||
55 | Total Must Fund | $1,595.00 | $59.07 | $4,557.14 | $168.78 | ||||||||||||||||||||||
56 | Total Base Scouting | $5,112.10 | $189.34 | $14,606.00 | $540.96 | ||||||||||||||||||||||
57 | Total Nice to Fund | $3,831.50 | $141.91 | $10,947.14 | $405.45 | ||||||||||||||||||||||
58 | Total Overall | $10,538.60 | $390.32 | $30,110.29 | $1,115.20 | ||||||||||||||||||||||
59 | |||||||||||||||||||||||||||
60 | $ | Popcorn Sales Equiv | |||||||||||||||||||||||||
61 | Carryover Funds | $4,256.86 | $12,162.46 | ||||||||||||||||||||||||
62 | Reserve | $3,000.00 | $8,571.43 | ||||||||||||||||||||||||
63 | Total | $7,256.86 | $20,733.89 | ||||||||||||||||||||||||
64 | |||||||||||||||||||||||||||
65 | $ | Popcorn Sales Equiv | |||||||||||||||||||||||||
66 | Half of Carryover Funds | $0.00 | $0.00 | ||||||||||||||||||||||||
67 | Budget | $10,538.60 | $30,110.29 | ||||||||||||||||||||||||
68 | Funds Needed | $10,538.60 | $30,110.29 | ||||||||||||||||||||||||
69 | Per Scout | $390.32 | $1,115.20 | ||||||||||||||||||||||||
70 | |||||||||||||||||||||||||||
71 | Pack Goals | (Using Half of the available carryover funding of $2,128.43) | Individual Goals | ||||||||||||||||||||||||
72 | Funds Raised | Popcorn Sales $ | Sales Per Scout | Pack Reward | Popcorn Sales $ | Pack Reward | |||||||||||||||||||||
73 | $4,900.00 | $14,000.00 | $518.52 | Base Scouting For Year | $500.00 | Pack Dues Paid | |||||||||||||||||||||
74 | $5,250.00 | $15,000.00 | $555.56 | All Derbies | $800.00 | Pie in the Face | |||||||||||||||||||||
75 | $5,950.00 | $17,000.00 | $629.63 | All Campouts | $1,000.00 | Derby Kits (Rocket, Car, Boat) | |||||||||||||||||||||
76 | $8,750.00 | $25,000.00 | $925.93 | Pizza Party | $1,500.00 | Small Scout Item | |||||||||||||||||||||
77 | $10,500.00 | $30,000.00 | $1,111.11 | $2,500.00 | Medium Scout Item | ||||||||||||||||||||||
78 | Top Seller | Large Scout Item | |||||||||||||||||||||||||
79 | |||||||||||||||||||||||||||
80 | |||||||||||||||||||||||||||
81 | |||||||||||||||||||||||||||
82 | |||||||||||||||||||||||||||
83 | |||||||||||||||||||||||||||
84 | |||||||||||||||||||||||||||
85 | |||||||||||||||||||||||||||
86 | |||||||||||||||||||||||||||
87 | |||||||||||||||||||||||||||
88 | |||||||||||||||||||||||||||
89 | |||||||||||||||||||||||||||
90 | |||||||||||||||||||||||||||
91 | |||||||||||||||||||||||||||
92 | |||||||||||||||||||||||||||
93 | |||||||||||||||||||||||||||
94 | |||||||||||||||||||||||||||
95 | |||||||||||||||||||||||||||
96 | |||||||||||||||||||||||||||
97 | |||||||||||||||||||||||||||
98 | |||||||||||||||||||||||||||
99 | |||||||||||||||||||||||||||
100 |