A company owner has 1000 shares of company stock she wants to divide among four employees as a bonus. Rather than simply divide the shares equally, she decides to give different amounts based on contribution, time with the company, etc. She decides the distribution must satisfy the following five (5) constraints: 1. The first employee gets twice as many shares as the second employee.
2. The third employee gets more shares than the first two together.
3. The fourth employee gets less than the second employee.
4. All the shares must be distributed.
5. Allocations must be in whole numbers—no fractional distributions.
Computer Science and Its Applications
Introduction to Working with Spreadsheets
The objective function is to marimize the number of shares the fourth employee gets while satisfying all the constraints.
Your solution should be general so that it can be used for distributing any number of shares such as 500or 1200 shares. In other words, the formula in your solution should not have 1000 embedded in it; butrather, should reference a cell that has the number of shares.