Question: EXCEL SOLVER You have decided to try adding ponchos to your portfolio of products you are bringing along with you on your summer Grateful Dead

EXCEL SOLVER You have decided to try addingEXCEL SOLVER You have decided to try adding

EXCEL SOLVER You have decided to try adding ponchos to your portfolio of products you are bringing along with you on your summer Grateful Dead tour. Your original answer is shown below, in Excel. You used Solver to solve the linear program, and here is the Answer Report. Microsoft Excel 16.0 Answer Report Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Obiective Cell (Max) Variahle Cells Constraints Here is the Sensitivity Report. I didn't include the Limits Report, because it's a waste of our time. Microsoft Excel 16.0 Sensitivity Report Variable Cells In the space below, answer the following questions: a. (3 pts.) What are the optimal quantities of sweatshirts, tie-dyes, and ponchos to make? b. (3 pts.) What are the optimal profits? c. (3 pts.) What is the most you would be willing to pay for another unit of volume? You realize that your profit estimates are off, and the profits per Sweatshirt are going to be $15 apiece. What should your production quantities be, given those profits per unit? I do not want you to re-solve this. If you think it needs to be re-solved, just say "we don't know, we'd have to solve the linear program over again." e. (3 pts.) How much would your profits change if you made 1 poncho

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!