Data Analysis and optimization with excel

Data analysis and optimization in excel. See attached excel file.
In addition,  include a separate part or document that explains your methodology, assumptions, assessments, etc. Assignment help