Microsoft Excel $14\mathrm{.}0$ Sensitivity Report

Problems P$4-22823.$ Good$-$to$-$Go Suitcase Company

Variable Cells

Constraints

Figure $4\mathrm{.}29$: Solver Sensitivity Report for Good$-$to$-$Go Suitcase Company

$4-23.$ Suppose Good$-$to$-$Go $($Problem $4-22)$ is considering the possible introduction of two new products to its line of suitcases: the Compact model $($for teenagers$)$ and the Kiddo model $($for children$).$ Market research suggests that Good$-$to$-$Go can sell the Compact model for no more than $\backslash$$$30,$ whereas the Kiddo model would go for as much as $\backslash (\backslash$$ $37\mathrm{.}50\backslash )$ to specialty toy stores. The amount of labor and the cost of raw materials for each possible new product are as follows:

Use a pricing$-$out strategy to check if either model would be economically attractive to make.