# IT Employment

## General discussion

Locked

### Excel Problem

By ·
I am taking an Excel class and have the following problem, can someone explain the steps I need to establish to determine the outcome?

A new small manufacturing company, which produces toys, has to decide
>whether they want to distribute their product through a wholesale
>distributor, go directly to department store, or reopen their own store.
>The table below shows the revenue results for each decision.
>Distribution Network Good Economic Conditions Not-So-Good Economic
>Conditions
>Wholesaler \$75.0 Million
> \$60 Million
>Direct \$82.5 Million
>\$12.5 Million
>Own Store \$177.5 Million
> \$-112.5 Million
>
>
>a. What is the probability value of Good Economic Conditions that will make
>distributing through a Wholesaler or Direct equal? What is the probability
>value to equate Wholesaler and Own Store?
>b. Create a sensitivity graph comparing the different alternatives as the
>probability of Good Economic Conditions changes.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

• 17

• 4

• 16

• 23