E Blending grapes in Wine . Range names used: Blend Plan ="3 (30 pts/1$B$15:$C$16 InputsAvail "3 (30 pts/$F$15 SF516 Inputsused -"3 (30 pts/$0$15 $0$18 A Ragd ='3 (30 pts/$8522 A Used "3 (30 pts/$$20 Revenue ''3 (30 pts/158525 B Regd ='3 (30 pts/$E$22 B Used "3 (30 pts)ISE$20 Wine 1 Wine 2 OX Selling prices Minimum grape A in Wine 1 Minimum grape Bin Wine 2 53% 45% Blonding plan (pounds of inputs into pounds of outputs) Wine 1 Wine 2 Used Available Grape A Grape B Total 0 0 0 0 Grape A constraint Grape constraint Actual Range Names have already been filled in. Required 3 4 A wine company sells two types (1 & 2) made up of grape A and grape B. There are only 7,300 pounds of grape A and 8,000 of grape B. Wine 1 sells for $230/case and wine 2 sells for $225/case. Wine 1 must have at least 53% of grape A and Wine 2 must have at least 45% of grape B Totalrever $0 27 a) Fill-in any missing input parameters. b) Determine the blend plan to maximize the total revenue. A formula for Total revenue is already provided in cell B25. State your answer here: E G Range names used: BlendPlan ='3 (30 pts/1$B$15-5C516 InputsAvail -3 (30 pts)+F515 $F$16 Inputs Used='3 (30 pts ISD$15.50$16 A Read -"3 (30 pts)158522 A Used ='3 (30 pts)158520 Revenue 3 (30 pts)158525 B Red *3 (30 pts)ISE522 B_Used ='3 (30 pts ISES20 Available B D 1 Blending grapes in Wine 2 3 4. 5 6 7 Wine 1 Wine 2 8 Selling prices 9 10 Minimum grape A in Wine 1 53% 11 Minimum grape B in Wine 2 45% 12 13 Blending plan (pounds of inputs into pounds of outputs) 14 Wine 1 Wine 2 Used 15 Grape A 0 0 16 Grape B 0 0 17 Total 18 19 Grape A constraint Grape B constraint 20 Actual 21 22 Required 23 24 25 Total revenue SO 26 27 28 29 30 31 32 33 34 35 36 Range Names have already been filled in. > A wine company sells two types (1 & 2) made up of grape A and grape B. There are only 7,300 pounds of grape A and 8,000 of grape B. Wine 1 sells for $230/case and wine 2 sells for $225/case. Wine 1 must have at least 53% of grape A and Wine 2 must have at least 45% of grape B a) Fill-in any missing input parameters. b) Determine the blend plan to maximize the total revenue. A formula for Total revenue is already provided in cell B25. State your answer here: Range Names have already been filled in. A wine company sells two types (1 & 2) made up of grape A and grape B. There are only 7,300 pounds of grape A and 8,000 of grape B. Wine 1 sells for $230/case and wine 2 sells for $225/case. Wine 1 must have at least 53% of grape A and Wine 2 must have at least 45% of grape B a) Fill-in any missing input parameters. b) Determine the blend plan to maximize the total revenue. A formula for Total revenue is already provided in cell B25. State your answer here: D F F G Range names used: BlendPlan ='3 (30 pts)758515 SCS16 InputsAvail =3 (30 pts)1SFS15: SFS16 Inputs Used="3 (30 pts)1$D$15.SDS16 A_Red =3 (30 pts)1$B$22 A Used =-3 (30 pts)|$B$20 Revenue -3 (30 pts)15B525 B_Red ='3 (30 pts)SE22 B_Used =3 (30 pts)ISES20 53% Used B 1 Blending grapes in Wine 2 3 4 5 6 7 Wine 1 Wine 2 8 Selling prices 9 10 Minimum grape A in Wine 1 11 Minimum grape B in Wine 2 45% 12 13 Blending plan (pounds of inputs into pounds of outputs) 14 Wine 1 Wine 2 15 Grape A 0 0 16 Grape B 0 0 17 Total 18 19 Grape A constraint Grape B constraint 20 Actual 21 22 Required 23 24 25 Total revenue $0 26 27 28 29 30 31 32 Available Range Names have already been filled in. > > A wine company sells two types (1 & 2) made up of grape A ar only 7,300 pounds of grape A and 8,000 of grape B. Wine 1 sel wine 2 sells for $225/case. Wine 1 must have at least 53% of must have at least 45% of grape B a) Fill-in any missing input parameters, b) Determine the blend plan to maximize the total revenue. A to revenue is already provided in cell B25. State your answer here
