Modify PC Tech’s product mix model so that there is no maximum sales constraint. Does this make the problem unbounded? Does it change the optimal solution at all? Explain its effect.
Answer to relevant QuestionsIn the product mix model it makes sense to change the maximum sales constraint to a “minimum sales” constraint, simply by changing the direction of the inequality. Then the input values in row 23 can be considered ...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 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 ...For a telephone survey, a marketing research group needs to contact at least 600 wives, 480 husbands, 400 single adult males, and 440 single adult females. It costs $3 to make a daytime call and (because of higher labor ...Each year, a shoe manufacturing company faces demands (which must be met on time) for pairs of shoes as shown in the file S13_40.xlsx. Employees work three consecutive quarters and then receive one quarter off. For example, ...
Post your question