any help on solving this problem would be appreciated.

82. C Econ 3300 EP1 Summer '22.xlsx - Read-Only Draw Page Layout Formulas Data Review View ? Tell me Calibri (Body) 11 == V ab Wrap Text General 1.7.5. BIU U V A Merge & Center $ % 9 V .00 .0 Conditional Format Cell Formatting as Table Styles x fx A B D E F G H I K Star Coffee sells three coffee blends (in 1-lb packages): PremiumCream, DeliSoft, and ValleyTaste. These blends are obtained by carefully mixing coffee beans imported from various countries, as presented below. For example, 1 lb of PremiumCream 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. 4 5 Minumum Consumption 6 PremiumCream 1 lb DeliSoft 1 lb ValleyTaste 1 lb Maximum Consumption lb 7 lb 8 Ethiopian beans 0.7 0.3 1000 9 Indonesian beans 0.3 0.2 2000 10 Colombian beans 0.3 0.8 1000 11 Brazilian beans 0.2 0.2 3000 12 Profit contributions are given below. For example, 1 lb of PremiumCream generates a profit of $3.50 13 14 15 PremiumCream ($/lb) DeliSoft ($/lb) Valley Taste ($/lb) 16 17 Profit contribution 3.5 2.8 2.5 18 The marketing department estimates demand for these blends should not exceed the quantities provided below. 19 20 21 PremiumCream (lb/month) 22 DeliSoft (lb/month) 1500 ValleyTaste (lb/month) 2000 23 Demand 2500 24 25 26 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) 27 28 29 30 1.1 points 31 AutoSave OFF Home Insert X Paste K16 Ready Questions + 200 100 400 100 .00