The data calculation in Excel

Required to perform data calculation in Excel. The details in the files attached below.