What is required as input for the predicted actuals function?

The predicted actuals function requires two or three input worksheets to generate accurate forecasts. Typically, one worksheet might contain historical actuals data, while another would include relevant contextual data, such as forecasts or planning scenarios. The third worksheet, if utilized, could be a support worksheet that provides additional parameters or insights necessary for refining the prediction process.

This multi-worksheet approach allows for a more robust analysis as it incorporates various data points and perspectives, ensuring that the predictions are not solely based on linear trends but also consider multiple variables that affect the outcomes. This integration of information enhances the accuracy and reliability of the predictions generated by the function, making it essential for effective supply chain planning and management.