Please use the provided Excel template or create your own to systematically address the problem at hand. You are tasked with configuring Solver to determine the optimal allocation of resources.

Follow these instructions:

Formulate the Problem: Clearly define and input the decision variables related to the allocation of Grade A and Grade B tomatoes across the products: Whole tomatoes, Juice, and Paste.

Objective Function: Set up the objective function in Solver to maximize the total profit from the production of these tomato products. Ensure the function captures the contributions per unit of product.

Solver Setup:

Clearly outline the decision variables in the appropriate cells.

Specify constraints regarding the availability of Grade A and Grade B tomatoes, production capacities, and quality requirements.

Set the objective as 'Maximize' for the total profit cell.

Documentation:

Provide a screenshot of the completed Solver setup showcasing the decision variables, constraints, and objective function.

Include a screenshot of the Excel spreadsheet displaying all cell formulas and values to transparently illustrate how each cell contributes to the overall model

RedBrand Canners:

The Produce Inspections latest estimate of the quality of the incoming tomatoes came in$.$ According to the report, about $20\%$ of the $3,000,000$ pound crop was Grade $$A$$ and the remaining portion was Grade $$B$.$

The goal was to could sell all the canned tomatoes they could produce. However, the expected demand for tomato juice and paste was limited$.$ The latest demand forecast $($Exhibit $1)$ shows selling prices had been set in light of the long$-$term marketing strategy of the company, and that potential sales had been forecast at these prices.

Being able to compute the contribution for each product, and according to his analysis the incremental profit on whole tomatoes was greater than for any other tomato product.

Contracts were agreeing to purchase the grower's production at an average delivered price of $18$ cents per pound, Which they computed the tomato products' contributions.

Although production capacity was ample, it was impossible to produce all whole tomatoes because too small a portion of the crop was $$A$$ quality. Using a numerical scale to record the quality of both raw produce and prepared products. This scale ran from $0$ to $10,$ the higher number representing better quality. $$A$$ tomatoes averaged $9$ points per pound and $$B$$ tomatoes $5$ points per pound. It was noted that the minimum average input quality for canned whole tomatoes was $8$ and for juice $6$ points per pound. Paste could be made entirely from $$B$$ grade tomatoes. This meant that whole tomato production was limited to $800,000$ pounds.

Tomato costs should be allocated on the basis of quality and quantity rather than by quantity only, Therefore, below shows the recomputed marginal profit on this basis and from the results $($see Exhibit $2).$