Compute for marginal price as well as solution for maximization problem by using Excel Solver.
Bright Future, Ltd (BF) is a nonprofit foundation giving medical treatment to emotionally distressed children. BF has recruited you as a business consultant to design an employment strategy which 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 sound service 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 service staff member (S) and $60,000 for each medical staff member (M).Using the Lagrangean multiplier approach calculate the optimal (i.e., service maximizing) combination of medical and social staff. Determine the optimal amount of service provided by BF.