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 unethical for advertisers to pitch products, Do you feel it's uneth...

Do you feel it's unethical for advertisers to pitch products to patients and students in this fashion? why?

Describe the global nature of sourcing and distribution, Q1. Discuss The gl...

Q1. Discuss The global nature of sourcing and distribution Q2. Let's also take a look at some examples of organizations and their training programs. Take some time to research a

Explain the basic economic order quantity, The basic Economic Order Quantit...

The basic Economic Order Quantity (EOQ) model can be considered a special case of the Economic Production Quantity (EPQ) model under which of the following condition? Answer The

Explain factors contributing to competitive rivalry include, Factors contri...

Factors contributing to competitive rivalry include A) The corporate attitudes toward marketing strategies B) Nature of the product and homogeneity of market C) The suppor

Interdependent sub systems - operations function, Interdependent sub-system...

Interdependent sub-systems A striking feature of complex, open systems is that each comprises a set of highly interdependent sub-systems. For instance, the human body consist

Discuss three key problems, In "Consequence Management in the 1995 Sarin At...

In "Consequence Management in the 1995 Sarin Attacks on the Japanese Subway System", what were some of the key problems confronting Japanese first responders to the chemical attack

Explain what role does tca play in the decision, 1. The chapter mentions th...

1. The chapter mentions the theory of transaction cost analysis (TCA). What role does TCA play in the decision to use a company sales force rather than independent manufacturers' a

Explain business plan to enhance to online education, If you can think of a...

If you can think of a business plan to enhance to online education programs at school?

Why health care cost are out of control in the united states, Discuss the f...

Discuss the following statement: "Health care cost are out of control in the United States, and increasing conflicts between employers and employees are likely as employers try to

Sequencing.., program to find optimal sequence, total elapsed time and tota...

program to find optimal sequence, total elapsed time and total idle time in 6 jobs and 3 machines

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