Chapter 9 b625aswc09financialplanning.xlsx

Chapter 9 b625aswc09financialplanning.xlsx - Microsoft...

Info icon This preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Microsoft Excel 15.0 Answer Report Worksheet: [b625aswc09financialplanning.xlsx]Sheet1 Report Created: 3/1/2016 9:12:21 AM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.063 Seconds. Iterations: 9 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.000001 Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative Objective Cell (Min) Cell Name Original Value Final Value $N$2 LHS 1 1728.7938549 Variable Cells Cell Name Original Value Final Value Integer $B$11 F 1 1728.7938549 Contin $C$11 B1 1 144.98814956 Contin $D$11 B2 1 187.85584783 Contin $E$11 B3 1 228.18791946 Contin $F$11 S1 1 636.14794384 Contin $G$11 S2 1 501.60571204 Contin $H$11 S3 1 349.68179096 Contin $I$11 S4 1 182.68091304 Contin $J$11 S5 1 0 Contin $K$11 S6 1 0 Contin $L$11 S7 1 0 Contin $M$11 S8 1 0 Contin Constraints Cell Name Cell Value Formula Status Slack $N$3 Year 1 LHS 430 $N$3=$P$3 Binding 0 $N$4 Year 2 LHS 210 $N$4=$P$4 Binding 0 $N$5 Year 3 LHS 222 $N$5=$P$5 Binding 0 $N$6 Year 4 LHS 231 $N$6=$P$6 Binding 0 $N$7 Year 5 LHS 240 $N$7=$P$7 Binding 0
Image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern