| Microsoft Excel 14.0 Answer Report | | | | | | | |
| Worksheet: [4571444_983971250_a3-dataAssignmentFile (1).xlsx]Stock Investment | | | | | | | |
| Report Created: 10/21/2020 1:27:31 PM | | | | | | | |
| Result: Solver found a solution. All Constraints and optimality conditions are satisfied. | | | | | | | |
| Solver Engine | | | | | | | |
| Engine: GRG Nonlinear | | | | | | |
| Solution Time: 0.046 Seconds. | | | | | | |
| Iterations: 4 Subproblems: 0 | | | | | | |
| Solver Options | | | | | | | |
| Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling | | | | | | |
| Convergence 0.0001, Population Size 100, Random Seed 0, Derivatives Forward, Require Bounds | | | | | | |
| Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative | | | | | | |
| | | | | | | |
| Objective Cell (Max) | | | | | | | |
| Cell | Name | Original Value | Final Value | | | |
| $H$10 | Unit Return TOTAL RETURN | $- | $1,200.00 | | | |
| | | | | | | |
| | | | | | | |
| Variable Cells | | | | | | | |
| Cell | Name | Original Value | Final Value | Integer | | |
| $C$9 | Numbers Produced A | – | 100.00 | Contin | | |
| $D$9 | Numbers Produced B | – | – | Contin | | |
| $E$9 | Numbers Produced C | – | – | Contin | | |
| | | | | | | |
| | | | | | | |
| Constraints | | | | | | | |
| Cell | Name | Cell Value | Formula | Status | Slack | |
| $F$12 | Price Per Stock | 2500 | $F$12<=$H$12 | Binding | 0 | |
