GENERATE GENERATE THE DECISION VARIABLE SOLUTION AND A SENSITIVITY REPORT 2. During the winter WeeMow Lawn Service contracts with customers for cutting lawns starting in the spring. WeeMow provides service to residential and commercial customers. The service has identified 50 possible residential customers and 15 potential commercial customers it has contacted. WeeMow services a customer once every 2 weeks during the growing season. A residential lawn on average takes 1.2 hours to cut, and a commercial property requires 5 hours to cut; the service's available work time is 8 hours, 6 days per week. The profit for a residential lawn is $23, and the profit for a commercial property is $61. The service has established a weekly budget of $350 for management, gas, and other materials, plus equipment repair. A residential lawn averages $12 in management, gas, material, and repair costs, and a commercial property averages $20 in costs. WeeMow wants to know how many residential and commercial jobs it should contract for from among its potential customers in order to maximize profits. Required: a. Which resources constrain how many jobs the service can contract for? b. If WeeMow could increase its weekly budget by $50 per week, or increase its workday to 9 hours, which would be more profitable? c. The solution to this problem should logically be integer, that is, whole jobs; however, the optimal solution is not integer. How would you suggest that WeeMow address this discrepancy? Do you think there is a way to handle this problem with the computer program you are using to solve this problem?
GENERATE GENERATE THE DECISION VARIABLE SOLUTION AND A SENSITIVITY REPORT 2. During the winter WeeMow Lawn Service contracts with customers for cutting lawns starting in the spring. WeeMow provides service to residential and commercial customers. The service has identified 50 possible residential customers and 15 potential commercial customers it has contacted. WeeMow services a customer once every 2 weeks during the growing season. A residential lawn on average takes 1.2 hours to cut, and a commercial property requires 5 hours to cut; the service's available work time is 8 hours, 6 days per week. The profit for a residential lawn is $23, and the profit for a commercial property is $61. The service has established a weekly budget of $350 for management, gas, and other materials, plus equipment repair. A residential lawn averages $12 in management, gas, material, and repair costs, and a commercial property averages $20 in costs. WeeMow wants to know how many residential and commercial jobs it should contract for from among its potential customers in order to maximize profits. Required: a. Which resources constrain how many jobs the service can contract for? b. If WeeMow could increase its weekly budget by $50 per week, or increase its workday to 9 hours, which would be more profitable? c. The solution to this problem should logically be integer, that is, whole jobs; however, the optimal solution is not integer. How would you suggest that WeeMow address this discrepancy? Do you think there is a way to handle this problem with the computer program you are using to solve this problem?
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
100%
PLEASE FOLLOW THE INSTRUCTIONS AND DO THIS TYPEWRITTEN ONLY. I WILL UPVOTE FOR YOUR GREATEST EFFORT. KINDLY SKIP THIS IF YOU HAVE ALREADY ANSWERED. THANK YOU SO MUCH
Transcribed Image Text:GENERATE THE DECISION VARIABLE SOLUTION AND
GENERATE A SENSITIVITY REPORT
2. During the winter WeeMow Lawn Service contracts with customers for cutting lawns starting in the
spring. WeeMow provides service to residential and commercial customers. The service has
identified 50 possible residential customers and 15 potential commercial customers it has
contacted. WeeMow services a customer once every 2 weeks during the growing season. A
residential lawn on average takes 1.2 hours to cut, and a commercial property requires 5 hours to
cut; the service's available work time is 8 hours, 6 days per week. The profit for a residential lawn is
$23, and the profit for a commercial property is $61. The service has established a weekly budget of
$350 for management, gas, and other materials, plus equipment repair. A residential lawn averages
$12 in management, gas, material, and repair costs, and a commercial property averages $20 in
costs. WeeMow wants to know how many residential and commercial jobs it should contract for
from among its potential customers in order to maximize profits.
Required:
a. Which resources constrain how many jobs the service can contract for?
b. If WeeMow could increase its weekly budget by $50 per week, or increase its workday to 9
hours, which would be more profitable?
c.
The solution to this problem should logically be integer, that is, whole jobs; however, the
optimal solution is not integer. How would you suggest that WeeMow address this
discrepancy? Do you think there is a way to handle this problem with the computer program
you are using to solve this problem?
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 10 images
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.