In Solver’s sensitivity report for the product mix model, the allowable decrease for available assembling hours is 2375. This means that something happens when assembling hours fall to 20,000 - 2375 =17,625. See what this means by first running Solver with 17,626 available hours and then again with 17,624 available hours. Explain how the two solutions compare to the original solution and to each other.
Answer to relevant QuestionsCan you guess the results of a sensitivity analysis on the initial inventory in the Pigskin model? See if your guess is correct by using Solver Table and allowing the initial inventory to vary from 0 to 10,000 in increments ...Modify the Pigskin spreadsheet model so that demand in any of the first five months must be met no later than a month late, whereas demand in month 6 must be met on time. For example, the demand in month 3 can be met partly ...Maggie Stewart loves desserts, but due to weight and cholesterol concerns, she has decided that she must plan her desserts carefully. There are two possible desserts she is considering: snack bars and ice cream. After ...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 ...Modify the original Red Brand problem so that all flows must be from plants to warehouses and from warehouses to customers. Disallow all other arcs. How much does this restriction cost Red Brand, relative to the original ...
Post your question