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

  Graphing the short run philips curve

Suppose that natural real GDP is constant.  For every 1 percent increase in the rate of inflation above its expected level, firms are willing to increase real GDP by 2 percent.

  Impact of vanishing immigrants on wages

For an unknown reason, aliens kidnapped all immigrants residing in the US. One morning America wakes up and finds that the only people left in the country are American citizens, while all legal and illegal immigrants are gone.

  Inflation and output ratio

Suppose that natural real GDP is constant.  For every 1 percent increase in the rate of inflation above its expected level, firms are willing to increase real GDP by 2 percent.

  Fishers equation-crowding out effect

In the country of Wiknam, the velocity of money is constant. Real GDP grows by 5 percent per year, the money stock grows by 14 percent per year, and the nominal interest rate is 11 percent. What is the real interest rate?

  Solution for basic health insurance

What is a fixed payment made by the privately insured patient in exchange for receiving the medical good or service? What is the percentage of each and every medical bill that the patient pays rather than the flat dollar amount?

  Analysis of specific news article related to economics

You will be asked to collect five (5) newspaper articles relating to subjects we are covering in the class. As we cover the various chapters you should be actively searching newspapers/magazines to find articles.

  Computing equilibrium price and quantity

Suppose the market for widgets can be described by the following equations: What is the equilibrium price and quantity?

  Economic statements related to market structure and pricing

True/False: For each of the following concepts, decide whether it's true or false, and briefly explain why (2-3 sentences).  You can also use diagrams if they are helpful. Each correct answer is worth.

  Intermediate macroeconomics

Use the IS/LM model and the IS-PC-MR model to explain what monetary policy to pursue.

  Compute the insurance amount against losses

Suppose a risk-averse consumer has an initial wealth of $5,000 and a utility function U(M) √M..  He faces an 80 percent chance of losing $4000, and a 20 percent chance of losing $0.

  Calculate the international supply and consumer surplus

Compute the producer surplus from parts a and b. Are producers better or worse off as a result of international trade? Discuss why.

  Laffer curve : tax rate and tax revenue

Question based on Laffer Curve : Tax Rate and Tax Revenue,  Do raising tax rates necessarily raise tax revenue? What factors affect how tax revenue changes when tax rates change?

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