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.

Tag:Computational Thinking | w01 | w02 | w03 | w04 | w05 | w06 | w07 | w08 | w09 | w10 | w11 | w12

Tag:Human Centred Design | w01 | w02 | w03 | w04 | w05 | w06 | w07 | w08 | w09 | w10 | w11 | w12