Constraints
1
2
5
Changing Cells
63
Profit
5
Totals
1
3
4
90
207
423
90
207
425
27
7
Total Profit
504
ABC Company manufactures two products, X and Y. Each unit of Product X requires 2 units of sheet
metal and 5 units of plastic. Each unit of Product Y
Bryant 1
Sharon C. Bryant
MGT 340 Intro Science Management
Dr. J
March 19, 2015
Exam Curve 3
State of Nature
Alternative
S1
S2
A1
75
-40
A2
0
100
Prior Probability
0.6
0.4
2. There is an option of paying $100 to have research done to better predict which
Chapter 8
NONLINEAR PROGRAMMING
INTRODUCTION
In every problem done thus far, the
constraints have use simple addition,
subtraction, and multiplication. Now
the constraints are going to have
exponents, radicals, and other
nonlinear functions such as logari
Chapter 9
DECISION ANALYSIS
DEFINITIONS
Decision maker: An individual or group responsible for
making decisions.
Alternatives: The options for the decision to be made
by the decision maker.
State of nature: Random factors that determine the
outcome of the
Microsoft Excel 15.0 Feasibility Report
Worksheet: [Book1]Sheet1
Report Created: 2/5/2015 11:43:19 PM
Constraints Which Make the Problem Infeasible
Cell
Name
Cell Value
Formula
Status
$G$9 See first constraint
420 $G$9<=$I$9 Binding
Slack
0
Microsoft Exce
Bryant 1
Sharon C. Bryant
MGT 340 Intro Science Management
Dr. J
March 19, 2015
Exam Curve 3
State of Nature
Alternative
S1
S2
A1
75
-40
A2
0
100
Prior Probability
0.6
0.4
2. There is an option of paying $100 to have research done to better predict which
Location
A
A
B
Responding To C
D
E
B
2.9
13.8
14.2
6.8
7.3
Cost (in millions $)
13.8
1.5
15.1
14.8
14.1
D
14.2
15.1
2.6
8.2
9.6
minimum
response time
6
E
6.8
14.8
8.2
2.3
6.4
7.3
14.1
9.6
6.4
2.6
3.7
3.1
4.2
2.7
3.6
1
Where?
1
1
1
minimum cost
17.3
1
A
A
Location
A
A
B
Responding To C
D
E
B
1.8
11.8
14.2
6.8
7.3
Cost (in millions $)
11.8
2.3
15.1
12.6
13.8
D
14.2
15.1
1.4
8.2
9.6
minimum
response time
7
E
6.8
12.6
8.2
1.8
6.4
7.3
13.8
9.6
6.4
2.7
1.4
3.1
4.2
4.4
3.6
0
Where?
1
1
1
minimum cost
11.7
0
A
A
Data
Selling Price
Fixed Costs
Marginal Cost
Sales Forecast
Production
Total Revenue
Total Fixed Cost
Total Variable Cost
Profit/Loss
$49.99
$1,282,292.00
$25.83
52,000
60,000
Income Stmt
$2,599,480.00
$1,282,292.00
$1,549,800.00
-$232,612.00
B - E Point
14.1.15 Problem - Chapter 2
Two products: X and Y
X= 2 units of Raw Material
Y = 5 Units of Raw Material
X = $3 profit
y = $6 profit
Goal: Max Profit
Constraints:
15 items made toal
45 units of Raw Material
Object Function: P = 3X + 6Y
X
1
2
Profit
Y
1
5
Total Fixed Costs
Total Variable Costs
Total Revenue
Total Costs
Profit
Break-even point
Results
$30,000,000.00
$260,000,000.00
$270,000,000.00
$290,000,000.00
-$20,000,000.00
60000 units
Data
Sales Forecast
Fixed Costs
Unit Revenue
Marginal Cost
Producti
Chapter 1 HW Quiz
XYZ Inc. sells a product for $22.45 per unit. It costs $13.13 to produce each product and the fixed
costs associated with the product are $15974.48. The company produced 5552 units but only sold
2295 of them. Determine the profit or loss
Total Fixed Costs
Total Variable Costs
Total Revenue
Total Costs
Profit
Break-even point
Results
$30,000,000.00
$260,000,000.00
$270,000,000.00
$290,000,000.00
-$20,000,000.00
60000 units
Data
Sales Forecast
Fixed Costs
Unit Revenue
Marginal Cost
Producti
Amount to produce (in lbs)
Amount to produce (in lbs)
Time to produce (in hours)
Hot Dogs
0
0.25
0.05
Weenies and Buns: Maximizing Profit
Hot Dog Buns Optimal amount of resource
0.1
200
0
800
0.03
220
Profit
$0.20
$0.10
Max Profit
Production Level
3200
20
Pg. 57 Problem 2.19
Data
Two Products: Hot Dogs (H) and Buns (B)
H = .25 lbs of Pork
H = 3 mins of Labor
H = .20 Profit
B = .10 lbs of Flour
B = 2 mins of Labor
B = .10 Profit
Lauren Prott
Mins of Labor
Pounds of Flour
Pounds of Pork
Hot Dogs
3.00
0.00
0.