If someone could pls answer this and explain how they did it that would be great! Thank you

2. Minimizing Cost (50 Points) Data File necded for this exercises None following tahle: zivet in the following table. Using Eicel Solver, determine hisw mach of each fertiliter whold be purchused to satisfy the tofuifecmenta at nuinimain cost. Be vure to select keep the folver wolution and geterate in answ ce report. E.red Solver Tack Notes you can find ievetal exarteles an Hacel Solvet ve Cownas Modale, eadir herture 5. Construinto Wring Excel Solver, detcrmine how moch of each fertilizer sthould be parchased to satisfy the recoirements at minimism cove Ble sure to select keep the Solver solvtion and generate an answer report. Excel Solver Task (a) Open a XEW wockbok and save it as Fertilizer. Custalse. Insent a Documentation worktheet and add an appoopriate titte for the workbok in cell A. In cell B3, enter your name, In cell BA. enier your studeat member. In celt BS, enter the completion date of yoer asigriment, and in oell B6, enter a sentence to describe the papose of the workbook: (b) Focmulate aed enter the aheve toptimization probleta using a new wortsheel. Note: you can find several examples on Evoel Selver on Canvas Module, under Lectare 5. (c) Eeter Solver Parameters (Set Ocioctive, To, By Chanfing Variablo Celts and Sibject to the Constraints) (d) Solve the peoblem. Be iure to select Kerp be Solver Salwilion and generate an Amswer report. (c) Uning the ation workineet, ativet the following quection. 1. How mach of each fertilizet theuld be porchawed is satitly the roquirements at minitium cont iit. What it the minimum eont ( (i) Formst your workbonk as detired (Headinge. Foot, Fill color, Number format..i.) (2) Save asd close your workthook Siubmission Guidelitaet Wkine Canvia, piease submis two iotubion files by no fater itain Oct, 20,2022 at 1154 fiM