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