The break-even quantity for the number of pupils

Assignment Help Financial Management

Reference no: EM131955667

Bri Smith and Joe Sullivan, two kinesiology students at ASU, are considering the possibility of offering swimming lessons to children at the university pool. The pool would charge a fixed rental fee of $1500 for the 8-weeks of lessons as well as an admission and lifeguarding fee of $7 per pupil. Bri and Joe estimate an additional cost of $4 per pupil to hire additional helpers. Bri and Joe plan to charge $65 per student for the 8-week class.

a. Use the data given to create a model for the total profit. Use the Excel tool Data/What-If Analysis/Goal Seek to determine the following:

b. the break-even quantity for the number of pupils needed to enroll in the swimming class.

c. the number of pupils they need to enroll if they want to make a profit of $5,000.

d. how much per pupil they would have to charge if only 60 pupils enrolled and they still wanted to realize their profit goal of $5,000.

e. Create a cost/revenue graph that shows total cost and total revenues (two lines) versus the number of pupils. (Make sure you reset the charge per pupil to $65 to determine graph inputs and use the range of the number of pupils from 0 to 150)

Reference no: EM131955667

Questions Cloud

Analyze and explain the cause and effect relationship : Analyze and explain the cause and effect relationship between two or more situations, phenomena, events, occurrences, ideas, or innovations.

What is the expected currency rate : A chemical manufacturer is setting up capacity in Europe and North America for the next three years. Annual demand in each market is 2 million kilograms.

Discuss about the mobile technologies and commerce : Reflect on how your topic relates to larger issues; evaluate the concepts you have presented; issue a call for action on the part of your audience;

What is the annual carrying costs of cheese inventory : Cheeseburger and Taco Company purchases 18,029 boxes of cheese each year. It costs $18 to place and ship each order and $4.00 per year for each box held.

The break-even quantity for the number of pupils : the break-even quantity for the number of pupils needed to enroll in the swimming class.

Before-tax cash flow as percentage of equity investment : The actual before-tax cash flow as a percentage of the equity investment, if the actual net operating income falls 10% below expectations

Do you believe that thinking profit can actually result : Question - Do you believe that thinking profit can actually result in more profit? Make sure to support your answer. Please answer the question completely

Determine bad debt expense to the allowance method : Castle Company provides estimates for its uncollectible accounts. The allowance for uncollectible accounts had a credit balance of $17,880 at the beginning.

Invest annually in real dollars to meet retirement goal : Calculate the amount you must invest annually in real dollars to meet your retirement goal.

User Account

All Pages