Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Business Management Expert

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

a. prepare the equations expressing this information.

b. Solve the problem using the Excel Solver, giving the amount of each fuel to be used. State any assumptions necessary to solve the problem.

Business Management, Management Studies

  • Category:- Business Management
  • Reference No.:- M9104867

Have any Question?


Related Questions in Business Management

With respect to your use of the internet have you ever

With respect to your use of the Internet, have you ever taken a speculative risk? If yes, what was it? If no, would you ever consider taking it?

Like users computers in a domain will have an account

Like users, computers in a domain will have an account established for them. Their account can be seen in AD Users and Computers and viewed or modified there. What if you were going to add a new group of people in a new ...

Mentoring programs are an excellent way to stay on track

Mentoring programs are an excellent way to stay on track, understand that there is a plan and that you are not alone, as well as see the light at the end of the tunnel. But for many organizations, mentoring is not nearly ...

The organizational analysis will utilize a minimum of five

The organizational analysis will utilize a minimum of five external, What is the organization and how would you describe it? Who are the leaders of the organization? Is the organization successful? How do you determine w ...

Identifynbspthe central ethical issues involved in the

Identify the central ethical issues involved in the following case: Six years ago Diane Carlson and Dina Sawyer founded a not-for-profit organization called  Green Streams , which extracts recyclable materials from the w ...

Discuss the question of a common mortality that people of

Discuss the question of a common mortality that people of all nations could share. Is there one moral philosophy that seems to be applied across nations? If so which one and why? Not so, why? Share the individual standar ...

What are main forms or limitations of households to engage

What are main forms or limitations of households to engage in self insurance in a country

Swot analysis on a company you are or have worked for share

SWOT analysis on a company you are or have worked for. Share 2 strengths - 2 weaknesses - 2 opportunities - 2 threats.

Name a company that addressed a recent ethical problem in a

Name a company that addressed a recent ethical problem in a positive way. Also, explain how or if this positively affects us as a community?

A leasing firm operates on the assumption that the annual

A leasing firm operates on the assumption that the annual number of miles driven in its leased cars is normally distributed with mean 13,500 and standard deviation 4,000 miles. To see whether this assumption is valid, a ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As