Question

In: Finance

Question 5 (Total of 24 marks) Hit-and-Miss Airlines are considering providing a new daily service between...

Question 5 (Total of 24 marks)

Hit-and-Miss Airlines are considering providing a new daily service between two cities. The aircraft has a maximum capacity of 200 passengers and each flight incurs a fixed cost of $27,000 regardless of the number of passangers. In addition, a cost is also incurred of $75 per passanger to cover such things as catering, booking, baggage handling.

The company is thinking of charging $225 per ticket. How many passengers will the airline need on each flight to break even? Find the break-even point algebraically and illustrate it using an EXCEL graph. Attach the printout or copy your EXCEL graph into your assignment submission. Based on your analysis, will Hit-and-Miss realize a profit or a loss if 160 seats are sold for a particular flight? Explain briefly.

EXCEL Instructions: Create a column called Number of Passengers and in that column enter values from 0 to 200 in increments of 20. Then create two more columns, one for Total Cost and another for Total Revenue. Enter appropriate formulae in EXCEL to obtain the total cost and total revenue corresponding to each value in the Number of Passengers column. Highlight the resulting three sets of numbers and go to the Chart Wizard to obtain the graph. Make sure that your graph has been labelled appropriately (i.e. title, axis labels, legend). Please refer to Topic 3 in the EXCEL Booklet for further instructions on entering formulae and graphing in EXCEL.

Solutions

Expert Solution

Break even point is the point where revenues = total costs

Let no. of pasengers be "x". Total cost = fixed costs+variable costs

= 27000+75x.

Revenue = 225x

Thus at breakeven, 225x = 27000+75x

or 150x = 27000

or x = 180.

Thus in order to break even the airlines will need 180 passengers.

The amount of 160 passengers is less than the break even requirement of 180 and so there will be a loss. This can be proved mathematically as well. Revenue = 160*225 = 36,000. Costs = 27000+(75*160) = 39,000. Thus loss = 36,000 - 39,000 = $3,000 loss.

Excel table:

No. of passengers Total cost Total revenue
0 27,000.00 0.00
20 28,500.00 4,500.00
40 30,000.00 9,000.00
60 31,500.00 13,500.00
80 33,000.00 18,000.00
100 34,500.00 22,500.00
120 36,000.00 27,000.00
140 37,500.00 31,500.00
160 39,000.00 36,000.00
180 40,500.00 40,500.00
200 42,000.00 45,000.00

Excel graph:


Related Solutions

Question 5: Relevant information for decisions (20 marks in total) The development of a new pesticide...
Question 5: Relevant information for decisions (20 marks in total) The development of a new pesticide for the horticultural industry has been successful. David is now discussing with you, options to expand operations to include this new line of pesticide, Microcide. A key issue is whether to make one of the components of the pesticide, Factor X, or to buy it in. Demand for the next 12 months is expected to be 200,000 litres. Costs if FOL makes all the...
Question 5: Relevant information for decisions (20 marks in total) The development of a new pesticide...
Question 5: Relevant information for decisions (20 marks in total) The development of a new pesticide for the horticultural industry has been successful. David is now discussing with you options to expand operations to include this new line of pesticide, Microcide. A key issue is whether to make one of the components of the pesticide, Factor X, or to buy it in. Demand for the next 12 months is expected to be 200,000 litres. Costs if FOL makes all the...
Question 1: Descriptive Statistics: Each question is worth 2 marks: Total (10 marks) Data: 22 24...
Question 1: Descriptive Statistics: Each question is worth 2 marks: Total Data: 22 24 26 26 28 30 32 38 44 A. What is the mean? B. What is the median? C. What is the mode? D. What is the 25th and 75th percentile? E. What is the interquartile range?
Question 3.3                              (Total: 45 marks; part 1: 24 marks; part 2: 15 marks; part 3:...
Question 3.3                              (Total: 45 marks; part 1: 24 marks; part 2: 15 marks; part 3: 6 marks) Star Finder Inc. has provided the following information for the year ended December 31, 2021: Sales revenue $1,300,000 Loss on inventory due to decline in net realizable value $80,000 Unrealized gain on FV-OCI equity investments 42,000 Loss on disposal of equipment 35,000 Interest income 7,000 Depreciation expense related to buildings omitted by mistake in 2020 55,000 Cost of goods sold 780,000 Retained...
Question 3.3 (Total: 45 marks; part 1: 24 marks; part 2: 15 marks; part 3: 6...
Question 3.3 (Total: 45 marks; part 1: 24 marks; part 2: 15 marks; part 3: 6 marks) Star Finder Inc. has provided the following information for the year ended December 31, 2021: Sales revenue $1,300,000 Loss on inventory due to decline in net realizable value $80,000 Unrealized gain on FV-OCI equity investments 42,000 Loss on disposal of equipment 35,000 Interest income 7,000 Depreciation expense related to buildings omitted by mistake in 2020 55,000 Cost of goods sold 780,000 Retained earnings...
Question 5: Hypothesis Testing: Each question is worth 7.5 marks: Total (15 marks) A. Suppose we...
Question 5: Hypothesis Testing: Each question is worth 7.5 marks: Total A. Suppose we know the standard deviation of the population is 3.7. We have a sample size of 625. We also have a sample mean of 46. We also have a population mean of 43. We want to test the hypothesis for the sample mean with 78% confidence level and do a two-tailed test on the hypothesis. State the null and alternate hypothesis for the sample mean and then...
Question 5: (24 marks) Ferris Industries is planning to replace its old equipment. The old equipment...
Question 5: Ferris Industries is planning to replace its old equipment. The old equipment cost was $350 000 five years ago. The old equipment is fully depreciated. If the new equipment is purchased, arrangements will be made to sell the old equipment. The old equipment is expected to be sold for only $20 000 on 1 January 2021. The new equipment will be placed in service on 1 January 2021. The details regarding the proposal are as follows: Expected acquisition...
Question 5 (7 marks) Bunnings Ltd is considering to invest in one of the two following...
Question 5 Bunnings Ltd is considering to invest in one of the two following projects to buy a new equipment. Each equipment will last 5 years and have no salvage value at the end. The company’s required rate of return for all investment projects is 8%. The cash flows of the projects are provided below. Equipment 1 Equipment 2 Cost $186,000 $195,000 Future Cash Flows Year 1 Year 2 Year 3 Year 4 Year 5 86 000 93 000 83...
Question 5:(total 8 marks) XEMACompany estimates that variable costs will be 60% of sales and fixed...
Question 5:(total 8 marks) XEMACompany estimates that variable costs will be 60% of sales and fixed costs will total $900,000. The selling price of the product is $5, and 500,000 units will be sold. Instructions: Using the contribution margin: (a)  Compute the break-even point in units and dollars.               (3marks) (c)  Compute the margin of safety in dollars and as a ratio.          (d)  Compute net income.                                                             
Rearden Metal is considering the purchase of a new blast furnace costing a total of $5...
Rearden Metal is considering the purchase of a new blast furnace costing a total of $5 million dollars. This furnace will qualify for MACRS 5-year depreciation (20%, 32%, 19.20%, 11.52%, 11/52%, 5.76%) . However, because of Rearden's substantial tax loss carry forwards, Rearden estimates its marginal tax rate to be only 10% over the next five years. Since Rearden will get very little tax benefit from the depreciation expense, they consider leasing the furnace instead. Suppose that Rearden and the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT