Use the Sensitivity Report for the Camm Textiles scenario (Figure 15.37) to answer the following: a. Explain
Question:
Use the Sensitivity Report for the Camm Textiles scenario (Figure 15.37) to answer the following:
a. Explain the reduced cost (0.14) for Fabric 2 Purchased in terms of the original data, and why it makes sense.
b. Explain the shadow price for the dobbie loom constraint.
c. Show where the shadow prices for the fabric constraints come from in terms of the original data and why they make sense.
Data from Figure 15.37
Transcribed Image Text:
5 Objective Cell (Min) Cell $8$20 Cost Total Decision Variable Cells 10 11 12 13 14 15 16 17 18 19 A B 28728 с $B$16 Fabric 3 on Dobble SCS16 Fabric 3 on Regular 20 SDS16 Fabric 3 Purchased 22 Constraints 26 Name Cell Name $B$14 Fabric 1 on Dobble SCS14 Fabrie 1 on Regular SD$14 Fabrie 1 Purchased SBS15 Fabric 2 on Dobble SCS15 Fabric 2 on Regular $D$15 Fabric 2 Purchased Cell Name $B$17 Hours Used on Dobble SCS17 Hours Used on Regular SE$14 Fabric 1 Total Yards Produced $E$15 Fabric 2 Total Yards Produced 29 $E$16 Fabric 3 Total Yards Produced D Final Value 83756.12 Final Value 30794.4 0 14206.6 10000 0 Final Value E Reduced Objective Cost Coefficient 0 0.180769231 76500 0 0 0.213636364 6552 18964 26573 45000 76500 10000 0 -0.85 0 0 0.14 0 0.15 Shadow Price -0.94 0 0.85 0.61 0.5 0.65 0 0.85 0.61 0.61 0.75 0.5 0.5 0.85 Constraint R.H. Side Allowable Increase 0.200000094 0.1500001 1E+30 Allowable Increase 6552 3022.468085 32760 45000 76500 82033.81818 10000 69413.23077 H 1E+30 1E+30 0.200000004 1E+30 0.180769231 Allowable Decrease 0.1400001 1E+30 1E+30 0.213636364 1E+30 1E+30 1E+30 1E+30 1E+30 0.14 1E+30 0.15 Allowable Decrease 8552 15775.73427 14205.6 78500 10000
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 80% (10 reviews)
Objective Cell Min Cell Name Final Value B20 Cost Total 8375612 Decision Variable Cells Final Reduce...View the full answer
Answered By
Mary Boke
As an online tutor with over seven years of experience and a PhD in Education, I have had the opportunity to work with a wide range of students from diverse backgrounds. My experience in education has allowed me to develop a deep understanding of how students learn and the various approaches that can be used to facilitate their learning. I believe in creating a positive and inclusive learning environment that encourages students to ask questions and engage with the material. I work closely with my students to understand their individual learning styles, strengths, and challenges to tailor my approach accordingly. I also place a strong emphasis on building strong relationships with my students, which fosters trust and creates a supportive learning environment. Overall, my goal as an online tutor is to help students achieve their academic goals and develop a lifelong love of learning. I believe that education is a transformative experience that has the power to change lives, and I am committed to helping my students realize their full potential.
5.00+
4+ Reviews
21+ Question Solved
Related Book For
Question Posted:
Students also viewed these Business questions
-
Use Solver to create the Sensitivity Report for this LP problem. Use this report to answer the following questions. Each question is independent of the others.
-
Explain the process of normalizing historical data and why it should be done before the valuation process is undertaken.
-
Use Solver to create the Sensitivity Report for this LP problem. Use this report to answer the following questions. Each question is independent of the others. (a) Interpret the shadow prices for the...
-
Consider the rigid aircraft in planar flight indicated below with points P and R separated by distance L. Known measurement data includes components of translational velocity and acceleration vectors...
-
Why do you need to know the sampling distribution of the difference between two sample means in order to perform a hypothesis test to compare two population means?
-
During the current period, Pensacola Pipe Company paid $39,600 for 30,000 units of material, all of which was immediately put into process. During the period, 14,800 units of output were produced,...
-
Calculate the MHR for Machine A from the following data: Cost of machine Rs 1,600 Estimated scrap value Rs 100 Effective working life 10,000 hours Running time per 4 weekly period 160 hours Average...
-
Blue Jay Delivery Service is incorporated on January 2, 2010, and enters into the following transactions during its first month of operations: January 2: Filed articles of incorporation with the...
-
Western Electric Utility Company faces increasing needs for capital. Fortunately, it has an A ( low ) credit rating. The corporate tax rate is 3 0 percent. Western s treasurer is trying to determine...
-
Melodic Musical Sales, Inc. is located at 5500 Fourth Avenue, City, ST 98765. The corporation uses the calendar year and accrual basis for both book and tax purposes. It is engaged in the sale of...
-
For Problem 13.37 (Shafer Office Supplies), obtain the Solver Sensitivity Report and answer the following questions: a. Suppose that 500 units of extra supply are available (and that the cost of this...
-
Suppose the distances that a pharmaceutical representative, Tracy Ross, travels between medical offices are as follows: Set up and solve a traveling salesperson problem using Evolutionary Solver....
-
What is a Pareto chart?
-
Identify a public conflict (such as a recent Congressional debate or even a celebrity breakup) that has come to the forefront in the media (or public's attention) in the last thirty days. You have...
-
Performance Management Issues You have been asked to return to your alma mater and speak to current students about performance management issues. To make the most of this experience for yourself and...
-
Analysis of competitor organization of our selected organization Walmart and its competitor Safeway. 1. Complete analysis of competitor organization; addresses all relevant factors and typically uses...
-
Defining Program Objectives of Youth centers Clearly define the objectives of your program or center. What specific outcomes do you hope to achieve? Examples may include promoting physical fitness,...
-
Identify a local or regional organization and analyze how they demonstrate servant leadership in their operations. You will want to review their website, social media, news, and other resources to...
-
Modify, compile, and test the client program in Table 25.17 and the server program in Table 25.16 to simulate a local DNS client and server. The server has a short table made of two columns, domain...
-
Create an appropriate display of the navel data collected in Exercise 25 of Section 3.1. Discuss any special properties of this distribution. Exercise 25 The navel ratio is defined to be a persons...
-
In the Sales Transactions database, use Excels filtering capability to extract all orders that used PayPal, all orders under $ 100, and all orders that were over $ 100 and used a credit card.
-
The Excel file Credit Risk Data provides information about bank customers who had applied for loans. 6 The data include the purpose of the loan, checking and savings account balances, number of...
-
Use the COUNTIF function to construct a frequency distribution of the types of loans in the Excel file Credit Risk Data and develop a column chart to express the results visually.
-
Comfort Golf Products is considering whether to upgrade its equipment Managers are considering two options. Equipment manufactured by Stenback Inc. costs $1,000,000 and will last five years and have...
-
Weaver Corporation had the following stock issued and outstanding at January 1, Year 1: 71,000 shares of $10 par common stock. 8,500 shares of $60 par, 6 percent, noncumulative preferred stock. On...
-
Read the following case and then answer questions On 1 January 2016 a company purchased a machine at a cost of $3,000. Its useful life is estimated to be 10 years and then it has a residual value of...
Study smarter with the SolutionInn App