G
Guest
Hello
I was wondering if someone could help me out on this problem. I have an
excel worksheet made up but I don't know how to finish the formulas to be
able to do the runs. Any help would be greatly appreciated.
Suppose that you decide to take over a small business, a candy-making
factory. In the pantry you have found the following items:
Cream cheese (packages) 35
Marshmallow creme (jars) 25
Granulated (white) sugar (cups) 100
Confectioners' sugar (cups) 100
Butter (cups) 100
Chocolate chips (cups) 30
Butterscotch chips (cups) 30
Nuts (cups) 40
White chocolate (lbs) 100
Evaporated milk (cans) 23
Pumpkin (cups) 27
Corn syrup (cups) 35
Eggs 48
In the desk you have found a standing order for:
3 orders of Aunt Teen's Creamy Chocolate Fudge (CF)
4 orders of Creamy Orange Fudge (OF)
2 orders of Spicy Pumpkin Fudge (PF)
3 orders of Bill's Divinity (BD)
In another drawer, you found this note:
Aunt Teen's Creamy Chocolate Fudge (profit -- $3.60 per order)
Creamy Orange Fudge (profit -- $2.50 per order)
Spicy Pumpkin Fudge (profit -- $2.88 per order)
Bill's Divinity (profit -- $4.34 per order)
You decide to make as much profit as you can, with the ingredients you have
on hand, and then close down the business. You will figure no expenses, and
will just pocket all the profit.
You also found in the desk the following web site address:
www.dessert.allrecipes.com/directory
On this web site, look up the recipes for the above candies, and note how
much of each ingredient you will need for each kind of candy. Now you are
ready to set up an Excel worksheet and find out how you can make the most
profit.
Prepare an Income Analysis and an Ingredients Inventory. Set up all formulas
appropriately. Do several what-if runs, including a run using the numbers
from the standing order. Do at least one what-if run using Goal Seek. Then,
run Solver, adding all appropriate constraints, asking Solver to maximize
your profits. Create an answer report, and save the Solver solution. Save the
workbook.
I am having the most trouble setting up the workbook correctly and putting
in the formulas to be able to run Goal Seek and solver. 6
I was wondering if someone could help me out on this problem. I have an
excel worksheet made up but I don't know how to finish the formulas to be
able to do the runs. Any help would be greatly appreciated.
Suppose that you decide to take over a small business, a candy-making
factory. In the pantry you have found the following items:
Cream cheese (packages) 35
Marshmallow creme (jars) 25
Granulated (white) sugar (cups) 100
Confectioners' sugar (cups) 100
Butter (cups) 100
Chocolate chips (cups) 30
Butterscotch chips (cups) 30
Nuts (cups) 40
White chocolate (lbs) 100
Evaporated milk (cans) 23
Pumpkin (cups) 27
Corn syrup (cups) 35
Eggs 48
In the desk you have found a standing order for:
3 orders of Aunt Teen's Creamy Chocolate Fudge (CF)
4 orders of Creamy Orange Fudge (OF)
2 orders of Spicy Pumpkin Fudge (PF)
3 orders of Bill's Divinity (BD)
In another drawer, you found this note:
Aunt Teen's Creamy Chocolate Fudge (profit -- $3.60 per order)
Creamy Orange Fudge (profit -- $2.50 per order)
Spicy Pumpkin Fudge (profit -- $2.88 per order)
Bill's Divinity (profit -- $4.34 per order)
You decide to make as much profit as you can, with the ingredients you have
on hand, and then close down the business. You will figure no expenses, and
will just pocket all the profit.
You also found in the desk the following web site address:
www.dessert.allrecipes.com/directory
On this web site, look up the recipes for the above candies, and note how
much of each ingredient you will need for each kind of candy. Now you are
ready to set up an Excel worksheet and find out how you can make the most
profit.
Prepare an Income Analysis and an Ingredients Inventory. Set up all formulas
appropriately. Do several what-if runs, including a run using the numbers
from the standing order. Do at least one what-if run using Goal Seek. Then,
run Solver, adding all appropriate constraints, asking Solver to maximize
your profits. Create an answer report, and save the Solver solution. Save the
workbook.
I am having the most trouble setting up the workbook correctly and putting
in the formulas to be able to run Goal Seek and solver. 6