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

Show the importance of e-commerce in product design, Question 1: (a) Op...

Question 1: (a) Operations management is an integral part of an organisation. Show how operations management can contribute to the success of an organisation. (b) Differen

Explain a linear trend equation, Value: 15.00 points Problem 3-2 National S...

Value: 15.00 points Problem 3-2 National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Month Sales (000) Units Feb. 17 M

Explain computer and software result in increased profits, The chief inform...

The chief information officer recommends that a new computer and software be purchased and installed at a cost of $100,000. This investment will decrease manpower costs by $4 per c

Explain purchasing process, Again, another point I would like to add are th...

Again, another point I would like to add are the ratings given to each game. During the purchasing process, CanGo has the ability to ask for I.D information to verify age. Sales mi

CUSTOMER SERVICE, THE SCOPPE AND NEED OF CUSTOMER SERVICE

THE SCOPPE AND NEED OF CUSTOMER SERVICE

Explain when qb researchers look in dept, When qb researchers look in dept....

When qb researchers look in dept. at single situation/when research method are they using/1. Laboratory studies/2. Field studies/3. Case study/4 meta-analysis/ 5.survey studies/ wh

Describe how to do in excel, Can you show how to do in excel? Bowman Bui...

Can you show how to do in excel? Bowman Builders manufactures steel storage sheds for commercial use, Joe Bowman, president of Bowman Builders, is contemplating producing sheds

Explain the similarities and differences of each leadership, Compare and co...

Compare and contrast the Contingency, Path-Goal, and Leader Member Exchange Theories. Describe the similarities and differences of each leadership theory. Explain some of the

Explain observable cultural forms, Think of an organization with which you ...

Think of an organization with which you are personally familiar (best), or of which you are aware through word of mouth or reading. Identify one underlying value, belief, or assump

Define how you might take production line approach, Q1: Explain how you mig...

Q1: Explain how you might take production line approach (transferring the concepts and methodologies of operations management) to a service organization such as a branch bank. Q

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