2. A company manufactures four types of the same product and in the final part of the manufacturing process there are assembly, polishing and packing operations. For each variant the time required for these operations is shown below (in minutes) as is the profit per unit sold. Type A B C D Assembly Polish Pack Profit ($) 2 3 4 2 23 2 1.5 2.5 3 2 3 3 6 4 5 4 •Suppose that the company is free to decide how much time to devote to each of the three operations (assembly, polishing and packing) within the total allowable time of 205,000 minutes. How many of each variant should the company make per year and what is the associated profit? Alternative scenario: Given the current state of the labour force the company estimate that, each year, they have 110,000 minutes of assembly time, 45,000 minutes of polishing time and 50,000 minutes of packing time available. How many of each type should the company make per year and what is the associated profit? o if you had an extra 100 hours to which operation would you assign it? o if you had to take 50 hours away from polishing or packing which one 0 о would you choose? what would the new objective function value be in these two cases? What should the profit of types A and D should be for the optimal production to be higher than zero? Answer using Microsoft Excel with Solver plugin. Indicate solutions within the file. Turn in the Homework Excel files with your name in the filename and also within the file.