The first thing I would suggest is write all the variables in algebraic form
and then plug them into XL. Then create a table which iterates all the
various scenarios. Finally, take the maximum profit--there's your answer.

Does that help?

Dave
--
Brevity is the soul of wit.


"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 :)