Reference no: EM131230445
AirPlains Airline is a new airline company that maintains a schedule of two daily flights each way between Salt Lake City, Denver, and Chicago. AirPlains Airline must strategically position itself as a low-cost provider in a volatile industry. Therefore, it must work toward finding a minimum cost for assigning flight crews to a given flight schedule while satisfying restrictions dictated by the Federal Aviation Administration. Using Excel Solver, determine all the possible crew rotations based on the flight schedule below. You will want to find an approximate expected cost of each combination and then solve the original crew scheduling problem by using these costs. Second, you will want to calculate the crew constraints to determine the decision variables, constraints, and objectives. Apply the following business rules (constraints) to your model:
- A crew that leaves a city in the morning has to return to the same city at night.
- The crew can return on another airplane. There are six airplanes in use. There is 1 crew
- When a crew is flying, the cost is $200 per hour. When a crew is waiting or returning, the cost is $75 per hour.
The AirPlains Airline flight schedule is as follows:
From To Departure Arrival
Salt Lake City Denver 9:00AM 12:00PM
Salt Lake City Denver 2:00PM 5:00PM
Salt Lake City Chicago 10:00AM 2:00PM
Salt Lake City Chicago 3:00PM 7:00PM
Denver Salt Lake City 8:00AM 11:00AM
Denver Salt Lake City 2:00PM 5:00PM
Denver Chicago 9:00AM 11:00AM
Denver Chicago 3:00PM 5:00PM
Chicago Salt Lake City 8:00AM 12:00PM
Chicago Salt Lake City 2:00PM 6:00PM
Chicago Denver 10:00AM 12:00PM
Chicago Denver 4:00PM 6:00PM
What is your view on emerging technologies
: What is your view on emerging technologies? What is the impact of new technology on Non-IT staff, employees, and associates? What is the impact of new technology on IT Staff?
|
Develope a comprehensive network improvement plan document
: For the assignments in this course, you will be developing a comprehensive Network Improvement Plan document. Your first task in this process will be to select an organization to use as the basis of your plan.
|
Write a cause or effect essay on given topics
: Write a cause/ effect essay of five or more paragraphs on one of these topics. - The cause of Obesity - The effect of involvement in sports on young children - The cause of stress in college students.
|
A traditional source of capital acquisition
: A traditional source of capital acquisition for a new small business venture has been borrowing against home equity, either as collateral or for liquid assets. Consider the current economic state of the overall US and your own local residential housi..
|
Calculate crew constraints to determine decision variables
: AirPlains Airline is a new airline company that maintains a schedule of two daily flights each way between Salt Lake City, Denver, and Chicago. AirPlains Airline must strategically position itself as a low-cost provider in a volatile industry. you wi..
|
Draft an executive summary memo
: Write the given assignment: - Read "Lesson Seven" (Concision) in Style: - Draft an executive summary memo for the chapter in a memo.
|
Range of optimality for each objective function coefficient
: What is the optimal value of the objective function? What are the optimal values of the two decision variables? Find the range of optimality for each objective function coefficient. How would a decrease of $1 in the X1 coefficient of the objective fu..
|
Decide upon the best mode of market entry
: Once a company decides to target a new country market to enter, it must then decide upon the best mode of market entry: identify the main modes of entry that a company can choose from, which methods are the least risky and the most risky, respectivel..
|
Identify some of the challenges of new product development
: Identify some of the challenges of new product development, discuss the eight stages of the new product development process, and 3. describe the different stages in the new product adoption process. Provide and discuss an example of: 1. a product or ..
|