Determine how to minimize the total cost of purchasing

Assignment Help Operation Management

Reference no: EM13107389

The problem requires an excel solution and an algebraic solution with variables: During the month of July, Pittsburgh resident BIll Fly must make four round trip flights between Pittsburgh and Chicago. The dates of the trips are shown in Table 4.75. Bill must purchase four round-trip tickets. Without a discounted fare, a round-trip ticket between Pittsburgh and Chicago costs $500. If Bill's stay in a city includes a weekend, he gets a 20% discount on the round-trip fare. If his stay in the city is at least 21 days, he receives a 35% discount If his stay is more than 10 days, he receives a 30% discount. However, at most one discount can be applied toward the purchase of any ticket. Determine how to minimize the total cost of purchasing the four round-trip tickets. (Hint: it might be beneficial to pair one half of one round trip ticket number with half of another round-trip ticket.) Table 4.75: Flights for BIll Fly Problem: Leave Pittsburgh: Leave Chicago: Monday, July 1 Friday July 5 Tuesday July 9 Thursday July 11 Monday July 15 Friday, July 19 Wednesday July 24 Thursday July 25

Reference no: EM13107389

Questions Cloud

What is the total energy of the photons : What is the total energy of the photons detected in a period of one hour If a radiation detector is capturing 8 X 10^7 photons per second at this wavelength,?

Create presentation for early childhood and middle childhood : Create the presentation for early childhood and middle childhood groups which addresses health issues suitable for each developmental level.

Determine the volume of carbon di oxide at a temperature : Determine the volume of CO 2 at a temperature twenty two degree Celsius and a pressure of 781 mmHg could be absorbed by 327 grams of Lithium hydroxide LiOH?

Determine the mass of h2o : Determine the mass of H 2 O is formed if oxygen of 10.0L react completely in the given equation?

Determine how to minimize the total cost of purchasing : The problem requires an excel solution and an algebraic solution with variables: During the month of July, Pittsburgh resident BIll Fly must make four round trip flights between Pittsburgh and Chicago.

Determines the rate constant for reaction : Determines the rate constant for this reaction and express and determine how many mL of a 0.157M solution of KOH is required to react with 0.385g of CH 3 COOH?

Is it significant to attract security management personnel : Do you believe rewards are more significant in attracting security management personnel to organization or in developing commitment to organization?

What is the radius of curvature of the mirror : Consider a concave mirror with a focal length of 18.90 cm. Find the location of the image when the object is 10.20 cm from the mirror. What is the magnification of the image? What is the radius of curvature of the mirror in cm? Is is virtual and u..

Rate constant for a particular second-order reaction : Determine how long will it take for the concentration to decrease to 0.13 mol/L express your answer in seconds.

User Account

All Pages