Linear Programming Problems

This site details the process of using Excel Solver to find the solution to three sample linear programming problems. The problems are intended to, but don’t need to be, worked in order. The process of setting up a problem in Excel is explained in greatest detail in Example 1, and in least detail in Example 3. Supplementary topics are listed at the bottom of this page or can be accessed by links within the sample problem pages.

Example 1 :	The Problem
The Transportation Problem	Enter the Problem into Excel
	Calculating the Constraint and Objective Function Answers
	Using Solver
	Analyze the Results
Example 2 :	Formulate the problem
Giapetto’s Woodcarving Problem	Enter the problem into Excel
	Using Solver
	Analyze the Results
Example 3 :	Formulate the problem
Bullco Fertilizer problem	Enter the problem into Excel
	Using Solver
	Analyze the Results
Excel Topics	Excel Basics
	Naming a Range of Cells
	Loading the Solver Add-In
	Adding Solver Constraints
	Setting Solver Options
Other Topics	MAT Lab Info
	Setup Your Lab Account