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

Marketing
20th Edition
ISBN:9780357033791
Author:Pride, William M
Publisher:Pride, William M
Chapter10: Digital Marketing And Social Networking
Section10.2: Dollar Shave Club Faces Sharp Competition
Problem 2C
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Marketing
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing