A computer plant produces mice, keyboards and flash drives. A mouse has a profit of $12.39/unit, and to produce it takes 0.32 hours of machine time and 0.45 hours of labor. A keyboard has a profit of...


could you please explain using excel solver model


A computer plant produces mice, keyboards and flash drives. A mouse has a profit of $12.39/unit, and<br>to produce it takes 0.32 hours of machine time and 0.45 hours of labor. A keyboard has a profit of<br>$10.10/unit, and to produce it takes 0.29 hours of machine time and 0.21 hours of labor. A flash drive<br>has a profit of $8.22/unit, and to produce it takes 0.22 hours of machine time and 0,16 hours of labor.<br>Each month, a total of 4,000 hours of machine time and 5,000 hours of labor are available.<br>The maximum monthly demand is 1,000 mice, 8,000 keyboards and 8,500 flash drives.<br>How many of each (to 0 decimal places) should the company make each month to maximize its profit<br>and what is that maximum profit?<br>

Extracted text: A computer plant produces mice, keyboards and flash drives. A mouse has a profit of $12.39/unit, and to produce it takes 0.32 hours of machine time and 0.45 hours of labor. A keyboard has a profit of $10.10/unit, and to produce it takes 0.29 hours of machine time and 0.21 hours of labor. A flash drive has a profit of $8.22/unit, and to produce it takes 0.22 hours of machine time and 0,16 hours of labor. Each month, a total of 4,000 hours of machine time and 5,000 hours of labor are available. The maximum monthly demand is 1,000 mice, 8,000 keyboards and 8,500 flash drives. How many of each (to 0 decimal places) should the company make each month to maximize its profit and what is that maximum profit?

Jun 09, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here