Question

Anyone here a pro with Microsoft Excel?

Answer 1

Post the specific question. Someone here might be able to answer it, but not if you don't post it.

Answer 2

please wait

Answer 3

There! @Rudy

Answer 4

Have you set up Excel to have the solver Add-In available? If not, that's step 1

Answer 5

Next setup all your formulas in Excel and finally just set up the expected output and conditions. And start up the solver.

Answer 6

Here's how I set it up.

Answer 7

In the solver, for objective, select the profit cell and set as Max.
In constraints, select 'Total number of products' cell and set to =>1850
In constraints, also select 'Total number of labor hours' cell and set to <=8000
And start the solver. That's it!

Answer 8

@tejasree Tell me what you got and we can compare results.

Answer 9

@Rudy

Answer 10

@tejasree question?