Transcription of Excel Solver - MIT
{{id}} {{{paragraph}}}
Example: bachelor of science
Excel Solver - MIT
10/3/17 1 Excel Solver 1 Table of Contents Introduction to Excel Solver slides 3-4 Example 1: Diet Problem, Set-Up slides 5-11 Example 1: Diet Problem, Dialog Box slides 12-17 Example 2: Food Start-Up Problem slides 18-19 2 Note that there is an Excel file that accompanies this tutorial; each worksheet tab in the Excel corresponds to each example problem 10/3/17 2 Introduction to Excel Solver (1 of 2) Excel has the capability to solve linear (and often nonlinear) programming problems with the Solver tool, which: May be used to solve linear and nonlinear optimization problems Allows integer or binary restrictions to be placed on decision variables Can be used to solve problems with up to 200 decision variables Solver is an Add-In program that you will need to load in Excel Microsoft users 1.
• Consider the problem of diet optimization based on cost and different nutritional factors • There are four different types of food: Brownies, Ice Cream, Cola, and Cheese Cake, with nutrition values and cost per unit as follows: Cost Task: • Find a minimum-cost diet that contains – at least 500 calories
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document: