Budgeting Exercise 07 Create a simple program budget Instructions Using the data given below, create a 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 right provides a suggested format for your spreadsheet. Knowing a format will assist you complete the problem quicker. Budgeting Exercise 07 Create a simple program budget Instructions Using the data given below, create a 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 right provides a suggested format for your spreadsheet. Knowing a format will assist you complete the problem quicker