Bright Future, Ltd (BF) is a nonprofit foundation providing medical treatment to emotionally distressed children. BF has
Question:
Bright Future, Ltd (BF) is a nonprofit foundation providing medical treatment to emotionally distressed children. BF has hired you as a business consultant to design an employment policy that would be consistent with its goal of providing the maximum possible service given its limited financial resources. You have determined that the service (Z) provided by BF is a function of its medical staff input (M) and social worker staff input (S) which is given by:
Z = M + .5S + .5 MS - S2
BF's staff budget for the coming year is $1,200,000. Annual employment costs are $30,000 for each social worker staff member (S) and $60,000 for each medical staff member (M). Using Excel Solver - Using the LaGrange an multiplier approach calculate the optimal (i.e., service
maximizing) combination of medical and social worker staff. Determine the optimal amount of service provided by BF.
University Physics with Modern Physics
ISBN: 978-0321696861
13th edition
Authors: Hugh D. Young, Roger A. Freedman, A. Lewis Ford