Calculate crew constraints to determine decision variables

Assignment Help Operation Management
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

Reference no: EM131230445

Questions Cloud

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 ..

Reviews

Write a Review

Operation Management Questions & Answers

  Book review - the goal

Operations Management is about a book review. Title of the book is "Goal". This book has been written by Dr. Eliyahu Goldartt. The book has been appreciated by many as one of those books which offers an insight into the operations and strategic capac..

  Operational plan in hospitality enterprise

Operational plan pertaining to a hospitality enterprise is given in detail in the solution. The operational plan is an important plan or preparation which gives guidelines regarding the role and responsibilities of each and every operation at all lev..

  Managing operations and information

Recognise the importance of a strategic approach to the development and deployment of organisational information systems. Demonstrate an understanding of the importance of databases and their integration to the organisation's overall information mana..

  A make-or-buy analysis

An analysis of the holding costs, including the appropriate annual holding cost rate.

  Evolution and contributor of operations management

Briefly explain Evolution and contributor of Operations management.

  Functions and responsibilities of an operations manager

A number of drivers of change have transformed the roles, functions and responsibilities of an operations manager over recent years. These drivers have not only been based on technological innovations but also on the need for organisations to develop..

  Compute the optimal order quantity

Compute the Optimal Order quantity of DVD players. Determine the appropriate reorder point.

  Relationship to operations practice in the organisation

Evaluate problems in operations and identify approaches to overcoming them. Critically evaluate operating plans and identify areas for improvement. Justify, implement and evaluate changes to operations in line with modern approaches.

  A make or buy analysis

Develop a report for Figi Fabricating that will address the question of whether the company should continue to purchase the part from the supplier or begin to produce the part itself.

  Prepare a staffing plan

Prepare a staffing plan showing the change of your unit from medical/surgical staffing to oncology staffing.

  Leadership styles in different organizations

Ccompare the effectiveness of different leadership styles in different organizations

  Risk management tools and models

Be able to understand the concept of risk, roles and responsibilities for risk management and risk management tools and models.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd