I'm looking for help using Solver to set up and solve the problem below. Please make sure to embed the formulation to the Linear Programming problem within the Excel solution. In addition to the typical supply and demand constraints that you need to include, please make sure to also account for the constraints which will ensure that locations 3, 4, 5, and 6 each receive at least 5 cars.

The Rent-a-dent car rentalcompany allows its customers to pick up a rental car at onelocation and return it to any of its locations. Currently 2locations(1,2) have 16 and 18 surplus cars and fourlocations(3,4,5,6) each need 10 cars. The cost of getting thesurplus cars from locations 1 and 2 to the other locations aresummarized in the following table.

Because 34 surplus cars are available at locations 1 and 2 and 40 cars are needed at locations 3,4,5 and 6, some locations will not receive as many cars as they need. However, management wants tomake sure that all the surplus cars are sent where they are needed and that each location needing cars receives at least five.

a. Formulate an LP model for this problem
b. Create a spreadsheet model for this problem and solve it using Solver.
c. What is the optimal solution?

Solution Summary

The solution provides a detailed explanation of how to find out the optimal solution by using excel solver.

WORLEY FLUID SUPPLIES PRODUCES THREE TYPES OF FLUID HANDLING EQUIPMENT CONTROL VALVES, METERING PUMPS AND HYDRAULIC CYLINDERS/ ALL THREE PRODUCTS REQUIRE ASSEMBLY AND TESTING BEFORE THEY CAN BE SHIPPED TO CUSTOMERS
CONTROL VALVE METERING PUMP HYDRAULIC CYLIND

The munchies cereal makes a cereal from several ingredients. Two of the ingredients, oats and rice provide A & B. The company wants to know how many ounces of oats andd rice should include in each box of cereal to meet the minimum requirements of 48 milligrams of vitamin A and 12 milligrams of vitamin B while minimizing cost. An

Consider a cost-benefit-trade-off problem having the following data:
Benefit Contribution
Per Unit of
Each Activity
Minimum
Acceptable
Benefit 1 2 Level
1 5 3 60
2 2 2 30
3 7 9 126
Unit Cost $60 $50
a. Formulate a linearprogramming model for this problem on a spreadsheet.
b. Use Solver to find the op

URE Industries gets a productivity of
f(x, y) = 2*x^2*y + 3*x*y^2 + 2*y^3
from x units of labor and y units of capital. If labor costs $50 per unit and capital costs $100 per unit, how many units of labor and capital should URE use, given that its budget is 150,000$?
a) Assume that x and y can be positive or negative (URE

Solve the linearprogramming model developed in Problem 22 for the Burger Doodle restaurant by using the computer. a. Identify and explain the shadow prices for each of the resource constraints. b. Which of the resources constraints profit the most? c. Identify the sensitivity ranges for the profit of a sausage biscuit and the a

Consider the following linearprogramming problem
MIN Z = 10x1 + 20x2
Subject to: x1 + x2 12
2x1 + 5x2 40
x2 13
x1 , x2 0
At the optimal solution, what is the value of surplus and slack associated with constraint 1 and constraint 3 respectively ?

Solve the following linearprogramming problem graphically, Maximize profit=
4x + 6y, Subject to: x + 2y ,< 8, 5x + 4y < 20, Non-negativity requirements x, y > 0, the greater than and less than sign have line under therm.

Management Science - Objectives, Constraints, Decision Variables. See attached file for full problem description.
H J K Total resources available
Resource X 4 6 5 1200
Resource Y 3 2 4 600
Resource Z 2 2 6 720
Profit contribution $34 $40 $44