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 organizational structure, Analyze the reason for the type of organi...

Analyze the reason for the type of organizational structure employed by the organization, and identify the key positions that support that organizational structure.

Explain descriptive statistics, Descriptive Statistics: Ages Variable Me...

Descriptive Statistics: Ages Variable Mean StDev Minimum Q1 Median Q3 Maximum Ages 23.56 8.97 17.00 18.25 21.00 23.75 49.00 1) Describe the shape of the data 2) What pe

, What happens if balance doesn’t exis

What happens if balance doesn’t exist

Explain the three steps in completing a job analysis, As an entrepreneur, h...

As an entrepreneur, how would you go about doing a job analysis for the first employee you are going to hire in your new business? What are the three steps in completing a job anal

Discuss entrepreneurship is more mundane, INC.. magazine claims, "Entrepren...

INC.. magazine claims, "Entrepreneurship is more mundane than it is sometimes portrayed . . . you don't need to be a person of mythical proportions to be very, very successful in b

Explain cost benefit analysis, Explain cost benefit analysis. Cost Ben...

Explain cost benefit analysis. Cost Benefit Analysis: This analysis is a mathematical technique for decision-making. This is a quantitative technique used to estimate the eco

Describe find the shortest route from node 1 to node 6, Find the shortest r...

Find the shortest route from Node 1 to Node 6. From Node To Node Distance 1 2 150 1 3 200 2 3 100 2 4 200 2 5 50 3 4 350 3 5 300 4 6 100 5 6 100 Which Answer is it? 300 450 550 650

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

Find what is the minimum unit price, An electronics firm is currently manuf...

An electronics firm is currently manufacturing an item that has a variable cost of $.50 per unit and a selling price of $1.00 per unit. Fixed costs are $14,000 per month. Current d

Explain minimum probability of performing needed, A system consists of thre...

A system consists of three identical components. In order for the system to perform as intended, all of the components must perform. Each has the same probability of performance. I

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