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

$.$

$$i will rate the solution

Q$1.$ A juice company has its products viz. canned apple and bottled juice with profit margin Rs$.4$ and

Rs$.2$ respectively pre unit. The following table shows the labour, equipment, and ingredients to produce

each product per unit.

Formulate the linear programming problem $($model$)$ specifying the product mix which will maximize the

profit without exceeding the levels of resources.