OEM DMOR Homework #2
Due Friday, September 21
st
(by midnight)
Model the following problems and display the optimal solution you obtain from Solver.
You do not need to turn in your Excel files.
Question 1.
We are trying to measure airplane fuel consumption,
f
, as a function of
distance traveled,
d
, and cruising altitude,
a
.
We have 8 data points, given as follows:
Observation
f
i
d
i
a
i
1
1100
17
22
2
1420
25
22
3
1900
29
35
4
1840
33
34
5
2000
36
30
6
2300
47
35
7
2640
53
39
8
2850
60
41
Part a:
One engineer believes that we can write fuel consumption as a linear function of
distance and altitude, i.e., if we’re planning a flight with distance
D
and cruising altitude
A
, our fuel consumed should be
p
1
D
+
p
2
A
, for some values
p
1
and
p
2
.
Our problem is to
determine the values of
p
1
and
p
2
that minimize the absolute value of errors predicted by
this formula.
That is, choose values of
p
1
and
p
2
that minimize:
1100 – 17
p
1
– 22
p
2
 + 1420 – 25
p
1
– 22
p
2
 + … + 2850 – 60
This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
This is the end of the preview.
Sign up
to
access the rest of the document.
 Fall '09
 VLADIMIRLBOGINSKI
 Water supply, Seawater, Water management

Click to edit the document details