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!!!

please solve using microsoft excel!!! A computer

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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!