Production Qty Ranges Page - maple-dev-team/docs GitHub Wiki

Objective

Display list of Production Qty Ranges, which is used on the forecast production plan to get the production batch size for each item according to the product bottle size and the average sales qty.

Overview

Table Columns

• Bottle Size: Product size.
• Batch Size: Batch size name.
• Batch Size Volume: Batch size volume in ml.
• Bottles Qty: Quantity of bottles with the row bottle size that can be produced with the row batch size volume.
  • Rules: Formula = Batch Size Volume / Bottle Size.
• Avg Sales Lower Range: Lower value of the Average Sales Range, for which the row batch size is selected to be produced.
• Avg Sales Upper Range: Upper value of the Average Sales Range, for which the row batch size is selected to be produced.

Table Filters

The data can be filtered by the fields:

• Bottle Size
• Batch Size

Inputs

• Template Bottle Sizes: list of the product sizes that will be included on the downloaded Template file.
  • Rules: Allow multiple product sizes to be selected.

Page Actions

• Download Template: downloads a template spreadsheet with the columns that need to be present on the upload file. The rows of the template are automatically filled with a combination of the product sizes selected and the list of Batch Sizes available on the system.
  • Rules: Button active when at least one product size is selected.
• Upload file: validates and saves the information present on the file selected. The information uploaded will overwrite the information previously uploaded.
  • Rules: File must be a spreadsheet.
  • Upload Validation Rules: file row information will be saved if the following rules are fulfilled
    1. Bottle Size, Batch Size, Batch Size Qty, Avg Sales Lower Range and Avg Sales Upper Range must be filled.
    2. Bottle Size, Batch Size Qty, Avg Sales Lower Range and Avg Sales Upper must exist on the system.
    3. Batch Size must exist on the system.

---

Flow