Using Excel Solver Add-in to find optimal hiring, firing, and layoff values

**ImportedBanana** · 05-06-2013, 11:17 PM

Hi,
Does anyone know how I might use the Excel 2010 solver add-in to find the optimal hiring, training, and layoff values for this spreadsheet?

Trying to keep costs at a minimum.

Spreadsheet: http://imgur.com/a/f7zKo

Your help would be greatly appreciated...

**ImportedBanana** · 05-07-2013, 12:52 AM

Nevermind, I think I've got it.

**ALSEGURO95** · 08-08-2022, 02:21 PM

Originally Posted by ImportedBanana

Nevermind, I think I've got it.

Do you still have this problem solved? I got the same problem but I'm not sure how to do it.

**Glenn Kennedy** · 08-12-2022, 01:00 PM

Hi.

It's a forum rule that you start your own thread, rather than "piggy-backing" on someone else's thread. This helps prevent massive confusion arising - which will happen if it is not clear which question is being answered. So please start your own thread and explain your own problem (make sure that, right from the start, you use a meaningful title (NOT things like "help needed" or "urgent problem"... think of the Google search terms that you would use to find the solution).

A picture is worth 1,000 words. An Excel sheet is worth 1,000 pictures. So, prepare a SMALL sample sheet (10-20 rows, not thousands!!!). Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!

**Alf** · 08-14-2022, 03:15 PM

An interesting homework setup and still used after 9 years.

I got the same problem but I'm not sure how to do it.

A material balance for the three categories hiring, firing and training. Then some "SUMPRODUCT" formulas for the different costs and three ranges of cells to change as well as specify the values in these ranges as integers. That's all you need.

Alf