Question: EXCEL SOLVER: Need Help solving this problem in EXCEL SOLVER. Please Help! A gold processor has two sources of gold ore, source A and source

EXCEL SOLVER: Need Help solving this problem in EXCEL SOLVER. Please Help! 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?

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 Finance Questions!

please provide excel solver Problem 1 Goldilocks needs to find at least 12 lb of gold and at least 18 lb of silver to pay the monthly rent. There are two mines in which Goldilocks can find gold and...

Here is the new homework question. Please review the General Homework instructions due to the instructor being so strict. Were there any podcasts or Homework document notes that you needed me to...

Questions: Authors Message. Highlight two or three of the authors major ideas from the chapter that resonate with you. Applying the information: How do these ideas affect you personally? What are the...

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 $ 2 0 per ton...

Fill in the Blanks to the problem! 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...

Hi, Please help me with homework. Thank you !!! Thumbs up for ALL answers. Material: Book Title Social Media Marketing: A Strategic Approach Author Barker, Barker, Bormann, Roberts, Zahay...

\fSUPPORT FOR THE CULTURAL DIVERSITY AND POLICING (CDAP) PROJECT AND ALL OF ITS PRODUCTS HAVE BEEN PROVIDED BY THE BUREAU OF JUSTICE ASSISTANCE GRANT #2001-DD-BX-K003. OPINIONS STATED IN THIS PAPER...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

(Questions from Lecture and Article) - Discussion Board Activity I need to read the following Lecture Note and the ?Wall Street Journal? articles that I uploaded, and writeanswers for theDiscussion...

CASE its lose in ROSE TREE REGIONAL AIRLINE or ad- ying Decision Support Using Microsoft Excel Solver PREVIEW onse Tree Regional Airline provides passenger transportation services and small-parcel...

Replace the force and couple-moment system by an equivalent resultant force and couple moment at point O. Express the results in Cartesian vector form. Units Used: kN = 103 N Given: F = (8 6 8) kN M...

Teaching is an art Justify this statement by giving suitable examples. Write your own teaching philosophy. Why do you think so? Justify

b . If the March futures price increases to 3 . 8 1 6 , what percentage return will you earn on your investment? Noter Do not round intermediate calculations. Round your answer to 2 decimal places. \...

PLEASE ANWSER ASAP I WILL GIVE THUMBS UP!!! Stratford Company distributes a lightweight lawn chair that sells for $20 per unit. Variable expenses are $8 per unit, and fixed expenses total $210,000...