The Gain/Loss Column within the Actual Cost grid is calculated as follows:

When Period Qty=0, Gain/Loss = (-Period Cost); Otherwise, Gain/Loss = (Forecasted Unit Cost - Period Unit Cost) x Period Quantity

When ToDate Qty=0, Gain/Loss = (-ToDate Cost); Otherwise, Gain/Loss = (Forecasted Unit Cost - ToDate Unit Cost) x ToDate Quantity

Questions? Contact [email protected] and we will be in touch with you.