Final Shadow Constraint Allowable Allowable Name Value Price R.H. Side Increase Decrease Protein 600 0.033 600 405.33 241.26 LHS Carbs LHS 480 0.009 480 458.40 192.00 Fat LHS 360 0.052 360 818.57 188.00 ill in the following blanks based on the Sensitivity Report to specify each of the Right-Hand Side ranges (round to only 2 decimal - The range for Protein is from to -. The range for Carbs 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%

I need some help on my operations management homework following the sensitivty report. Thank you

Chrissy is a health and fitness coach. She wants to create a nutritional supplement, which meets the required daily dose of key nutrients at the
lowest cost. Her goal is to sell this blend to her own clients to ensure that their nutritional needs are met in the most efficient manner possible. She
decides to combine three different protein powders in order to create her own blend. The price of Type A Protein Powder is $25 per pound and it
contains 42 gms of protein, 20 gms of carbohydrates and 10 gms of fat per serving. The price of Type B Protein Powder is $10 per pound and it
contains 12 gms of protein, 20 gms of carbohydrates and 5 gms of fat per serving. The price of Type C Protein Powder is $8 per pound and it
contains 4 gms of protein, 2 gms of carbohydrates and 10 gms of fat per serving. Each pound of any protein powder is equivalent to 12 servings.
Chrissy runs a cost minimization linear program and identifies that her blend would need to meet her own minimum requirements of 50 gms of
protein, 40
gms
of carbohydrates, and 30 gms of fat per serving. Her sensitivity report is given here.
Microsoft Excel 16.0 Sensitivity Report
Variable Cells
Final
Reduced Objective Allowable Allowable
Name
Value
CostCoefficient
Increase
Decrease
A
0.705
25
5.80
11.32
В
1.122
10
11.94
1.53
C
1.734
8
6.44
5.60
Constraints
Final
Shadow Constraint Allowable Allowable
Name
Value
Price R.H. Side
Increase
Decrease
Protein
600
0.033
600
405.33
241.26
LHS
Carbs LHS
480
0.009
480
458.40
192.00
Fat LHS
360
0.052
360
818.57
188.00
Fill in the following blanks based on the Sensitivity Report to specify each of the Right-Hand Side ranges (round to only 2 decimal spaces.
a. The range for Protein is from
to
b. The range for Carbs is from
to
c. The range for Fat is from
to
Transcribed Image Text:Chrissy is a health and fitness coach. She wants to create a nutritional supplement, which meets the required daily dose of key nutrients at the lowest cost. Her goal is to sell this blend to her own clients to ensure that their nutritional needs are met in the most efficient manner possible. She decides to combine three different protein powders in order to create her own blend. The price of Type A Protein Powder is $25 per pound and it contains 42 gms of protein, 20 gms of carbohydrates and 10 gms of fat per serving. The price of Type B Protein Powder is $10 per pound and it contains 12 gms of protein, 20 gms of carbohydrates and 5 gms of fat per serving. The price of Type C Protein Powder is $8 per pound and it contains 4 gms of protein, 2 gms of carbohydrates and 10 gms of fat per serving. Each pound of any protein powder is equivalent to 12 servings. Chrissy runs a cost minimization linear program and identifies that her blend would need to meet her own minimum requirements of 50 gms of protein, 40 gms of carbohydrates, and 30 gms of fat per serving. Her sensitivity report is given here. Microsoft Excel 16.0 Sensitivity Report Variable Cells Final Reduced Objective Allowable Allowable Name Value CostCoefficient Increase Decrease A 0.705 25 5.80 11.32 В 1.122 10 11.94 1.53 C 1.734 8 6.44 5.60 Constraints Final Shadow Constraint Allowable Allowable Name Value Price R.H. Side Increase Decrease Protein 600 0.033 600 405.33 241.26 LHS Carbs LHS 480 0.009 480 458.40 192.00 Fat LHS 360 0.052 360 818.57 188.00 Fill in the following blanks based on the Sensitivity Report to specify each of the Right-Hand Side ranges (round to only 2 decimal spaces. a. The range for Protein is from to b. The range for Carbs is from to c. The range for Fat is from to
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Purchasing
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.
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.