Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You work for Calvert-Lewin Experiences Ltd. The company specialises in the provision of trips for tourists in and around the major cities of Australia. Your

You work for Calvert-Lewin Experiences Ltd. The company specialises in the provision of trips for tourists in and around the major cities of Australia. Your manager is currently investigating introducing a new product, which are Luxury helicopter rides over the Hunter Valley in NSW. Each trip would be 50km in total. Your manager wants you to use cost-volume-profit analysis in order to help assess the plans feasibility, via Microsoft Excel software. She provides you with the following estimated data: Selling price per trip: $630 (total for 3 customers trips only run with 3 customers) Costs: Fuel: $50 per trip Gourmet snack per customer: $45 Helicopter rental per month: $20,000 Insurance per month (unlimited trips): $1,000 Pilot costs: $4,000 per month plus $120 per trip Maintenance costs are difficult to estimate but data from a similar company in a different location shows that these monthly costs were $9,000 when 5,000 kms were flown and $5000 when 1,500 kms were flown. Your manager has also undertaken some limited market research and is not aware of any other business currently offering this product in the Hunter Valley. However, she also found that one business did offer a similar product before the covid pandemic hit and it provided around 3 trips per day but struggled to make a profit. Also, she is mindful that after covid things are changing quickly as restrictions ease. She believes the estimated cost data above may be conservative and that lower costs (particularly for helicopter rental and pilot costs) may be possible. REQUIRED: Calculate the following based on the estimates given:

1) The Break-even point in trips per month

2) The Break-even point in dollars of revenue per month

3) Assuming a profit after tax requirement from the Helicopter trip business of $120,000 per year and a tax rate of 30%, calculate:

Trips required per month to obtain target profit

Revenue required per month to obtain target profit

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_2

Step: 3

blur-text-image_3

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

Strategic Audits For Continuous Business Improvement

Authors: Parbatee Chang

2nd Edition

1507679483, 978-1507679487

More Books

Students also viewed these Accounting questions