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 primary reason people buy, What Is The Primary Reason P...

What Is The Primary Reason People Buy And Own Major Appliance Such As Washing Machine. Is there a secondary reason as well?

Explain furniture manufacturer can maximize its revenue, A furniture manufa...

A furniture manufacturer produces tables and chairs. Each table and chair must be made entirely out of oak or entirely out of pine. A total of 150 board feet of oak and 210 board f

Describe factors affecting morale, Describe factors affecting morale. F...

Describe factors affecting morale. Factors that tend to lower or improve the worker morale are: 1. Job Factors - Nature of job, Fatigue and boredom related with the job,

Which strategy is assisting in an organisation, Which strategy is assisting...

Which strategy is assisting in an organisation? Organisational flexibility will assist the organisation accomplish short lead times needed while meeting customer demands, assis

Propose process improvements, propose process improvements, and justify you...

propose process improvements, and justify your reasons, for the improvements, to the flowchart for answering calls.

Define the future values of the following ordinary annuities, Find the futu...

Find the future values of the following ordinary annuities: a. FV of $800 paid each 6 months for 5 years at a nominal rate of 5%, compounded semi-annually. Round your answer to

Explain expert role for human resource professionals, The functional expert...

The functional expert role for human resource professionals: Answer A) is concerned with looking out for the interests of management B) is concerned with providing inputs that help

Explain how would you make a needs assessment, Suppose you were conducting ...

Suppose you were conducting a marketing analysis for a new textbook about technology management. What would you need to know to identify a market segment? How would you make a need

Define the reasons why a firm would seek iso registration, Discuss the reas...

Discuss the reasons why a firm would seek ISO 9000 registration.

Supplier relationships in a supply network, Supplier relationships in a sup...

Supplier relationships in a supply network are categorised in which ways:- Single, multiple, delegated and parallel

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