The Sault Superior Filter Company makes two types of filters for domestic air purifiers: the standard...

Transcribed Image Text:

The Sault Superior Filter Company makes two types of filters for domestic air purifiers: the standard (nicknamed the Cleaner) for ordinary use, and the Scrubber for industrial-strength problems. The Cleaners bring in a profit of $0.50 each, while the Scrubbers command a profit of $1.25 each. Due to a higher piece-rate wage for the Scrubbers, the labor union was able to negotiate a requirement that each day the number of Scrubber filters produced will be at least as great as the number of Cleaners. The production line can turn out 25 Scrubbers per minute or 75 Cleaners per minute. Only one type of filter can be made at a time, but the production line is easily changed over at a negligible cost from one kind of filter production to the other. FFC must produce at least 5,000 Cleaners today to fill a rush order. The production day is 8 full hours (480 minutes). Required: Formulate a linear programming (LP) model and Solve in Excel to determine how many of each filter should be produced today to maximize profit. The Sault Superior Filter Company makes two types of filters for domestic air purifiers: the standard (nicknamed the Cleaner) for ordinary use, and the Scrubber for industrial-strength problems. The Cleaners bring in a profit of $0.50 each, while the Scrubbers command a profit of $1.25 each. Due to a higher piece-rate wage for the Scrubbers, the labor union was able to negotiate a requirement that each day the number of Scrubber filters produced will be at least as great as the number of Cleaners. The production line can turn out 25 Scrubbers per minute or 75 Cleaners per minute. Only one type of filter can be made at a time, but the production line is easily changed over at a negligible cost from one kind of filter production to the other. FFC must produce at least 5,000 Cleaners today to fill a rush order. The production day is 8 full hours (480 minutes). Required: Formulate a linear programming (LP) model and Solve in Excel to determine how many of each filter should be produced today to maximize profit.

Answer rating: 100% (QA)

The detailed answer for the above question is provided below Cleaner 9000 and Scrubber 9000 Let the ... View the full answer