Question Details

[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>=$I$4

 

$2 $G$5>=$I$5

 

$2 $G$6>=$I$6

 

$17 $G$7>=$I$7

 

$48 $G$8>=$I$8

 

$54 $G$9>=$I$9

 

51% $B$11<=$B$13

 

100% $C$11<=$C$13

 

0% $D$11<=$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%

 

<= 100%

 

<= 100% 0%

 

<= 100% 100% 6

 

6

 

6

 

6

 

6

 

6 $10

 

Ending Balance

 

$8

 

$2

 

$2

 

$17

 

$48

 

$54 >=

 

>=

 

>=

 

>=

 

>=

 

>= 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>=$I$4

 

$3 $G$5>=$I$5

 

$2 $G$6>=$I$6

 

$23 $G$7>=$I$7

 

$55 $G$8>=$I$8

 

$62 $G$9>=$I$9

 

74% $B$11<=$B$13

 

100% $C$11<=$C$13

 

0% $D$11<=$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%

 

<= 100%

 

<= 100% 0%

 

<= 100% 100% 7

 

7

 

7

 

7

 

7

 

7 $11

 

Ending Balance

 

$9

 

$3

 

$2

 

$23

 

$55

 

$62 >=

 

>=

 

>=

 

>=

 

>=

 

>= Minimum Balance

 

2

 

2

 

2

 

2

 

2

 

2

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Sep 18, 2020

PRICE: $15

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)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Sep 18, 2020

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

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.

Order Now