Solve the problem requires an excel solution, Operation Management

Assignment Help:

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


Related Discussions:- Solve the problem requires an excel solution

Explain the scope overview and business case sections, The scope overview a...

The scope overview and business case sections of the project charter provide the high-level "what and why" of the project A. TRUE B. FALSE

How minimize the work-in-process inventory, The production manager must det...

The production manager must determine the processing sequence for 7 jobs through the grinding and debarring departments. The same sequence will be followed in both departments. The

Ghant for Inventory Control, Hello! I need some help creating a ghant shed...

Hello! I need some help creating a ghant shedule for silo bins. I am harvesting, and I have large grain bins which will be filled depending on how fast we harvest. I also need to

Explain describe your findings as frequencies, Poll a small sample of class...

Poll a small sample of class members, work associates, or friends and ask them to answer the following in a paragraph or two: "What are your career aspirations for the next five

What are the elements of supply chain management, Q. What are the elements ...

Q. What are the elements of supply chain management? The three elements of supply chain management: • Responsiveness as an example how flexibly and rapidly supply can meet d

Use of post-operative patient controlled analgesia, Use of post-operative p...

Use of post-operative patient controlled analgesia: Does the use of post-operative patient controlled analgesia (pca) in hospital settings help reduce overall morphine consump

Suppose the number of requests for week, An electrical contractor's records...

An electrical contractor's records during the last 5 weeks indicate the number of actual job requests. Predict the number of requests for week 6 using each of the below methods:

Describe the objectives of trade unions, Describe the objectives of trade u...

Describe the objectives of trade unions. The Objectives of trade unions are: (i) To take labour out of the competitive procedure because when a number of workers freely comp

Write Your Message!

Captcha
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