Need help with this ASAP!!
I need to create an expense report for the information given below! Thank you.
Instructions: 1. Use the information listed below to calculate the cost of running this camp for one summer. 2. Be sure to incorporate formulas for all calculations (make the spreadsheet do the work for you!) 3. Make use of borders, shading and cell styles to present the data in a clear, easy to read format 4. Include TWO charts with your report. You may choose which data to include in your chart and also the layout of the charts. Expense Details Planet Kids Sports Camp operates at Glen Eden Conservation Area in Milton Ontario. The camp program runs Monday - Friday for 10 weeks in July & August Staff Requirements: > 10 counsellors, each counsellor works 40 hours per week for 10 weeks at a rate of $14/hour 1 camp director works 40 hours per week for 10 weeks at a rate of $17/hour, plus an additional 12 weeks prior to the above camp period at 20 hours per week. 1 administrator works 40 hours per week for 10 weeks at a rate of $15/hour, plus an additional 12 weeks prior to the above camp period at 20 hours per week. 20 volunteers who work for free > End of camp pizza party - $5 per person, attended by all staff and volunteers Program Costs: Permits - rental of Glen Eden facilities, $2000/week Equipment - flat fee for the entire summer equipment, $3500 > Transportation - school bus rental for pick up and drop off, $1000/week > Uniforms - $20 per uniform; all staff and volunteers require 2 uniforms > Swimming - occurs each day for 1 hour; requires 3 lifeguards at cost of $15/hour/guard Camp Supplies- $10/camper/week for miscellaneous supplies such as food, crafts, etc.. First Aid Kit - 2 full kits @$125 each and 20 fanny packs at $25 each > Portable water jugs - $50/jug, require 5 Administrative Costs Insurance - flat fee for the entire summer, $7500 > Online registration & website - $99/month, one year contract required Online ads - 3 months of ads at $750/month Banners - 2 banners at $450 each Camp Expo - $1000 vendor fee >Canopy Tent - $450, flat fee General admin supplies - flat fee for the entire summer, $300 Capacity The camp has capacity for 100 campers each week at camp The camp is projecting the following attendance numbers. o 5 weeks at full capacity 3 weeks at 80% capacity O 2 weeks at 65% capacity O Instructions: 1. Use the information listed below to calculate the cost of running this camp for one summer. 2. Be sure to incorporate formulas for all calculations (make the spreadsheet do the work for you!) 3. Make use of borders, shading and cell styles to present the data in a clear, easy to read format 4. Include TWO charts with your report. You may choose which data to include in your chart and also the layout of the charts. Expense Details Planet Kids Sports Camp operates at Glen Eden Conservation Area in Milton Ontario. The camp program runs Monday - Friday for 10 weeks in July & August Staff Requirements: > 10 counsellors, each counsellor works 40 hours per week for 10 weeks at a rate of $14/hour 1 camp director works 40 hours per week for 10 weeks at a rate of $17/hour, plus an additional 12 weeks prior to the above camp period at 20 hours per week. 1 administrator works 40 hours per week for 10 weeks at a rate of $15/hour, plus an additional 12 weeks prior to the above camp period at 20 hours per week. 20 volunteers who work for free > End of camp pizza party - $5 per person, attended by all staff and volunteers Program Costs: Permits - rental of Glen Eden facilities, $2000/week Equipment - flat fee for the entire summer equipment, $3500 > Transportation - school bus rental for pick up and drop off, $1000/week > Uniforms - $20 per uniform; all staff and volunteers require 2 uniforms > Swimming - occurs each day for 1 hour; requires 3 lifeguards at cost of $15/hour/guard Camp Supplies- $10/camper/week for miscellaneous supplies such as food, crafts, etc.. First Aid Kit - 2 full kits @$125 each and 20 fanny packs at $25 each > Portable water jugs - $50/jug, require 5 Administrative Costs Insurance - flat fee for the entire summer, $7500 > Online registration & website - $99/month, one year contract required Online ads - 3 months of ads at $750/month Banners - 2 banners at $450 each Camp Expo - $1000 vendor fee >Canopy Tent - $450, flat fee General admin supplies - flat fee for the entire summer, $300 Capacity The camp has capacity for 100 campers each week at camp The camp is projecting the following attendance numbers. o 5 weeks at full capacity 3 weeks at 80% capacity O 2 weeks at 65% capacity O
