# Solver Microsoft Excel

Excel 2007 Excel 2003 Macros Excel 2007 Macros Excel 2003 Excel 2010

Need help with this Linear Programming Problem (Solver)?
To make one package of all beef hot dogs, a manufacturer uses 1 lb of beef; to make one package of regular hot dogs, the manufacturer uses 1/2 lb each of beef and pork. The profit on the all-beef hot dogs is 40 cents per pack and the profit on regular hot dogs is 30 cents per pack. If there are 200 lbs of beef and 150 lbs of pork available, how many packs of all-beef and regular hot dogs should the manufacturer make to maximize profit? What is the profit?

You can solve the problem in many ways. We can use simple Algebra or Solver and the advantages of the latter become obvious with the increase in the complexity of the problem.
Entering the data in the Microsoft Excel worksheet properly is half the battle won. The easiest way is to enter the data as the user narrates it. So we have entered the data for manufacturing one hot dog of each kind in cells B4:C5 and calculated the profit in range E4. The ingredients required, the quantity used in each hot dog, the total quantity used and the total quantity of meat available is entered into range B8 to E9 with appropriate headers.The quantity of meat used to manufacture the hot dogs is calculated based on the quantity of hot dogs produced. We also apply logical constraints like the calculations cannot have negative values in the production of hot dogs and the quantity of raw material used for production can never exceed what is available in the ware-house. Although these things are quite logical to the human brain the computer and its program need to be told this clearly!

Watch the video (12.3MB) below to see how Microsoft Excel's Solver performs its magic once you tell it what to do:

More Tips:
How do I view and edit Microsoft Excel files on an iPad?
Inventory Soluton
How to rename and color worksheet tabs
Copy Worksheet Quickly
Criteria Range
Animations in Microsoft Excel
Create two charts at once
How to avoid errors while working in Excel
How to benefit from Microsoft Excel Templates
How to use Microsoft Excel 2007 with Word 2007 - create mail merge labels
Landscape Oriented Worksheet Template
How to-make a worksheet fit a printed page
How to make your charts more impressive
Perpetual Calendar from 1900 to 9999
How to clear  conditional formattng  in Excel worksheets
How to speed up data entry of decimal numbers
How to change the color of the gridlines of an Excel worksheet or hide them
How to use Autosum in Multiple Worksheet Cells Quickly
How to have your free personal assistant in Mcrosoft Excel who reads out the data to you
How to use the status bar in Microsoft Excel to do a quick data analysis
How to calculate equal monthly payments or instalments using a mathematical equation
Data Forms to Enter and Edit Data
View 2 worksheets in same workbook side by side
Accessing a specific worksheet in large workbooks with multiple worksheets
Referencing a cell in another worksheet
How to perform a what-if analysis using a scrollbar form control
An interesting payroll solution
Future Value Solution in Microsoft Excel
Another Interesting Conditional Formatting Solution
DSUM and Array Formulas for addition solutions
IF Function Question
How to use command buttons on a splash screen in MS-Excel
Copy Paste Data from one Excel Worksheet to Another
How to separate comma separated values (csv) in a worksheet cell in Microsoft Excel into rows or columns
Excel 2007 Excel 2003 Macros Excel 2007 Macros Excel 2003 Excel 2010