case analysis, management homework help

I have upload the requirement and case files. Please follow the requirements to finish this assignment.