Practical Management Science
6th Edition
ISBN: 9781337406659
Author: WINSTON, Wayne L.
Publisher: Cengage,
expand_more
expand_more
format_list_bulleted
Related questions
Question
thumb_up100%
I need some help on my operations management homework following the sensitivty report. Thank you
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
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by stepSolved in 2 steps
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.Similar questions
- All of the department leaders were on an executive retreat over the weekend with the chief operations officer, Stacey. Stacey presented the company's new operations plan at the retreat. During her presentation, she mentioned that the efficiencies gained through equipment acquisition meant the company is currently overstaffed. Some departments will experience lay-offs sometime in the coming months. The plans for staff reduction aren't yet finalized and an official announcement won't be made until a plan is in place. The department leaders don't discuss this with each other, but each informally spreads the word with his or her department on Tuesday. Which type of communication network is this? Gossip grapevine chain O All channel Cluster grapevine chain O Wheelarrow_forwardDiscuss why it is important to evaluate processes within an organization using flowcharting and performance metrics.arrow_forwardUnder the operations analysis, how do you know how to assign responsibilities?arrow_forward
- Share the knowledge needed to become a certified Six Sigma Black Belt. Note: (Explain the basics, what happens is that I am studying industrial engineering)arrow_forwardHow can information be gathered for a complete operations manual?arrow_forwardWhat Are The Three Major Business Functions, And How Are They Related To One Another? Give Specific Examples?arrow_forward
- What are the human resources requiring for business operation and success? Create an organization chart as a setup team for business operations.arrow_forwardHow do I solve an operation management case method.arrow_forwardCASE STUDY 4-1 TELECOMMUTING WITH A NEW TWIST Open a new Microsoft® Word document and answer the following questions. Save the file on your computer with your last name in the file name. (Example: case_1-1 _Jones.doc) Click the Choose File button to find and select your saved document. According to GlobalWorkplace-Analytics.com published in January 2016, there were 3.7 million employees (2.8 percent of the workforce) that are at least half-time telecommuters. And telecommuters among the non-self-employed population have increased by 103 percent since 2005. The employee population grew by 1.9 percent from 2013 to 2014, while the employee population who telecommute grew 5.6 percent. Data from Flexjobs.com published in 2016 showed telecommuters save 260 hours by not commuting on a daily basis and are 50 percent less likely to quit their jobs. Half of the U.S. workforce has jobs that are compatible with telecommuting arrangements. Working from home offers some clear advantages for both…arrow_forward
- Is a scriptural approach to operations different than the ethical approach described in the chapter? Explain.arrow_forwardHello can you help me with one of my work please? Can you discuss the operations performance in a company (Operation management)? in about 800 words, it would really help me for my understanding Thanks in advancearrow_forwardHello, can you help me with one of my work please? can you discuss the operations performance in an organisation? in 800 words. Thanks in advancearrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Operations ManagementOperations ManagementISBN:9781259667473Author:William J StevensonPublisher:McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi...Operations ManagementISBN:9781259666100Author:F. Robert Jacobs, Richard B ChasePublisher:McGraw-Hill Education 
Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning
Production and Operations Analysis, Seventh Editi...Operations ManagementISBN:9781478623069Author:Steven Nahmias, Tava Lennon OlsenPublisher:Waveland Press, Inc.
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.