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 both Ovens can be used for 50 hours each to bake Cookies and Breads. The rest of the time is used for baking other products. Moreover, Tyler starts each week with a stock of 25 batches of Cookies and 30 batches of Breads because the Cookies and Breads he produces can be considered to be “fresh” for a maximum of 2 weeks. There is an average weekly demand of 70 batches of Cookies and 50 batches of Breads. For each batch of Cookies, Tyler makes $30 in profit and for each batch of Breads Tyler makes $25 in profit. If there are any “close to losing freshness” goods at the end of the week, Tyler sells them at heavily discounted prices on weekends with a profit of $5 per batch of Cookies and $4.50 per batch of Breads. How should Tyler plan his production to maximize his profits 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. LINEAR PROGRAM EQUATIONS: Objective: Maximize Profit 30*70 + 25*50 + 5*(C-70-25) + 4.5*(B-50-30) s.t. constraints: Oven A available: 14C + 16B <= 50*60 minutes Oven B available: 12C + 17B <= 50*60 minutes Min Cookies required: C >= 70 + 25 (weekly demand + stock for following week) Breads required: B >= 50 + 30 (weekly demand + stock for following week) Non-negativity: C, B >= 0 Integer: C, B are both integers
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 both Ovens can be used for 50 hours each to bake Cookies and Breads. The rest of the time is used for baking other products. Moreover, Tyler starts each week with a stock of 25 batches of Cookies and 30 batches of Breads because the Cookies and Breads he produces can be considered to be “fresh” for a maximum of 2 weeks. There is an average weekly demand of 70 batches of Cookies and 50 batches of Breads. For each batch of Cookies, Tyler makes $30 in profit and for each batch of Breads Tyler makes $25 in profit. If there are any “close to losing freshness” goods at the end of the week, Tyler sells them at heavily discounted prices on weekends with a profit of $5 per batch of Cookies and $4.50 per batch of Breads. How should Tyler plan his production to maximize his profits 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.
LINEAR PROGRAM EQUATIONS:
Objective: Maximize Profit 30*70 + 25*50 + 5*(C-70-25) + 4.5*(B-50-30)
s.t. constraints:
- Oven A available: 14C + 16B <= 50*60 minutes
- Oven B available: 12C + 17B <= 50*60 minutes
- Min Cookies required: C >= 70 + 25 (weekly demand + stock for following week)
- Breads required: B >= 50 + 30 (weekly demand + stock for following week)
- Non-negativity: C, B >= 0
- Integer: C, B are both integers
Step by step
Solved in 2 steps with 3 images