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 course wrap-up, "Course Wrap-Up" Please respond to the following: I...

"Course Wrap-Up" Please respond to the following: Identify three concepts from your graduate course work that you found to be of significant value and explain how you plan to apply

Explain different components of the marketing mix, What is the definition o...

What is the definition of marketing? What are the benefits and drawbacks of incorporating marketing into the sales function of an organization? Do you think that marketing should b

Describe what is the average time a car is in the system, Automobiles arriv...

Automobiles arrive at the drive-through window at the downtown Urbana, Illinois, post office at the rate of 4 every 10 minutes. The average service time is 2 minutes. The Poisson d

Explain what is the formula for calculating duration, Answer the following ...

Answer the following questions (use MS Project help if necessary)- Define effort-driven? Under what circumstances would you turn off effort driven scheduling? Use a real-w

Demand Forecasting and Inventory Management., Discuss the supply management...

Discuss the supply management''s heightened concern for future acquisition needs - for example, capital equipment acquisition, supplies contract, standard commodity, etc.

Explain an engine system consists of three main components, An engine syste...

An engine system consists of three main components in a series, all having the same reliability. Determine the level of reliability required for each of the components if the engin

After working for 30 years, After working for 30 years, Ramjee Somjee Dutt ...

After working for 30 years, Ramjee Somjee Dutt opted for VRS and started a courier company and did

Compute the schedule variance or cost performance index, A project to build...

A project to build a new bridge seems to be going very well since the project is well ahead of schedule and costs seem to be running very low. A major milestone has been reached wh

Explain some of the key decisions its management, Describe some of the key ...

Describe some of the key decisions its management has faced within the past year or two. Identify an ethical issue the organization either faces or has faced in the past. If it has

The Strategic Significance of Design, What is the strategic significance of...

What is the strategic significance of Design in operations management?

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