subject

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.

ansver
Answers: 1

Other questions on the subject: Computers and Technology

image
Computers and Technology, 22.06.2019 03:30, raytaylorh010801
Write a computer program to calculate the three-phase fault current for a fault at f in figure 1.16, with the network normal, and with one line at a time removedproblems 1.1 write a computer program to calculate the three-phase fault current for a fault at f in figure 1.16, with the network normal, and with one line at a time removed 20 power system relaying from service. the positive-sequence impedance data are given in the accompanying table. use the commonly made assumption that all prefault resistance values are (1.0+j0.0) pu, and neglect all resistance values. calculate the contribution to the fault flowing through the cb b and the voltage at that bus. for each calculated case, consider the two possibilities: cb b2 closed or open. the latter is known as the stub-end fault í• figure 1.16 problem 1.1 system data for figure 1.16 from to positive sequence 0.0+j0.1 0.05j0.15 0.04 j0.2 0.01 jo. i 0.015 + j0.15 0.01 j0.19 0.01 +j0.19 0.03+j0.1 0.0+j0.08 6 6 6 from service. the positive-sequence impedance data are given in the accompanying table. use the commonly made assumption that all prefault resistance values are (1.0 + j 0.0) pu, and neglect all resistance values. calculate the contribution to the fault flowing through the cb b1, and the voltage at that bus. for each calculated case, consider the two possibilities: cb b2 closed or open. the latter is known as the “stub-end” fault.
Answers: 2
image
Computers and Technology, 23.06.2019 18:00, larry5007
Freya realizes she does not have enough in her bank account to use the debit card. she decides to use a credit card instead. which questions should freya answer before using a credit card? check all that apply. can i pay at least the minimum payment each month? can i make payments on time and avoid late fees? will i have to take out a loan? how much in finance charges can i afford to pay? should i talk to a consumer credit counseling service?
Answers: 1
image
Computers and Technology, 24.06.2019 00:00, marika35
Visualizing a game of “tag” to remember the meaning of contagious
Answers: 3
image
Computers and Technology, 24.06.2019 16:50, genyjoannerubiera
Ramp charts are generally created in wordlotusexcelpowerpoint
Answers: 1
You know the right answer?
A company owner has 1000 shares of company stock she wants to divide among four employees as a bonus...

Questions in other subjects:

Konu
Mathematics, 19.07.2019 16:20