2. Create a new worksheet called Lookup to the right of Purchase Plan. In the Lookup sheet, create a table that has monetary information on each of the toys: a. Blue Raider Urban Adventure Set has a retail price of $19.95, a unit cost of $15.36, and a storage cost of $.15. b. Super Action Kit has a retail price of $14.95, a unit cost of $14.21, and a storage cost of $.10. c. Blue Raider Outdoor Set has a retail price of $16.95, a unit cost of $13.77, and a storage cost of $.25. d. Hiking Kit has a retail price of $11.95, a unit cost of $10.03, and a storage cost of $.15.

Paste === Format Cell 3s Table Styles Format BIU a Av x v fx Mighty Toys Purchasing Plan Cancel Al B D F G H 4 1 Mighty Toys Purchasing Plan Retail Price Gross Revenue Unit Cost Total Unit Cost Storage Cost per Unit Total Storage Cost Total Cost Profit 4 Blue Raider Urban Adventure Set 5 Super Action Kit Blue Raider Outdoor Set 7 Hiking Kit Number Purchased 1 1 1 0 Total 10 Constraints 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 20 27 28 29 30 31 32 33 34 35 36 7 38 39 40 42 43 Purchase Plan + Average: 0.75 Count: 19 Sum 3 4 J tv X W P MacBook Pro esc 80 OOO ODO st DIL >> Paste === Format Cell 3s Table Styles Format BIU a Av x v fx Mighty Toys Purchasing Plan Cancel Al B D F G H 4 1 Mighty Toys Purchasing Plan Retail Price Gross Revenue Unit Cost Total Unit Cost Storage Cost per Unit Total Storage Cost Total Cost Profit 4 Blue Raider Urban Adventure Set 5 Super Action Kit Blue Raider Outdoor Set 7 Hiking Kit Number Purchased 1 1 1 0 Total 10 Constraints 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 20 27 28 29 30 31 32 33 34 35 36 7 38 39 40 42 43 Purchase Plan + Average: 0.75 Count: 19 Sum 3 4 J tv X W P MacBook Pro esc 80 OOO ODO st DIL >>