4-34 Consider the Tiger Catering problem (Problem 4-35). For each of the following situations, what would be the impact on the sandwich-making plan and total cost? If it is possible to compute the new cost or sandwich-making plan, do so. (a) The unit cost for tuna sandwiches decreases by \$0.30. (b) The unit cost for tuna and cheese sandwiches increases to $2.40. (c) The unit cost for ham sandwiches increases to $3.75. (d) The unit cost for ham and cheese sandwiches decreases by $0.70. (e) The club does not want any more than 12 ham sandwiches. (f) The unit cost for cheese sandwiches decreases to $2.05 Microsoft Excel 14.0 Sensitivity Report Problems 4-33to37. Tiger Catering Company \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline4 & A & B & C & D & E & F & G & H & \\ \hline 1 & \multicolumn{6}{|c|}{ Tiger Catering Company } & & & \\ \hline32 & & Tuna & Tuna/Ch & Ham & Ham/Ch & Cheese & & & \\ \hline 4 & Number to make & 10.00 & 30.00 & 10.00 & 12.00 & 8.00 & & & \\ \hline 5 & Cost & $242 & $212 & $3.35 & $302 & $236 & $176.42 & & \\ \hline 6 & Constraints & & & & & & & & \\ \hline 7 & Bread (slices) & 2 & 2 & 2 & 2 & 2 & 140.00 & = & 70 \\ \hline 18 & Min Tuna & 1 & & & & & 10.00 & >= & 10 \\ \hline 19 & Min Tuna/Ch & & 1 & & & & 30.00 & >= & 12 \\ \hline 20 & Min Ham & & & 1 & & & 1000 & >= & 10 \\ \hline 21 & MinHam/Ch & & & & 1 & & 12.00 & >= & 12 \\ \hline & & & & & & & LHS & Sign & RHS \\ \hline \end{tabular}