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

Compute the movement cost or load, Registration at Southern University has ...

Registration at Southern University has always been a time of emotions, commotions and lines. Students must move among 4 stations to complete the process. Last semester's registrat

Explain levels of management by management skills, Explain levels of Manage...

Explain levels of Management by Management Skills. Management Skills needed successful manager, be categorized as given below: Technical skill refers to the pro

Explain private employees to prevent drug, Should urine testing, or other t...

Should urine testing, or other types of testing, be permitted among public and private employees to prevent drug and alcohol abuse? why or why not?

Explain concerns for product design in a dfma program, Name and briefly des...

Name and briefly describe the four primary concerns for product design in a DFMA program.

Explain forces for change can either be internal or external, Forces for ch...

Forces for change can either be internal or external. Describe each of these forces that can cause a change and give an example of each type of force.

Define conflict conceptualized differently under the unitary, The National ...

The National Labour Relations Act has been criticized as an outdated piece of legislation that is hindering, rather than helping, American cope with the realities of the new global

Integrated solutions in product design, Integrated solutions in product des...

Integrated solutions in product design and control of machinery are based on    CAD and CAM technologies.

Explain benefits and variable pay, Benefits and Variable Pay Please respond...

Benefits and Variable Pay Please respond to the following- • Analyze the types of benefits usually available in the health care industry and determine which benefits are most im

Explain morale, Explain Morale. Morale: It is a measure of extent whi...

Explain Morale. Morale: It is a measure of extent which level as either high or low of voluntary cooperation illustrated by a individual or a work group and of the intensity

In detail identify three other supply chain issues, a) Determine the total ...

a) Determine the total cost (purchase price + delivery cost) to make a Blaster unit using these woofer and tweeter components and each delivery combination option? W1 & T1: W2 &

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