1. Create a new worksheet called Lookup to the right of Purchase Plan. In the Lookup sheet, enter your name in cell A1, and create a table that has monetary information on each of the toys:
   1. Blue Raider Urban Adventure Set has a retail price of $19.95, a unit cost of $15.36, and a storage cost of $.15.
   2. Super Action Kit has a retail price of $14.95, a unit cost of $14.21, and a storage cost of $.10.
   3. Blue Raider Outdoor Set has a retail price of $16.95, a unit cost of $13.77, and a storage cost of $.25.
   4. Hiking Kit has a retail price of $11.95, a unit cost of $10.03, and a storage cost of $.15.
2. On the Purchase Plan sheet, write the formulas that will populate the retail price, unit cost, and storage cost per unit in their respective cells.
3. Write the formulas that calculate the gross revenue (number purchased multiplied by the retail price), the total unit cost (unit cost multiplied by the number purchased), the total storage cost (storage cost per unit multiplied by the number purchased), the total cost (total unit cost plus total storage cost), and the profit (gross revenue minus the total cost) for each of the toys.
4. Write the formulas to add the total number of toys purchased in cell B8, the total cost in cell I8, and the total profit in cell J8. Check that formulas entered in Step 4 link the objective cell (total profit) with the variable cells. Add sample values to the variable cells to ensure that your worksheet is set up correctly and produces the expected results.
5. Create a constraints list in the worksheet that identifies the constraints in this problem.
6. Format all monetary fields as Accounting with two decimal places.
7. Use Solver to determine the best way to purchase the Mighty Toys sets and kits and maximize the profit. Make sure that Solver is set to use Simplex LP as the solving method.
8. Produce an answer report of your final solution. Use the answer report to recommend additional changes that might maximize the total profit. Place your recommendations in a cell on the answer report worksheet.

A1 Mighty Toys Purchasing Plan \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline & \begin{tabular}{c} Number \\ Purchased \end{tabular} & Retail Price & \begin{tabular}{c} Gross \\ Revenue \\ \end{tabular} & Unit Cost & Total Unit Cost & \begin{tabular}{c} Storage Cost \\ per Unit \end{tabular} & \begin{tabular}{c} Total Storage \\ Cost \end{tabular} & Total Cost & Profit \\ \hline Blue Raider Urban Adventure Set & 1 & & & & & & & & \\ \hline Super Action Kit & 1 & & & & & & & & \\ \hline Blue Raider Outdoor Set & 1 & & & & & & & & \\ \hline Hiking Kit & 0 & & & & & & & & \\ \hline & & & & & & & Total & & \\ \hline \end{tabular} Constraints: Total Cost (18) Blue Raider Urban Adventure Set (B4) Super Action Kit (B5) Blue Raider Outdoor Set (B6) Hiking Kit (B7) Number Purchased (B4:B7) Total Number Purchased Super Action Kit (B5) Hiking Kit (B7) Blue Raider Outdoor Set (B6) A1 Mighty Toys Purchasing Plan \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline & \begin{tabular}{c} Number \\ Purchased \end{tabular} & Retail Price & \begin{tabular}{c} Gross \\ Revenue \\ \end{tabular} & Unit Cost & Total Unit Cost & \begin{tabular}{c} Storage Cost \\ per Unit \end{tabular} & \begin{tabular}{c} Total Storage \\ Cost \end{tabular} & Total Cost & Profit \\ \hline Blue Raider Urban Adventure Set & 1 & & & & & & & & \\ \hline Super Action Kit & 1 & & & & & & & & \\ \hline Blue Raider Outdoor Set & 1 & & & & & & & & \\ \hline Hiking Kit & 0 & & & & & & & & \\ \hline & & & & & & & Total & & \\ \hline \end{tabular} Constraints: Total Cost (18) Blue Raider Urban Adventure Set (B4) Super Action Kit (B5) Blue Raider Outdoor Set (B6) Hiking Kit (B7) Number Purchased (B4:B7) Total Number Purchased Super Action Kit (B5) Hiking Kit (B7) Blue Raider Outdoor Set (B6)