need to determine production schedule for the amnufactoring of valves.

[meldooley]

i can have 500 hours in casting department, 500 hours for machine department and 100 hours in the final shipping depart.
first thing I need to do is add formulas to the worksheet to calculate total production time for casting,machining, and final assembly. I need to add a mathematical formula in the objective field and then enter a formula to link the objective cells with variable cells.Then add test values to the variable cells to ensure that my workbook is set up correctly.atc value production -melinda dooley.xlsxatc value production -melinda dooley.xlsx

[RobertMika]

What's your expected answer?

[FDibbins]

You have provided some sample data (which is good), but you have not indicated what your expected outcome is?

[meldooley]

I am needing to have optimal combination of values to max profit. has to constitute 10% of production run, no single valve should be 50 % of of total production line. Goal is to max the total proofit but not to exceed the time allowed in each department. 500 in casting , 500 in machine depart, and 100 in final assembly department

[RobertMika]

Post your desired result within your workbook.