VBA/Microsoft Excel BLENDING PROBLEM

Case Study 3 lending Problem Blending Problem Problem Description A refinery produces three types of gasoline, A. B and C, which are blends of three crude number, cost, and avalabilty. gasoline (inal products) and crude all (ingredients) for the cument be the following: (a) The cument production cost of gasolne (b)The production capacity of the refinery 14.000 barrels: (c) It estmated that f we spend $1 on advertising each type of gas, demand will increase by 10 bamelsday. The following Is the blending rule for this product: If we take 2, 3) and pour fal together, then the surfur percentage ofthe blend as follows: a similar way. Below we present a mathematical formulation of this problem: Suoject to: i-1.2.3 j -1,2,3 j-1,23 SC j -1,2,3 j -1,2,3 20 i, j -1.23 presents the number of barrels of crude u purchased p, Presents the Price paid per bamel of crude t g Presents the number of barrels of gar JProduced: g, presents the price per bame orgass f: presents the un production cost d the demand for gas presents the n umber of barrels of crude Iused to produce gas a presents the dollars spent an advertis gas o: the Increase in demand presents for each dolar spend in advertsng: O: presents the octane number of gas su Case Study 3 lending Problem Blending Problem Problem Description A refinery produces three types of gasoline, A. B and C, which are blends of three crude number, cost, and avalabilty. gasoline (inal products) and crude all (ingredients) for the cument be the following: (a) The cument production cost of gasolne (b)The production capacity of the refinery 14.000 barrels: (c) It estmated that f we spend $1 on advertising each type of gas, demand will increase by 10 bamelsday. The following Is the blending rule for this product: If we take 2, 3) and pour fal together, then the surfur percentage ofthe blend as follows: a similar way. Below we present a mathematical formulation of this problem: Suoject to: i-1.2.3 j -1,2,3 j-1,23 SC j -1,2,3 j -1,2,3 20 i, j -1.23 presents the number of barrels of crude u purchased p, Presents the Price paid per bamel of crude t g Presents the number of barrels of gar JProduced: g, presents the price per bame orgass f: presents the un production cost d the demand for gas presents the n umber of barrels of crude Iused to produce gas a presents the dollars spent an advertis gas o: the Increase in demand presents for each dolar spend in advertsng: O: presents the octane number of gas su