Written by students who passed Immediately available after payment Read online or as PDF Wrong document? Swap it for free 4.6 TrustPilot
logo-home
Lecture 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.

Institution
Module

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

Connected book

Written for

Institution
Module

Document information

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

Subjects

£6.92
Get access to the full document:

Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF

Get to know the seller
Seller avatar
alexperez

Also available in package deal

Get to know the seller

Seller avatar
alexperez University of Denver
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
1 year ago

0.0

0 reviews

5
0
4
0
3
0
2
0
1
0

Trending documents

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 exams and reviewed by others who've used these revision notes.

Didn't get what you expected? Choose another document

No problem! You can straightaway pick a different document that better suits what you're after.

Pay as you like, start learning straight 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 smashed it. It really can be that simple.”

Alisha Student

Frequently asked questions