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 naximum of 300 units per month. Inventory holding costs are assessed at $30 per unit in beginning nventory each month. Aire-Co estimates the demand for its product to be 300, 400, and 500 units, respectively, over the next three months. Aire-Co wants to be able to meet this demand at minimum cost. a. Formulate an LP model for this problem. b. Implement your model in a spreadsheet and solve it. c. What is the optimal solution? d. How does the solution change if each plant is required to produce at least 50 units per month? e. How does the solution change if each plant is required to produce at least 100 units per month?

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 naximum of 300 units per month. Inventory holding costs are assessed at $30 per unit in beginning nventory each month. Aire-Co estimates the demand for its product to be 300, 400, and 500 units, respectively, over the next three months. Aire-Co wants to be able to meet this demand at minimum cost. a. Formulate an LP model for this problem. b. Implement your model in a spreadsheet and solve it. c. What is the optimal solution? d. How does the solution change if each plant is required to produce at least 50 units per month? e. How does the solution change if each plant is required to produce at least 100 units per month?

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Binomial coefficient (x+y)^5
QUANTIFICATION True or False (FOR SOME x) (FOR SOME y), with x and y as integers: x^2 + y = x.
Why digraph is used in travelling sales man problem?
create this webpage using html
How round off errors occur during numerical computation using computer? – Explain with examples
What kinds of problems are solved by algorithms (Other than searching, sorting etc.) ?
how to solve this in MATlab Use MATLAB to find the polynomial that has the roots x=-2 ± 5.-7. Multiple Choice 11z¹+z²+203x+57=0 11z¹+z²+57z-203=0 2³ +11x² +57 +203=0 ²-11a²+57a-203-0
Estimation of Pi using Monte Carlo Method Scilab Code where n = 1500 .
9- Equation (Ln Y= x³ + 5) is written in excel to solve as follows: a) =A2^3+5 b) =Exp(A2^3+5) c)=Ln(A2^3+5) d)=Ln Y= A2^3+5
Answer the following using Polya's Four step in Problem Solving. Plese indicate the steps. 1. You have two noses and three hats. How many different nose-hat disguises can you wear?
Make a Microsoft Excel program to solve the given system of linear equations using Inverse Method. Note: I would really appreciate clear and simple directions to make the excel program; kindly tell me step-by-step what to type in Microsoft excel to make the program work. It has to be inverse method. No need for manual written solution; just the excel. Thank you.