Decision Variables: Let, Xij be the quantity of crude oil (in barrels) purchased from source i refined at refinery j. Similarly, let Ykl represent the quantity of refined products (gasoline or distillate) shipped from refinery k to market l - X11: Quantity of Brunei crude oil purchased and refined in Australia. - X12: Quantity of Brunei crude oil purchased and refined in Japan. - X21: Quantity of Iranian crude oil purchased and refined in Australia. - X22: Quantity of Iranian crude oil purchased and refined in Japan. - Y13: Quantity of gasoline shipped from Australia to Taipei. - Y14: Quantity of gasoline shipped from Australia to Manila. - Y23: Quantity of gasoline shipped from Japan to Taipei. - Y24: Quantity of gasoline shipped from Japan to Manila. - Y33: Quantity of distillate shipped from Australia to Taipei. - Y34: Quantity of distillate shipped from Australia to Manila. - Y43: Quantity of distillate shipped from Japan to Taipei. - Y44: Quantity of distillate shipped from Japan to Manila. Objective Function: Minimize cost (Z)= 47X1+ 42X11+ 8X22+ 7X12+ 4.5Y13+ 4.5Y23+ 4.5Y33+ 4.5Y43+8Y24 +8Y34+8Y44+5Y13+13Y23+34Y33+34Y43+5Y11+13Y21+3Y12+3Y22 Constraints Crude oil availability: X11+X21<=275000 X12+X22<=300000 Refinery capacity: X11+X12<= 350000 (Australia) X21+X22<= 275000 (Japan) Market demand: Y12+Y14+Y11<= 70000 (Gasoline Demand in Sydney) Y23+Y24+Y21<=35000 (Gasoline demand in Nagoya) Y33+Y34+Y12<= 45000 (Distillate demand in Taipei) Y43+Y44+Y22<= 50000 ((Distillate demand in Manila) Y13+Y23<= 150000 (Distillate demand in Sydney) Y33+Y43<= 70000 (Distillate demand in Nagoya) Product Yields Constraint 0.410X11+ 0.295X21= Y13+Y23 (Gasoline From Brunei) 0.523X11+ 0.645X21= Y33+ Y43 (Distillate from Brunei) 0.410X12+0.295X22= Y14+Y24 ( Gasoline from Iran) 0.523X12+ 0.645X22= Y34+Y44 (Distillate from Iran) International Shipping Prohibition Y13+Y14+Y23+Y24+Y11+Y21+Y12+Y22=0 Non- Negative Constraints Xij, Ykl >= 0 Assumption : The demand for Australia and Japan is not explicitly stated in the given information, so we can assume that these locations do not have demand for gasoline and distillate products Provide answer using excel solve in also provide the excel sheet with answer report and sensitivity report