IF YOU COPY ANOTHER CHEGG ANSWER TO THIS QUESTION I WILL GIVE YOU A THUMBS DOWN.

Windy City Bakery makes three popular cakes: Cake 1, Cake 2, and Cake 3 . Windy City Bakery has four bakers, Baker A, Baker B, Baker C, and Baker D. Baker A can make only Cakes 1 and 3. Baker B can make only Cakes 1 and 2. Baker C can make only Cake 3. Baker D can only make Cake 2. After carefully analyzing the bakers' available hours and the cakes they make, Windy City Bakery determined: 1. Each baker's hours per month that would be available to make these cakes, 2. The time (in hours) each baker needs to make a cake, and 3. The unit profit for each cake. This information is summarized in the table below. Thus, for example, baker A needs two hours to make Cake 1 and three hours to make Cake 3. Baker A cannot make Cake 2. Similarly, baker B needs 2.5 hours to make Cake 1 and three hours to make Cake 2. Baker B cannot make Cake 3 , etc. The unit profit from each cake is as follows: Cake 1,$6; Cake 2, $7; and Cake 3 , $10. Based on past experiences, in a month, Windy City Bakery can sell up to 80 units of Cake 1, 50 units of Cake 2, and 50 units of Cake 3. Each baker can work up to 120 hours per month. Additionally, due to the nature of the cakes, a fractional number of units would not be made. For example, Windy City Bakery would not make 1.5 units of any cake. Windy City Bakery makes three popular cakes: Cake 1 , Cake 2, and Cake 3 . Windy City Bakery has four bakers, Baker A, Baker B, Baker C, and Baker D. Baker A can make only Cakes 1 and 3. Baker B can make only Cakes 1 and 2. Baker C can make only Cake 3. Baker D can only make Cake 2 . After carefully analyzing the bakers' available hours and the cakes they make, Windy City Bakery determined: 1. Each baker's hours per month that would be available to make these cakes, 2. The time (in hours) each baker needs to make a cake, and 3. The unit profit for each cake. This information is summarized in the table below. Thus, for example, baker A needs two hours to make Cake 1 and three hours to make Cake 3 . Baker A cannot make Cake 2. Similarly, baker B needs 2.5 hours to make Cake 1 and three hours to make Cake 2. Baker B cannot make Cake 3, etc. The unit profit from each cake is as follows: Cake 1,$6; Cake 2,$7; and Cake 3 , $10. Based on past experiences, in a month, Windy City Bakery can sell up to 80 units of Cake 1, 50 units of Cake 2, and 50 units of Cake 3. Each baker can work up to 120 hours per month. Additionally, due to the nature of the cakes, a fractional number of units would not be made. For example, Windy City Bakery would not make 1.5 units of any cake. - The Windy City Bakery would like to maximize its profit from baking and selling those cakes. Your tasks are to formulate the problem so that it can be solved by Solver. Thus, you need to: 1. Specify and formulate the Changing Cells (you may prefer to use yellow highlight to indicate the changing cells) 2. Specify and formulate the Objective Function cell (you may prefer to use a light blue highlight to indicate the objective cell) 3. Specify and formulate the Constraints. 4. Solve this problem with the Excel Solver and determine what is the maximum profit per month and how many units of Cakes 1,2 , and 3 that must be made by each baker per month in order to maximize the profit per month. Note: If a baker cannot make that particular cake, in the Solver window, you can add a constraint for that cell to be zero (like we did for the tutor example in class - this is equivalent to a tutor not being able to help for a certain class)