Hi Brad,

Thanks for your response. Dave suggested using the Solver and according to
the assignment I think that is what we need to do. Even though I know nothing
about "Solver"


"Brad" wrote:

There are some elegant ways to figure this out - but since you are new to
excel try this method out:

Start off with 40 chairs and determine how many tables you can have with the
restrictions you have been given. The repeat the process with 39 chairs....
until you finally get down to 1 chair.

The equations that you have to deal with are

Chairs <=40

1 * chairs + 2 * tables <= 75 or tables <= (75 - 1 * chairs ) / 2

4 * chairs + 5 * tables <= 280 or tables <= (280 - 4 * chairs) / 5

The number of tables that you can use is the minimum of the two answers from
the two equations above.

and you want the max of

9 * chairs + 11 * tables

Hence you need to perform the above calculation for each row of data -
starting with the forty chairs - all the way down to one chair.


"Newbie" wrote:

My daughter is taking an excel class - she needs help with this story problem
- can anyone assist us on getting her started.

Manager of furniture store is planning a sale. The store has 75 square feet
of space to display and stock merchandise. During the sale, each table cost
$5, and retails for $11, and takes up two square feet of space.

Each chair cost $4 and retails for $9 and takes up one square foot of space.

The maximum amount allocated for purchasing the tables and chairs for the
sale is $280.

The manager doesn't think she can sell more thean 40 chairs but the demand
for the tables is unlimited.

We need to help determine how many table and chairs the manager should
puchase in order to make the most profit.

Help - We hate story problems :)