do on LINDO program

3. LP formulation - Juice blending A company produce juice packages with three fruit juice concentrates; orange, banana and pineapple. The sugar content per gallon of three juices - orange, banana, and pineapple - is 10, 15, and 20 percent, respectively. The fiber content per gallon of three juices - orange, banana, and pineapple - is 13, 20, and 27 percent, respectively. For a good taste and health, the company wants to satisfy followings: Sugar content: at least 17 %, but at most 21 %. Fiber content: at least 3% Because of a recent banana inventory, banana content should be greater than 200 gallons in total juice production. Because of the purchasing cost, pineapple usage should be less than 500 gallons in total juice production. The cost per gallon is 50 cents for orange juice, 80 cents for banana juice, and 90 cents for pineapple juice. For next month demand, the company needs to produce 12,000 of juice packages. Each package needs 8 fl oz (= 0.0625 gallon) of mixed juice. Please formulate this problem as a LP to find the minimum cost while satisfying the sugar content, banana inventory, and demand requirement, and 12,000 juice packages production. a) Please formulate this problem as a LP. MUST define the decision variables first! Then, identify the objective function and constraints. b) Solve the problem using LINDO or Solver and attach the output using Courier New font. c) Explain your production plan, such as amount of each juice used and total cost. No handwriting for model and outputs! No grade for handwriting! 3. LP formulation - Juice blending A company produce juice packages with three fruit juice concentrates; orange, banana and pineapple. The sugar content per gallon of three juices - orange, banana, and pineapple - is 10, 15, and 20 percent, respectively. The fiber content per gallon of three juices - orange, banana, and pineapple - is 13, 20, and 27 percent, respectively. For a good taste and health, the company wants to satisfy followings: Sugar content: at least 17 %, but at most 21 %. Fiber content: at least 3% Because of a recent banana inventory, banana content should be greater than 200 gallons in total juice production. Because of the purchasing cost, pineapple usage should be less than 500 gallons in total juice production. The cost per gallon is 50 cents for orange juice, 80 cents for banana juice, and 90 cents for pineapple juice. For next month demand, the company needs to produce 12,000 of juice packages. Each package needs 8 fl oz (= 0.0625 gallon) of mixed juice. Please formulate this problem as a LP to find the minimum cost while satisfying the sugar content, banana inventory, and demand requirement, and 12,000 juice packages production. a) Please formulate this problem as a LP. MUST define the decision variables first! Then, identify the objective function and constraints. b) Solve the problem using LINDO or Solver and attach the output using Courier New font. c) Explain your production plan, such as amount of each juice used and total cost. No handwriting for model and outputs! No grade for handwriting