Question: Assignment on Integer Programming A janitorial service, Mothers Helpers, provide workers to clean office buildings during late evening hours using workers with two skill levels,

Assignment on Integer Programming A janitorial service, Mothers Helpers, provide workers to clean office buildings during late evening hours using workers with two skill levels, 1 and 2. Each level 1 person is paid $12 per hour and each level 2 person is paid $8 per hour. The workers wash floors and vacuum offices. Each level 1 person can vacuum 9 offices per hour, whereas level 2 person can vacuum only 2 offices per hour. Each level 1 person can wash 2 floors per hour; whereas level 2 person can wash 3 floors per hour. In order to complete a new job in the allotted time, 18 offices must be vacuumed per hour and 12 floors must be washed per hour.Use Excel and determine the number of each type of person that will be needed to complete the job within the allotted time and minimum cost

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!