Question: Please show formula so I can learn how this is done. Your bakery makes a variety of products: cookies, cupcakes muffins, and donuts. You want

Please show formula so I can learn how this is done.
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. 12 13 14 Cookies Cupcakes Muffins Donuts 50 50 Produced in dozens Demand in dozens 50 50 600500 400 300 16 17 18 Price/Dozen CostDozen Profit/Dozen $2.50 $3.25$3.50 $5.00 $180$1.50$2.00 $2.70 $0.70.: $1.75: $1.50--$230 20 21 Materials used per dozen Flour Sugar Eggs Butter Chocolate Chips Labor Hours 0.5 0.3 0.4 02 0.5 0.5 1.25 0.75 1.75 3.25 0.3 23 24 25 26 0.75 2 0.25 0.3 0 0.4 0.25 0.5 0.4 0.6 28 29 30 Used Available Flour Sugar Eggs Butter Chocolate Chips Labor Hours 337 5 2000 600 105 32 220 1200 50 50 500 600 95800 35 37 Profit $312 50
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
