Excel Help

I am needing help build an excel sheet with the provided info. I have attached an example via my text book of what is needing to be completed.