Question: Problem A-6 (Static) Logan Manufacturing wants to mix two fuels, A and B for its trucks to minimize cost. It needs no fewer than 3,000

Problem A-6 (Static) Logan Manufacturing wants to mix two fuels, A and B for its trucks to minimize cost. It needs no fewer than 3,000 gallons to run its trucks during the next month. It has a maximum fuel storage capacity of 4.000 gallons. There are 2,000 gallons of fuel A and 4,000 gallons of fuel Bavailable. The mixed fuel must have an octane rating of no less than 80, 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 90 and costs $1.20 per gallon Fuel B has an octane of 75 and costs $0.90 per gallon o. 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.) B s.t Fuel demand A B NM A B Storage Fuel A available Fuel B available + + + + B s B Blend A + B 2 , 0 b. Solve the problem using the Excel Solver, giving the amount of each fuel to be used. (Leave no cells blank - be certain to enter "0" wherever required. Round your answers to the nearest whole number.) Decision for A Decision for B Total cost Decision for A Decision for B Total cost Resources Used Demand Storage Fuel A Fuel B Blend

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Part U67 is used in one of Broce Corporation's products. The company's Accounting Department reports the following costs of producing the 15,900 units of the part that are needed every year. Per Unit...

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,400 gallons to run its trucks during the next month. It has a maximum...

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...

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,900 gallons to run its trucks during the next month. It has a maximum...

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,400 gallons to run its trucks during the next month. It has a...

1. Logan manufacturing wants to mix two fuels, A and B, for its trucks to minimize cost. It needs no fewer than 150 gallons to run its trucks during the next month. It has a maximum fuel storage...

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...

5 Logan Manufacturing wants to mix two fuels, A and B, for its trucks to minimize cost. It needs no fewer than 3.400 gallons to run its trucks during the next month. It has a maximum fuel storage...

What is the source of the field work and reporting standards for an audit of ICFR?

5 Write a detailed Note on Micro-finance Institution Ordinance 2001.(country Pakistan).

The all - inclusive concept provides stakeholders with a more comprehensive view of a company s profitability, while also separates the unusual items to reduce the impact of volatility.

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...