At its most basic level, your spreadsheet uses this logic to determine your available budget:
Your forecast of how much you expect to sell during the month. open to buy spreadsheet
A column for inventory that has already been purchased but has not yet arrived. At its most basic level, your spreadsheet uses