Saltar al contenido principal
La version française est traduite automatiquement de l'anglais. // La versión en español se traduce automáticamente del inglés. // A versão em português é traduzida automaticamente do inglês.

Section 5. Supply Planning Module: Supply Planning

A. Supply Planning: An Overview​

Supply Planning Screen – Plan by MOS Supply Planning Screen – Plan by MOS

Supply Planning Screen – Plan by Quantity Supply Planning Screen – Plan by Quantity

  • What? All major data points (consumption, shipments, inventory) come together on the supply planning screen, and this is where most QAT users will spend the majority of their time. Users can click on many of the cells in the table to directly edit their data. It is recommended to use this screen for active supply planning (including data updates and planning new shipments), but to use the data entry screen when significant amounts of data entry is required. Note that some sections vary based on whether the planning unit is planned by MOS or planned by Quantity (as selected in Planning Unit Settings) – differences are noted below.

    • This screen can also be viewed by the alternate reporting unit (ARU) associated with the planning unit. This means that users can view their supply plans in terms of the product names and units of measure they enter the data in, with values on the table and graph changing according to the ARU/PU conversion factor that is established by the user (see Alternate Reporting Units). The user selects to view by ARU clicking on the radio button and then selecting the desired ARU to display.

      Supply Planning Table –by Planning Unit vs by Alternate Reporting Unit Supply Planning Table –by Planning Unit vs by Alternate Reporting Unit

  • Who? Realm Admins, Program Admins, Supply Plan Reviewers, and Program Users can add data/edit data in the supply plan. Certain “view only” roles can view the supply plan.

  • When? At any time. The user does not have to be online. However, they must have downloaded a program onto their local computer while online before beginning.

  • How?

    Note: other than step 1 being required, the remaining steps are not sequential, but an explanation of the features available in the supply planning screen.

    1. On the left menu bar, go to Supply Planning > “Supply Planning”

      1. Select the desired Program. The drop-down list in the supply plan screen will show all the programs that have been downloaded by the user. Refer to Download Program for details on how to download a program.
      2. Select the desired QAT Planning Unit or Alternate Reporting Unit (ARU).
      QAT Planning Unit / Alternate Reporting Unit Selectors
    2. The screen displays two Supply Plan tabs: Local Supply Plan and Server Supply Plan - vX. The “Local Supply Plan” tab is the local version that was selected under “program” and is available to be edited. The “Server Supply Plan” is the latest version available on the server and is only available for viewing (not editable).


      Local/Server Supply Plan Tabs
    3. By default, the past 3 months and 15 future months from the current date are shown. Use Scroll to Left/Right to show data for 3 months in the past/future


      Scroll to left / right bar
    4. Click “Show Formulae” at the top right of the screen for explanations on calculations on this screen and click on the PDF & CSV icons to export this report, and will include all planning units in the program. In PDF, only the graph for the selected product will be included, but there will be tables for each planning unit.


      Show Formulae buttonPDF and CSV Export Icons
    5. Understanding the stock balance calculations on the top half of the table:


      Ending Stock Balance Calculation
      Ending Stock Balance Calculation
      • Opening Balance represents the quantity of stock at the beginning of the month. It is equal to the ending balance of the previous month, except the very first month of the program, where the opening balance is zero. It can be an inventory count from the previous month (bolded), or a projected value (unbolded).
      • Ending Balance represents the quantity of stock at the end of the month. It can be an inventory count (bolded), or a projected value (unbolded).
      • Follow the +/- signs besides each row to understand how the math works from opening balance to ending balance.

The bottom half of the table contains more detail to help the user interpret the stock status.

 Differences in the Supply Planning Table - Plan by MOS vs Plan by Quantity


Differences in the Supply Planning Table - Plan by MOS vs Plan by Quantity

  • Average monthly consumption (AMC) is an average of the consumption over the months indicated by the AMC parameters, which are displayed above the table. To edit these parameters, see Planning Unit Settings.

    Differences in the Supply Planning Legend- Plan by MOS vs Plan by Quantity


    Differences in the Supply Planning Legend- Plan by MOS vs Plan by Quantity

  • Unmet demand. Estimated quantities of product that would have been consumed if sufficient stock was available:

    • When the forecast consumption is greater than the projected available beginning stock on hand.
    • When the actual consumption includes days of stock out
    • When a negative manual adjustment is larger than the projected ending balance
  • The second row from the bottom

    • Planned by MOS: Months of Stock is calculated as the ending balance of the month divided by the AMC.
    • Planned by Quantity: Max Quantity is calculated as the Minimum Qty + Reorder Frequency * AMC.
  • Stock Status Color-coding

    • Planned by MOS: The “Months of Stock” row is color-coded based on the stock status using the color coding displayed in the legend. Stock status is determined by comparing the MOS with the MIN MOS and MAX MOS.
    • Planned by Quantity: The “Ending Balance” row is color-coded based on the stock status using the color coding displayed in the legend. Stock status is determined by comparing the quantity of the “ending balance” with the min quantity (provided by user) and max quantity (calculated).
  1. Reading the stock status graph. The dates on this graph follow the table. By default, all graph elements are displayed. Click on any data element in the legend to hide a data element. The Stock Status graph has two vertical (Y) axes:

    • The primary (left) axis is in units, and depicts shipments, consumption, stock, and expiries. For Plan by Quantity, there minimum and maximum quantities use the primary axis.

      Figure: Supply Planning Graph - Primary Axis (Plan by MOS)
      Figure: Supply Planning Graph - Primary Axis (Plan by MOS)

      Figure: Supply Planning Graph - Primary Axis (Plan by Quantity)
      Figure: Supply Planning Graph - Primary Axis (Plan by Quantity)
    • For plan by MOS, there is a secondary (right) axis in months, and depicts the stock parameters (minimum, maximum) and the calculated months of stock.

      Figure: Supply Planning Graph - Secondary Axis (Plan by MOS)
      Figure: Supply Planning Graph - Secondary Axis (Plan by MOS)

B. Supply Planning: Consumption​

In the supply planning table, only one number will show per month for the whole program in the consumption row. As noted in the legend, forecasted consumption is indicated by purple italic text, while actual consumption is indicated by black non-italicized text.

Consumption Table Legend

Logic for Consumption Data Displayed

  • For single-region programs, the actual consumption will be displayed when it is available. If actual consumption is not available, the forecasted consumption will display.
  • For multi-region programs, QAT will display the greater between Σ(actuals) or Σ(forecast) across regional data. (Note: this logic is being reviewed and may be updated in the future).

To add or edit consumption records

Lots of data to add/update?
Go to data entry screen!


Lots of data to add/update right-click menu

On the consumption details pop-up, users can directly access the Consumption data entry by clicking the link on the top right corner (see Consumption Data). Left click to open a tab on your browser, right click and select “Open link in new Quantification Analytics Tool window” to open a separate QAT PWA window.

  1. Click on the month and cell on the Consumption row in the supply planning screen. A new window called Consumption Details will pop up. In the table that appears, each row represents a region. Single-region programs will only have one row, while multi-region programs would have multiple rows. The total shows the aggregated consumption for all regions.
  2. Click on the consumption record of any month and region to display further details. Any records for that month and region will display below.
  3. To create a new record, right click on the details row and select "Add new consumption" or click the "+ Add Row" button.
  4. To edit a record, click on any cell and edit consumption details (consumption type, data source, quantity, etc.) Double click to activate any dropdowns. See Consumption Data for additional guidance on consumption data entry.
  5. Click "Submit" to save the changes and return to the main supply planning screen, where your changes will be reflected.
Consumption Details Dialog

C. Supply Planning: Shipments​

By default, shipments are only shown as one row in the supply planning screen – this is the aggregate quantity of all shipments (excluding suggested shipments). To show more details, click on the + icon to the left of the "+ Shipments" row to expand and display the sub-rows. You will see five rows split up by order status (top row for suggested shipments which are automatically calculated).

To see a detailed breakdown of all shipments in a month, click on the cell in the corresponding month in the '+Shipments' row. To see the detailed breakdown of all shipments by status, click on the cell in the corresponding month in the individual status row.

ERP (enterprise resource planning) data is linked to ERP from procurement agents and are non-editable (see ERP Shipment Linking)

For all shipment rows, the colors indicate the procurement agent. If a month has multiple shipments with different procurement agents, the cell will be green. Red triangles on the top right of the cell indicate that a shipment is an emergency. If the shipment is a local procurement, there will be an L icon in the bottom left of the cell. If the shipment is ERP linked, there will be a link icon in the top left of the cell. Shipments can have multiple icons such as a local ERP linked emergency order. The legend appears at the top of the screen.

Shipments in Supply Planning Shipments in Supply Planning

The following sections will cover how to update existing shipments and create new shipments within the supply planning screen. See Shipment Data for more tips on the shipment data fields, which apply across the Shipment Data Entry screen and the supply planning screen.

C1. Updating an Existing Shipment​

  1. Click on the cell representing the month and shipment to be edited. Clicking on the "+Shipments" row will open up a tab with all shipments for that month regardless of status. Clicking on one of the status rows will open up a tab showing only shipments for that month with that status.

Planned Shipment Highlight

  1. The Shipment Details pop-up will appear. Make all desired changes. To update batch or date information, right click on the shipment row. The top of the pop-up allows users to navigate to a different month to make changes to those shipments as well.

Shipment Details Table Columns

  1. Click "Submit" to save the changes and return to the main supply planning screen, where changes will be reflected (Note: The Submit button will not appear if all required fields are not filled.)

Shipped Shipment Table Highlight

Note: Planned shipment was edited to shipped, showing the 130,000 has now been moved from "Planned" row to the "Shipped & Arrived" row.

Shipment Parameters Tooltips

Reminder: Tool tips are provided to help guide where to update specific parameters. These provide clarity into what users need to update.

Updating Shipment Quantity with Recalculate Button​

For planned shipments in the future, QAT will suggest a revised shipment quantity as an early warning to avoid going below minimum stock levels. Just like suggested shipments (see Creating a New Shipment), QAT will only provide the recalculate button if the shipment falls in a month that is below min followed by at least two months that also below minimum stock level. The quantity recommended by the recalculate button will follow the same logic as the QAT suggested shipments (see Rules for Suggested Shipments below).

Below are the steps to use the recalculate button in the Supply Planning screen:

  1. Go to a planned shipment in the future where the current month and at least following 2 months are below minimum stock level.
  2. Left click on the shipment.
  3. Find the 'Order Quantity' column and right click.

Suggested Shipment Highlight

  1. Click 'Recalculate'. A pop-up message will appear telling you how much quantity QAT is suggesting to add and how much quantity the revised shipment will be.

Recalculate Button Recalculate Button

  1. Click 'Ok'. The pop-up will go away, and the revised order quantity will appear in the 'Order Quantity' column. Click 'Submit' if you wish to proceed with the revised order quantity. At any point, the user can override the quantity by double clicking into the cell and typing in a new quantity.

The revised quantity will now reflect in the supply plan.

C2. Creating a New Shipment​

There are two ways to create new shipments – 1) converting a QAT suggested shipment into a planned shipment or 2) manually adding a shipment.

QAT Suggested Shipments

QAT suggests a shipment as an early warning to avoid going below minimum stock levels. These are not actual shipment and as such, do not affect stock projections. Only when a suggested shipment is accepted and the status changes, will it be counted towards your stock projections. QAT will automatically mark a suggested shipment as an emergency shipment if it is within the lead time. See Rules for Suggested Shipments below.

To Convert a Suggested Shipment into a planned shipment:

  1. Click on the row for Suggested Shipment under the desired month.
  2. The Shipment Details pop-up will appear. Change the status to the desired status, fill out the required fields, indicated by an asterisk. Double click to activate any dropdowns. Scroll to the right to see all fields. Hover over tool tips if any clarification is needed (shown in picture below). The order quantity will be pre-filled by the suggested order quantity.

Suggested Shipment

  1. Click “Submit” to save the changes and return to the main supply planning screen, where changes will be reflected (Note: The Submit button will not appear if all required fields are not filled)

Rules for Suggested Shipments:

For Plan by MOS:
  1. Is the planning unit understocked (MOS<Min) for 3 straight months? a. If yes, suggested shipment will bring the current month’s stock level to maximum. b. If no, no suggested shipment.
  2. If the planning unit is stocked out, QAT will always suggest a shipment. a. If both of the next 2 months are <Min, the suggested shipment will bring the current month’s stock level to maximum. b. If 1 of the next 2 months is >Min, the suggested shipment will bring the current month’s stock level to minimum.
  3. If AMC = 0 or N/A, there will not be a suggested shipment for that month.
For Plan by Quantity:

Where Month N is the month QAT is calculating for, and X = Distribution Lead Time

  1. If AMC = 0 or N/A for Month N, no suggested shipment
  2. If Month N is stocked out (Ending balance = 0), QAT will always suggest a shipment a. If both of next 2 months (N+1, N+2) are < min qty, suggested shipment is the quantity that would bring month N to maximum qty. b. If one or both of the next 2 months (N+1 or N+2) is > min qty, suggested shipment is the quantity that would bring month N to minimum qty.
  3. Is product understocked (ending balance < Min qty) for 3 straight months (Month N, N+1, N+2)? a. If yes, suggested shipment is the quantity that would bring Month N to maximum qty. b. If no, no suggested shipment

QAT puts the suggested quantity in Month N-X. In other words, X months before Month N, where X is the distribution lead time.

To Manually Create a New Shipment:

  1. Click on the cell representing the month the shipment should be added to. Clicking on the '+Shipments' row will open up a tab with all shipments for that month regardless of status. Clicking on one of the status rows will open up a tab showing only shipments for that month with that status. Either option will work for adding a new shipment.
  2. The Shipment Details pop-up will appear. To add a new row, click on the '+ Add Row' button or right click on any row and select 'Add new shipment' Double click to activate any dropdowns. Change to the desired status, quantity, and complete the required fields indicated by an asterisk. Scroll to the right to see all fields.
  3. To create multiple new shipments, right click on any row and select “Add new shipment” or click the “+ Add Row” button. a. Be mindful of tool tip icons to help guide which specific parameters need to be updated.

Shipment Parameters Tooltip Crop

Manual Shipment Table Entry

  1. Click “Submit” to save the changes and return to the main supply planning screen, where changes will be reflected (Note: The Submit button will not appear if all required fields are not filled.)

D. Supply Planning: Inventory/Adjustments​

In the supply planning table, one number will show per month for the whole program in the manual adjustments row, regardless of how many manual adjustments are made. Similarly, the ending balance will always be one row, regardless of whether the ending balance is projected by QAT or provided by the user as an inventory count.

Adjustments and Ending Balances in Table

Logic for Adjustments and Ending Balances

  • When there are no inventory counts,

    • Adjustments = the sum of all manual adjustments (Σ(manual adjustments))
    • Ending balance = projected inventory
  • When there are inventory counts,

    • For single-region programs, if there is an inventory count, that inventory count will be the ending balance.
    • For multi-region programs where not all regions are reporting, QAT will use whichever is greater, Σ(inventory count) or (projected inventory) as the ending balance
    • For multi-region programs where all regions are reporting, QAT will use Σ(inventory count) as the ending balance.
  • Whenever QAT uses inventory count as the ending balance, auto adjustments are calculated on top of manual adjustments.

  1. To add or edit adjustment or inventory records, click on the month and cell on the adjustments or ending balance rows in the supply planning screen.

    1. A new window called Adjustments and Inventory Details will pop up. In the table that appears, each row represents a region. Single-region programs will only have one row, while multi-region programs would have multiple rows.
    2. The total shows the aggregated adjustments and inventory for all regions.
    3. Click on the record of any month and region to display further details

Lots of data to add/update?
Go to data entry screen!

Lots of data to add/update

On the Adjustments and Inventory Details pop-up, users can directly access the Adjustments and Inventory data entry by clicking the link on the top right corner (see Inventory Data). Left click to open a tab on your browser, right click and select “Open link in new Quantification Analytics Tool window” to open a separate QAT PWA window.

Adjustment and Inventory Details

  1. Any records for that month and region will display below.

    • To add an adjustment or inventory record, click on add row, or right-click on the bottom table and select “Add new adjustment” or “Add new inventory”. Enter the required details. For adjustments, users can enter both positive and negative adjustments, in the past and in the future, and notes are required

Adjustment and Inventory Details Context Menu

  • To edit a record, click on any cell to edit.
  1. Note: A user can review which batch is affecting their ending balance for a particular month, by clicking on “Final Inventory” in the “Adjustment and Inventory Details” screen pop-up.

Batches included in Final Inventory Pop-up Batches included in Final Inventory Pop-up

  1. For months with an inventory record, the user can click edit the batch quantities.

    • Note: redistributing batch quantities should be the last resort. It’s always better to update the information upstream (shipment, consumption, adjustment) instead of updating the inventory batch information.
    • How to do it?
      1. Ensure there is an actual/manual inventory count for the month
      2. Click on “final inventory” to pull up the batches
      3. Type over the actual quantity – use the dropdowns if you want to change batches
      4. Remember, the total of the batches must match the total inventory total for the month
    • Right click on any batch to view the batch ledger (learn more in Supply Planning: Project Expired Stock and Batch Information)

Batches Affecting Final Inventory Pop-up Batches Affecting Final Inventory Pop-up

E. Supply Planning: Project Expired Stock and Batch Information​

Users can view the projected expired stock, if any, for each month in their supply plan in the Projected Expired Stock row. Clicking on the cell will bring a pop-up window with the expiry details.

Projected Expired Stock row highlight

From the pop-up – users can do 2 functions:

  1. Edit the batch that contributed to the expiry: Click on the Batch Number. QAT will automatically redirect the user to the shipment from which the batch was generated. From the shipment screen, a user can edit the Batch Name, Expiry Date, and Shipment Quantity.



    Projected Expired Batch Details Pop-up
    Note: Users can also edit this information in the Shipment Data entry screen (see Shipment Data).
  2. View the batch ledger: Click on the Expired Quantity cell. QAT will automatically open a pop-up screen below with the batch ledger, which shows the life of a batch month-by-month from shipment receipt to expiry.

Logic for Batches & Expiries Flowchart

Logic for Batches & Expiries

  • Batches start with shipments.

    • QAT automatically generates one batch for each shipment that equals the quantity of the shipment.
    • Batch expiry dates are based on shipment receive date plus planning unit shelf life (Updatable by Program Admins in Planning Unit Settings).
    • Users can override the batch number, expiry date, and split shipments into multiple batches.
  • For consumption

    • By default, QAT uses First Expired, First Out (FEFO) logic.
    • Users can override the FEFO logic and instead, choose a specific batch from a dropdown to tag to that actual consumption record.
  • For adjustments

    • By default, QAT uses the Best-Case Scenario logic: For positive adjustments (manual or automated), QAT adds to the batch that is last to expire (longest shelf life). For negative adjustments (manual or automated), QAT subtracts from the batch that is the expiring soonest (shortest shelf life).
    • Users can override the Best-Case Scenario logic and instead, choose a specific batch from a dropdown to tag to that manual adjustment record.
    • Users cannot override the Best-Case Scenario logic for an auto-adjustment record.
Batch Ledger details

Note: unless the user tags a batch to specific actual consumption or adjustment entries (see “Add/Update Batch Details” in Consumption Data and Inventory Data), QAT will default to monthly batch quantities being placed in the “Auto-Allocated” column in the Batch Ledger.

F. Scenario Planning​

QAT provides users with predefined scenarios for supply planning. This functionality will allow users to make changes to- and visualize their data in different ways, without necessarily affecting their current supply plan. Users can apply one or more scenarios to their data to see how those changes affect stock projections. The selected scenario(s) can then be applied to a current supply plan, creating a new version.

There are currently six predefined scenarios available to users; more can be programed into QAT depending on the need and use cases. QAT users can request new scenarios through raising a ticket. The need for new scenarios will be managed centrally by the Realm Admin.

Available scenarios:

  • Increase forecasted consumption: for a user-defined percentage and period. This will apply a percent increase to forecast values for each month of the selected period.
  • Decrease forecasted consumption: for a user-defined percentage and period. This will apply a percent decrease to forecast values for each month of the selected period.
  • Forecast phase in/out product: for a user-defined period and start and end forecast consumption values. QAT will draw a straight line by interpolating between the start and ending values, and will replace the current forecast consumption values.
  • Remove unfunded shipments: all shipments without an assigned funding source (i.e., funding source = TBD) will be removed from the supply plan and stock projections.
  • Remove all Planned shipments: all shipments with status “planned” will be removed the supply plan and from stock projections. User can check a box to only remove the “planned shipments” that do not comply with the established lead times (i.e. expected receipt date is sooner than what would be feasible given lead times).
  • Remove all Submitted shipments not within the lead time: all shipments with status “submitted” that do not comply with the established lead times will be removed from the supply plan and stock projections.
  • Remove all On Hold Shipments not within the lead time: all shipments with status “on hold” that do not comply with the established lead times will be removed from the supply plan and stock projections.
  • Re-plan supply plan: for a user-defined time period, QAT removes planned shipments that are not correctly maintaining stock between MIN/MAX parameters and creates new planned shipments to comply with stock parameters, using suggested shipment logic described in Section 5.C2 Creating a New Shipment.

To access these scenarios:

  1. Go to Supply Planning and click on “Scenario Planning”.
  2. Select a predefined scenario from the dropdown menu and edit the required fields
  3. Click Add to view the changes.

Scenario Planning Screen Scenario Planning Screen

  1. The scenario will be shown in the "Scenario List".

Scenario Planning Scenario List Scenario Planning Scenario List

  1. If the user wishes to apply the scenario to their supply plan, they can click on the "Submit" button. The new supply plan will get stored in the computer of that user, and the user can upload this to the server as a new version via the Upload functionality.
  2. If the user does not wish to apply the scenario to their current supply plan, they can click on the "Cancel" button or the "Reset" button, and the changes will not take effect.

G. QAT Problem List​

Purpose: A Supply Plan Review integrated within QAT that allows for a quality check to easily identify problematic data/issues and correct these before uploading a supply plan to the server as a “Draft” or “Final” version.

  • Accessible to: Realm Admins, Program Admins, and Program Users
  • Navigation: Supply Planning → QAT Problem List

QAT Problem List QAT Problem List

Note: Only the Problem associated with the programs that have been downloaded by the user in their local machine will appear in the QAT Problem List. For details on how to download specific programs and versions, refer to the Download Program section of the User Manual.

G1. QAT Problem List Basics​

Each Problem that is flagged in the QAT Problem List will have a separate line. This will have the associated planning unit, a description of the problem, a suggestion on how to fix the problem, the problem status, user notes, a checkbox for identifying if the problem has been reviewed, the latest reviewer notes (as applicable), the date it was last reviewed and the criticality.

Aspects QAT Problem List Aspects QAT Problem List

QAT Problems can be subdivided into four main categories: Data Quality, Procurement Schedule, Supply Planning, and Other. They are also assigned to different levels of criticality: Low (blue), Medium (yellow), High (orange), and Critical (red). The criticality informs users the extent to which a problem affects the quality of the supply plan. However, regardless of criticality, all problems must be “In-compliance” or “Addressed” in the QAT Problem List in order for a program to be uploaded as a Final Version. There are five main statuses associated with the individual problems in the QAT Problem List:

  1. In-Compliance – Issue has been closed through data entry by the user. Status will be automatically changed, and notes are not required.

    Example – A planning unit is missing actual consumption in the last 3 months. A user enters actual consumption data for the last 3 months. QAT automatically marks this as 'in-compliance'.

  2. Resolved – Issue has been manually marked by reviewer as 'resolved'. The reviewer uses this status if this issue will unlikely be corrected via data entry and also does not require further notes in the future. Only a reviewer can mark an issue as 'resolved'.

    Example – A planning unit gets flagged for not following dynamic forecasting. The user enters a note that this planning unit does not follow dynamic forecasting as it is not a seasonal product. The reviewer marks this as resolved because the explanation will most likely not change in the future.

  3. Addressed – Issue has been manually marked by either reviewer or user as 'addressed'. The user applies this status when they cannot resolve the issue through data entry. This status must be accompanied by a note. The reviewer uses this status if this issue cannot be resolved in this review period, but will be resolved in the future, most likely in a few periods, rather than before the next review.

    Example – A planning unit being phased out only has 8 months of forecasted consumption in the future instead of 18. This is acceptable as it is a phasing out planning unit, but the user will still need to de-activate the planning unit once it is fully phased out, which is why the issue is marked as 'addressed' instead of 'resolved'.

  4. Open – This problem has been automatically flagged by QAT, or the problem has been manually marked by the reviewer as ‘Open’. The reviewer could use this status when rejecting a supply plan to indicate that the notes are not accepted.

    Example – A user has a planning unit that is missing actual consumption data in the last 3 months. QAT will automatically flag this as 'Open'. If the problem has been 'Addressed' when uploaded and approved, the problem will revert back to the 'Open' status for the next submission.

  5. Reviewed - The issue has been reviewed by the supply plan reviewer. This field is only editable by the supply plan reviewer.

G2. Closing and Addressing Problems​

  1. Closing a problem via data entry: to change an ‘Open’ problem to one that is ‘In-compliance,’ the user will need to complete the suggestion provided in the “Suggestion” column for the specific problem. For example, the suggestion may be to “provide actual consumption” for specific months. Thus, the user will need to:

    Closing a Problem Example Closing a Problem Example

    1. Navigate to the Consumption Data Entry screen by either clicking directly on the Problem (which will open a new QAT window) or by clicking on Supply Plan Data → Consumption Data.
    2. From the consumption data entry screen, the user will add actual consumption for the requested months. For instructions on how to add consumption, please refer to Consumption Data.
    3. Navigate back to the QAT Problem List and click Recalculate to refresh the QAT Problem List to include the most recent addition of actual consumption data. The previously flagged problem should now be “In-compliance” and no longer be flagged by the QAT Problem List.

    QAT Problem List Recalculate/Refresh FQAT Problem List Recalculate/Refresh

  2. Addressing a problem with a comment: If a problem that has been flagged in the QAT Problem List cannot be fixed and made 'In-compliance' through data entry as recommended in the "Suggestion" column, a user can provide a comment and manually change the status to "Addressed." For example, a planning unit may be overstock/understocked and the suggestion to "re-evaluate supply plan to meet the min/max parameters" is presented. If a user is unable to fix this problem via data entry, they will need to address the problem:

    1. Double-click on the Problem Status dropdown for that problem and choose "Addressed." Users must provide an explanatory note in the Notes column for all problems marked as "Addressed."

    Addressing a Problem &amp; Adding a Note Addressing a Problem & Adding a Note

    Note: the user can also see in the "Problem Transaction Details" screen by right clicking on the Problem. This area will show the user past notes, reviewers, dates reviewed, etc.

    Problem Transaction Right Click Figure Problem Transaction Right Click

    Problem Transaction Details Figure: Problem Transaction Details

    1. Click "Update." The QAT Problem List will now include the most recent addition of explanatory notes and the status.

G3. QAT Problem List: Explanation of Problems​

  • Missing recent actual consumption inputs (within the last 3 months) If a planning unit is missing recent actual consumption data inputs within the last three months, it will be flagged in the QAT Problem List. If the inputs are filled in for any of these last three months, whether it is one month or all three months, the problem will not be flagged by the system.

  • Any gaps in the last 6 months (actual consumption) QAT checks if a planning unit is missing a month or multiple months of recent actual consumption inputs between two actual consumption entries in the specified 6-month range. This problem is looking for accidental gaps in actual consumption inputs. If there is any gap in actual consumption data in the past 6 months, the QAT Problem List will flag this as an issue. For example, a user inputs actual consumption for September, October, and December. This will be flagged by the QAT Problem list because there is a gap of missing actual consumption inputs for November.

  • Missing recent inventory inputs (within the last 3 months) If a planning unit is missing recent actual inventory data inputs within the last three months, it will be flagged in the QAT Problem List. If the inputs are filled in for any of these last three months, whether it is one month or all three months, the problem will not be flagged by the system.

  • Supply Plan lacks forecasted consumption within the next 18 months If a planning unit is missing the forecasted consumption inputs for one or more months for a period of 18 months from the current month, QAT will flag it as a problem. QAT will check for gaps to ensure that all of the future 18 months have forecasted consumption values.

    Note: If there is a planning unit that is phasing out, it is recommended that the user puts zero as the forecasted consumption, until it is fully phased out, at which point the planning unit will need to be deactivated.

  • Shipments with received dates in the past QAT will check the receive dates of all shipments to see if any are in the past based on the current date. If the receive date for a shipment is in the past, it will be flagged in the QAT Problem List. For example, there is a planning unit with a receive date of September 30st, 2026. As this date is in the past, QAT will flag it, and the user will need to either change the shipment status to “Received” or change the receive date to one that is in the future.

    Note: there is a fourteen-day buffer time for QAT to recognize that the shipment receive date is in the past and for the problem to be flagged.

  • Shipments that should have been submitted by the target date QAT will check the estimated shipment dates, which are calculated based on the Program’s pre-defined lead times, to see if there are any shipments with an estimated “Submitted” date in the past. If the estimated shipment submitted date is in the past, it will be flagged in the QAT Problem List. For example, there is a planning unit with a target submitted date of October 15th, 2026. As this date is in the past, QAT will flag it, and the user will need to either change the shipment status to “Submitted” or change the receive date to one that is further in the future. Changing the receive date to one further in the future, will cause QAT to automatically recalculate the target shipment dates. If it is not possible to change the status or receive date, a user many ‘Address’ the problem (see Closing and Addressing Problems).

    Note: There is a fourteen-day buffer time for QAT to recognize that the shipment submitted date is in the past and for the problem to be flagged.

  • Dynamic forecasting is not used (for commodity groups Malaria, ARV, VMMC) For any products that belong to the following tracer categories: Malaria, ARV, or VMMC, QAT will check for dynamic forecasting. Forecasting best practices encourages forecasting with dynamic monthly values, in order to show that factors, such as seasonality, program scale-up, or campaigns have been taken into account. If a planning unit from one of these three commodity groups has four consecutive months with static consumption, it will be flagged in the QAT Problem List.

  • Supply Plan does not follow minimum/maximum parameters If a planning unit is overstocked, understocked or stocked out at any point during the next 18 months, it will be flagged in the QAT Problem List, denoting the exact months that are experiencing the issue. The QAT Problem List will also denote the number of shipments being received in the next 18 months.

    Plan by MOS: Overstocked is defined by MOS > Maximum MOS. Understocked is defined by MOS < Minimum MOS. See below for an example of a problem and the accompanying supply plan graph:

    Flagged in Sep 2026

    In the next 18 months, this supply plan is

    *OVER MAX for 13 month(s) (Jan-27 to Mar-27, Jul-27 to Apr-28)


    There are shipment(s) in Nov-26, May-27, Oct-27, Apr-28

    Supply Plan does not follow min/max MOS parameter example Supply Plan does not follow min/max MOS parameter example

    Note: If the MOS value for a given month is “N/A”, then all such instances are excluded while calculating the overstocked, understocked or stocked out problems.

    Plan by Quantity Example: Overstocked is defined by Ending Balance Quantity > Maximum Quantity. Understocked is defined by Ending Balance Quantity < Minimum Quantity. Note that QAT will only flag the overstock if this overstock occurs more than distribution lead time in a row (e.g. if lead time is 2 months, then QAT flags if there is an overstock more than 2 months in a row - but won’t flag the problem if the overstock every other month). See below for an example of a problem and the accompanying supply plan graph:

    Flagged in Feb 2021 (Distribution lead time is 1 month)

    In the next 1-6 months (Mar-23 to Aug-23), inventory is...

    * over the max stock qty + distribution lead time for 1 month(s)

    * under the min stock qty for 0 month(s)


    In the next 7-18 months (Sep-23 to Aug-24), inventory is...

    * over the max stock qty + distribution lead time for 6 month(s)

    * under the min stock qty for 0 month(s)

    Supply Plan does not follow min/max quantity parameter example Supply Plan does not follow min/max quantity parameter example

  • Other – Manual These are specific questions or clarifications manually entered by the supply plan reviewer that are not automatically flagged by QAT. These problems could be items that supply plan reviewer wants addressed that quarter before finalizing or a reminder for the next quarterly submission. The problem description, suggestion, and the criticality are determined by the supply plan reviewer.