Question: a. Formulate an LP model for this problem b. Create a spreadsheet model for this problem and solve it using Solver Blacktop Refining extracts minerals

a. Formulate an LP model for this problem b.

a. Formulate an LP model for this problem

b. Create a spreadsheet model for this problem and solve it using Solver

Blacktop Refining extracts minerals from ore mined at two different sites in Montana. Each ton of ore type 1 contains 20% copper, 20% zinc, and 15% magnesium. Each ton of ore type 2 contains 30% copper, 25% zinc, and 10% magnesium. Ore type 1 costs $90 per ton while ore type 2 costs $120 per ton. Blacktop would like to buy enough ore to extract at least 8 tons of copper, 6 tons of zinc, and 5 tons of magnesium in the least costly manner

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!

Develop a LP and spreadsheet model for Problem 2 3 at the end of Chapter 3 in the Ragsdale portion of your book. What is the minimum transportation cost if the rental car company optimizes shipments...

For every problem: Set up the model in Excel, use Solver to determine the optimal solution. Answer any other questions that are asked Problem1 Problem2 problem 3 A furniture manufacturer produces two...

\"4;qu run lAlVALulI 21. Valu-Com Electronics manufactures ve different models of telecommunications interface cards for PCs and laptops. As smnmarized in the following table, each of these devices...

I cannot figure out the formulas for Cells H6,H7,H8,H9,H10 My Formula for Cell F19 is =SUMPRODUCT(C6:G10,C13:G17) 25. The Shop at Home Network sells various household goods during live television...

5550 per month, and three-DEUTUIT each type should the developer include in the bu l ans in order to m e the potential rental income from the building? a Formulate an LP model for this problem. b....

8. The Rent-A-Dent car rental company allows its customers to pick up a rental car at one location and return it to any of its locations. Currently, two locations ( 1 and 2) have 16 and 18 surplus...

I have created the spreadsheet and have the following functions, just not sure if the value I got for the total investment is correct: Minimize A1 + B1 + C1 + D1 Subject to: 1.06A1-1A2 = 0 (year 2...

Josh Steele manages a professional choir in a major city. His marketing plan is focused on generating additional local demand for concerts and increasing ticket revenue and also gaining attention at...

Questions and Problems 123 The maintenance supervisor wants to determine the minimum number of employees to schedule that meets the minimum staffing requirements. a. Formulate an LP model for this...

Could you slove this using Python instead of Excel Please, thank you. 31. Virginia Tech operates its own power generating plant. The electricity generated by this plant supplies power to the...

Steritech Co., a furniture wholesaler, sells merchandise to Butler Co. on account, $86,000, terms 2/10, n/30. The cost of the merchandise sold is $51,600. Steritech Co. issues a credit memorandum for...

Which of the following best explains how recessionary gaps in the economy are fixed by self-adjustment in the long run? The decrease in wages will increase the short-run aggregate supply and increase...

4. How does accounting help in the capital allocation process?

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...