Reference no: EM132476843

Problem 1: 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.

                                                                           Cookies                 Cupcakes     Muffins            Donuts

Produced in dozens	50	50	50	50
Demand in dozens	600	500	400	300
Price/Dozen	$2.50	$3.25	$3.50	$5.00
Cost/Dozen	$1.80	$1.50	$2.00	$2.70
Profit/Dozen	$0.70	$1.75	$1.50	$2.30

Materials used per dozen
Flour		0.5	1.25		1.75	3.25
Sugar		0.3	0.75		0.3	0.75
Eggs		0.4	1		1	2
Butter		0.2	0.3		0.25	0.25
Chocolate Chips		0.5	0		0.5	0
Labor Hours		0.5	0.4		0.4	0.6
		Used	Available
Flour	337.5			2000
Sugar	105			500
Eggs	220			1200
Butter	50			500
Chocolate Chips	50			600
Labor Hours	95			800
Profit	$312.50