Q$2.$ A factory produces three using three types of ingredients viz. A$,$ B and C in different proportions.

The following table shows the requirements o please explain step by step in excel how to solve do not use ai

$.$

$$i will rate the solutionvarious ingredients as inputs per $kg$ of the products.

The three profits coefficients are $20,20$ and $30$ respectively. The factory has $800kg$ of ingredients A$,$

$1800kg$ of ingredients B and $500kg$ of ingredient C$.$

Determine the product mix which will maximize the profit and also find out maximum profit.