A firm that assembles computers and computer equipment is about to start producing two new

microprocessors $($type $1$ and type $2).$ Each requires assembly, inspection, and storage.

Management likes to maximize profit. You are given the following information.

Whatever combination of type $1$ and $2$ is produced will be sold. Using an Excel solver, solve this problem.

a$.$ What is the total profit?

b$.$ Go to your sensitivity analysis; if type $1$ profit increases to $$65,$ what is the new optimal value $($type $1$ and type $2),$ or is it still the same? Explain

c$.$ What constraint is binding?

d$.$ If you decrease the inspection constraint on the right$-$hand side by one hour $($one hour less$),$ what would happen to your profit? $($Hint: shadow price$/$dual price$).$