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: 77% (9 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
22+ 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?
-
The horizontal x-axis is drawn through the centroid C of the area shown, and it divides the area into two component areas A1 and A2. Determine the first moment of each component area with respect to...
-
What is a benefit of k-fold cross-validation over the static holdout method? a. The k-fold cross-validation method is computationally faster. b. The k-fold cross-validation method is easier to...
-
Economic income is considered to be a better predictor of future cash flows than accounting income is. A technique used by securities analysts to determine the degree of correlation between a firms...
-
A ball is launched upward from the ground with an initial velocity of 19 m/s and reaches height above the ground before falling back down. Take the upward direction to be positive. Refer to the...
-
Health Care Partners (HCP) was a 40-year-old company providing health care benefits for large corporations. In order to keep health care costs down for its clients, HCP needed to get a large group 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....
-
On December 31, 20X1, the Income Statement columns of the worksheet for The Sax Shop contained the following information. Give the entries that should be made in the general journal to close the...
-
Explain the owners and shareholder rights and abilities of Amazon as related to Yener's tool, OECD ( Organization for Economic Cooperation and Development) principle, and course reading. With...
-
A retailer in a boutique jewelry store has estimated expenses of 39%, markdowns at 15%, and stock shortage at 6.3%. A profit of 4% is desired. Calculate the initial markup percentage required.
-
Discuss the capital structure of Southwest Airlines. Outline the most recent year's debt, equity, and total capital to show the overall capital structure of the corporation. Articulate the...
-
Scenario Labor Expense Salvage Value of Buildings Salvage Value of Land Best Case $200,000 $150,000 $300,000 Expected Case 250,000 100,000 200,000 Worst Case 350,000 20,000 40,000 Make a scenario...
-
The physician's office that you manage wants to buy equipment for $20,000 with projected cash flows of $3,000 per year over the equipment's ten-year useful life. Calculate the NPV/IRR at 10 percent....
-
A sports equipment company is known for a special grip on its tennis rackets that is imported from South America. The cost of shipping these grips has grown steadily more expensive, and the business...
-
Does log 81 (2401) = log 3 (7)? Verify the claim algebraically.
-
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.
-
Objectives: Fuzzy Bear Network, London, has decided to set up Client-Server networking services for all the staff using Oracle Virtual Machine/VMware. You have been appointed as a network...
-
How do you write an agenda for a first meeting? How to write a meeting agenda 1. Identify the meeting's goal. ... 2. Seek input from the participants. ... 3. Prepare the list of questions that you...
-
A company is requesting a quote for computers for 3 departments, HR, Software Development and Web Design. Please provide a full lists of components, with links from www.canadacomputers.com, required...
Study smarter with the SolutionInn App