Linear programming problem in excel solver

B.1  The LP relationships that follow were formulated by Richard Martin at the Long Beach Chemical Company. Which ones are invalid for use in a linear programming problem, and why?
Maximize = 6X1 + 12 X1X2 + 5X3
Subject to: 4X1X2 + 2X3 ≤ 70
                       7.9X1 – 4X2 ≥ 15.6
                       3X1 + 3X2 + 3X3 ≥ 21
                       19X2 – 13 X3 = 17
                       -X1-X2 + 4X3 = 5
                       4X1 + 2X2 + 3 √X3 ≤ 80 

B.5   The Attaran Corporation manufactures two electrical products: portable air conditioners and portable heaters. The assembly process for each is similar in that both require a certain amount of wiring and drilling. Each air conditioner takes 3 hours of wiring and 2 hours of drilling. Each heater must through 2 hours of wiring and 1 hour of drilling. During the next production period, 240 hours of wiring time are available and up to 140 hours of drilling time may be used. Each air conditioner sold yields a profit of $25. Each heater assembled may be sold for a $15 profit. 

Formulate and solve this LP production-mix situation, and find the best combination of air conditioners and heaters that yields the highest profit. 

B.7   Green Vehicle, Inc. manufactures electric cars and small delivery trucks. It has just opened a new factory where the C1 car and the T1 truck can both be manufactured. To make either vehicle, processing in the assembly shop and in the paint shop are required. It takes 1/40 of a day and 1/60 of a day to paint a truck of type T1 and a car of type C1 in the paint shop, respectively. It takes 1/50 of a day to assemble either type of vehicle in the assembly shop. A T1 truck and a C1 car yield profits of $300 and $220, respectively, per vehicle sold. Formulate and solve an LP to maximize profit for the company.

Define the objective function and constraint equations.

Graph the feasible region.

What is a maximum profit daily production plan at the new factory?

How much profit will such a plan yield, assuming whatever is produced is sold?


Each coffee table produced by Kevin Watson Designers nets the firm a profit of $9. Each bookcase yields a $15 profit.​ Watson’s firm is small and its resources limited. During any given production period ​(of 1 ​week)​, 10 gallons of varnish and 12 lengths of​ high-quality redwood are available. Each coffee table requires approximately 1 gallon of varnish and 1 length of redwood. Each bookcase takes 1 gallon of varnish and 2 lengths of wood.

Formulate Watson’s production-mix decision as a linear programming problem, and solve. How many tables and book-cases should be produced each week? What will the maximum profit be?


Doug Turner Food Processors wishes to introduce a new brand of dog biscuits composed of chicken- and liver-flavored biscuits that meet certain nutritional requirements. The liver-flavored biscuits contain 1 unit of nutrient A and 2 units of nutrient B; the chicken-flavored biscuits contain 1 unit of nutrient A and 4 units of nutrient B. According to federal requirements, there must be at least 40 units of nutrient A and 60 units of nutrient B in a package of the new mix. In addition, the company has decided that there can be no more than 15 liver-flavored biscuits in a package. If it costs 1¢ to make 1 liver-flavored biscuit and 2¢ to make 1 chicken-flavored, what is the optimal product mix for a package of the biscuits to minimize the firm’s cost? 

a) Formulate this as a linear programming problem. 

b) Solve this problem graphically, giving the optimal values of all variables. 

c) What is the total cost of a package of dog biscuits using the optimal mix?

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more