Using the Solver, find the solution and answer the questions given below the LP
Chapter 8. Tyler bakes Cookies (C) and Breads (B) with the help of two ovens in his little bakery. The time taken by Oven A to bake each cookie batch is 14 minutes and the time taken by Oven B is 12 minutes. The time taken by Oven A to bake a batch of bread is 16 minutes and the time taken by Oven B is 17 minutes. Each week Oven A can be used for 28 hours, and Oven B can be used for 25 hours to bake Cookies and Breads. The rest of the time is used for baking other products. Moreover, Tyler starts the next week with a stock of 20 batches of Cookies and 20 batches of Breads. There is a weekly demand of 70 batches of Cookies and 35 batches of Breads. For each batch of Cookies, Tyler makes $15 in revenue and for each batch of Breads Tyler makes $20 in revenue. How should Tyler plan his production to maximize his revenue while meeting his weekly demand and adding to his stock for the following week? To help you guys out, I am giving you the Linear Program equations here. Using the Solver, find the solution and answer the questions given below the LP.
Objective: Maximize Revenue 15C + 20B
s.t. constraints:
-
-
-
- Oven A available: 14C + 16B <= 1680 minutes
- Oven B available: 12C + 17B <= 1500 minutes
- Min Cookies required: C >= 70– 20 (weekly demand – stock available)
- Breads required: B >= 35 – 20 (weekly demand – stock available)
- Non-negativity: C, B >= 0
- Integer: C, B are both integers
-
-
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 6 images