Question: Use microsoft excel's solver tool to solve this problem, provide screenshots of your excel spreadsheet, equations used in cells or a screenshot of solver constraints

Use microsoft excel's "solver" tool to solve this problem, provide screenshots of your excel spreadsheet, equations used in cells or a screenshot of solver constraints - if any are applied.

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?

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!