What is the minimum cost achieved

Assignment Help Operation Management

Reference no: EM131275589

Logan manufacturing wants to mix two fuels, A and B, for its trucks to minimize cost. It needs no fewer than 3000 gallons to run its trucks during the next month. It has a maximum fuel storage capacity of 4000 gallons. There are 2000 gallons of fuel A and 4000 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. Formulate and solve the problem using the Excel Solver. What is the minimum cost achieved? Response Feedback: The constraint on octane rating can be written as 90 A/(A+B) + 75 B / (A+B) >= 80 which after some algebra becomes 90 A + 75 B >= 80 A + 80 B, or further, 10 A - 5 B >= 0

Reference no: EM131275589

Questions Cloud

Demand for an organic item in whole foods market : The demand for an organic item in whole foods market store in montclair is constant at 10 units a week. The fixed order cost is $4.50 with no lead time. The holding cost equals to 15% of inventory value annually. The item cost $1.5 each and sell for ..

Expalin and of the plan do check act cycle : Expalin and of the Plan Do Check Act (PDCA) cycle and then explain how it would relate to an organization that has been given a new assignment that has never been done before? Also, what is the role of continous improvement in this system?

Branding for a restaurant : Describe the concept of a brand image, being sure to include the relationship between what the consumer sees or hears and consumer behavior. Provide your restaurant clients with TWO traits you believe should be part of their brand image, and explain ..

What is the minimum cost achieved : Logan manufacturing wants to mix two fuels, A and B, for its trucks to minimize cost. It needs no fewer than 3000 gallons to run its trucks during the next month. It has a maximum fuel storage capacity of 4000 gallons. There are 2000 gallons of fuel ..

Report the maximum value of the objective function : Formulate and use linear programming to solve the following problem. A firm wants to determine how many units of each of three products (products X, Y, and Z) they should produce in order to make the most money. Write the constraints and the objectiv..

How many truckloads of scraap should be purchased per day : HiTech Metal Company is developing a plan for buying scraap metal for its operations. HiTech receives scraapmetal from two sources, Hasbeen Industries, and Gentro Scraap, in daily shipments using large trucks. Each truckload of scraap from Hasbeen yi..

Quality principles emphasized at corporate level by digitex : The case presented six total quality principles emphasized at the corporate level by Digitex. Discuss how suppliers, through their performance, can impact each of these principles.?

Recommendation to implement particular product : In Assignments 2.1, 2.2, and 2.3, you will be building up a formal, researched justification report (one part at a time) that culminates in a recommendation to implement a particular product, service, or program in your place of employment. Describe ..

User Account

All Pages