100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached 4.2 TrustPilot
logo-home
Class notes

Lecture #8 - Linear Programming

Rating
-
Sold
-
Pages
4
Uploaded on
31-12-2024
Written in
2024/2025

Identify the objective, decision cells, and constraints in an optimization problem. Set up an optimization problem in Excel. Set up Solver to solve an optimization problem in Excel.










Whoops! We can’t load your doc right now. Try again or contact support.

Document information

Uploaded on
December 31, 2024
Number of pages
4
Written in
2024/2025
Type
Class notes
Professor(s)
Asim shrestha
Contains
Lecture #8 - linear programming

Subjects

Content preview

Assumptions

1.​ Limited resources
2.​ Explicit objectives
3.​ Linearity
4.​ Homogeneity
5.​ Divisibility



Parts of a Linear Program

●​ Objective (target cells)
●​ Decision cells (changing cells)
●​ Constraints



Maximization Problems




Minimization Problems

, Building a Linear Program

1.​ Identify and describe the objective
2.​ Identify and describe the decision variables
3.​ Identify and describe each constraints
4.​ Add non-negativity constraints
5.​ Combine everything into the model



Fuel & Solvent Company

You work at a company that produces two products: a fuel additive and a solvent. Each
of these products is formed from a combination of three materials.

OPTIMIZATION PROBLEM
You have been asked to find the best combination of products that will maximize
potential profit.



Objective

●​ Each ton of fuel yields a profit of $40
●​ Each ton of solvent yields a profit of $30

→ Maximum profit = $40 x Fuel + $30 x Solvent


Decision Cells

You have been asked to find the best combination of products that will maximize
potential profit.

DECISION CELLS
●​ Quantity (tons) of fuel
●​ Quantity (tons) of solvent
$8.39
Get access to the full document:

100% satisfaction guarantee
Immediately available after payment
Both online and in PDF
No strings attached

Get to know the seller
Seller avatar
alexperez

Also available in package deal

Thumbnail
Package deal
Analytics I: Data Management and Analysis
-
8 2024
$ 52.62 More info

Get to know the seller

Seller avatar
alexperez University of Denver
View profile
Follow You need to be logged in order to follow users or courses
Sold
2
Member since
1 year
Number of followers
0
Documents
47
Last sold
11 months ago

0.0

0 reviews

5
0
4
0
3
0
2
0
1
0

Recently viewed by you

Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Frequently asked questions