Formulate an lp model for problem

Assignment Help Finance Basics
Reference no: EM132798607

Aire-Co produces home dehumidifiers at two different plants in Atlanta and Phoenix. The per unit cost of production in Atlanta and Phoenix is $400 and $360, respectively. Each plant can produce a maximum of 300 units per month. Inventory holding costs are assessed at $30 per unit in beginning inventory each month. Aire-Co estimates the demand for its product to be 300, 400, and 500 units, respectively, over the next 3 months. Aire-Co wants to be able to meet this demand at minimum cost.

-Formulate an LP model for this problem.

-Implement your model in a spreadsheet and solve it.

-What is the optimal solution?

-How does the solution change if each plant is required to produce at least 50 units per month?

-How does the solution change if each plant is required to produce at least 100 units per month?

Reference no: EM132798607

Questions Cloud

Organizations achieve a competitive advantage : 1. Identify how changes in the external environment may affect the Operations Management (OM) strategy for a company. For example, what impact are the following
What is the bottleneck time of work cell : The three-station work cell illustrated in Figure S7.7 has a product that must go through one of the two machines at station 1 (they are parallel) before procee
How much will you have when you start your business : If the account earns 9% compounded annually, how much will you have when you start your business 12 years from now
What is the optimal solution : A furniture manufacturer produces two types of tables (country and contemporary) using three types of machines. The time required to produce the tables on each
Formulate an lp model for problem : Aire-Co produces home dehumidifiers at two different plants in Atlanta and Phoenix. The per unit cost of production in Atlanta and Phoenix is $400 and $360, res
Unit 04 Database Design and Development Assignment : Unit 04 Database Design and Development Assignment Help and Solution, HND in Computing - Assessment Writing Service - Data base system for the SmartMovers
Compute the income or loss from continuing operations : Net income (after tax) is $3,600. Income tax rate is 40%. Compute the income or loss from continuing operations before income taxes
Determine the optimal solution using excel solver : A company makes three products, and it has three machines available. The LP problem is formulated as below. Max Z: 4x1+ 4x2+ 7x3
Explain five objectives of the internal audit function : Hollibarn Ltd set up an internal audit department upon the advice of the external auditor. Explain FIVE objectives of the internal audit function

Reviews

Write a Review

Finance Basics Questions & Answers

  Estimated cost of capital for numata

BioTron Medical, Inc. Brent Bush, CFO of a medical device distributor, BioTron Medical, Inc, was approached by Japanese customer, Numata, with a proposal

  Describe the order of financial sources for managers

1. Describe the order of financial sources for managers who subscribe to the pecking order theory of financing.

  Discuss the impact of leadership style on innovation

Discuss the impact of leadership style on innovation in organisations, including how specific approaches may encourage or inhibit innovation

  Find the future value just after the last deposit

Deposits of $2,000 $4,000, $5000, $1000 and $3000 were made at the end of each of five consecutive years respectively at 6% compounded annually.

  Estimate the value of the call and put options using the

you are trying to value three-month call and put options on merck with a strike price of 30. the stock is trading at

  A common stock will pay a cash dividend of 4 next year

a common stock will pay a cash dividend of 4 next year. after that the dividends are expected to increase indefinitely

  What is the ytm

Parkway Void Co. issued 15-year bonds two years ago at a coupon rate of 8.9 percent. The bonds make semiannual payments.

  Discuss the advantages and disadvantages of closed-end

discuss the advantages and disadvantages of closed-end country funds cecfs relative to the american depository receipts

  For what price does the dividend-discount model predict

Analysts are predicting an 10.1% per year growth rate in earnings over the next five years. After that, Colgate's earnings are expected to grow.

  What is the net advantage of leasing

What is the net advantage of leasing? Should Sadik take the lease? Consider the $200,000 estimated residual value. How high could the residual value.

  Compound interest

Old Time Savings Bank pays 4% interest on its savings accounts. If you deposit $1,000 in the bank and leave it there, how much interest will you earn in 1st year?

  How much would a person save with the hmo

The Tucker family has health insurance coverage that pays 80 percent of out-of-hospital expenses after a $500 deductible per person.

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