# Question

Other sensitivity analyses besides those discussed could be performed on the product mix model. Use Solver Table to perform each of the following. In each case keep track of the values in the changing cells and the objective cell, and discuss your findings.

a. Let the selling price for Basics vary from $220 to $350 in increments of $10.

b. Let the labor cost per hour for assembling vary from $5 to $20 in increments of $1.

c. Let the labor hours for testing a Basic vary from 0.5 to 3.0 in increments of 0.5.

d. Let the labor hours for assembling and testing an XP vary independently, the first from 4.5 to 8.0 and the second from 1.5 to 3.0, both in increments of 0.5.

a. Let the selling price for Basics vary from $220 to $350 in increments of $10.

b. Let the labor cost per hour for assembling vary from $5 to $20 in increments of $1.

c. Let the labor hours for testing a Basic vary from 0.5 to 3.0 in increments of 0.5.

d. Let the labor hours for assembling and testing an XP vary independently, the first from 4.5 to 8.0 and the second from 1.5 to 3.0, both in increments of 0.5.

## Answer to relevant Questions

In PC Tech’s product mix problem, assume there is another PC model, the VXP that the company can produce in addition to Basics and XPs. Each VXP requires eight hours for assembling, three hours for testing, $275 for ...Using the graphical solution of the product mix model as a guide, suppose there are only 2800 testing hours available. How do the answers to the previous problem change? 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 ...Modify the Pigskin spreadsheet model so that except for month 6, demand need not be met on time. The only requirement is that all demand be met eventually by the end of month 6. How does this change the optimal production ...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 ...Post your question

0