Microsoft Excel 15.0 Feasibility Report

Feasibility Report 1
Microsoft Excel 15.0 Feasibility Report
Worksheet: 1253982_part_a6_report.10.xlsxSheet1
Report Created: 30/09/2016 09:09:34
Constraints Which Make the Problem Infeasible
Cell Name Cell Value Formula Status Slack
$J$14 D4+D5+D6<=21 Cell 0 $J$14>=2000 Violated -2000

Feasibility Report 2
Microsoft Excel 15.0 Feasibility Report
Worksheet: 1253982_part_a6_report.10.xlsxSheet1
Report Created: 30/09/2016 09:09:34
Constraints (not including Variable Bounds) Which Make the Problem Infeasible
Cell Name Cell Value Formula Status Slack
$J$14 D4+D5+D6<=21 Cell 0 $J$14>=2000 Violated -2000

Sheet1

Target cell(max) Name Final values
Shares $26,200.00

Adjustable cells
Name Amount to be spend per stock CP Number of shares with the current price Projected future price Projected future income
MSP, Inc. $2,000.00 $25.00 80 $35.00 $2,800.00
James Industries $2,000.00 $50.00 40 $60.00 $2,400.00
Chronos, Inc. $10,000.00 $100.00 100 $125.00 $12,500.00
QM Associates, Inc. $9,000.00 $75.00 120 $90.00 $10,800.00
PharmoCo Research $2,000.00 $35.00 57.14 $50.00 $2,857.14
$25,000.00

Constraints
Cell Value Formula Inequality
0 25000 <= 10000 0 0 >= 2000
0 10000 25000
0 9000
0 2000