British Airways Forecasting

From SkySuite Wiki
Jump to navigation Jump to search

British Airways Forecasting

This help wiki page will document how the BA forecast currently works, how to amend items/ quantities and also troubleshooting to issues you may face.

Overview of the forecast process

As of today the BA forecast has been uploaded using past consumption figures provided to Skylog via the BA planning team, due to this all items are subject to manual change which we will detail below in this page on how to achieve.

Suggested quantities for station orders comes from the 'Network Analysis' forecast (also known as the 'NWA' forecast) which is where all high level forecast data is held, but the NWA forecast flows into the 'NWA Demand by Warehouse' forecast which sums up all the items per warehouse, that in turn flows into the MRP planning algorithms. Once these figures are in the MRP the system will then suggest quantities to be ordered from suppliers.

Amending the active forecast

Now you know all about the background to the forecasting in SkyLog now we will discuss how to amend the active forecast.


You will firstly need to navigate to the main forecast page: https://rsprod.skylogportal.com/NetworkAnalysis and find the 'Active' status forecast and click the drop down, you will see there is a cog button;


BA FCST 1.PNG


Three drop down options will be presented;


BA FCST 2.PNG


  • Upload Forecast Change Document - You can use the forecast amendment template document to upload mass changes
  • Manually Change Forecast - Instead of using the excel template you can instead manually alter the forecast via the portal
  • View Actioned Changes' - All changes that have been actioned against the forecast can be viewed here for audit purposes


Upload Forecast Change Document - Walkthrough

If you wish to upload the forecast change document then follow the below steps, if instead you would like to do edit manually navigate to here.

To start, you will need to edit the template document with the items, quantities and instructions to be uploaded, when you open the docunent you will be presented with four main tabs


BA FCST 5.PNG


Each tab allows you to alter the forecast in a slightly different way


BA FCST 4.PNG


but there is an explanation on how each sheet works to the right of the columns


BA FCST 6.PNG


Once you have entered the details that are required to be amended select "Upload Forecast Change Document" from the drop down detailed above and select the file from your PC and upload it.


BA FCST 3.PNG


The following screen will then be presented which will detail all non-approved forecast changes (not just the ones uploaded by yourself)


BA FCST 7.PNG


When you have reviewed the changes uploaded the approval tick column on the right hand side of the screen needs to be ticked for all items you wish to change (note: if you filter you will only select all the records that are filtered)


BA FCST 8.PNG


Once ready just press "Approve Selected" at the bottom of the page.


Manually Change Forecast - Walkthrough


If you only have one part at one station that you wish to update manually adjusting could be a much faster way than using the forecast upload document, simply select "Manually Change Forecast" from the drop down that pressing the edit cog button presents you.


BA FCST 10.PNG


The page presented is the same as detailed in the above which is where the forecast change approvals lie but you will see that there is an add button which you will need to press to enter the manual changes


BA FCST 11.PNG


Use the drop down to select the appropriate 'Action' you need to perform


BA FCST 12.PNG


Depending on the action chosen the fields presented will differ and require entering


BA FCST 13.PNG


Once all the required data is entered select "Update"


BA FCST 8.PNG


Find the item you have just entered and select it using the tick box to the right and select "Approve Selected" at the bottom


Reviewing Changes Made


After "Approve Selected" is pressed the active forecast will refresh but depending on the amount of changes done could take some time and will present differnt statuses until it is back to 'Active'

When the status is again 'Active' it is good practice to review the changes you have made by using the filters, if you spot something that doesn't look quite right press the edit cog again and select "View Actioned Changes". In this screen you can review the changes that have been approved thus you will need to verify if what was approved is correct or not.


Troubleshooting

Why isn't there any demand against my item in the MRP?

The most commonly asked question