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.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
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,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.