Manufacturing wants to mix two fuels

Assignment Help Operation Management

Reference no: EM131229213

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

Reference no: EM131229213

Questions Cloud

Explain how you believe these types of clients will benefit : Research screening tools and therapeutic interventions that are relevant to clients with particular characteristics such as gender, age, disabilities, culture, and physical handicaps.

Functions that a household automatic dishwasher : State the functions that a household automatic dishwasher performs during its operation cycle. For each function, indicate the primary medium (signals, data, material, or energy) involved. Describe the physical elements involved in the implementa..

Inventory of a store-predicting future grade of class : Create a Simulation in Excel and can chose any topic. Few Examples are: Tossing of a Coin, Inventory of a store, Predicting future grade of class based on current performance etc.

What resources should grueber ask for : What resources should Grueber ask for? What are the biggest challenges for IR? How would you position the function to handle those challenges? How do you see these issues relating to empowerment?

Manufacturing wants to mix two fuels : 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 f..

Should the states take a more active role in emergency : Should the states take a more active role in emergency management at the local level? Do you feel there is anything that the states could do to improve local capacities without infringing on their jurisdictional rights?

What type and degree of social influence may be impacting : What type and degree of social influence may be impacting this reported lack of understanding and awareness of sexual assault as a crime? What steps would you recommend, or endorse if they are already in place, as necessary to address this situati..

Studying level 2 business administration : Highschool student (grade 12) studying level 2 business administration Wish to present in an instructional booklet for my employees (max word 1,600) Topic autumn semester: organise workplace information explainon how to collect, organise and distrib..

Each of the products using an appropriate naive method : Predict orders for the following day for each of the products using an appropriate naïve method. Blueberry Muffin: the basic naïve forecast is: 58 Cinnamon Buns: the basic naïve forecast is: trend-adjusted naïve forecast is: ? Cupcakes: the seasonal-..

User Account

All Pages