help with excel solver operations management problem

[cduval04]

Jason the jeweler makes diamond bracelets, necklaces, and earrings. He wants to work at
most 160 hours per month. He has 800 ounces of diamonds. The profit, labor time and
ounces of diamonds required to produce each product is given below. If demand for each
product is unlimited, how can Jason maximize his profit?Solve the problem in MS Excel

the excel workbook I have so far is attached I just don't understand the formulas!

[shg]

We don't do homework, but will help if you have a specific and narrow question.

[cduval04]

We don't do homework, but will help if you have a specific and narrow question.

I tried actually doing it...could u tell me if I got the profit box anywhere near correct? and also if the total labor hours and the ounces of diamonds for bracelets necklaces and earrings are correct (or close) based on the data I put in the solver parameters? Also how would I go about getting data for the # of bracelets, earrings and necklaces made if the demand is unlimited? In the solver, I just put >=0 for the profit box, but I still am not sure how to get raw data for the number of these items that were produced with just ounces of diamonds. maybe I'm not supposed to?

any help you can give would be appreciated

thanks

[shg]

Not too close. The quantity produced appears nowhere on your sheet. The total profit is the profit per item times the quantity produced of each (which must be constrained to be non-negative integers), and the total labor and total diamond weight constrained to be not greater than what is available.

[Alf]

I wonder why I spend time in this forum giving help for free when a jeweller can earn that much in a month?

Alf