2010 Fall, ECON 2500, Homework 15 and 16 Key
# 3 from the scan entitled "Problems 2-25, pg 195-206, Linear Programming Applications.pdf" in the class folder on the G driv
Objective:
Maximized Return: $ 188,800.00
Decisions:
Automobile Furniture Other Secured Signature
Amount $630,000.00 $170,000.00 $460,000.00 $140,000.00
Constraints:
Automobile Furniture Other Secured Signature
Maximum Automobile 1
Maximum Furniture 1
Maximum Other Secured 1
Maximum Signature 1
Maximum Risk-Free Securities
Signature Loan Maximum -0.1 -0.1 -0.1 0.9
Third Constraint -1 1 1
Fourth Constraint 1 1
Maximum Total 1 1 1 1
Paremeters:
Automobile Furniture Other Secured Signature
Rates of return: 8% 10% 11% 12%
ions.pdf" in the class folder on the G drive
Risk-Free Securities
$600,000.00
Risk-Free Securities Sumproduct Inequality Constraint
$630,000.00 = 5
>= 6
>= 10
>= 7
>= 4
>= 6
>= 0
>= 0
>= 0
>= 0
>= 0
>= 0
2010 Fall, ECON 2500, Homework 15 and 16 Key
# 25 from the scan entitled "Problems 2-25, pg 195-206, Linear Programming Applications.pdf" in the class folder on the G dr
Objective/Target Cell
Minimized Costs of Part-Time Workers: $ 152.00
Decisions/Changing Cells
Full Time @ 11 AM Full Time @ 1 PM 11 AM Noon 1 PM 2 PM 3 PM 4 PM
Employees Starting at: 1 1 8 -0 0 -0 2 0
Constraints
Full Time @ 11 AM Full Time @ 1 PM 11 AM Noon 1 PM 2 PM 3 PM 4 PM
11 AM to Noon 1 0 1 0
Noon to 1 PM 1 0 1 1
1 PM to 2 PM 1 1 1 1 1
2 PM to 3 PM 1 1 1 1 1 1
3 PM to 4 PM 0 1 0 1 1 1 1
4 PM to 5 PM 1 1 1 1 1 1
5 PM to 6 PM 1 0 1 1 1
6 PM to 7 PM 1 1 1 1
7 PM to 8 PM 1 1 1
8 PM to 9 PM 1
9 PM to 10 PM 1
11 AM Minimum 1
Noon Minimum 1
1 PM Minimum 1
2 PM Minimum 1
3 PM Minimum 1
4 PM Minimum 1
5 PM Minimum
6 PM Minimum
Parameters
Part-time Wage Rate = $7.60
in the class folder on the G drive
5 PM 6 PM
4 6
5 PM 6 PM Sumproduct Inequality Constraint
9 >= 9 0
9 >= 9 1
10 >= 9 2
10 >= 3 3
3 >= 3 4
4 >= 3 5
1 6.999999998 >= 6 6
1 1 14 >= 12 7
1 1 12 >= 12 8
1 1 11 >= 7 9
1 7 >= 7 10
8 >= 0 11
-3.155E-10 >= 0
1.8969E-09 >= 0
-3.5527E-10 >= 0
1.999999999 >= 0
5.71019E-11 >= 0
1 4 >= 0
1 6 >= 0