Question is in the attachment, will need formulas showing the work and ms excel workbook

Question is in the attachment, will need formulas showing the work and ms excel workbook 1