The purpose of the Evaluative Model is to compute the values of all Performance Measures necessaryto determine the cost and effectiveness of any proposed coal procurement plan. The Evaluative Model will take the Offers Edit Report and the Decision Variables as its key inputs. Prior to building the model, yoo will need to read the case thoroughly and have a strong understanding of the underlying business problem. To complete this assignment, yOu will first need to model the underlying business problem described in the case (in particular, you must clearly identify each of the Decision Variables and each of the many performance measures]. Next, you will need to design a spreadsheet that will implement the model. Finally, you will construct the spreadsheet, doing your best to "build it right the first time". This is a sizable spreadsheet modelling task and you will have several weeks to work on it with your team. ll'ou will want to be careful to stay on track and not fall behind. Your team should expect to work together regularly on this project. The professor and teaching assistants will be available to answer questions through this process as well. For this Deliverable, you will need to update your initial model on direct feedback, new concepts and techniques presented in class, and any other changesfadditions that your group chooses to make to your initial model