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 C…