Question: please solve using microsoft excel!!! A computer plant produces mice, keyboards and flash drives. A mouse has a profit of $7.36/unit, and to produce it
please solve using microsoft excel!!!

A computer plant produces mice, keyboards and flash drives. A mouse has a profit of $7.36/unit, and to produce it takes 0.20 hours of machine time and 0.35 hours of labor. A keyboard has a profit of $13.58/unit, and to produce it takes 0.36 hours of machine time and 0.42 hours of labor. A flash drive has a profit of $4.71/unit, and to produce it takes 0.07 hours of machine time and 0.11 hours of labor. Each month, a total of 3,100 hours of machine time and 7,200 Aurs of labor are available. The maximum monthly demand is 10,000 mice, 8,000 keyboards and 12,700 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
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
