Problem A$-6($Algo$)$

Logan Manufacturing wants to mix two fuels, A and B$,$ for its trucks to minimize cost. It needs no fewer than $3,300$ gallons to run its trucks during the next month. It has a maximum fuel storage capacity of $4,500$ gallons. There are $1,700$ gallons of fuel A and $4,000$ gallons of fuel B available. The mixed fuel must have an octane rating of no less than $65.$

When fuels are mixed, the amount of fuel obtained is just equal to the sum of the amounts put in$.$ The octane rating is the weighted average of the individual octanes, weighted in proportion to the respective volumes.

The following is known: Fuel A has an octane of $85$ and costs $$0\mathrm{.}70$ per gallon. Fuel B has an octane of $57$ and costs $$0\mathrm{.}80$ per gallon.

a$.$ Write the equations expressing this information. $($Leave no cells blank $-$ be certain to enter $"0"$ wherever required. Negative answers should be indicated by a minus sign. Round your answers to $2$ decimal places.$)$Fuel demand A $+$ B $>=$

Storage A $+$ B $<=$

Fuel A available A $+$ B $<=$

Fuel B available A $+$ B $<=$

Blend A $+$ B $>=$

A$,$B $>=$

s$.$t

b$.$ Solve the problem using the Excel Solver, giving the amount of each fuel to be used. $($Round your answers to the nearest whole number.$)$