Use Solver to create a Sensitivity Report for question, and answer the following
ID: 3119027 • Letter: U
Question
Use Solver to create a Sensitivity Report for question, and answer the following questions a. Is the solution degenerate? b. Is the solution unique? c. How much should the recycler be willing to pay to acquire more cardboard? d. If the recycler could buy 50 more tons of newspaper at a cost of $18 per ton, should the company do it? Why or why not? e. What is the recycler's marginal cost of producing each of the three different types of pulp? f. By how much would the cost of converting white office paper into newsprint have to drop before it would become economical to use white office paper for this purpose? g. By how much would the yield of newsprint pulp per ton of cardboard have to increase before it would become economical to use cardboard for this purpose? h. Create a Spider Plot showing the impact on optimal total cost of varying cost per ton of newspaper, mixed paper, white office paper, and cardboard between plus or minus $1 from their stated values in $0.20 increments. What does this chart reveal, and what are the managerial implications? i. Suppose it is possible to increase any of the (nonzero) recycling yield coefficients in the problem by up to 5% in 1% increments. Create a Spider Plot and Table summarizing the effect this would have on the optimal total cost. If the company could increase one of the yield coefficients by 5% for free, which one should it choose, and how much would be saved?Explanation / Answer
Dear Student,
Please make it correct. In "Recycling Yield" table newspaper can be recycled to yield 85% of newsprint pulp or alternatively can be recycled to yield 80 of packaging paper or alternatively it can be recycled to yield " 2014 " print stock . " make it correct ".
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.