please explain step by step in excel how to solve do not use ai

$.$

$$i will rate the solution

Q$1.$ An organization manufactures three products viz. A$,$ B and $c.$ The required raw material per piece of

product A$,$ B and C is $2kg,1kg,$ and $2kg.$ Assume that the total weekly availability is $50kg.$ In order to

produce the products the raw materials are processed on a machine by the labour force and on a weekly

MBA$-$H$2040$

Quantitative Techniques for Managers

the availability of machine hours is $30.$ Assume that the available total labour hour is $26.$ The following

table illustrates time required per unit of the three products.

The profit per unit from the products $A,B$ and $C$ are #$25,$#$30$ and #$40.$

Formulate the dual linear programming problem and determine the optimum values of the dual

variables.