Solution for maximization problem by using excel solver

Assignment Help Macroeconomics
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 - 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.

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.

Reviews

Write a Review

Macroeconomics Questions & Answers

  Factors shifting the aggregate demand curve

For each of the following events, state whether the aggregate demand curve would increase, decrease, or stay the same.

  Assessment of degree of difficulty

Assess the degree of difficulty associated with measuring marginal revenue product for each of the following occupations.

  Economic recession-effect of invention

Consumption accounts for about 60% of GDP, while investments accounts for about 20% for GDP. But many economists think that, to understand economic recession, it is more significant to look at investment than consumption. Why?

  Computation of elasticity of demand

What elasticity of demand did the Village Administrator seem to assume here in his prediction for 1970- 1971? Compute the approximate elasticity of demand (round off, two decimal places is close enough).

  Production possibility frontier to illustrate

Use a production possibility frontier to illustrate the probable results of your fiscal policy. By how much did consumption change? By how much did savings change?

  Finding marginal propensity to consume

What is the marginal propensity to consume. What is the slope of the consumption function (you should give a numerical answer, not a formula)?

  Evaluate price elasticity of demand

Calculate the price elasticity of demand for the product below using average values for the prices and quantities in your formula.

  Consumption and savings function

Suppose the slope of the consumption function is 0.75 and there was an increase in income of $100. Calculate the increase in consumption.

  Demand function about consumption and aggregate demand

Explain the impacts of an expansionary fiscal policy such as a tax cut on the levels GDP, Consumption, Investment, interest rate and unemployment and price.

  Calculating the growth rate of output

What is the inflation rate in Home? In Foreign? What is the rate of change in the nominal exchange rate? Which currency is expected to appreciate? At what rate? Explain.

  Graph of weekly budget line

Tom earns $15 per hour for up to 40 hours of work each week. he is paid $30 per hour for every hour in excess of 40.

  Economically interpret the regression results

Use Excel program to estimate of the state's demand for KBC microbrews in Ohio. Print (past) the computer regression output and provide an economic interpretation of the regression results.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd