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

Sorry, this is not an Excel problem. It is a math problem. Once you have
the appropriate equations, if you need help putting them into Excel, then
that would be a question for this forum. Maybe someone else will think
different though.

I hate story problems too.

Regards,
Paul

"Newbie" wrote in message
...
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 :)

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

Thanks for your responses - She forgot to show me a couple of things :)

She needs to create an Orders worksheet containing an income statement as
well as an estimate on the amount of space the tables and chairs will take up
in the display area.

Based on the information we know that the number of tables and chairs
ordered must be greater then 0 and less than 40, and the total cost is equal
to $280.And also the total space taken up must be less than or equal to 75
square feet.

But the question states to create an answer report detailing the parameters
of the problem and the optimal solution.....I'm lost.



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

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

"Optimal solution" leads me to believe the question is asking you to use
Excel's Solver tool. Does it make any mention of that?

Dave
--
Brevity is the soul of wit.


"Newbie" wrote:

Thanks for your responses - She forgot to show me a couple of things :)

She needs to create an Orders worksheet containing an income statement as
well as an estimate on the amount of space the tables and chairs will take up
in the display area.

Based on the information we know that the number of tables and chairs
ordered must be greater then 0 and less than 40, and the total cost is equal
to $280.And also the total space taken up must be less than or equal to 75
square feet.

But the question states to create an answer report detailing the parameters
of the problem and the optimal solution.....I'm lost.



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

Dave it does....It states test your knowledg of Solver to create a worksheet
finding a product mix for a furniture store that maximizes profits subject to
constraints of floor space.

"Dave F" wrote:

"Optimal solution" leads me to believe the question is asking you to use
Excel's Solver tool. Does it make any mention of that?

Dave
--
Brevity is the soul of wit.


"Newbie" wrote:

Thanks for your responses - She forgot to show me a couple of things :)

She needs to create an Orders worksheet containing an income statement as
well as an estimate on the amount of space the tables and chairs will take up
in the display area.

Based on the information we know that the number of tables and chairs
ordered must be greater then 0 and less than 40, and the total cost is equal
to $280.And also the total space taken up must be less than or equal to 75
square feet.

But the question states to create an answer report detailing the parameters
of the problem and the optimal solution.....I'm lost.



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

You should start your research he http://www.solver.com/tutorial.htm

You also should make sure you have Solver installed on your excel
installation. To check if you do, go to Tools menu and see if Solver is an
option. If it is, it is installed. If not, you need to install it, likely
via the Office installation CDs (or if you're using a company-supplied
version of XL, via your company's network).

Dave
--
Brevity is the soul of wit.


"Newbie" wrote:

Dave it does....It states test your knowledg of Solver to create a worksheet
finding a product mix for a furniture store that maximizes profits subject to
constraints of floor space.

"Dave F" wrote:

"Optimal solution" leads me to believe the question is asking you to use
Excel's Solver tool. Does it make any mention of that?

Dave
--
Brevity is the soul of wit.


"Newbie" wrote:

Thanks for your responses - She forgot to show me a couple of things :)

She needs to create an Orders worksheet containing an income statement as
well as an estimate on the amount of space the tables and chairs will take up
in the display area.

Based on the information we know that the number of tables and chairs
ordered must be greater then 0 and less than 40, and the total cost is equal
to $280.And also the total space taken up must be less than or equal to 75
square feet.

But the question states to create an answer report detailing the parameters
of the problem and the optimal solution.....I'm lost.



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

Thanks Dave, I really appreciate your assistance.

I know nothing of "Solver" so this should help!

Daughters :) I thought I was done with Story Problems

"Dave F" wrote:

You should start your research he http://www.solver.com/tutorial.htm

You also should make sure you have Solver installed on your excel
installation. To check if you do, go to Tools menu and see if Solver is an
option. If it is, it is installed. If not, you need to install it, likely
via the Office installation CDs (or if you're using a company-supplied
version of XL, via your company's network).

Dave
--
Brevity is the soul of wit.


"Newbie" wrote:

Dave it does....It states test your knowledg of Solver to create a worksheet
finding a product mix for a furniture store that maximizes profits subject to
constraints of floor space.

"Dave F" wrote:

"Optimal solution" leads me to believe the question is asking you to use
Excel's Solver tool. Does it make any mention of that?

Dave
--
Brevity is the soul of wit.


"Newbie" wrote:

Thanks for your responses - She forgot to show me a couple of things :)

She needs to create an Orders worksheet containing an income statement as
well as an estimate on the amount of space the tables and chairs will take up
in the display area.

Based on the information we know that the number of tables and chairs
ordered must be greater then 0 and less than 40, and the total cost is equal
to $280.And also the total space taken up must be less than or equal to 75
square feet.

But the question states to create an answer report detailing the parameters
of the problem and the optimal solution.....I'm lost.



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

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

We kinda have rules around here about doing homework for students. Maybe you
should also.

--
Don Guillett
SalesAid Software

"Newbie" wrote in message
...
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 :)

Doing this on solver gives me a solution that says 40 chairs and 17½ tables
would be the best.

How can I set solver to work to integers?

--
Allllen


"Don Guillett" wrote:

We kinda have rules around here about doing homework for students. Maybe you
should also.

--
Don Guillett
SalesAid Software

"Newbie" wrote in message
...
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 :)

You have to add the constraint "cell reference = int" where "int" is integer.

Dave
--
Brevity is the soul of wit.


"Allllen" wrote:

Doing this on solver gives me a solution that says 40 chairs and 17½ tables
would be the best.

How can I set solver to work to integers?

--
Allllen


"Don Guillett" wrote:

We kinda have rules around here about doing homework for students. Maybe you
should also.

--
Don Guillett
SalesAid Software

"Newbie" wrote in message
...
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 :)

I wasn't asking for someone to do homework I was asking for someone to lead
me in the right direction, as Brad and Dave did.

"Don Guillett" wrote:

We kinda have rules around here about doing homework for students. Maybe you
should also.

--
Don Guillett
SalesAid Software

"Newbie" wrote in message
...
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 :)

...how many table and chairs the manager should
purchase in order to make the most "profit."

and you want the max of
9 * chairs + 11 * tables

Just two cents. This is how one would set up Solver.
However, this would maximize sales.
Perhaps for Profit, consider maximizing:
(11-5) Tables + (9-4) Chairs.
or
6 Tables + 5 Chairs.

For the op, this doesn't change the Integer solutions, but if any of the
numbers were different, it could change the dynamics of the solution. ( ie
$303 "Profit", with 18 Tables & 39 Chairs.)

--
HTH :)
Dana DeLouis
Windows XP & Office 2003


"Brad" wrote in message
...
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 :)

Hi

Even without Solver (or Excel) this particular example presents a fairly
simple problem.
The most limiting resource is space - 75 sq feet.
Chairs generate $5 each, with 1 sq ft space hence 5$/sq ft
Tables generate $6 each, but require 2 sq ft hence 3$/sq ft.

First try maximising the item that returns the greatest value to the
most limiting resource.
This is chairs (stated to be 40 max) leaving 35 sq ft which would mean
that 17 tables could be purchased (and sold) which would generate $302
total profit.
This would only use 74 sq ft, so there is 1 sq ft slack.
Sacrificing 1 chair and thereby dropping profit by $5, would release
another 1sq ft and enable 1 more table with an increase of $6, lifting
total profit to $303.
So optimal solution is 39 chairs and 17 tables.

--
Regards

Roger Govier


"Newbie" wrote in message
...
Thanks Dave, I really appreciate your assistance.

I know nothing of "Solver" so this should help!

Daughters :) I thought I was done with Story Problems

"Dave F" wrote:

You should start your research he
http://www.solver.com/tutorial.htm

You also should make sure you have Solver installed on your excel
installation. To check if you do, go to Tools menu and see if Solver
is an
option. If it is, it is installed. If not, you need to install it,
likely
via the Office installation CDs (or if you're using a
company-supplied
version of XL, via your company's network).

Dave
--
Brevity is the soul of wit.


"Newbie" wrote:

Dave it does....It states test your knowledg of Solver to create a
worksheet
finding a product mix for a furniture store that maximizes profits
subject to
constraints of floor space.

"Dave F" wrote:

"Optimal solution" leads me to believe the question is asking you
to use
Excel's Solver tool. Does it make any mention of that?

Dave
--
Brevity is the soul of wit.


"Newbie" wrote:

Thanks for your responses - She forgot to show me a couple of
things :)

She needs to create an Orders worksheet containing an income
statement as
well as an estimate on the amount of space the tables and
chairs will take up
in the display area.

Based on the information we know that the number of tables and
chairs
ordered must be greater then 0 and less than 40, and the total
cost is equal
to $280.And also the total space taken up must be less than or
equal to 75
square feet.

But the question states to create an answer report detailing
the parameters
of the problem and the optimal solution.....I'm lost.



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

So optimal solution is 39 chairs and 17 tables
That should have read
So optimal solution is 39 chairs and 18 tables


--
Regards

Roger Govier


"Roger Govier" wrote in message
...
Hi

Even without Solver (or Excel) this particular example presents a
fairly simple problem.
The most limiting resource is space - 75 sq feet.
Chairs generate $5 each, with 1 sq ft space hence 5$/sq ft
Tables generate $6 each, but require 2 sq ft hence 3$/sq ft.

First try maximising the item that returns the greatest value to the
most limiting resource.
This is chairs (stated to be 40 max) leaving 35 sq ft which would mean
that 17 tables could be purchased (and sold) which would generate $302
total profit.
This would only use 74 sq ft, so there is 1 sq ft slack.
Sacrificing 1 chair and thereby dropping profit by $5, would release
another 1sq ft and enable 1 more table with an increase of $6, lifting
total profit to $303.
So optimal solution is 39 chairs and 17 tables.

--
Regards

Roger Govier


"Newbie" wrote in message
...
Thanks Dave, I really appreciate your assistance.

I know nothing of "Solver" so this should help!

Daughters :) I thought I was done with Story Problems

"Dave F" wrote:

You should start your research he
http://www.solver.com/tutorial.htm

You also should make sure you have Solver installed on your excel
installation. To check if you do, go to Tools menu and see if
Solver is an
option. If it is, it is installed. If not, you need to install it,
likely
via the Office installation CDs (or if you're using a
company-supplied
version of XL, via your company's network).

Dave
--
Brevity is the soul of wit.


"Newbie" wrote:

Dave it does....It states test your knowledg of Solver to create a
worksheet
finding a product mix for a furniture store that maximizes profits
subject to
constraints of floor space.

"Dave F" wrote:

"Optimal solution" leads me to believe the question is asking
you to use
Excel's Solver tool. Does it make any mention of that?

Dave
--
Brevity is the soul of wit.


"Newbie" wrote:

Thanks for your responses - She forgot to show me a couple of
things :)

She needs to create an Orders worksheet containing an income
statement as
well as an estimate on the amount of space the tables and
chairs will take up
in the display area.

Based on the information we know that the number of tables and
chairs
ordered must be greater then 0 and less than 40, and the total
cost is equal
to $280.And also the total space taken up must be less than or
equal to 75
square feet.

But the question states to create an answer report detailing
the parameters
of the problem and the optimal solution.....I'm lost.



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

Yes but it was a good question to learn from
--
Allllen


"Newbie" wrote:

I wasn't asking for someone to do homework I was asking for someone to lead
me in the right direction, as Brad and Dave did.

"Don Guillett" wrote:

We kinda have rules around here about doing homework for students. Maybe you
should also.

--
Don Guillett
SalesAid Software

"Newbie" wrote in message
...
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 :)

I realize everyone is pushing towards using Solver, but this is a problem
that requires more logic than the mechanical use of a black-box tool.

Each table nets a profit of $6 and uses 2 sq. ft. of space. Essentially,
the store makes $3/sq.ft.

Each chair nets $5/sq.ft.

Clearly, you want to focus on chairs. The clincher is that each chair costs
less than a table ($4 vs. $5).

So, the store should sell as many chairs as it can. From the space
limitation that would be 75. From the budget limitation that would be 70.
From the estimated demand it would be 40.

Taking the min. of the three, the answer is #chairs = 40.

That leaves the store with a budget of $280 - $4*40 = $120 and 75-40 = 35
sq.ft. of space for tables.

In 35 sq.ft. one can fit 17-1/2 or 17 tables. With $120, one can buy 120/5
= 24 tables. Take the min. of the two and the answer is 17 tables.

Bottom line: 40 chairs and 17 tables.

No need for Solver, XL, or complicated algebra. Just basic logic and simple
arithmetic.

Of course, not all problems are this easy to solve. Most *do* require
Solver. But, in this case it appears the teacher created the problem "by
hand." Bad move on her/his part.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
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 :)

Correction: I don't see my first post yet, but I should have reviewed it
before hitting 'send'.

The 1 sq. ft. that is wasted was bugging me but I ignored the feeling.

A slightly improved solution would be to take away 1 chair (lose $5) and add
1 table (gain $6). That would use up the last sq. ft. of space, still be
under the budget, and increase profit by $1.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
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 :)

Hi Tushar

You came to the same conclusion as my earlier posting, that this
particular example can be easily solved with pen and paper, and the same
mathematical result of $303.

However, my prize would be to the student who thinks like Wal-Mart and
says I can make $616.50.

If I stack one chair "seat down" on another chair, I can get in twice
the number of chairs.
Also, I can put the chairs on top of the tables, so in total I can stock
37 tables and 150 chairs.
As for the other constraints, well I'll tell the manufacturer because of
the large order I am giving him, I am going to reduce retail prices to
$9 for Tables and $6 for Chairs and he can have 50% of that figure to
manufacture, as well as give me 180 days credit.
I will have all the money in from sales before I need to pay him.

Only sell 40 chairs, why at my prices I can sell heaps more.
Advertising 1 table plus 4 chairs for $33 compared with my competitors
$47 I will sell out easily and make $616.50 profit compared with his
$303.
Or maybe the profit would only be $604.50 as the 2 "surplus" chairs
would probably be broken, stolen or be some sort of inventory loss.

Said with large tongue in cheek<bg

--
Regards

Roger Govier


"Tushar Mehta" wrote in
message om...
Correction: I don't see my first post yet, but I should have reviewed
it
before hitting 'send'.

The 1 sq. ft. that is wasted was bugging me but I ignored the feeling.

A slightly improved solution would be to take away 1 chair (lose $5)
and add
1 table (gain $6). That would use up the last sq. ft. of space, still
be
under the budget, and increase profit by $1.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
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 :)

LOL!

That is excellent out-of-the-box reasoning. {grin}

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Hi Tushar

You came to the same conclusion as my earlier posting, that this
particular example can be easily solved with pen and paper, and the same
mathematical result of $303.

However, my prize would be to the student who thinks like Wal-Mart and
says I can make $616.50.

If I stack one chair "seat down" on another chair, I can get in twice
the number of chairs.
Also, I can put the chairs on top of the tables, so in total I can stock
37 tables and 150 chairs.
As for the other constraints, well I'll tell the manufacturer because of
the large order I am giving him, I am going to reduce retail prices to
$9 for Tables and $6 for Chairs and he can have 50% of that figure to
manufacture, as well as give me 180 days credit.
I will have all the money in from sales before I need to pay him.

Only sell 40 chairs, why at my prices I can sell heaps more.
Advertising 1 table plus 4 chairs for $33 compared with my competitors
$47 I will sell out easily and make $616.50 profit compared with his
$303.
Or maybe the profit would only be $604.50 as the 2 "surplus" chairs
would probably be broken, stolen or be some sort of inventory loss.

Said with large tongue in cheek<bg

That was a good reply

have you ever tried to sort a column with many entries into groups of 1 thru
8 and repeat this until complete column is sorted
Thanks

"Tushar Mehta" wrote:

LOL!

That is excellent out-of-the-box reasoning. {grin}

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Hi Tushar

You came to the same conclusion as my earlier posting, that this
particular example can be easily solved with pen and paper, and the same
mathematical result of $303.

However, my prize would be to the student who thinks like Wal-Mart and
says I can make $616.50.

If I stack one chair "seat down" on another chair, I can get in twice
the number of chairs.
Also, I can put the chairs on top of the tables, so in total I can stock
37 tables and 150 chairs.
As for the other constraints, well I'll tell the manufacturer because of
the large order I am giving him, I am going to reduce retail prices to
$9 for Tables and $6 for Chairs and he can have 50% of that figure to
manufacture, as well as give me 180 days credit.
I will have all the money in from sales before I need to pay him.

Only sell 40 chairs, why at my prices I can sell heaps more.
Advertising 1 table plus 4 chairs for $33 compared with my competitors
$47 I will sell out easily and make $616.50 profit compared with his
$303.
Or maybe the profit would only be $604.50 as the 2 "surplus" chairs
would probably be broken, stolen or be some sort of inventory loss.

Said with large tongue in cheek<bg