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 Tyler needs to produce batches of Cookies and batches of Breads to achieve a maximized revenue of $ If the revenue from Cookies was reduced to $10 instead of $15, Tyler would need to produce batches of Cookies and batches of Breads to achieve a maximized revenue of $

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Question

100%

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

Tyler needs to produce batches of Cookies and batches of Breads to achieve a maximized revenue of $
If the revenue from Cookies was reduced to $10 instead of $15, Tyler would need to produce batches of Cookies and batches of Breads to achieve a maximized revenue of $

Expert Solution