Joke Collection Website - Talk about mood - Use EXCEL to solve "Solver" as an example:

Use EXCEL to solve "Solver" as an example:

The formula in D5: =B5*C5

The formula in D6: =B6*C6, until D7, and so on.

Formula in E5: =sum(C5:C8)

Formula in B11: =D5.

Before calculation, open the Solver option and check "Use linear model" and "Assume non-negative". Please refer to the attached picture for subsequent restrictions and other conditions. I assume here: the number of actual working workers = 300 people. I changed the limit to 300 people before, but there was no solution. The solution result was that 299 people were used. Hope it helps.