Help - Daughter

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 cheekbg

--
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 cheekbg

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 cheekbg