Algoma Northern Delivery Service ( ANDS) wants to blend two gasolines (R and S) for use in its trucksFor the upcoming period, at least 10,000 gallons are required. ANDS has a local 20,000-gallon storage facilityAny required quantities of R and gasoline may be purchased from a local Sault Ste. Marie refinery and mixed. R is 87 octane and costs $0.90 a gallon. is 93 octane and costs $1.20 per gallon. ANDS's fleet of 100 trucks requires an octane of no less than 89. Octane of the mixed output is linearly proportional to input octaneFor example, equal parts of R and S would yield a 90-octane output. There is no gasoline loss in the blending process . Required : Formulate a linear programming model for this problem

AND please solve on EXCEL spreet sheet