Explanation Given Information: There are 20 salespeople stationed in Chicago and 10 salespeople are stationed in Denver. A round trip from Chicago to Los Angeles costs $195 and from Denver to Los Angeles costs $395. At most 10 salespeople can be flown to Los Angeles. A round trip plane flight from Chicago to New York costs $182 and from Denver to New York costs $166. The amount of money that can be spent to fly the salespeople is $5,770. Calculation: Consider the number salespeople that you should fly from Chicago to Los Angeles to be x , the number salespeople that you should fly from Chicago to New York to be y , the number of salespeople that you should fly from Denver to Los Angeles be z and the number of salespeople that you should fly from Denver to New York to be w . Maximize: p = x + y + z + w With subject to: 195 x + 182 y − 395 z + 166 w ≤ 5770 x + y ≤ 20 z + w ≤ 10 x + z ≤ 10 y + w ≤ 15 x ≥ 0 , y ≥ 0 , z ≥ 0 , w ≥ 0 Use Excel spreadsheet to solve the following linear programming problem, Maximize: p = x + y + z + w With subject to: 195 x + 182 y − 395 z + 166 w ≤ 5770 x + y ≤ 20 z + w ≤ 10 x + z ≤ 10 y + w ≤ 15 x ≥ 0 , y ≥ 0 , z ≥ 0 , w ≥ 0 First open an excel spreadsheet, Then follow the following steps: Step 1: Enter the text in the cells as,

7th Edition

ISBN: 9781337280426

Author: Stefan Waner, Steven Costenoble

Publisher: Cengage Learning

See similar textbooks

Videos

Question

Chapter 5.3, Problem 46E

To determine

To calculate: The number of salespeople that you should fly from Chicago to Los Angeles, Chicago to New York, Denver to Los Angeles and Denver to New York with the help of the provided information.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Chapter 5.3, Problem 45E

Chapter 5.3, Problem 47E

Students have asked these similar questions

pl4ease do not provide solution in image format thank you!

A furniture store expects to sell 120 coffee tables during the next year. It costs $1.50 to store one coffee table for one year. To reorder, there is a fixed cost of $10, plus $2.80 for each coffee table ordered. In what lot size and how many times per year should an order be placed to minimize inventory costs? coffee tables per order orders per year

Briefly describe the concept of double taxation. Particularly explain how corporations are subject to double taxation while a sole proprietorship is not subject to double taxation.

Chapter 5 Solutions

Finite Mathematics

Ch. 5.1 - In Exercises 1-26, sketch the region that...Ch. 5.1 - In Exercises 1-26, sketch the region that...Ch. 5.1 - In Exercises 1-26, sketch the region that...Ch. 5.1 - In Exercises 1-26, sketch the region that...Ch. 5.1 - In Exercises 1-26, sketch the region that...Ch. 5.1 - Prob. 6E Ch. 5.1 - In Exercises 1-26, sketch the region that...Ch. 5.1 - In Exercises 1-26, sketch the region that...Ch. 5.1 - Prob. 9E Ch. 5.1 - In Exercises 1-26, sketch the region that...

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, subject and related others by exploring similar questions and additional content below.

The number of salespeople that you should fly from Chicago to Los Angeles, Chicago to New York, Denver to Los Angeles and Denver to New York with the help of the provided information.

Solution Summary: The author calculates the number of salespeople that you should fly from Chicago to Los Angeles, Chicago, New York, Denver, and Denver.

Videos

To calculate: The number of salespeople that you should fly from Chicago to Los Angeles, Chicago to New York, Denver to Los Angeles and Denver to New York with the help of the provided information.

Want to see the full answer?

Chapter 5 Solutions