Calculate seasonal indexes for each quarter

Assignment Help Operation Management

Reference no: EM131725713

Southwest Airlines (LUV)

Find the quarterly net income data for the past five years (you can locate this information from the Investors Relations section on the Southwest Airlines website or from any other reliable source to obtain these financials). Be sure to site the source of your data.

Use the quarterly data to do the following:

a. Collect and copy the data from Q3 2012 through Q2 2017 into Excel. Graph the data. Label axes appropriately.

b. Calculate seasonal indexes for each quarter

c. Run a trendline through the plot of the data.

d. Use the trendline and the seasonal indexes to make forecasts for the next four quarters (Q3 2017 – Q2 2018). Use whatever forecast method on the de-seasonalized data that you believe to be the best fit.

e. Describe the seasonality of Southwest’s income – eg. Are there quarters that experience peaks or declines in net income? If so, explain why you think that these patterns are occurring.

Do your work in Excel but copy all relevant tables and results in to Word.

Your Word document should include a coversheet, and answers to all questions. Embed Excel graphs and tables into the Word document. You must also submit the Excel spreadsheet as an appendix so I can view your calcualtions.

Reference no: EM131725713

Questions Cloud

Define the three forms of business analytics : Define the three forms of business analytics and their business functions: descriptive, predictive, and prescriptive.

What resistive force does the wood exert on the bullet : A rifle with a barrel length of 60 cm fires a 11g bullet with a horizontal speed of 350m/s . The bullet strikes a block of wood and penetrates to a depth.

Extensive project management experience : If choosing a project manager, and you only had one choice, would you prefer they have extensive project management experience

What is project completion time : what are the critical path activities. What is the project completion time?

Calculate seasonal indexes for each quarter : Find the quarterly net income data for the past five years. Calculate seasonal indexes for each quarter

How much will each annual payment be : This loan is to be repaid in equal installments at the end of each year over the next eight years. How much will each annual payment be?

Interest portions of upcoming month payment : Knowing that the mortgage is financed with 4.55% APR, what do you know about the principal and interest portions of this upcoming month's payment?

Why is important to formulate strategy in specific order : Provide an example of each category of strategy formulation for discussion. Why is it so important to formulate strategies in this specific order?

When the discount rate is percent : What is the present value of a $290 payment in one year when the discount rate is 8 percent? (Round your answer to 2 decimal places.)

User Account

All Pages