Continuing the previous problem, perform a sensitivity analysis on the selling price of VXPs. Let this price vary from $500 to $650 in increments of $10, and keep track of the values in the changing cells and the objective cell. Discuss your findings.
Answer to relevant QuestionsAgain continuing problem 2, suppose that you want to force the optimal solution to be integers. Do this in Solver by adding a new constraint. Select the changing cells for the left side of the constraint, and in the middle ...Consider the graphical solution to the product mix problem. Now imagine that another constraint—any constraint—is added. Which of the following three things are possible: (1) The feasible region shrinks; (2) The feasible ...Some analysts complain that spreadsheet models are difficult to resize. You can be the judge of this. Suppose the current product mix problem is changed so that there is an extra resource, packaging labor hours, and two ...Modify the Pigskin spreadsheet model in the following way. Assume that the timing of demand and production are such that only 70% of the production in a given month can be used to satisfy the demand in that month. The other ...A manufacturing company makes two products. Each product can be made on either of two machines. The time (in hours) required to make each product on each machine is listed in the file S13_33.xlsx. Each month, 500 hours of ...
Post your question