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

Quality management., examples of internal and external failure cost

examples of internal and external failure cost

Explain how many observations should the manager take, A bank manager wants...

A bank manager wants to determine the percent of time that tellers are working and idle. She decides to use work sampling, and her initial estimate is that the tellers are idle 30

Why management scientist to find the optimal solution, Dinoco produces thre...

Dinoco produces three types of oil products: domestic oil, petrol for car and aviation fuel. Each product must meet the minimum average octane regulation. The average octane levels

Explain lower foreign labour costs, Global expansion is fuelled by a (n): A...

Global expansion is fuelled by a (n): Answer (1) shrinking customer market, lower foreign labour costs, and advances in technology. (2) Expanding new customer market, lower foreign

Describe installing and servicing personal computer business, You work for ...

You work for a computer parts and software distributor. Your co-worker and friend is starting up a second business installing and servicing personal computers. She asks you not to

What does acknowledging sources involve, What does acknowledging sources in...

What does acknowledging sources involve? Sources of information and the ideas of others that you use in your assignments, research and class activities may include books, journa

Explain smoothing constan, Systembolaget uses forecasting to predict the nu...

Systembolaget uses forecasting to predict the number of bottles they think they will sell the next day. Below are the number of bottles sold each day during the five-day work week

Explain usefulness in that particular situation, The five types of leadersh...

The five types of leadership styles are most applicable in certain situations. Discuss the applicability of each of the five types in project leadership situations and its usefulne

QUALITY TIPS, QUALITY TPIS ON EFFECTIVE PLANNINGuestion #Minimum 100 words ...

QUALITY TPIS ON EFFECTIVE PLANNINGuestion #Minimum 100 words accepted#

Attract as well buyers to complete the on-line buying proce, It appears tha...

It appears that the potential to lose web site customers is a high rate (75%), so to provide research into troubleshooting to determine how to get customers to purchase product is

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