7) The Edmond Public School system has received a grant from the NEA which pays the district a certain amount of money per counselor ($1250) and teacher ($1500) that it sends to specialized training on technology in the classroom and the growing need for business and technology graduates in the workforce (i.e., MIS Majors). They look to create a LP model to help them decide how many teachers and counselors from each of their three high schools (North, Memorial and Santa Fe) they should send to the training to maximize the payment to the district. The model must make decisions for how many teachers and counselors to send from each individual high school. (Do not worry about integer solutions for now).

A total of 30 combined teachers and counselors can be sent. At least 10 TOTAL of each type must be sent to training. There is a cost associated with transporting the staff from the high school to the training. Each person (teachers and counselors cost the same) sent from North costs the district $10, from Memorial $11 and from Santa Fe, $12.50. The most that can be spent on transportation is $340 this is refundable from the NEA. However, the cost limits means that we are not guaranteed that all 30 seats will be filled.

Other restrictions: There must be at least 2 teachers and 2 counselors sent from each school. Of the total number in attendance, an individual high school can supply no more than 40% of the total, but no less than 30%.

Finally, each school was asked to allocate 5 points to specify a preference ranking between teachers and counselors attending the training (higher is more preferred) . The final allocation of training seats to schools (by staff category) must provide a weighted average of at least 2.75 for each school. North weighted teachers a 3 and counselors a 2, Memorial the reverse (teachers a 2 and counselors a 3), and Santa Fe ranked teachers a 1 and counselors a 4.

Find the optimal decisions for how many teachers and counselors should attend training from each of the three schools using SOLVER.