- Instructions Mezcoph Will Be Holding A Summer Exercise Camp For Children Using The Data Given Below Create A Budget Th 1 (272.65 KiB) Viewed 59 times
children. Using the data given below, create a budget that will
work out what each participant must be charged, so that the program
will make a $2,000 surplus on the basis that the maximum number of
participants is achieved. You may use the worksheet provided but
are not obligated to do so. Please describe your calculations. This
can be done at the end of the budget or to the right of each
number. To receive full credit for this assignment you must show
and describe your work. Your Scenario MEZCOPH is planning to put on
a ten week summer exercise camp to introduce kids to the importance
of exercise. The camp will operate six hours per day MonFri. The
maximum number of participants is 25. A room has been booked in
Drachman Hall for $30 per hour. MEZCOPH students have been hired to
run the program which will cost a total of $45 per hour. MEZCOPH
has a sound system of its own but needs to purchase music costing
$30. The program will be advertised in the local newspaper over a
three week period at a total of $390. There will be photocopying
costs of $80. How much should MEZCOPH charge each participant for
the ten week program if MEZCOPH wants to make a $2,000 surplus.
Produce a one page budget that sets out all costs and shows how the
participant’s fees are calculated. Ensure your document has a
professional appearance, and includes the assignment title and your
name.
Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments v 11 ~ A A = ab Wrap Text General 2 Insert Σ' ΑΥ» Calibri (Body) BTU Dex Delete v Paste 3 ܀ A ܝ ܀ . Merge Cantar $ % $8 Conditional Format Cell Formatting as Tabla Styles ! Format v Sort & Filter Find & Select Y Analyze Data H13 A C D L F H 1 K M M N P R S T Exercise Camp Budget (fill out shaded areas) 2 Calculation Explanations 25 (provided) · Number of participants 4 5 Program Duration (Weeks) 6 Hours Per Day/Week 7 Total Program Hours 10 (provided) 30 (6 hrs per day x 5 days per wk) 300 (10 wks x 30 hrs per wk) 8 (Student calculation explanations) 9 20 Exercise Hall Cost 11 Student Costs 12 Photocopying 13 Music Costs Advertising 15 Total Program Costs 16 -7 Required Surplus 18 9 Total Income Required 20 21 Cost Per Participant 22 23