Question
I have 4 questions related the following case study below: You work for Calvert-Lewin Experiences Ltd. The company specialises in the provision of trips for
I have 4 questions related the following case study below:
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 plan's 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. |
- The Break-even point in trips per month
- The Break-even point in dollars of revenue per month
- 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
- You are required to copy and paste your excel work into a written document in which you follow the report format to provide context to your analysis and offer recommendations as to whether this business should be undertaken. Issues to consider include (but are not limited to):
- Research into real-world competitors and information
- Limitations of CVP analysis
- The impact of changes to variables (inputs) on the results
- Whether the business should be undertaken even though a loss is expected
- The risks and rewards of the business
It would be very much appreciated if you provide me excel file which you probably use to calculated these questions!
Thank you so much
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