Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started