Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Frank Woods Business Accounting Volume 1

Authors: Frank Wood, Alan Sangster

10th Edition

9780273681496

More Books

Students also viewed these Accounting questions

Question

Demonstrate knowledge of the company/organization and the position.

Answered: 1 week ago