Chapter 9 b625aswc09financialplanning.xlsx

# Chapter 9 b625aswc09financialplanning.xlsx - Microsoft...

• Lecture Slides
• 5

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

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

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

This is the end of the preview. Sign up to access the rest of the document.
• Spring '18
• Max Integer Sols, Zürich Hauptbahnhof

{[ snackBarMessage ]}

### What students are saying

• 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.

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

• 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.

Dana University of Pennsylvania ‘17, Course Hero Intern

• 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.

Jill Tulane University ‘16, Course Hero Intern