Creative Robotics (CR) manufactures two lightweight robots designed for easier house-cleaning. The Alpha-ONE model is older, heavier, and is designed for carpet cleaning. The Alpha-TWO model is newer, lighter, and is designed primarily for wooden floor cleaning. The management team is trying to identify how to minimize the total costs of producing these two models. Their full-time workers consist of primarily manufacturing experts and about 3 people are required to commit themselves to manufacture the Alpha-ONE model and 4 for the Alpha-TWO model, per day. They have a total pool of 100 full-time workers now but are willing to hire more manufacturers if required. Similarly, the Alpha-TWO model is more complex and management has a pool of 20 part-time technical workers to help with the complexity, every day. Again, they are willing to hire more part-time workers if required to assist with the Alpha-TWO model. As far as staff allocations for additional assistance in manufacturing Alpha-ONE and Alpha-TWO models, the expected number of individuals are 3 and 2 per day, respectively. The management has 58 people in their staff pool who can assist with the productions but has shown the willingness to hire more staff members if required. At the current time, they expect the cost of producing each Alpha-ONE model to be about $200 per day and each Alpha-TWO model to be $225 per day. Formulate a linear programming model that can be used to determine the number of units of each model that should be produced to minimize the total cost of producing them based on the labor force constraints. Write your linear program Equations in your answer file. You can either solve this problem graphically or by using Solver in Excel and then fill the blanks below: Creative Robotics should produce ______ Alpha-ONE Models and ________Alpha-TWO Models per day. The Minimized Total Cost value is $____ per day. Based on the slack variables you obtained, do they need to hire additional workers? Answer “Yes” or “No” ______ For the problem, you solved above for Creative Robotics, obtain the Sensitivity Report, and answer the following questions. Remember to round to two digits and you can enter “infinity” for unlimited regions: The cost range for Alpha-ONE Model is from ___ to ___ The cost range for Alpha-TWO Model is from ___ to ___ The range for Full Time Workers is from ___ to ___ The range for Part-Time Workers is from ___ to ___ The range for Staff is from ____ to ___

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...
icon
Related questions
Question
100%

Creative Robotics (CR) manufactures two lightweight robots designed for easier house-cleaning. The Alpha-ONE model is older, heavier, and is designed for carpet cleaning. The Alpha-TWO model is newer, lighter, and is designed primarily for wooden floor cleaning. The management team is trying to identify how to minimize the total costs of producing these two models. Their full-time workers consist of primarily manufacturing experts and about 3 people are required to commit themselves to manufacture the Alpha-ONE model and 4 for the Alpha-TWO model, per day. They have a total pool of 100 full-time workers now but are willing to hire more manufacturers if required. Similarly, the Alpha-TWO model is more complex and management has a pool of 20 part-time technical workers to help with the complexity, every day. Again, they are willing to hire more part-time workers if required to assist with the Alpha-TWO model. As far as staff allocations for additional assistance in manufacturing Alpha-ONE and Alpha-TWO models, the expected number of individuals are 3 and 2 per day, respectively. The management has 58 people in their staff pool who can assist with the productions but has shown the willingness to hire more staff members if required. At the current time, they expect the cost of producing each Alpha-ONE model to be about $200 per day and each Alpha-TWO model to be $225 per day. Formulate a linear programming model that can be used to determine the number of units of each model that should be produced to minimize the total cost of producing them based on the labor force constraints. Write your linear program Equations in your answer file. You can either solve this problem graphically or by using Solver in Excel and then fill the blanks below:

  1. Creative Robotics should produce ______ Alpha-ONE Models and ________Alpha-TWO Models per day.
  2. The Minimized Total Cost value is $____ per day.
  3. Based on the slack variables you obtained, do they need to hire additional workers? Answer “Yes” or “No” ______

For the problem, you solved above for Creative Robotics, obtain the Sensitivity Report, and answer the following questions. Remember to round to two digits and you can enter “infinity” for unlimited regions:

  1. The cost range for Alpha-ONE Model is from ___ to ___
  2. The cost range for Alpha-TWO Model is from ___ to ___
  3. The range for Full Time Workers is from ___ to ___
  4. The range for Part-Time Workers is from ___ to ___
  5. The range for Staff is from ____ to ___
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 8 images

Blurred answer
Similar questions
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
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…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.