## [answered] Microsoft Excel 15.0 Answer Report Worksheet: [Assignment 4

Anyway you can help interpret a & b. I just cannot explain it in my own words. This is due tonight.?

Microsoft Excel 15.0 Answer Report

Worksheet: [Assignment 4_Solution.xlsx]1(a)

Report Created: 3/12/2015 3:33:11 PM

Result: Solver found a solution. All Constraints and optimality conditions are satisfied.

Solver Engine

Engine: Simplex LP

Solution Time: 0.015 Seconds.

Iterations: 3 Subproblems: 0

Solver Options

Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling

Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative Objective Cell (Max)

Cell

Name

\$G\$9 Year 6 Ending Balance Original Value

\$54 Variable Cells

Cell

Name

Original Value

\$B\$11 Participation Project A

51%

\$C\$11 Participation Project B

100%

\$D\$11 Participation Project C

0% Constraints

Cell

Name

\$G\$4 Year 1 Ending Balance

\$G\$5 Year2 Ending Balance

\$G\$6 Year 3 Ending Balance

\$G\$7 Year 4 Ending Balance

\$G\$8 Year 5 Ending Balance

\$G\$9 Year 6 Ending Balance

\$B\$11 Participation Project A

\$C\$11 Participation Project B

\$D\$11 Participation Project C Final Value

\$54 Final Value

Integer

51% Contin

100% Contin

0% Contin Cell Value

Formula

\$8 \$G\$4&gt;=\$I\$4

\$2 \$G\$5&gt;=\$I\$5

\$2 \$G\$6&gt;=\$I\$6

\$17 \$G\$7&gt;=\$I\$7

\$48 \$G\$8&gt;=\$I\$8

\$54 \$G\$9&gt;=\$I\$9

51% \$B\$11&lt;=\$B\$13

100% \$C\$11&lt;=\$C\$13

0% \$D\$11&lt;=\$D\$13 Status

Slack

Not Binding

\$6

Not Binding

\$0

Binding

\$0

Not Binding

\$15

Not Binding

\$46

Not Binding

\$52

Not Binding 0.4886363636

Binding

0

Not Binding

1 Starting Balance Year 1

Year2

Year 3

Year 4

Year 5

Year 6 Cash Flow (at full participation)

Project A

Project B Project C Total Case Flow Other Project

-4.5

-6

-14 -8.3011363636

-6.8

-8

-8 -11.4772727273

-6.3

-3

-8 -6.2215909091

21

-2

-7 8.7386363636

0

25

-4

25

0

0

38

0 Participation 51%

&lt;= 100%

&lt;= 100% 0%

&lt;= 100% 100% 6

6

6

6

6

6 \$10

Ending Balance

\$8

\$2

\$2

\$17

\$48

\$54 &gt;=

&gt;=

&gt;=

&gt;=

&gt;=

&gt;= Minimum Balance

2

2

2

2

2

2 Microsoft Excel 15.0 Answer Report

Worksheet: [Assignment 4_Solution.xlsx]1(b)

Report Created: 3/12/2015 3:33:26 PM

Result: Solver found a solution. All Constraints and optimality conditions are satisfied.

Solver Engine

Engine: Simplex LP

Solution Time: 0.047 Seconds.

Iterations: 3 Subproblems: 0

Solver Options

Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling

Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative Objective Cell (Max)

Cell

Name

\$G\$9 Year 6 Ending Balance Original Value

\$62 Variable Cells

Cell

Name

Original Value

\$B\$11 Participation Project A

74%

\$C\$11 Participation Project B

100%

\$D\$11 Participation Project C

0% Constraints

Cell

Name

\$G\$4 Year 1 Ending Balance

\$G\$5 Year2 Ending Balance

\$G\$6 Year 3 Ending Balance

\$G\$7 Year 4 Ending Balance

\$G\$8 Year 5 Ending Balance

\$G\$9 Year 6 Ending Balance

\$B\$11 Participation Project A

\$C\$11 Participation Project B

\$D\$11 Participation Project C Final Value

\$62 Final Value

Integer

74% Contin

100% Contin

0% Contin Cell Value

Formula

\$9 \$G\$4&gt;=\$I\$4

\$3 \$G\$5&gt;=\$I\$5

\$2 \$G\$6&gt;=\$I\$6

\$23 \$G\$7&gt;=\$I\$7

\$55 \$G\$8&gt;=\$I\$8

\$62 \$G\$9&gt;=\$I\$9

74% \$B\$11&lt;=\$B\$13

100% \$C\$11&lt;=\$C\$13

0% \$D\$11&lt;=\$D\$13 Status

Slack

Not Binding

\$7

Not Binding

\$1

Binding

\$0

Not Binding

\$21

Not Binding

\$53

Not Binding

\$60

Not Binding 0.2613636364

Binding

0

Not Binding

1 Starting Balance Year 1

Year2

Year 3

Year 4

Year 5

Year 6 Cash Flow (at full participation)

Project A

Project B Project C Total Case Other Project

-4.5

-6

-14 -9.323864

-6.8

-8

-8 -13.02273

-6.3

-3

-8 -7.653409

21

-2

-7 13.51136

0

25

-4

25

0

0

38

0 Participati 74%

&lt;= 100%

&lt;= 100% 0%

&lt;= 100% 100% 7

7

7

7

7

7 \$11

Ending Balance

\$9

\$3

\$2

\$23

\$55

\$62 &gt;=

&gt;=

&gt;=

&gt;=

&gt;=

&gt;= Minimum Balance

2

2

2

2

2

2

Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Sep 18, 2020

Solution~0001013837.zip (25.37 KB)

Buy this answer for only: \$15

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy from our tutoring website www.aceyourhomework.com (Deadline assured. Flexible pricing. TurnItIn Report provided)

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Sep 18, 2020

EXPERT

Tutor

ANSWER RATING

### Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN YOUR SET DEADLINE.