Break Even Problems

Answer the following break even problems. In addition to the answers (rounded to 0 decimal places), show the spreadsheets you created to solve them (like you do for homeworks in lab). Next to any cells with equations, put the equation in text. For example, if I was doing a spreadsheet to sum the number of fish my son and I caught, it would look like:

Q3 (5 points)

A computer plant produces mice, keyboards and flash drives. A mouse has a profit of $10.28/unit, and to produce it takes 0.24 hours of labor and 0.17 hours of machine time. A keyboard has a profit of $13.15/unit, and to produce it takes 0.45 hours of labor and 0.23 hours of machine time. A flash drive has a profit of $5.32/unit, and to produce it takes 0.11 hours of labor and 0.07 hours of machine time.

Each month, a total of 7,200 hours of labor and 3,100 hours of machine time are available.

The maximum monthly demand is 10,500 mice, 8,000 keyboards and 12,700 flash drives.

How many of each should the company make each month to maximize its profit and what is that maximum profit? Include your spreadsheet with any formulas noted. Also include a list of the constraints you used.

B 1 Fish Prof Miller Caught 2 Fish Prof Miller Son Caught 3 Total Fish Caught 3 7 10 Formula in cell B3 is =SUM(B1:B2)