I need a Google Sheets expert

My manufacturing company is looking for help improving our orders dashboard, which is in Google Sheets. We want to be able to harness the information better to make projections or analyze our production queue. For example, if an employee wants to take 2 weeks off, will we fall behind?