# Question: Shortly after being hired as a cost analyst with Florida

Shortly after being hired as a cost analyst with Florida International Airlines, Kim Williams was asked to prepare a report that focused on passenger ticketing cost. The airline writes most of its own tickets, makes little use of travel agents, and has seen an increased passenger interest in e-ticketing. After some discussion, Williams thought it would be beneficial to begin her report with an overview of three different cost estimation tools: scatter diagrams, least-squares regression, and the high-low method. She would then present the results of her analysis of the past year’s monthly ticketing cost, which was driven largely by the number of tickets written. These results would be presented in the form of algebraic equations that were derived by the three tools just cited. The equations follow. (C denotes ticketing cost, and PT denotes number of passenger tickets written.)
Least-squares regression: C = \$300,000 + \$2.25 PT
Scatter diagram: C = \$295,000 + \$2.20 PT
High-low method: C = \$301,000 + \$2.40 PT
Williams had analyzed data over the past 12 months and built equations on these data, purposely including the slowest month of the year (February) and the busiest month (November) so that things would tend to average out. She observed that November was especially busy because of Thanksgiving, passengers purchasing tickets for upcoming holiday travel in December, and the effects of a strike by Southeastern Airlines, Florida International’s chief competitor. The lengthy strike resulted in many of Southeastern’s passengers being rerouted on Florida International flights.

Required:
1. Prepare a bullet-point list suitable for use in Williams’s report that describes the features of scatter diagrams, least-squares regression, and the high-low method. Determine which of the three tools will typically produce the most accurate results.
2. Will the three cost estimation tools normally result in different equations? Why?
3. Assuming the use of least-squares regression, explain what the \$300,000 and \$2.25 figures represent.
4. Assuming the use of a scatter diagram, predict the cost of an upcoming month when Florida International expects to write 570,000 tickets.
5. Did Williams err in constructing the equations on data of the past 12 months? Briefly explain.
6. Assume that over the next few years, more of Florida International’s passengers will take advantage of e-ticketing over the Internet. What will likely happen to the airline’s cost structure in terms of variable and fixed cost incurred?

Sales1
Views312