Question: Help me to solve it by using Solver (excel) thanks Suppose that a mine mainly produces neodymium, but that recent price spikes in two REEs,

Help me to solve it by using Solver (excel) thanks
Suppose that a mine mainly produces neodymium, but that recent price spikes in two REEs, namely praseodymium and terbium, are causing the mine to excavate from a combination of five ore types that are relatively high in Pr and Tb, and blend them. However, the radioactive impurities, thorium and uranium, must be maintained to within tolerances. Consider the ore characterization data within the following table: and the following composition specifications: a) Formulate and solve a linear program in Excel to determine the blend of ore that maximizes the praseodymium content, while satisfying the remaining specifications, with a treatment cost below $16.00/t ore. b) Repeat the previous exercise, except to maximize the terbium content. Does this give the same result as in part a)? c) Repeat the previous exercise, except to minimize the thorium content. Compare this result to those of parts a) and b). d) Comment on the interplay (duality) between minimization and upper bounding, and between maximization and lower bounding, with reference to beneficial praseodymium and terbium content and detrimental thorium content. How does this relate to multiobjective optimization for management of complex processes, including the notion of conflicting objectives? e) The ore characterization data contains only the average compositions of each soil, and no information about the standard deviation. Describe the complications that can arise if certain of the ores are highly variable, and/or if the process is poorly controlled. What approaches can be used to manage these risks? (three or four sentences are sufficient)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
