restaurant inventory management google sheet

I need a restaurant inventory management system that will track our food inventory on a daily basis. The ideal candidate for this project should have experience in creating advanced Google Sheets with formulas and charts. The layout should be simple and easy to navigate. The system should be designed to automatically update our inventory on a daily basis. The primary goal of this system is to ensure that we always have the right amount of food in stock and avoid wastage.