Share
Explore BrainMass

# Linear Programming problems:Excel solver

E* Q. Formulate and solve a spreadsheet model for the revised advertising-mix problem that includes
this fourth advertising medium. Identify the data cells, the changing cells, and the target cell.
Also show the Excel equation for each output cell expressed as a SUMPRODUCT function.
b. Indicate why this spreadsheet model is a linear programming model.
c. Express this model in algebraic form.

4.8 Consider a cost-benefit-trade-off problem having the following data:
a. Formulate a linear programming model for this problem on a spreadsheet. 3
b. Use the spreadsheet to check the following solutions: (X1,X2) = (7, 7), (7, 8), (8, 7), (8'-S).
(8,9), (9, 8). Which of these solutions are feasible? Which of these feasible solutions has the
best value of the objective function?
c. Use the Solver to find an optimal solution.
d. Express the model in algebraic form.

4.16 The Fagersta Steelworks currently is working two mines to obtain its iron ore. This iron ore is shipped to either of two storage facilities. When needed, it then is shipped on to the company's steel plant. The diagram below depicts this distribution network, where M1 and M2 are the two mines, S1 and S2 are the two storage facilities, and P is the steel plant. The diagram also shows the monthly amounts produced at the mines and needed at the plant, as well as the shipping cost and the maximum amount that can be shipped per month through each shipping lane.
Management now wants to determine the most economic plan for shipping the iron ore from the mines through the distribution network to the steel plant.
a. Identify all the requirements that will need to be expressed in fixed-requirement contraints.
E* b. Formulate and solve a linear programming model for this problem on a spreadsheet.
c. Express this model in algebraic form.

#### Solution Summary

This posting contains solutions to following LPPs:

\$2.19