Solve Mathematical problem in EXCEL

Solved Mathematical Problem for Excel Dataset

With your given data and description of required tasks, I have compiled the results by applying formulas to first row of sheet 1 and sheet 2 and derived results in additional 4 columns. In order to make it viewable I've hidden unnecessary columns. I hope I'm in the right direction Please correct me If I'm wrong and update me with your feedback. I have uploaded 4 images.Thanks and Regards.