Capital project material tracking spreadsheet/smartsheet

I work for a construction company and I have been tasked with creating a spreadsheet/smartsheet that tracks inbound material as per contract, actuals received, damaged, etc. Once material is received onsite, it is divide as needed and transported to laydown areas throughout the site. My bosses are very much graphical people and are looking for a dashboard that could easily depict project health