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 what is the role and impact of hr practices, What is the role and i...

What is the role and impact of HR practices domestically and internationally when globalization forces the organization to seek expansion overseas?

Explain vutton handbags, In which of the following situations would a court...

In which of the following situations would a court likely hold Melissa liable for copyright infringement? Please debate and support your answer with appropriate cites to support. A

Process configurations - products, Process configurations - products ...

Process configurations - products The categorisation of production systems according to volume of output was discussed: project, job shop, batch and continuous. The Hayes and

Explain e-activity evaluate the lessons, From the e-Activity, evaluate the ...

From the e-Activity, evaluate the lessons learned in this chapter to determine which single lesson would be most beneficial to the company you researched. Provide specific examples

Explain forecast week 7 using a six-week moving average, Weekly sales of ry...

Weekly sales of rye bread at the corner store are shown below. Using this data, forecast Week 7 using a six-week moving average. Week Sales 1 415 2 389 3 420 4 382 5

Explain what is the purpose of registering securities, Analyze why you thin...

Analyze why you think that the Securities Act of 1933 allows for an exemption to a nonprofit educational organization? The state, based on their securities regulations, could re

Disparate impact exists hiring records, If a plaintiff proves that a dispar...

If a plaintiff proves that a disparate impact exists, an organization may then defend its employment by showing validation or _______________. a. business necessity b. hiring recor

Depict the project network using aon, Task time estimates for a production ...

Task time estimates for a production line setup project at Robert Klassens Ontario factory are as follows: Activity Time (in hours) Immediate Predecessors A 6.0 B 7.2 C 5.0 A D 6.0

Explain different types of decisions, Explain Different types of Decisions....

Explain Different types of Decisions. Different types of Decisions: Decisions may be of various types. Several of the significant types of managerial decisions are explained

Improve efficiency in service organisations, Lean" thinking was first devel...

Lean" thinking was first developed with manufacturing organisations in mind. Explain FIVE examples of ways in which these waste elimination principles may be applied to improve eff

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