jagomart
digital resources
picture1_Spreadsheet For Expenses 40917 | Summer Camp Budgets


 225x       Filetype XLSX       File size 0.02 MB       Source: ventureteambuilding.co.uk


File: Spreadsheet For Expenses 40917 | Summer Camp Budgets
sheet 1 camp weekly budget camper to staff ratio numbers of campers 12 24 36 48 60 72 84 96 groups required 1 2 3 4 5 6 7 8 ...

icon picture XLSX Filetype Excel XLSX | Posted on 14 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: Camp Weekly Budget
Camper to Staff Ratio
Numbers of Campers 12 24 36 48 60 72 84 96
Groups Required 1 2 3 4 5 6 7 8
Total Staff Required 2 2 3 4 5 6 7 8
Leaders Required 1 1 2 3 4 5 6 7










Income
Campers x Avg Booking Fee 240 480 720 960 1200 1440 1680 1920
Total £240 £480 £720 £960 £1,200 £1,440 £1,680 £1,920
Weekly Value £1,200 £2,400 £3,600 £4,800 £6,000 £7,200 £8,400 £9,600










Expenses (Daily)
Venue Fee £80 £80 £120 £120 £160 £160 £200 £200
Camp Director (CD) £100 £100 £100 £100 £100 £100 £100 £100
Additional Staff £60 £60 £120 £180 £240 £300 £360 £420
Specialist Activities £40 £40 £80 £80 £120 £120 £160 £160
Drinks and Snacks £6 £12 £16 £22 £24 £29 £29 £34
Add Expense Description £0 £0 £0 £0 £0 £0 £0 £0
Add Expense Description £0 £0 £0 £0 £0 £0 £0 £0
Add Expense Description £0 £0 £0 £0 £0 £0 £0 £0
Add Expense Description £0 £0 £0 £0 £0 £0 £0 £0
Total £286 £292 £436 £502 £644 £709 £849 £914
Daily Expenses (Weekly Value) £1,430 £1,460 £2,181 £2,508 £3,220 £3,544 £4,247 £4,568
Other Expenses (Weekly)
£5 per camper Advertising £50 £50 £100 £100 £150 £150 £200 £200
Equipment £100 £150 £150 £200 £250 £300 £350 £400
Misc/Petty Cash £40 £40 £60 £60 £80 £80 £100 £100
Special Event £100 £125 £150 £175 £200 £225 £250 £300
Paperwork and Admin £12 £24 £36 £48 £60 £72 £84 £96
Add Expense Description £0 £0 £0 £0 £0 £0 £0 £0
Add Expense Description £0 £0 £0 £0 £0 £0 £0 £0
Total £302 £389 £496 £583 £740 £827 £984 £1,096










Combined Expenses £1,732 £1,849 £2,677 £3,091 £3,960 £4,371 £5,231 £5,664










Income £1,200 £2,400 £3,600 £4,800 £6,000 £7,200 £8,400 £9,600
Expendiure £1,732 £1,849 £2,677 £3,091 £3,960 £4,371 £5,231 £5,664
Net -£532 £551 £923 £1,709 £2,040 £2,829 £3,169 £3,936










2 Weeks -£1,064 £1,102 £1,846 £3,418 £4,080 £5,658 £6,338 £7,872
3 Weeks -£1,596 £1,653 £2,769 £5,127 £6,120 £8,487 £9,507 £11,808
4 Weeks -£2,128 £2,204 £3,692 £6,836 £8,160 £11,316 £12,676 £15,744
5 Weeks -£2,660 £2,755 £4,615 £8,545 £10,200 £14,145 £15,845 £19,680
6 Weeks -£3,192 £3,306 £5,538 £10,254 £12,240 £16,974 £19,014 £23,616
7 Weeks -£3,724 £3,857 £6,461 £11,963 £14,280 £19,803 £22,183 £27,552
8 Weeks -£4,256 £4,408 £7,384 £13,672 £16,320 £22,632 £25,352 £31,488
9 Weeks -£4,788 £4,959 £8,307 £15,381 £18,360 £25,461 £28,521 £35,424
10 Weeks -£5,320 £5,510 £9,230 £17,090 £20,400 £28,290 £31,690 £39,360

Sheet 2: Start-Up Costs
Start-Up Costs
Description Supplier Price Qty Total Actual Variance
Domain Registration GoDaddy £7.00 1 £7.00

Logo Design Online Company £50.00 1 £50.00

Business Registation Companies Made Simple £49.99 1 £49.99

Website Design Weebly - 1 Year Subscription £63.00 1 £63.00

Photo Stock Shutterstock £6.00 5 £30.00

Forms, Document Start-Up Pack Out of School Alliance £49.50 1 £49.50

Camp Insurance Morton Michel £242.00 1 £242.00

Laptop Online £250.00 1 £250.00

Printer Online £80.00 1 £80.00

Add Expense Description


£0.00

Add Expense Description


£0.00

Add Expense Description


£0.00


£821 £0 £0







Camp Specifics
Description Supplier Price Qty Total Actual Variance
Activity Equipment Various £500.00 1 £500.00

Training Day - Camp Training Venture Team Building £385.00 1 £385.00

Training Day Costs - Venue, Drinks, Documentation Various £150.00 1 £150.00

Misc Various £150.00
£0.00

Add Expense Description


£0.00

Add Expense Description


£0.00

Add Expense Description


£0.00

Add Expense Description


£0.00

Add Expense Description


£0.00

Add Expense Description


£0.00

Add Expense Description


£0.00

Add Expense Description


£0.00


£1,035 £0 £0








Total £1,856




Actual £0




Variance -£1,856




The words contained in this file might help you see if this file matches what you are looking for:

...Sheet camp weekly budget camper to staff ratio numbers of campers groups required total leaders income x avg booking fee pound value expenses daily venue director cd additional specialist activities drinks and snacks add expense description other per advertising equipment miscpetty cash special event paperwork admin combined expendiure net weeks startup costs supplier price qty actual variance domain registration godaddy logo design online company business registation companies made simple website weebly year subscription photo stock shutterstock forms document pack out school alliance insurance morton michel laptop printer specifics activity various training day venture team building documentation misc...

no reviews yet
Please Login to review.