Aire-Co produces home dehumidifiers at two different plants in Atlanta and Phoenix. The per unit cost of
Question:
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 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?
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
a X1j Number of dehumidifiers made in Atlanta in month j X2j Numb...View the full answer
Answered By
Rinki Devi
Professional, Experienced, and Expert tutor who will provide speedy and to-the-point solutions.
Hi there! Are you looking for a committed, reliable, and enthusiastic tutor? Well, teaching and learning are more of a second nature to me, having been raised by parents who are both teachers. I have done plenty of studying and lots of learning on many exciting and challenging topics. All these experiences have influenced my decision to take on the teaching role in various capacities. As a tutor, I am looking forward to getting to understand your needs and helping you achieve your academic goals. I'm highly flexible and contactable. I am available to work on short notice since I only prefer to work with very small and select groups of students.
I have been teaching students for 5 years now in different subjects and it's truly been one of the most rewarding experiences of my life. I have also done one-to-one tutoring with 100+ students and helped them achieve great subject knowledge.
2+ Reviews
10+ Question Solved
Related Book For 
Spreadsheet Modeling & Decision Analysis A Practical Introduction to Management Science
ISBN: 978-0324656633
5th edition
Authors: Cliff T. Ragsdale
Question Posted:
