Does this analysis help decide which department needs new equipment? If yes, please explain your answer. If not, please describe the appropriate analysis technique to answer the question about new equipment, and discuss what additional data is needed.

A B C D E F G H Microsoft Excel 16.74 Sensitivity Report Worksheet: [Book9.xIsx]Sheet1 Report Created: 27/6/2023 10:37:04 am Variable Cells Constraints \begin{tabular}{llrrrrr} \hline & & Final & Shadow & \multicolumn{3}{c}{ Constraint Allowable Allowable } \\ Cell & Name & Value & Price & R.H. Side & Increase & Decrease \\ \hline \$F\$19 & Key Customer Order 150 LHS & 1100 & 0 & 150 & 950 & 1E+30 \\ \hline \$F\$20 & Key Customer Order 600 LHS & 600 & -44 & 600 & 475 & 75 \\ \hline \$F\$21 & Plant Capacity (hrs) - Drawing LHS & 2200 & 0 & 4000 & 1E+30 & 1800 \\ \hline \$F\$22 & Plant Capacity (hrs) - Extrusion LHS & 1950 & 0 & 4200 & 1E+30 & 2250 \\ \hline \$F\$23 & Plant Capacity (hrs) - Winding LHS & 1850 & 0 & 2000 & 1E+30 & 150 \\ \hline \$F\$24 & Plant Capacity (hrs) - Packaging LHS & 2300 & 34 & 2300 & 150 & 950 \\ \hline \$F\$25 & Next Months Orders - W0075C LHS & 1100 & 0 & 1400 & 1E+30 & 300 \\ \hline \$F\$26 & Next Months Orders - W0033C LHS & 250 & 30 & 250 & 50 & 250 \\ \hline \$F\$27 & Next Months Orders - W0005X LHS & 0 & 0 & 1510 & 1E+30 & 1510 \\ \hline \$F\$28 & Next Months Orders - W0007X LHS & 600 & 0 & 1116 & 1E+30 & 516 \\ \hline \end{tabular} Data 1. Next month orders Note: Vivian Napoli has given her word to a key customer that MG Wire will manufacture 600 units of product W0007X and 150 units of product W0075C for him next month. 2. Standard cost 3. Selected operating data 4. Plant capacity (hours) Note: Inspection capacity is not a problem: we can work overtime as necessary to accommodate any schedule. 5. Bill of resource (hours/unit)