What easier way to monitor produce supplies than by using a spreadsheet and a free one at that. There are plenty of websites that offer spreadsheets for tracking various restaurant inventory. Restaurants generally consist of a multitude of items that need to be stocked and re-stocked on a regular basis, since the majority of these items get consumed daily. Having a free restaurant produce spreadsheet is one way to properly maintain a complete list of what needs to be ordered next time from the food service in charge of supplying all the perishables.
The website with the most commonly used spreadsheets available is called freerestaurantforms.com and these are completely free documents that are able to be downloaded right to your computer. This spreadsheet can be altered in any way needed to make it fit better with your list of produce used. Not all restaurants carry the same items or quantities, so these numbers are easily inserted to make them accurate for your restaurant.
While the individual items are located in the column to the far left, the estimated quantities to be used and how much was ordered are listed to the right.
The columns start off the with par amounts for a typical weekday and weekend, with each amount able to be placed in a separate column. The days of the week are then listed, starting with Monday and ending on Sunday, with two columns alloted for each individual day.
There is a column for Par and a column for Ord. This is a great way to use this free restaurant produce spreadsheet for keeping track of what is used on a daily basis. It is nicely organized and very easy to follow. This format will make ordering produce much simpler, since you can see if the par amounts are as accurate as you thought or if you need to adjust your produce order.
