Question

When Marie McCoy woke up Saturday morning, she remembered that she promised the PTA she would make some cakes and/or homemade bread for its bake sale that afternoon. However, she does not have time to go to the store to get ingredients, and she has only a short time to bake things in her oven. Because cakes and breads required different baking temperatures, she cannot bake them simultaneously, and she has only 3 hours available to bake. A cake requires 3 cups of flour, and a loaf of bread requires 8 cups; Marie has 20 cups of flour. A cake requires 45 minutes to bake, and a loaf of bread requires 30 minutes. The PTA will sell a cake for $10 and a loaf of bread for $6. Marie wants to decide how many cakes and loaves of bread she should make.Formulate a linear programming model for this problem just like was presented in class.Solve this model by using Solver. Set up Solver just like was presented in class.Show all steps of Excel Work and Formulas. Thanks.

Answer 1

see explaination

Explanation:

Let x cakes & y losf of bread that Marie decides to make,

Now the constraints are:

3x + 8y <= 20

45x + 30y <= 180 or 3x + 2y <= 12

x >= 0

and y >= 0

THe PTA's revenue function that needs to be maximixed is :

Z(x,y) = 10x + 6y

see attachment