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 any more than demanded because they would go to waste. We are only going to make batches of a complete dozen, so be sure to make sure the changing cells are integers. Use Solver to calculate the optimal number of dozens of product to make.

Please use/include excel formulas.