Spreadsheet Modeling and Applications: Essentials of Practical Management
Science
Chapter 1
Introduction to Modeling
DS 570 Management Science
Chap 1-1
Model and Modeling
A model is a mathematical description of a system.
Linear programming models
Network
Binding constraint: constraint that holds as an equality \
Non binding / Slack: constraint where there is a difference, called the slack, between the two sides of the
inequality:
Constraints: Conditions that must be satisfied in an optimization model
Fea
Student Instruction Sheet
Early Supplier Integration in the Design of the Skid-Steer Loader
(John Deere Case; page 448; 6th edition of Schroeder)
Instructions to Students:
1. Read the case carefully, assimilating all facts and data.
2. Read the Problem So
Chapter 6
Exercise 16
Real Estate Developer
Types of Apartments
Efficiencies
One Bedroom
Two Bedroom
Three Bedroom
Req. SqFt
500
700
800
1000
Total
Rent Prices
$350
$450
$550
$750
$23,200
Total Sq Ft
Units Build
0
8
22
10
40
33,200
Decision Variables
E =
Ch. 3 Question 20
Total Cost
Elec
30,000
0
Gas
10,000
5,000
$55
$67
$85
$95
Total Avail
Total Req
30,000
30,000
15,000
15,000
Resources
Production
Assembly
Packaging
0.2
0.3
0.1
0.4
0.5
0.1
# to make
# to buy
Cost to make
Cost to buy
Used
10000
14000
4000
Chapter 3 Exercise 22 HW
Bond
Returns
Maturity
risk
tax free
A
B
C
$20,338.98
$20,338.98
$29,661.02
9.5%
8.0%
9.0%
long
short
long
long
high
low
low
high
yes
yes
no
yes
Short Term
Short Term
Short Term
limit %
limit amt
Total
50.0%
$50,000.00
$50,000.00
H