Mathematics Homework Help

Please refer to the attached file. Please do include a proper Linear Programming model in part B. I have no idea on how to go about answering the question and help is urgently needed. Answers to be in word document.

1a) Axel, a business executive, proposed two alternatives to NewCrest. One is investing
$100,000 in option I, $200,000 in II and $150,000 in III. The other is investing
$60,000 in option I, $100,000 in II and $125,000 in III. NewCrest takes a
conservative approach to decision-making. That is, it chooses the alternative that
maximizes the minimum return produced by the two outcomes of the economic
outlook. Discuss among the two alternatives proposed by Axel, which one NewCrest
will choose. Please write clearly alternatives, states of nature and payoffs in a payoff
table. Please limit the answer to within one page.

1b) Ben, another business executive, pointed out that NewCrest has an unlimited number
of alternatives, not just the two proposed by Axel. Which alternative is best if
NewCrest takes a conservative approach to decision-making? To answer that
question, Ben drafted,
“Define investment in option I,
investment in option II, and
investment in option III.
The objective is to
Maximize min ”.
The objective function is not linear. Please search online “tricks to maximize the min
of objective functions” or “transformations into linear programs”. Then help Ben
develop a complete Linear Programming (LP) model that represents the problem of
deciding how much to invest in each option. Please limit the answer to within one
page.

1c) Use the Excel Solver to find the optimal solution to the problem in Part (b) and
summarise how NewCrest should invest. Please paste here three screenshots, (1) the
problem worksheet just before clicking the Solver command, (2) the Solver
Parameters dialog just before clicking Solve and (3) the Answer Report created by the
Solver. Please limit the answer to within three pages.