Need help formulating this model in excel using analytic solver:Universal Technologies has identified two qualified vendors with the capability to supplyelectronic components. Each vendor has different pricing schemes for the three products,including some discounts based on the volume purchased, as shown in the table below (this willrequire the use of linking constraints based on the volume ranges. For the coming year,Universal has estimated its volume requirements for these components and has obtained price-break schedules from each vendor. The products sold by each vendor are identical, so aproduct may be bought from each of the vendors (e.g. half of the units for Product 1 could bepurchased from Vendor A and the other half purchased from Vendor B). Universal believeseach Vendor has the necessary capacity to meet any level of demand based on therequirements, however, Universal wants to make sure that neither Vendor receives more than60% of the total requirement.a. Create an optimization model and solve using Analytic Solver's LP/Quadratic Engine.You MUST use binary and integer decision variables as well as the requiredlinking constraints to solve this problem and receive full credit.Label this worksheet 1a.b. Using your optimal solution: assume that each product purchased at a discount waspurchased from the same vendor at the non-discounted (highest) price. Perform thefollowing analysis:i. What would the total cost be if there were no discounts?ii. What is the percentage decrease in cost these discounts represent for theoptimal solution from the value you calculated above for 2 bi ?