Case study and excel file with calculated data are uploaded. I only need the sections I will specify below completed:Provide…