Q327. Our agency provides three types of client service: A, B, and C. And we have 3 kinds of staff: X, Y, and Z.

Each type A service requires 3 hours of an X staff member's time and 1 hour of a Y. Type B requires 2 X, 1 Y, and 3 Z hours. And type C requires 1 X, 3 Y, and 2 Z.

Currently we have 2 X, 1 Y and 1 Z on staff. We pay X's $25 per hour, Ys get $30 and Zs get $40. Assume everyone works a 35 hour week. At 35 hours per week our labor costs are 4200.

Revenue from type A service is $100, B is $200, and C is $300.

Regulations require that we serve at least 5 of each client type each week and that we serve at total of at least 21 clients each week.

What client mix will allow us to maximize revenue?

Excel Worksheet here.