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 distinction between feasibility and acceptability, Remind yourself ...

Remind yourself of the distinction between feasibility, acceptability and vulnerability discussed. Evaluate both technologies using these criteria.

Explain approaches that project managers, Project managers frequently face ...

Project managers frequently face competing constraints. Identify these common constraints and describe approaches that project managers can use to make the trade-offs required to s

Define the term management, Define the term Management.  Ans:  "Mana...

Define the term Management.  Ans:  "Management is the accomplishment of results by the efforts of many people"  - LAWRENCE APPLEY   "Management is the art of getting

Benefits of access of patient''s information through lan, This project allo...

This project allows doctor to access their patient's information easily through their local area network and through the internet. They can also update the status of each patient t

Explain assemble a computer mouse, You have been asked to set up an assembl...

You have been asked to set up an assembly line to assemble a computer mouse. The precedence network is shown below; task times in minutes are given in parentheses. There are 480 mi

Explain decision making and control processes, 1. From an international cul...

1. From an international cultural perspective, how much of an impact is on the timely decision making and control processes can there be when there is a difference in national and

Explain how would you measure marketing productivity, How would you measure...

How would you measure marketing productivity? What measures would you use and why? Explain.

Explain district investigation of sexual harassment case, Peter Lewiston wa...

Peter Lewiston was terminated on July 15, 2004, by the governing board of the Pine Circle Unified School District (PCUSD) for violation of the district sexual harassment policy. Pr

Explain description of the crime, Find a news article with homicide Provide...

Find a news article with homicide Provide a brief description of the crime. What does the crime data suggest about this type of crime? Does the article discuss the motive for the c

Presume the restaurant operates 360 days per year, A fast-food restaurant b...

A fast-food restaurant buys hamburger buns from a national bakery supplier. The daily usage of buns at the restaurant is normally distributed with an average of 160 and standard de

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