Solve the Optimization problem using **Excel**

A manufacturing firm produces two products, A and B, using two limited resources. The maximum amounts of resources 1 and 2 available per day are 1000 and 250 units, respectively. The production of 1 unit of product A requires 1 unit of resource 1 and 0.2 unit of resource 2, and the production of 1 unit of product B requires 0.5 unit of resource 1 and 0.5 unit of resource 2. The unit costs of resources 1 and 2 are given by the relations (0.375 - 0.00005u1) and (0.75 -0.0001uz), respectively, where u; denotes the number of units of resource i used (i = 1, 2). The selling prices per unit of products A and B, pa and pe, are given by PA = 2.00 -0.0005XA-0.00015x8 pe = 3.50 -0.0002XA-0.0015x8 where xa and xs indicate, respectively, the number of units of products A and B sold. Formulate the problem of maximizing the profit assuming that the firm can sell all the units it manufactures