A fabriccompany uses yellow paint, green paint, and red paint to make three different types of cloth styles: Bright, Pastel, Monotone. The salespeople estimate that they can sell all the cloths produced. For each type of cloth, the amount of materials required to produce 1 kg of cloth is shown below:Cloth TypePaintrequired (kg)BrightPastelMonotoneYellow214Green540Red301The available paint per week are:Availability (kg)Yellow960Green740Red 230

Net Profits for three types of cloth are:Net Profits ($/kg)Bright8Pastel4Monotone7a)Set up a linear program that can be solved to maximize the total net profit per week. b)Solve the linear program by Excel Solver. Print your Excel worksheet to show your answer. c)How much of each type of cloth should be made to optimize the profit? What is the optimal profit? d)If the sales potential of Pastel Cloth is 100 kg per week maximum, will your answer in part c be changed? Show the new answer by printing out the new Excel worksheet if Yes.