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

  Perspectives regarding competition

Then support perspectives regarding competition from the opposite perspective from your real opinion again with an actual example. (Discuss it from both perspectives why competition can be good and then why it can be bad. So first you give your re..

  What is the government budget balance

What is the government budget balance? Does the government have a budget surplus, budget deficit, or balanced budget?

  Return on common stockholders equity

Cutler Corp. has a return on assets ratio of 12%. It plans toissue bonds at 8% and use the cash to repurchase stock. What effectwill this have on its debt to total assets ratio and on its return on common stockholders' equity? (Number example woul..

  Analysis on the impact of panama canal expansion

The Panama Canal has a great impact on the world trade since it opened in 1914. To remain competitive among world shipping routes, the Panama Canal Authority has started an expansion project since September 2007. Please make an analysis on the imp..

  Endogenous verses exogenous growth theories

In neoclassical growth models, the sources of growth, is exogenous usually "technology". Such theoretical models hence are able to describe how an economy grows, but not why it grows. To overcome this shortcoming, several growth models have bee..

  Let us say that an economy has a consumption function given

let us say that an economy has a consumption function given by c 900 0.9yd where yd is the disposable income. there

  Illustrate what happens to the money supply

Illustrate what happens to the money supply, interest rates, and the economy in general if the Federal Reserve is a NET BUYER of government bonds.

  Instruments of monetary policy of federal reserve system

Describe the structure of the Federal Reserve System. What are the responsibilities and functions of each of the components of the Federal Reserve System? What are the instruments of monetary policy of the Federal Reserve System? Explain each one.

  Expansionary and contractionary fiscal policies

Begin by explaining fiscal policy. Describe expansionary and contractionary fiscal policies. Identify the situations in which expansionary fiscal policy and contractionary fiscal policy would be used.

  Explain shortly when linear regression analysis

1. Explain shortly when linear regression analysis might be a good forecasting technique versus trend smoothing.2. Explain shortly how logistics supports broad enterprise strategy.3. Illustrate how international politics and national objectives can a..

  Your firm operates three plants the cost functions vary

your firm operates three plants. the cost functions vary across the three plants.plant amarginal cost 6qaverage

  Impact us business seeking to do business in other countries

Determine how the content of the report you selected would most likely impact U.S. businesses seeking to do business in foreign countries. Provide specific examples to support your response - Impact U.S. businesses seeking to do business in foreign..

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