INVENTORYBAL function

Returns balance of inventory at end of each month(s) from start month

Syntax

The INVENTORYBAL function syntax has the following arguments

  • Starting_inventory     Required.    Number.    Inventory available at start of period

  • Inventory_used     Required.    Array.    Total drawdown of inventory during each month(s) for COGS or other purposes. Note: By default, this function will return a row of values for the same number of columns that you select for this input. Please make sure that adjacent cells do not have any other content. Add the month_numner input in this function if you need this value for a specific month (and not for all months).

  • Inventory_added     Required.    Array.    Inventory added (purchased) during each month(s)

  • Month_numberOptional.    Number.    Month for which this value is required. Leave this blank (no input) if you need values for the same number of months as the input array. Input value must be integer >=1. For example, enter 6 if you'd like this value for month 6. Note: value will be returned for specified month only if you enter a value.