Please provide the Excel formulas for the below A F 3 4 5 D E 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. 6 7 8 9 10 11 12 13 14 15 Produced in dozens Demand in dozens Cookies 125 600 Cupcakes Muffins 163 400 500 400 Donuts 293 300 16 17 18 19 20 21 22 Price/Dozen Cost/Dozen ProfitDozen $2.50 $1.80 $0.70 $3.25 $1.50 $1.75 $3.50 $2.00 $1.50 $5.00 $2.70 $2.30 1.75 3.25 1.25 0.75 23 ooo 0.3 0.75 Materials used per dozen Flour Sugar Eggs Butter Chocolate Chips Labor Hours 1 2 0.5 0.3 0.4 0.2 0.5 0.5 24 25 26 27 1 0.3 0.25 ano NA 0 0.4 0.25 0.5 0.4 0 0.6 28 29 30 31 32 33 34 35 36 37 38 Flour Sugar Eggs Butter Chocolate Chips Labor Hours Used 1920 500 1200 247 262 464 17 Available 2000 500 1200 500 600 800 Profit $1,648.00