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

Find the probability that both service clerks are busy, Discounts Wholesale...

Discounts Wholesale Club has two service desks, one at each entrance of the store. Customers arrive at each service desk at an average of one every six minutes. The service time at

Explain making and marketing the new product, Mary Williams, owner of Willi...

Mary Williams, owner of Williams Products, is evaluating whether to introduce a new product line. After thinking through the production process and the costs of raw materials and n

Use of confidence interval calculator and the area gas, To complete this sc...

To complete this scenario, use the Confidence Interval Calculator and the Area Gas Prices %u2013 Random Sample documents, provided in the Resources. The Minneapolis Star Tribune

Explain divisions of labour are appropriate, Draw an organizational chart o...

Draw an organizational chart of the business school or college that you attend. Outline its major roles and functions. How differentiated is it? Do you think the distribution of au

Soucing, advantages and disadvantages of parallel sourcing

advantages and disadvantages of parallel sourcing

Changes in employment by sector - operations function, (1) Firstly, conside...

(1) Firstly, consider the changes in employment by sector over the period charted in the figure (1850 - 2000). What factors do you think contributed to the reduction in employment

Explain how do hr managers cope with stress, Why hr managers, etc. Is a lon...

Why hr managers, etc. Is a lonely job? How do hr managers cope with stress? What does it take to become a hr manager? Reference and cited

Production control, Production Control After planning the next manageri...

Production Control After planning the next managerial production function is to control the production according to the production plans because production plans cannot be acti

Explain hospital risk pool, A hospital has contracted with an HMO to provid...

A hospital has contracted with an HMO to provide acute care inpatient services for $1,000 per day, subject to a 10 percent withhold. The proposed budget for inpatient services is b

Compute the estimated sample size needed, Practical Application Scenario 2 ...

Practical Application Scenario 2 To complete this scenario, use the Sample Size Estimator file provided in the Resources. The third shift at Microsoft's Windows' security uni

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