Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Do a 5 Week Error forecast(MAD) for the data below. please see work in excel. North-South Airline Data for Boeing 737-200 Jets In 2008, Northern

Do a 5 Week Error forecast(MAD) for the data below. please see work in excel.

image text in transcribed

image text in transcribed
North-South Airline Data for Boeing 737-200 Jets In 2008, Northern Airlines* merged with Southeast Airlines to create the fourth largest U.S. carrier. The new North-South Airline inherited both an aging fleet of Boeing 737-200 aircraft and Stephen Ruth. Ruth was a tough former secretary of the navy who stepped in as new president and chairman of the board. Ruth's first concern in creating a financially solid company was maintenance costs. It was commonly believed in the airline industry that maintenance costs rose with the age of the aircraft. Ruth quickly noticed that, historically, there has been a significant difference in reported B737-200 maintenance costs (from ATA Form 41s) both in the airframe and engine areas between Northern Airlines and On November 12, 2008, Ruth assigned Peg Young, vice president for operations and maintenance, to study the issue. Specifically, Ruth wanted to know (1) whether the average fleet age was correlated to direct airframe maintenance costs and (2) whether there was a relationship between average fleet age and direct engine maintenance costs. Young was to report back with the answer, along with quantitative and graphical descriptions of the relationship, by November 26. First, Young had her staff construct the average age of Northern and Southeast B737-200 fleets, by quarter, since the introduction of the aircraft to service by each airline in late 1999 and early 2000. The average age of each fleet was calculated by first multiplying the total number of calendar days that each aircraft had been in service at the pertinent point in time by the average daily utilization of the respective fleet to total fleet-hours flown. The total fleet-hours flown was then divided by the number of aircraft in service at that time, giving the age of the "average" aircraft in the fleet. The average utilization was found by taking the actual total fleet-hours flown at September 30, 2008, from Northern and Southeast data, and dividing by total days in service for all aircraft at that time. The average utilization for Southeast was 8.3 hours per day, and the average utilization for Northern was 8.7 hours per day. Because the available cost data were calculated for each yearly period ending at the end of the first quarter, average fleet age was calculated at the same points in time. The fleet data are shown in the following table. Airframe cost data and engine cost data are both

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Quantitative Analysis For Management

Authors: Barry Render, Ralph M. Stair, Michael E. Hanna

11th Edition

9780132997621, 132149117, 132997622, 978-0132149112

More Books

Students also viewed these General Management questions

Question

=+Are there many returns?

Answered: 1 week ago