Question
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
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