$*$Please explain the process for solving part B & C using the sensitivity report and shadow prices.

The Otto Maddick Machine Tool Company produces two products, muffler bearings and torque amplifiers. One muffler bearing requires $0\mathrm{.}125$ hours of assembly labor, $0\mathrm{.}25$ hours in the stamping department and $9$ square feet of sheet metal. Each torque amplifier requires $1/3$ hours in assembly and $0\mathrm{.}25$ hours in stamping and uses $6$ square feet of sheet metal. Current capacities are $400$ hours of assembly labor and $375$ hours of stamping capacity. Sheet steel costs $$0\mathrm{.}15$ per square foot. Muffler bearings sell for $$9$ and torque amplifiers sell for $$11\mathrm{.}00.$ Use linear optimization to find the number of each product to make to maximize profit. Do not constrain the solution to integers. The available amount of sheet steel may be considered unlimited. The cost of Labor is not charged to the products.

$$A new product called the furtengrinder uses $0\mathrm{.}5$ hours of assembly time and $10$ square feet of sheet metal and sells for $$32\mathrm{.}10.$

$$Use shadow prices from Solver$$s sensitivity report to determine the maximum number of stamping hours it could use before it would become unprofitable to produce furtengrinders.$$

Please show formulas input in excel and the solver parameters $($i$.$e objective, changing variable cells, and constraints$).$