can-you-solve-this-assignment-please-

all files required for the assignment are provided below.

questions that have excel files in them must be solved on excel please