Question: I need help with the excel portion mostly and using solver Rico - AG is a German fertilizer company, which has just received a contract
I need help with the excel portion mostly and using solver
RicoAG is a German fertilizer company, which has just received a contract to supply tons of fertilizer. The guaranteed composition of this fertilizer is by weight at least nitrogen, phosphorus, and potash. This fertilizer can be mixed from any combination of the raw materials described in the table below.
tableRaw Material, Nitrogen, Phosphorus, Potash,tableCurrent World PriceTonEuroANSPCPBG
RicoAG wants you to determine the least cost mix to produce the fertilizer order.
a Formulate a LP model for this problem. Write out the linear optimization problem being solved. pts
b Develop a spreadsheet model in EXCEL to solve the problem and solve it pts
c What is the optimal solution ie total cost and amount of each raw material used pts
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
