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

B$26$:B$28,$ and the total profit. Discuss your findings.

Are they intuitively what you expected?$\backslash$table$[[2,$A$,$B$,$C$,$D$,$E$,$F$,$G$,$H$],[1,$Assembling and testing computers,,,,,,,$],[2,,,,,,,,],[3,$Cost per labor hour assembling,$$11,,,,,,],[4,$Cost per labor hour testing,$$15,,,,,,],[5,,,,,,,,],[6,$Inputs for assembling and testing a co$,$inter,,,,,,$],[7,,$Basic,XP$,,,,,],[8,$Labor hours for assembly,$5,6,,,,,],[9,$Labor hours for testing,$1,2,,,,,],[10,$Cost of component parts,$$150,$$$225,,,,,],[11,$Selling price,$$300,$$$450,,\{$

$\backslash$table$[[$The trick here is to let the$],[$single value in cell G $18$ drive$],[$both values in cells B$18$ and$],[$C$18$ from their original values.$]]\}],[12,$Unit margin,$$80,$$$129,],[13,,,,],[14,$Assembling, testing plan $($# of computers$),,],[15,,$Basic,XP$,],[16,$Number to produce,Original values,$\%$ change in both$],[18,$Maximum sales,$600,1200,,600,1200,0\%,],[19,,,,,,,],[20,$Constraints $($hours per month$),$Hours used,,Hours available,,,$],[21,$Labor availability for assembling,Labor availability for testing,Net profit $($$ this month$),$Basic,XP$,$Total,,,,$],[25,,$$$44,800,$$ $154,800,$$$199,600,,,,]]$