Question

In: Advanced Math

EXCEL SOLVER: A gold processor has two sources of gold ore, source A and source B....

EXCEL SOLVER: A gold processor has two sources of gold ore, source A and source B. In order to keep his plant running, at least three tons of ore must be processed each day. Ore from source A costs $20 per ton to process, and ore from source B costs $10 per ton to process. Costs must be kept to less than $80 per day. Moreover, Federal Regulations require that the amount of ore from source B cannot exceed twice the amount of ore from source A. If ore from source A yields 2 oz. of gold per ton, and ore from source B yields 3 oz. of gold per ton, how many tons of ore from both sources must be processed each day to maximize the amount of gold extracted subject to the above constraints? NEED TO ANSWER IN EXCEL SOLVER NEED HELP PLEASE

Solutions

Expert Solution

IF YOU HAVE ANY DOUBTS COMMENT BELOW I WILL BE TTHERE TO HELP YOU..ALL THE BEST..

Assume that we get x tons of source A and y tons of source B (perday)
obviously: x0 and y0
the cost : C=20x+10y 80
given condition : y2x
we need to maximize the amount of gold extracted : S=2x+3y
we graph:



the region of (x,y) is the region in triangle ABC where A,B,C arethe critical points
A(0,0) ,B(2,4) ,C(4,0)
the maximize occur at certain critical point so we can substitute:
S(A)= 0    ;S(B)=16 ;S(C)=8 (B is theintersection of y=2x and 20x+10y=80)
=> S maximize at B,when x=2 and y=4
so one day,he should process 2 tons of source A and 4 tons ofsource B to get maximum is 16 oz. of goal .

I HOPE YOU UNDERSTAND..

PLS RATE THUMBS UP..ITS HELPS ME ALOT..

THANK YOU...!!


Related Solutions

Solve the following LP problem using the Solver in MS Excel.   A municipality has two incinerators...
Solve the following LP problem using the Solver in MS Excel.   A municipality has two incinerators for burning trash . Incinerator A costs $3 .80 per ton of trash to operate, and has a capacity of 28 tons per day . Incinerator B costs $4 .25 per ton to operate, and has a capacity of 30 tons per day . The municipality produces over 100 tons of trash per day, and all trash not burned in the incinerators must be...
4.B Construct an Excel model with solver to solve for the profit maximizing levels of price...
4.B Construct an Excel model with solver to solve for the profit maximizing levels of price and quantity for the profit function, Z = qp - cf - qcv, where cf = 8000, cv = 6, and the demand function for the product is q = 2400 - 24p. Illustrate the solution with a graph of the profit function, showing the profit maximizing price level. For an oligopoly as described in the chapter, construct an Excel model to solve for...
A cart for hauling ore out of a gold mine has a mass of 423 kg,...
A cart for hauling ore out of a gold mine has a mass of 423 kg, including its load. The cart runs along a straight stretch of track that is sloped 4.51
A cart for hauling ore out of a gold mine has a mass of 423 kg,...
A cart for hauling ore out of a gold mine has a mass of 423 kg, including its load. The cart runs along a straight stretch of track that is sloped 4.51° from the horizontal. A donkey, trudging along and to the side of the track, has the unenviable job of pulling the cart up the slope with a 535-N force for a distance of 159 m by means of a rope that is parallel to the ground and makes...
For the following provide (a) algebraic formulation, (b) optimized model using Excel-Solver, and (c) statement of...
For the following provide (a) algebraic formulation, (b) optimized model using Excel-Solver, and (c) statement of the optimal solution. Paper Company plant produces rolls of paper of various types for its customers. One product type is rolls of wrapping paper in several different standard widths, as follow: 12, 15, 20, 24, 30, or 40 inches. The various-width rolls are produced by slicing 60-inch wide rolls in plant. For a given week, company waits for all its customer orders to come...
Create a model and use Excel Solver to answer the following: A computer company manufactures two...
Create a model and use Excel Solver to answer the following: A computer company manufactures two types of computers. Each type of computer will require assembly time, inspection time, and storage space. The amounts of each of these resources that can be devoted to the production of the computers is limited. The manager wants to determine the quantity of each computer to produce to maximize the profit generated by sales of these computers. In order to develop a suitable model...
[PLEASE ANSWER IN EXCEL TEMPLATE BELOW (A/B ON SEPARATE PAGES) AND SHOW FORMULAS/SOLVER INFO] La Quinta...
[PLEASE ANSWER IN EXCEL TEMPLATE BELOW (A/B ON SEPARATE PAGES) AND SHOW FORMULAS/SOLVER INFO] La Quinta Inn is staffing its receptionists in its biggest hotel in San Antonio. Receptionists work 6-hour shifts at the hotel lobby. There are two types of receptionists: those who speak English as a first language and those who are fully bilingual (English and Spanish). The requirements for the number of receptionists depend on the customer arrivals during various hours. The Inn believes that the need...
1.     What is true regarding integer programming/ A)    Optimal decision variables will be 0 or 1 B)    Excel solver...
1.     What is true regarding integer programming/ A)    Optimal decision variables will be 0 or 1 B)    Excel solver does not provide sensitivity report C)    Solving an integer programming problem by solving a linear programming problem and rounding gives you the optimal solution D)    All E)    None
This assignment requires using the Excel add-in called Solver. Sam manufacturing company produces two types of...
This assignment requires using the Excel add-in called Solver. Sam manufacturing company produces two types of tires: Economy tires and Premium tires. The manufacturing time and the profit contribution per tire are given in the following table. Answer the following assuming that the company is interested in maximizing the total profit contribution. What is the linear programming model for this problem? Develop a spreadsheet model and find the optimal solution using Excel Solver. How many tires of each model should...
Suppose there are only two sources of SO2 emissions in Florida. Source 1 is a coal...
Suppose there are only two sources of SO2 emissions in Florida. Source 1 is a coal fired power plant and Source 2 is an oil refinery. Marginal control costs for the two firms are given by MCC1=10*q1 and MCC2=15*q2, where q1 and q2 represent the tons of pollution that each respective firm controls. Both sources currently emit 20 tons of sulfur dioxide. Florida's government decides that it wants to reduce SO2 pollution by 20 tons total. Next, suppose the government...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT