A janitorial service, Mother’s 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 and provide algebraic model
A janitorial service, Mother’s 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 and provide algebraic model
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter4: Linear Programming Models
Section: Chapter Questions
Problem 64P
Related questions
Question
A janitorial service, Mother’s 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 and provide algebraic model
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps with 8 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,