Please solve this problem in EXCEL and also use EXCEL SOLVER*

Thank you! :)

For each Linear Programming question, you must submit the following. 1) What are the decisions to be made? 2) What is the business objective? 3) What are the constraints? You should articulate the above three in plain English. 4) Next, define the decision variables, objective function and constraints. Question 3(Blending): The task is to determine an optimal blend to create the paint to paint a very large building. The blended paint to be used is to be created by blending four raw paints and two thinners. Data on the paints, thinners and requirements on the blend are given below. Find the blend that minimizes the cost of making one gallon of the Blend. Note that you do not have the information to determine how many gallons of paint to make, but you should be able to determine how to make a gallon of the blend, at least cost. Paint Type Thinner type 1 1 2 Data 3 4 Cost (S/Gal) Viscosity(CP) Vapor pressure(psi) Brilliance content(gs/gal) Durability content(gs/gal) 9 900 0.2 30 2000 7 780 0.4 20 1500 5.57 620 0.6 50 1000 4 375 0.8 10 500 3 2 12 0 1.85 25 8 0 0 0 The Blend must have the following properties: Property Viscosity Brilliance content Requirement Minimum of 400 CP Between 15 and 30 gs/Gal Reason So that a single coat is enough So, the surface is properly reflective For proper drying in time For weather resistance Vapor Pressure Durability content Between 2 and 4 psi Minimum of 575 gs/Gal. Note: There is no requirement that all the paints and all the thinners must be used. The optimal solution may use only a subset of paints and thinners