Solution With Solver

I have a spreadsheet that I working on for the correct number of staff for each shift. I have currently 3 shifts ( 3pm, 5 pm and 8pm). I need to ensure that I achieve at least 85% of completion of items with the correct number of staff at each shift at the cell marked red.

Each column for each shift will have the same number. For example, for 3pm shift , if we decide to have 10 staff, that the number 10 will be the same for that column from 3pm to 12.00am. One of cells for each shift will be zero, indicating break time.The same goes for 5pm to 2am shift and 8pm to 5am shift.

How do I use the solver to give me the solution for the correct number of staff for each shift if I want the completion percentage (in red) to be 85%? The total number of staff is 33.

My apologies again and I hope you can assist.
I am unable to upload here as I getting an error message. I have parked the file as below:
http://download.yousendit.com/2885A38034855EB6

Thanks in advance!

Kumar

Here's what i have done to your sheet:
Made 3 input cells to put in the number of Staff for each shift. You put in number of staff for shift 1 and 2. The number of staff for shift 3 is calculated based on the number of staff total (you can change the number of staff total)

The solver then needs to change the value of only 2 cells. This is the cells for number om staff on shift 1 and 2. All other cells are calculated.

the result you get will not be integers, but if you start with different start values you will get different results. Chose the result that gives you a close match to integers and round of the numbers manually.

I tried some solutions of making the results be integers, but that seemed to give the solver some problems on getting the right result. You could try this with different settings of the tolerations etc and see if you can find a solution

If you run the solver as the values are set in your example you will get a close enough match.

New file is enclosed