12. In PC Tech's two-line product mix model, use SolverTable to run a sensitivity analysis on the cost per assembling labor hour, letting it vary from $5 to $20 in increments of $1. Keep track of the computers produced in row 21, the hours used in the range B26: B28, and the total profit. Discuss your findings. Are they intuitively what you expected?

SHOW ALL WORK OF SOLVERTABLE (input, output)

Assembling and testing computers Cost per labor hour assembling Cost per labor hour testing, ine1 Cost per labor hour testing, line 2 $11 519 $17 Range wames used Number to produce Hoursused Maximum_sales Numbet tested on line 1 Number tested an_line 2 Total computers_produced Totalprofit D26.028 0262 23-03 819-19 120.20 021-01 10 Inputs for asembling and testing a computer Model Model 2 Model 3 Model & Models Model Model Models Labor hours for assembly 5 SS 55 55 6 Labor hours for testing. Ine 1 1.5 2 2 2 2.5 2.5 2.5 3 Labor hours for testing in 2 2.5 2.5 25 25 3.5 Cost of component parts 5150 $225 $225 $225 $250 $250 $250 $300 Selling price $350 $450 5460 $470 5510 SCOO unit margin teed on line 1 5128 5132 5142 $142 $167 5172 $177 Unit margin tested on line 2 $122 $123 $160 5500 sas $148 Assembling, testing plan of computers) Model Model Model Model Model Model Model Number tested on line 1 0 0 125 0 0 1000 Nuntertexted on line 2 0 0 o 0 0 Totalcomputer produced 1500 0 0 600 0 1000 1000 1000 Model 0 0 0 Maximum 1500 1250 1250 1000 1000 Constraints hours per month Labor available for assembling Labor availability for testing, line 1 Labor availability for testing, line 2 Hoursed 20000 SOOD 41875 Hours available 30000 5000 6000 Net profits per tant Tested on line 1 Tested on line 2 Model 1 $191,250 $0 Model Model Model Model 5 Model 6 Model so so $19.000 so $0 $172,000 $0 0 $70,063 $0 $163,500 $ Model Total 50 5382,250 $0 5233,563 $615,813