Excel

c Using SOLVER (MANUALLY GRADED) D Formula: Applyin Excel' s Solver to maximize profit in a product mi x. 4 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 PROBLEM be earned by purchasing (for sale) Sho-Biz Novelty Company plans to maximize the profit to required for storage (as shown in the table below) . Student Work Area a mix of three specific products with respective costs and space Required. Apply SOLVER to the table shown to determine the mix of products that will yield maximum profit. (Formulas and range names have already been set. ) Sho-Biz Novelti Item Profit Balloons Hand Buzzers Funny Forks Resources 4.50 3.15 3.14 Available Used Cost per 10 10.00 12.50 7.90 1,500 Slots Used 2.00 0.75 1.00 100 ORDER Profit: Answer Field 33.4% of your score. use Excel's SOLVER feature to determine the mix of products that will yield maximum profit.