1. A company would like to invest in the metal stock market, and the maximum available investment is $4,500,000. Write all associated equations (Profit equation, metals constrain equations and special contrain equations, then use Excel to find the best compensation of stocks to maximize the profit, if Metal Interest return (5) Up to allowed investment 5,600,000 3,500,000 1,500,000 Gold 0.45 Silver 0.35 Coppre 017 Iron 037 1,200,000 And the company put the following two constrains At least 35% of the stocks must be Copper b. 25% of the stocks should be Gold and silver Coppes must be less

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter7: Nonlinear Optimization Models
Section: Chapter Questions
Problem 49P: If a monopolist produces q units, she can charge 400 4q dollars per unit. The variable cost is 60...
icon
Related questions
Question
1. A company would like to invest in the metal stock market, and the maximum available investment is $4,500,000.
Write all associated equations (Profit equation, metals constrain equations and special comtrain equations), then use Excel to find the best compensation of stocks to maximize the profit, if
Metal Interest return ($) Up to allowed investment
Gold 0.45
Silver 0.35
Copper 0.17
0:37
1,200,000
And the compsey put the following two constrains
a. At least 35% of the stocks must be Copper
b. 25% of the stocks should be Gold and silver
Copper must be less than won
Iron
5,600,000
3,500,000
Styles
1,500,000
Transcribed Image Text:1. A company would like to invest in the metal stock market, and the maximum available investment is $4,500,000. Write all associated equations (Profit equation, metals constrain equations and special comtrain equations), then use Excel to find the best compensation of stocks to maximize the profit, if Metal Interest return ($) Up to allowed investment Gold 0.45 Silver 0.35 Copper 0.17 0:37 1,200,000 And the compsey put the following two constrains a. At least 35% of the stocks must be Copper b. 25% of the stocks should be Gold and silver Copper must be less than won Iron 5,600,000 3,500,000 Styles 1,500,000
Expert Solution
steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,