Alliance air is service in which customers pay flat-rate

Assignment Help Operation Management
Reference no: EM132221908

Alliance Air is a service in which customers pay a flat-rate to Alliance Air and are guaranteed a seat on an airplane between any two locations. To offer this service, Alliance Air prepurchases daily seats between every pair of major cities. A route which has been growing in popularity is between Phoenix and Dallas and Alliance Air is seeking your advice on how many seats to prepurchase between these two cities so that they maximize their daily profit.

Whenever an Alliance Air customer flies on a prepurchased seat, Alliance Air obtains $100 in profits. However, if Alliance Air has more customers seeking a seat then they have prepurchased, Alliance Air is forced to book that passenger on a seat purchased that day. In such a situation, Alliance Air has a profit of -$170 due to the high cost of same-day flights. If not all of their prepurchased seats are taken, then Alliance Air makes a profit of -$20 by selling the seats at a discount to passengers outside of their customer base. Based on their data, Alliance Air knows that number of customers seeking a flight on any day follows a Poisson distribution with mean 40.

Using this information, complete the following tasks/questions:

Develop an Excel spreadsheet model which can calculate the daily profits for Alliance Air given a particular demand for that day. Using the given demand distribution, set-up your spreadsheet as a simulation model using daily profits as the output. Run the simulation assuming Alliance Air prepurchases 37 seats on the plane. What is the average daily profit in this scenario?

How many seats would you recommend Alliance Air to prepurchase if they wanted to maximize their average daily profit? To answer this, modify the number of prepurchased seats and observe various statistics about the expected daily profits (e.g. average, max, min, etc.) just like in Valentine's Candy example. What are the minimum and maximum daily profits if they were to purchase this quantity? What percentage of the time is Alliance Air’s daily profit above 2,250?

Reference no: EM132221908

Questions Cloud

Human resources textbook including donald super model : Cringes every time she sees a human resources textbook including Donald Super's model, which attaches ages to career stages.
Examples of sustainable products and designs : Examples of Sustainable Products and Designs: Find a product that you think best exemplifies the principles of sustainable design.
What are your thoughts about the metrics : What are your thoughts about the Metrics? Would you use different metrics ?
Return on marketing spent with the new practice in the case : Explain how you would compute a return on marketing spent with the new practice in the case.
Alliance air is service in which customers pay flat-rate : Alliance Air is a service in which customers pay a flat-rate to Alliance Air and are guaranteed a seat on an airplane between any two locations.
How you plan to uncover new information in the data : Discuss how you plan to uncover new information in the data that is not self-evident. How could you summarize your data to answer key questions
What sort of training-experience is needed by individuals : What sort of training and experience is needed by the individuals who built and operate this system? What about by the individuals who use this system?
Tuckman five-stage model of group development is performing : The Ashe effect involves giving into a majority but wrong conclusion? The last stage of Tuckman's five-stage model of group development is ' performing'.
Explain process for implementing compensation strategy : Explain the process for implementing a compensation strategy?

Reviews

Write a Review

Operation Management Questions & Answers

  Comment on the legal and ethical ramifications raised

About how Target used customer purchases and other data to send sales promotions to a teen, and comment on the legal and ethical ramifications raised.

  Planning has always been an integral function of management

Planning has always been an integral function of management but is there an increasing need now for planning by managers in organizations ?

  Explain how this leader has influenced you

If you could recommend changes to his/her leadership approach, philosophy, and style, what would you suggest? Why?

  Disney entered europe with several incorrect assumptions

Disney entered Europe with several incorrect assumptions and poor research. Identify the problems that arose and how Disney should adjust for the immediate situation

  Caribbean social theories-plantation society-plural society

Which of the Caribbean social theories; Plantation society, Plural Society or Creole Society, best describes the modern Caribbean society.

  Describe an issue a city would face

Discuss alternative solutions to that issue. Discuss why you believe the alternatives would be best for the problem. Include citations for your solutions.

  Research the trends and issue affecting the global workforce

Consider arguments for and against each of the three countries' approaches to compensation. Research the trends and issues affecting the global workforce.

  How does race bias impact the workplace

How does race bias impact the workplace?

  Identify the three major sociological theoretical paradigms

Identify the three major sociological theoretical paradigms. For each, what are its core questions? Which one do you relate to best?

  What affirmative defenses can johnny raise

What affirmative defenses can Johnny raise? Can Johnny get the letter seized by the police suppressed? Why?

  Increase capacity through the addition of new equipment

Tom Johnson Manufacturing intends to increase capacity through the addition of new equipment.

  How they should promote and monitor the transformation

Assume that you have been asked to advise the Akawini management team on how they should promote and monitor the transformation of risk management.

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