AutoSave OFF Home Insert Draw Page Layout X Calibri (Body) 14 V B I U U Paste B2 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 Ready 8 9. C... Econ 3300 EP1 Summer '22-2 General == Delete Format 500-0000 Merge & Center $%9 Conditional Format Cell Formatting as Table Styles A B C D E F G H I J K Star Coffee sells three coffee blends (in 1-lb packages): Premium Cream, DeliSoft, and ValleyTaste. These blends are obtained by carefully mixing coffee beans imported from various countries, as presented below. For example, 1 lb of Premium Cream is the result of blending 70% Ethiopian and the remaining 30% Indonesian beans (no Colombian or Brazilian beans). Due to contracts with suppliers, minimum monthly bean consumptions must be satisfied. Due to logistics/capacity, monthly bean consumptions cannot exceed maximum monthly amounts as given below. For example, monthlly consumption of Ethipian beans must be at least 200 lb but no more than 1000 lb. Minumum Consumption PremiumCream 1 lb DeliSoft 1 lb ValleyTaste 1 lb Maximum Consumption lb lb Ethiopian beans 0.7 0.3 1000 Indonesian beans 0.3 0.2 2000 Colombian beans 0.3 0.8 1000 Brazilian beans 0.2 0.2 3000 Profit contributions are given below. For example, 1 lb of Premium Cream generates a profit of $3.50 PremiumCream ($/lb) DeliSoft ($/lb) ValleyTaste ($/lb) Profit contribution 3.5 2.8 2.5 The marketing department estimates demand for these blends should not exceed the quantities provided below. PremiumCream DeliSoft Valley Taste Questions + X fx Formulas Data Review V = = = V A View Tell me ab Wrap Text 200 100 400 100 W SL Insert B M a of Share Comments APO 1 M Sort & Find & Analyze Filter Select Data L M 150% AutoSave OFF 8 9. C... Home Insert Draw Page Layout Formulas Data Review View Tell me X 11 == V ab Wrap Text (6 Calibri (Body) BIU A V g fx Paste L13 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 Ready A Questions + Econ 3300 EP1 Summer '22-2 General $ % 9 V F B == Delete Format Merge & Center 500-0000 Conditional Format Cell Formatting as Table Styles C D E G H I J K PremiumCream (lb/month) DeliSoft (lb/month) 1500 2500 Valley Taste (lb/month) 2000 Demand How many pounds of PremiumCream, DeliSoft, and ValleyTaste should Star Coffee produce every month in order to maximize total profit? Assume the variables are continuous. Formulate the problem below (obtain the mathematematical model) 1.1 points Subject To: 0.2 points 0.2 points 0.2 points 0.2 points 0.2 points 0.2 points 0.2 points 0.2 points 0.5 points 0.5 points 0.5 points Total points formulatio a of Share Comments APO O M Sort & Find & Analyze Filter Select Data L M