Linear Programming from Scratch Professor Cursio's hint: if you do not see solver, raise your hand and I'll fix this for you. This is not part of the exom. Gatson manufacturing company produces 2 types of tires: Economy tire; Premium tire. The manufacturing time and the profit contribution per tire are given in the following table: Manufacturing Time (Hours) Time Available Operation Economy tires Premium tires Hours Material Preparation 4/3 1/2 600 Tire Building 4/5 1 650 Curing 1/2 2/4 580 Final Inspection 1/5 1/3 120 Profit/Tire $12 $10 Answer the following assuming that the company is interested in maximizing the total profit contribution. Part A: What is the linear programming mathematical model for this problem? Part B: Develop a spreadsheet model and find the optimal solution using Excel Solver. How many tires of each model should Gatson manufacture? Part C: What is the total profit contribution Gatson can earn with the optimal production quantities? Professor Cursio's hints: For part A, I want to see an objective function and some constraint equations. For Parts B and C I need to see an Excel spreadsheet. Also, when typing in the numbers to a spreadsheet, I would write "=4/3" and then Excel would translate this to 1.3333...If you omit the "=" then Excel might think this is a date rather than a value