Reference no: EM132909585

-The Otto Maddick Machine Tool Company produces two products, muffler bearings and torque amplifiers. One muffler bearing requires 0.125 hours of assembly labor, 0.25 hours in the stamping department and 9 square feet of sheet metal. Each torque amplifier requires 1/3 hours in assembly and 0.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.15 per square foot. Muffler bearings sell for $9 and torque amplifiers sell for $11.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.5 hours of assembly time and 10 square feet of sheet metal and sells for $32.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). Please provide a detailed step-by-step description of your proposed solution.