Use Excel Solver

1. Devos Inc. has 4 factories: Minnie, Maxwell, Slappy, and Boni. You are given the following information on their inputs and outputs. Use the tab Factories:

Inputs:	Minnie	Maxwell	Slappy	Boni
# of managers	17	7	24	38
# of patents	13	20	9	28
# of workers	1185	525	1625	3275

Outputs:	Minnie	Maxwell	Slappy	Boni
# of error free tests	106	107	104	95
# of days without injury	88	80	82	87
# of units	1657	757	2857	1817

1. Is the Boni factory efficient or inefficient. Highlight in orange the number in Solver that tells you the answer and below your constraints, state in 1-3 sentences how you know Boni is efficient or inefficient.
2. Which output(s) does Boni do worse on than the composite hospital? By how much. Make sure you answer is clearly notated for this problem.
3. Which input(s) indicate they may not be used efficiently? Why is that your answer?