Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Ques 20. Filtron Corporation produces filtration containers used in water treatment systems. Although business has been growing, the demand each month varies considerably. As a
Ques 20. Filtron Corporation produces filtration containers used in water treatment systems. Although business has been growing, the demand each month varies considerably. As a result, the company utilizes a mix of part-time and full-time employees to meet production demands. Although this approach provides Filtron with great flexibility, it resulted in increased costs and morale problems among employees. For instance, if Filtron needs to increase production from one month to the next, additional part-time employees have to be hired and trained, and costs go up. If Filtron has to decrease production, the workforce has to be reduced and Filtron incurs additional costs in terms of unemployment benefits and decreased morale. Best estimates are that increasing the number of units produced from one month to the next will increase production costs by $1.25 per unit, and that decreasing the number of units produced will increase production costs by $1.00 per unit. In February Filtron produced 10,000 filtration containers but only sold 7500 units; 2500 units are currently in inventory. The sales forecasts for March, April, and May are for 12,000 units, 8000 units, and 15,000 units, respectively. In addition, Filtron has the capacity to store up to 3000 filtration containers at the end of any month. Please deveop a Linear programming model equaitons whether in excel or Lingo
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started