Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Inventory Best Practices

Authors: Steven M. Bragg

2nd Edition

1118000749, 9781118000748

More Books

Students also viewed these Accounting questions

Question

5. How can we use language to enhance skill in perceiving?

Answered: 1 week ago

Question

What actions might have prevented Bobs resignation?

Answered: 1 week ago