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
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.

Institution
Course

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
Course

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

R156,76
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

Document 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 notes.

Didn't get what you expected? Choose another document

No worries! You can immediately select a different document that better matches what you need.

Pay how you prefer, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card or EFT 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