For this week's assignment, build the model from Question 2 in last week's homeworking using Microsoft Excel and run it in Solver. In case you need it, I have copied and pasted Question 2 below! Did you get the same answer as you did by using the graphical solution?

Now imagine that Bronc-Dough is able to purchase another pound of flour for $3. Based on the sensitivity report, should they buy the flour?

Next, imagine that Bronc-Dough has invested in a significant R&D project to develop the recipe for a new product: a cinnamon roll! Each batch of cinnamon rolls will earn $4 in profit, takes 1 pound of flour, and 2 pounds of sugar! Re-run the model with the cinnamon roll added in as a product. Remember to add the cinnamon roll to your formulation. Does this addition change the model at all? Should Bronc-Dough begin making cinnamon rolls?

For the submission, please submit an Excel sheet with your models and a Word document with the question write-up!

1. You are working at Bronc-Dough, a bakery on campus. The bakery makes 3 products: Rolls, Donuts, and Bread. You are concerned with two products: flour and sugar, which go into each of these products. Products are sold as such: Rolls and Donuts are sold by the dozen (12). So, 1 unit of Donuts is actually a dozen donuts. Bread is sold by the loaf, so 1 unit of Bread, is 1 loaf of bread. Each dozen rolls will earn $6.00 in profit. Each dozen donuts will earn $8.00 in profit. Each loaf of bread will earn $3.00 in profit.
   1. Write the objective function for the bakery profit!
   2. Is this a maximization or minimization problem?
2. Now, imagine that we have 50 pounds of flour and 35 pounds of sugar available. Each dozen rolls uses 2 pounds of flour and 0.5 pounds of sugar. Each dozen donuts uses 1 pound of flour and 1.5 pounds of sugar. Each loaf of bread uses 1 pound of flour and 0.5 pounds of sugar.
   1. What are the constraints? Write them out in narrative form (in a sentence) first.
   2. Now, write the constraints in terms of math speak.
   3. Remember the non-negativity constraint!