Again continuing problem 2, perform a sensitivity analysis where the selling prices of Basics and XPs simultaneously change by the same percentage, but the selling price of VXPs remains at its original value. Let the percentage change vary from -25% to 50% in increments of 5%, and keep track of the values in the changing cells and the total profit. Discuss your findings.
Answer to relevant QuestionsConsider 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 ...Model 8 has fairly high profit margins, but it isn’t included at all in the optimal mix. Use Solver Table, along with some experimentation on the correct range, to find the (approximate) selling price required for model 8 ...In one modification of the Pigskin problem, the maximum storage constraint and the holding cost are based on the average inventory (not ending inventory) for a given month, where the average inventory is defined as the sum ...A company faces the following demands during the next three weeks: week 1, 2000 units; week 2, 1000 units; week 3, 1500 units. The unit production costs during each week are as follows: week 1, $130; week 2, $140; week 3, ...During the next two months an automobile manufacturer must meet (on time) the following demands for trucks and cars: month 1, 400 trucks and 800 cars; month 2, 300 trucks and 300 cars. During each month at most 1000 vehicles ...
Post your question