Four constraints at the optimal solution

Assignment Help Macroeconomics
Reference no: EM131168219

How do you solve the following problem using excel?

Electrocomp's management realizes that it forgot to include two critical constraints (see Problem 7-14). In particular, management decides that there should be a minimum number of air conditioners produced in order to fulfill a contract. Also, due to an oversupply of fans in the preceding period, a limit should be placed on the total number of fans produced. (a) If Electrocomp decides that at least 20 air conditioners should be produced but no more than 80 fans should be produced, what would be the optimal solution? How much slack is there for each of the four constraints?

(b) If Electrocomp decides that at least 30 air conditioners should be produced but no more than 50 fans should be produced, what would be the optimal solution? How much slack is there for each of the four constraints at the optimal solution?

Reference no: EM131168219

Questions Cloud

The characteristics of water as a fire suppression agent : Write research paper on one of the topics: - --- The characteristics of water as a fire suppression agent.
Income inequality hypothesis : Use the production function equation to describe the ‘income inequality hypothesis', i.e. that labour income is being redistributed to capital. What might that particular model imply about what is happening and why?
Mention the importance of leadership : State two important characteristics of Directing. Mention the importance of Leadership
Identify ticker symbols of stocks to trade : Identify ticker symbols of stocks to trade. You Yahoo.Finance.com to get historical market values. Use "Research Project Part A" template as a guide to complete this part of the research project.
Four constraints at the optimal solution : If Electrocomp decides that at least 30 air conditioners should be produced but no more than 50 fans should be produced, what would be the optimal solution? How much slack is there for each of the four constraints at the optimal solution?
What you learn from this control chart : John makes 20 computers per day for Pathway computer. Production data appear in the file P20_48 .xlsx. Construct a control chart based on the number of defective computers produced during each of the last 30 days. Explain as fully as possible what..
Waht kind of new technologies can help students learn : How can new technologies be used problem solution effectively in education? - Should Students/Teachers use new technology when learning in class/when teaching in class?
How you will apply managerial decision-making methods : Provide an explanation of how you will apply managerial decision-making methods throughout your action plan.  Which business functions will be impacted by your action plan? What tactics will you use to manage implementation across business function..
Cash receipts journal : Finer Company uses a sales journal, a purchases journal, a cash receipts journal, a cash disbursements journal, and a general journal. The following transactions occur in the month of May. May 2 Sold merchandise costing $300 to B. Facer for $450 c..

Reviews

Write a Review

Macroeconomics Questions & Answers

  Inflation targeting be a good policy

Why might it be difficult for the Fed to formally adopt inflation targeting?  Would inflation targeting be a good policy for the Fed in the present economic environment

  In using the taylor rule

In using the Taylor Rule as a guideline for monetary policy, what are the pros and cons of using forecasted values of inflation and output rather than observed values of these variables?

  Describe the present economic crisis situation in europe

Describe the present economic crisis situation in Europe.  Why has it been so difficult for the Europeans to find a solution to this problem?   Comment on what implications the crisis may have for the rest of the world if Europeans are not able to ag..

  Long-term federal government budget problems

Question:. Explain why there are long-term Federal government budget problems. Explain why the base-line forecast of the CBO is misleading.

  Derive and compare demand curve

Question based on Derive and compare demand curve,  Derive Ambrose's demand function for peanuts. How does it compare with Johnny's demand curve for peanuts?

  Problem based on utility function

Problem based on  Utility Function - Problem,  Answer and explain the following using a diagram which is completely labeled.

  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?

  Problem - income elasticity of demand

Problem - Income Elasticity of Demand,  Interpret the following Income Elasticities of Demand (YED) values for the following and state if the good is normal or inferior; YED= +0.5 and YED= -2.5

  Positive balance of payment

Question Positive Balance of Payment: "Things will look good for the US if we could just get to where we are consistently running a positive Balance of Payments."

  Effect of recession on the investment curve

Comment on the effect of a recession on the investment curve (only) and on the level of savings, investment, and the equilibrium real interest rate in the financial crisis that hits United States first starting in fall 2007.

  Affect of falling domestic investment on trade surplus and

How will a fall in domestic investment affect the trade surplus and net capital outflows in the domestic economy, the trade deficit and capital inflows in the rest of the world.

  Crises in the banking sector and bank run

Banking crises crisis decreases depositors' confidence in the banking system. What would be the effect of a rumor about a banking crisis on checkable deposits in such a country?

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