Uploaded image for project: 'CFA MX '
  1. CFA MX
  2. CFAMX-8797

Forecast - Update Forecast Events to support new imported Actual , based on Net Sales

    Details

    • Type: Story
    • Status: Closed (View Workflow)
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
    • Sprint:
      CFAMX 2020R2 SA Sprint 5
    • SCRUM Team:
      Globogym Purple Cobras
    • Story Points:
      3
    • Work Type Classification:
      Sustaining

      Description

      As an Operator, I would like Forecast Events for any store using an AWS forecast to correctly use either Actual sales or Gross Actual (as implemented in INF-10956 INF-10956 - Story.pdf ) so that my Events are accurate

      Notes

      • Enhance the Forecast Events pipeline to use either the Actual or the Gross Actual, when updating the system forecast to account for events created for restaurants whose forecast is imported from AWS.
        • Note: No change is required for the Events Reversal as the reversal pipeline is skipped for imported forecasts
      • When the adjustment amount for a day included in an Auto Event is calculated, either the Gross Actual or Actual should be used, depending on how the forecast was generated
      • The Forecast Events for any days using the AWS Forecast should use the new formula defined in when determining Actual values to calculate the System forecast
      • Any store using the InFORM forecast values should continue to use the original formula.

      Acceptance Criteria

      1. Confirm that either the Actual or the Gross Actual values will be used when calculating Forecast Event Adjustment for days that are using Imported Forecasts.
        • InFORM generated = Net Sales = Actual
        • Imported + Net Sales = Net Sales = Actual
        • Imported + Gross Sales = Gross Actual
      2. Confirm that current Forecast Events logic remain the same for stores with InFORM generated forecast.
      3. Confirm that current Forecast Events logic remain the same for stores with imported forecasts based on Gross Actual.

        Attachments

        1. Event Profile Data.xlsx
          15 kB
          Colin Wyatt-Goodall
        2. ForecastingEvents.sql
          3 kB
          Colin Wyatt-Goodall
        3. INF-10956 - Story.pdf
          546 kB
          Will Englefield
        4. testing doc.docx
          125 kB
          Colin Wyatt-Goodall

          Issue Links

            Activity

              People

              • Assignee:
                will.englefield Will Englefield (Inactive)
                Reporter:
                will.englefield Will Englefield (Inactive)
              • Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 18h Original Estimate - 18h
                  18h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 32h 10m
                  32h 10m

                    PagerDuty

                    Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.