Question: Find integer problem Problem # 1_Integer Problem 11,OU. The GM of the winery wants to find out the optim number of each table wine to

Find integer problem
Find integer problem Problem # 1_Integer Problem 11,OU. The GM of the

Problem # 1_Integer Problem 11,OU. The GM of the winery wants to find out the optim number of each table wine to produce. The Kelowna Premium Winery produces three kinds of table wine - a blush, a white A. Formulate and solve an integer programming model for this problem. Named the and a red, all made from grapes. The winery has 30,000 pounds of grapes available to sheet as #1A. ( 7 points) produce wine for this year 2020. A cask of blush requires 360 pounds of grapes, a cask B. Copy Sheet 1A and add the constraint below to your solver. Named the sheet as of white requires 375 pounds and a cask of red requires 410 pounds. The winery has #1B. 9:55 PM enough storage space for 100 casks of wine. The winery has 1500 hours of production capacity, and it requires 14 hours to produce a cask of blush, 10 hours to produce a cask For profit purposes and from historical records, the winery target that the of white and 18 hours to produce a cask of red. sales of Red will be at least 30% of the total sales, blush will be at least 50% and The profit for a cask of blush is $12,400, the profit for a cask of white is $9,300, and white will be 20%. Named the sheet as #1B. (3 points) the profit for a cask of red $ 11,00. The GM of the winery wants to find out the optimum C. Copy Sheet 1B and add the constraint below to your solver. Named the sheet as number of each table wine to produce. #1C. A. Formulate and solve an integer programming model for this problem. Named the The winery has a contract that guarantees its buyers 32 cask of blush, 12 sheet as #1A. ( 7 points) cask of white and 18 cask of red. (2 points) G B. Copy Sheet 1A and add the constraint below to your solver. Named the sheet as D (Curl)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!