simple program budget

Instructions

Using the data given below, spreadsheet that will work out what each participant must be charged, so that the program will make a 2,000 profit on the basis that the maximum number of participants is achieved. For this exercise, you are not provided with a ready-to-go Excel file. You must prepare the spreadsheet yourself however a suggested layout for your spreadsheet is given below.

Your Scenario Data

Lots of Fun Inc. is a business that is planning to put on a ten week program to introduce kids into drama. The maximum number of participants is 20.

A hall has been booked in the town's cultural centre for two hours each Wednesday evening for 30 per hour.

A qualified teacher has been hired for the program who will cost 45 per hour.

Lots of Fun Inc. has a sound system of its own but there is likely to be a need to purchase music costing 30.

The program will be advertised in the local newspaper over a three week period at a total cost of 390.

There will be photocopying costs of 80.

How much should Lots of Fun charge each participant for the ten week program if Lots of Fun want to make a 2,000 profit.

Produce a one page summary that sets out all costs and shows how the participant's fees are calculated. Ensure your document has professional appearance and has appropriate headers and footers.

Suggested Format for Spreadsheet

The illustration of below provides a suggested format for your spreadsheet. Knowing a format will assist you complete the problem quicker.

Drama Program Budget Program Duration {Weeks} Hours per Night Total Program Hours Room Hire Teaching Photocopying CD Music Advertising Sub-Total Profit Required Total Income Required Participants Cost per participant