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
Rico-AG is a German fertilizer company, which has just received a contract to supply 1,000 tons of 3-12-12 fertilizer. The guaranteed composition of this fertilizer is (by weight) at least 3% nitrogen, 12% phosphorus, and 12% potash. This fertilizer can be mixed from any combination of the raw materials described in the table below.
\table[[Raw Material,% Nitrogen,% Phosphorus,% Potash,\table[[Current World Price/Ton],[(Euro)]]],[AN,50,0,0,160],[SP,1,40,5,170],[CP,2,4,35,204],[BG,1,15,17,182]]
Rico-AG 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. (6 pts )
b. Develop a spreadsheet model in EXCEL to solve the problem and solve it.(6 pts )
c. What is the optimal solution (i.e., total cost and amount of each raw material used)?(4 pts)
1
I need help with the excel portion mostly and

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 General Management Questions!