Your company, Gnomes-to-Go, makes three ornamental models of gnomes: Lawn, Porch and Sidewalk. Each gnome has to go through three departments:
Casting, Deburring and Painting. The material costs are $4, $2, and $3, for Lawn, Porch and Sidewalk, respective
NOTE: Before starting this problem, please read part b of this question, and be sure to name your arrays in a manner consistent with the
instructions.
The McKnew Company is multinational company that imports, distributes, and sells Rubber Chickens to Clem
Mgt 312 Exam 1
Note Sheet
The feasible region is the collection of all points that simultaneously satisfy all of the
constraints.
There can never be an optimal point of profit in the feasible region on the interior; it will
lie on a corner/line.
Solver
Lawn
Porch
Sidewalk
Product made
Revenue
Material cost
Labor cost
Profit per unit
Constraints
Casting
Deburring
Painting
Profit
<- named range
<- sales price
<- SUMPRODUCT(C10:C12,I10:I12)
replace C with D and E
<- profit = revenue - material cost - labor
ContinuousTitle columns: replication| (i.e. $); Discrete means whole numbers/integers only (i.e. people)
1. means decimals are possible
IF(logical start),what to do if true,what to do if false)
Continuous uniformly distributed btwn a&b: U(a,b) = a + (b-a)
Introductory Linear Programming Problem
We have three farms located in three different western states. Each farm is limited as to
the number of acres of irrigable land and the amount of water available during a growing
season:
Farm
1
2
3
Usable land
400
6
T he Good To Go. Problem
Problem state m e n t:
Good ToGo makes three kinds ofsuitcas es: Stand a r d, Deluxe and Luxury styles.
Each suitcase goes through four production stages: Cutting &Coloring, Assembly,
Finishing, and Quality &Packaging. The total
Introductory Linear Programming Problem
We have three farms located in three different western states. Each farm is limited as to
the number of acres of irrigable land and the amount of water available during a growing
season:
Farm
1
2
3
Usable land
400
6
Minimum Cost Flow Problems
Basic network problem: Nodes connected by arcs
Supply node: Net flow (outflow-inflow) is positive
Demand node: Net flow is negative
Transshipment node: Net flow is zero
Capacity: Maximum flow through an arc
Assumptions
1. At lea
X1
Profit per unit
Production
put into solver Constraint
put into solver Constraint
put into solver Constraint
Profit
SOLVER:
select simple
X2
9
5
12
12
4
X3
6
10
15
5 (put in solver)
6
-6
0
(use sumproduct)
Utlilized
30
270
0
0
2
30
180 (use sumproduct)
Sample LP Applications
Manufacturing Applications
Your company produces headbands and wristbands for athletes. Each can be either all cotton or a mix of
cotton and 10% spandex. You have promised local retailers to supply a minimum of 200 all cotton
headba
Introductory Linear Programming Problem
We have three farms located in three different western states. Each farm is limited as to
the number of acres of irrigable land and the amount of water available during a growing
season:
Farm
1
2
3
Usable land
400
6
Cost
TC
From
250 Anderson
275 Anderson
290 Statesboro
230 Statesboro
350 Greenville
300 Greenville
325 Greenville
315 Macon
290 Macon
310 Macon
320 Macon
100 SO
125 SO
150 SO
35665
To
Greenville
Macon
Greenville
Macon
Raleigh
Columbia
Atlanta
Columbia
Atl
Month
Food
Clothing
August
104.362057
September 110.072754
October
131.226491
November
116.645978
December
119.723612
January
104.255558
February
141.613974
March
122.76125
April
143.352565
May
117.338065
Essentials Date?
$50 44.8563687 N
$50 49.7330213 N
Option 1
ProbabilityCumulative Return
0.3
0
1
0.3
0.3
5
0.4
0.6
7
Sample
1
2
Defined as array
3
Option1
4
5
6
7
8
9
10
RN
Coin Toss
0.177945
H
0.525687
T
0.970871
T
0.353819
H
0.444262
H
0.502387
T
0.7087
T
0.929384
T
0.596739
T
0.129099
H
Total number he
Cost
TC
From
250 Anderson
275 Anderson
290 Statesboro
230 Statesboro
350 Greenville
300 Greenville
325 Greenville
315 Macon
290 Macon
310 Macon
320 Macon
100 SO
125 SO
150 SO
35665
To
Ship
Greenville
Macon
Greenville
Macon
Raleigh
Columbia
Atlanta
Columbi
Your company, Gnomes-to-Go, makes three ornamental models of gnomes: Lawn, Porch and Sidewalk. Each gnome has to go through three departments:
Casting, Deburring and Painting. The material costs are $4, $2, and $3, for Lawn, Porch and Sidewalk, respective