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

Define the strategies that you might use in addressing goals, Develop a str...

Develop a strong talent management program globally to develop and retain talent that you have been losing to competitors and downsizing. Discuss the strategies that you might use

Describe different leadership theories, This week you learned about a numbe...

This week you learned about a number of different leadership theories. Choose two of today's leaders listed below and research on their leadership styles: • Richard Branson •

Explain elements of the integrated model of motivation, Analyze the four el...

Analyze the four elements of the integrated model of motivation to determine which element is the most essential to get right when motivating employees. Explain your rationale. •As

Explain organizational complexity affect human behaviour, Given the multipl...

Given the multiple components (subsystems) of the organizational system model, organizations might be said to be complex. Drawing from your own work and organizational experiences

Explain a set of circumstances consider disciplinary action, Describe a set...

Describe a set of circumstances under which you might legitimately consider disciplinary action for a chronic complainer.

Describe what is meant by a franchise, Question: a) What is a strategy...

Question: a) What is a strategy? b) Describe what is meant by a franchise. c) Henry Fayol put forward 6 primary functions of management. State the 6 functions and brief

Explain companies doing acquisitions and mergers in future, Based on your r...

Based on your research of the United and Continental Airline merger, evaluate the challenges experienced during the merger and the resulting impact to the business. Assess the effe

Describe contract types has the greatest risk with the buyer, Which of the ...

Which of the following contract types has the greatest risk with the buyer? Answer Cost sharing Cost-Plus-Incentive-Fee Firm-Fixed-Price Fixed-Price-Incentive-Fee

Compute the value of the policy variable, You are asked to analyze the kanb...

You are asked to analyze the kanban system of LeWin, a French manufacturer of gaming devices. One of the workstations feeding the assembly line produces part M670N. The daily deman

Responsiveness - customer satisfaction and service quality, Responsiveness ...

Responsiveness - Customer Satisfaction and Service Quality Concerns the willingness or readiness of employees to provide service. It involves timeliness of service: mailing a

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