. For each of the two problems below, formulate (write equations much like our white boarding exercise in class) and then solve using Solver . The equations part and the Excel Model to apply Solver on should be clearly laid out in an Excel sheet. For each problem, use a separate sheet. A Multi-Plant Model 1. A company operates in two factories, A and B. Each factory makes two products, standard and deluxe. A unit of standard gives a profit contribution of $10, while a unit of deluxe gives a profit contribution of $15 Each factory uses processes, grinding and polishing, for producing its products. Factory A has a grinding capacity of 80 hours per week and polishing capacity of 60 hours per week. For factory B, these capacities are 60 and 75 hours per week, respectively The grinding and polishing times in hours for a unit of each type of product in each factory are given in the table below FactoryA FactoryB Deluxe Deluxe Standard 4 Standard Grinding Polishing It is possible, for example, that factory B has older machines than factory A, resulting in higher unit processing times In addition, each unit of each product uses 4kg of a raw material. The company has 120kg of raw material available per week. To start with, we will assume that factory A is allocated 75kg of raw material per week and factory B the remaining 45kg per week