50.1K

Verified Solution

Link Copied!

BudgetingCreate a simple program budgetInstructionsUsing the data given below, create a spreadsheet that will work out what each participantmust be charged, so that the program will make a $2,000 profit on the basis that themaximum number of participants is achieved.Prepare the spreadsheet as per the suggested layout given below.Your Scenario DataLots of Fun Inc. is a business that is planning to put on a ten week program to introducekids into drama. The maximum number of participants is 20.A hall has been booked in the town's cultural centre for two hours each Wednesdayevening 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 purchasemusic costing $30.The program will be advertised in the localnewspaper over a three week period at a totalcost of $390.There will be photocopying costs of $80.How much should Lots of Fun charge eachparticipant for the ten week program if Lots ofFun want to make a $2,000 profit.Produce a one page summary that sets out allcosts and shows how the participants fees arecalculated. Ensure your document hasprofessional appearance and has appropriateheaders and footers.Suggested Format for SpreadsheetThe illustration of right provides a suggestedformat for the spreadsheet

Answer & Explanation Solved by verified expert

See Answer