Solution for maximization problem by using excel solver

Reference no: EM1314498

Bright Future, Ltd (BF) is a non-profit 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 sound service input (S) which is given by: Z = M + .5S + .5 MS - S² 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.

Reference no: EM1314498

Questions Cloud

Describe why an equal percentage increase : Describe why an equal percentage increase (or decrease) in sales for each firm would have such differing effects on operating income. Evaluate the ratio of contribution margin to operating income for each firm in 2008. (Hint: Divide contribution..

Business cycle and unemployment : What is business cycle? Describe the four phases of the business cycle. Where on the business cycle do you think the U.S. economy is today?

Equivalent test statistic : We want to test the hypothesis that population B has a smaller variance than population A.

Find coleman''s overall or weighted average cost : Cost of Capital - WACC - Theory - What is Coleman's overall, or weighted average, cost of capital (WACC)? Ignore flotation costs and What factors influence Coleman's composite WACC

Solution for maximization problem by using excel solver : Bright Future, Ltd (BF) is a non-profit foundation providing medical treatment to emotionally distressed children. Determine the optimal amount of service provided by BF.

Find the largest square tile : Find the largest square tile.

Hypothesis test-single mean test : Do these data suggest a statistically significance difference between the proportions of drug-resistant cases in the two states? Use a 0.02 level of significance and computed value of 2.37.

Find the lozier''s income from continuing operations : What was Lozier's gross profit, What was Lozier's income from operations, What was Lozier's income before income tax and What was Lozier's income from continuing operations

Computation of real gdp economic growth : Given table of data comprising real GDP and its components over a number of years, compute compound annual percentage changes in real GDP (economic growth) and compute the shares in real GDP of consumption.

User Account

All Pages