Your bakery makes a variety of products: cookies, cupcakes, muffins, and donuts. You want to maximize your profit by optimizing the mix of products you make. You cannot use any more materials or labor than is available, nor do you want to make more goods than the amount that is demanded because the excess would go to waste. You only make batches of a complete dozen, so make sure the changing cells are integers. Use Solver to calculate the optimal number of dozens of product to make. Produced in dozens Demand in dozens Price/Dozen Cost/Dozen Profit/Dozen Materials used per dozen Flour Sugar Eggs Butter Chocolate Chips Labor Hours Flour Sugar Eggs Butter Chocolate Chips Labor Hours Profit Cookies 50 600 $2.50 $1.80 $0.70 0.5 0.3 0.4 0.2 0.5 0.5 50 95 Cupcakes Muffins Donuts 50 50 50 500 400 300 $312.50 $3.25 $1.50 $1.75 Used Available 337.5 2000 105 500 11 220 1200 50 500 600 800 1.25 0.75 1 0.3 0 0.4 $3.50 $2.00 $1.50 1.75 0.3 1 0.25 0.5 0.4 $5.00 $2.70 $2.30 3.25 0.75 2 0.25 0 0.6