1. A small wine group owns two wineries. Winery 1 costs $ 25,000 per day to operate and it can produce 300 barrels of high-quality grape wine, 200 barrels of medium-quality grape wine, and 150 barrels of low-quality grape wine. Winery 2 is just recent with modern technology for wine processing. It costs $30,000 per day to operate, and it can produce 300 barrels of high-quality grape wine, 250 barrels of medium-quality grape wine, and 400 barrels of low-quality grape wine. The company has orders totaling 35,000 barrels of high-quality grape wine, 30,000 barrels of medium-quality grape wine, and 40,000 barrels of low- quality grape wine. How many days should the company run each winery to minimize the costs and still meets its orders?

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...
icon
Related questions
Question
100%
Help me answer in full details thank you
1. A small wine group owns two wineries. Winery 1 costs $ 25,000 per day to
operate and it can produce 300 barrels of high-quality grape wine, 200 barrels of
medium-quality grape wine, and 150 barrels of low-quality grape wine. Winery
2 is just recent with modern technology for wine processing. It costs $30,000
per day to operate, and it can produce 300 barrels of high-quality grape wine,
250 barrels of medium-quality grape wine, and 400 barrels of low-quality grape
wine. The company has orders totaling 35,000 barrels of high-quality grape
wine, 30,000 barrels of medium-quality grape wine, and 40,000 barrels of low-
quality grape wine. How many days should the company run each winery to
minimize the costs and still meets its orders?
Transcribed Image Text:1. A small wine group owns two wineries. Winery 1 costs $ 25,000 per day to operate and it can produce 300 barrels of high-quality grape wine, 200 barrels of medium-quality grape wine, and 150 barrels of low-quality grape wine. Winery 2 is just recent with modern technology for wine processing. It costs $30,000 per day to operate, and it can produce 300 barrels of high-quality grape wine, 250 barrels of medium-quality grape wine, and 400 barrels of low-quality grape wine. The company has orders totaling 35,000 barrels of high-quality grape wine, 30,000 barrels of medium-quality grape wine, and 40,000 barrels of low- quality grape wine. How many days should the company run each winery to minimize the costs and still meets its orders?
Expert Solution
steps

Step by step

Solved in 2 steps with 4 images

Blurred answer
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,