Question: Create a two way Solver Table for the product mix model

Create a two-way Solver Table for the product mix model, where total profit is the only output and the two inputs are the testing line 1 hours and testing line 2 hours available. Let the former vary from 4000 to 6000 in increments of 500, and let the latter vary from 3000 to 5000 in increments of 500. Discuss the changes in profit you see as you look across the various rows of the table. Discuss the changes in profit you see as you look down the various columns of the table.




Sale on SolutionInn
Sales0
Views78
Comments
  • CreatedApril 01, 2015
  • Files Included
Post your question
5000