/
Fulfillment Hourly Dashboard

Fulfillment Hourly Dashboard

Owned by Albert Saludaga
Last updated: Dec 19, 2023

This report displays various graphs and insights for a certain date that contain the number of invoices made, the hours spent, and the workload weight for each employee. Also generates a table for the order types processed during the date.

The Just In Time (JIT) Production section displays 3 graphs: 2 for Fulfillment (Count of How Old, Percentage) and 1 for Order Types.

Report Definition

  1. Author Name

    1. April Dianne Gahuman

  2. Presentation Medium

    1. SSRS Portal

  3. Fields (Data)

    1. Today’s Fulfillment

      1. Representative Name

      2. Invoice Count

      3. Hours

      4. Workload Weight

    2. Order Types Processed

      1. Order Type

      2. Invoice Count

      3. Completed

      4. % Completed

      5. Labor Hours

      6. Labor Hours Needed

      7. Labor Hours Diff

      8. Grand Total

    3. Just In Time (JIT) Production

      1. Fulfillment

        1. Count of How Old

        2. Days

      2. Order Types

        1. Days Old

        2. Order Type

  4. Grouping

    1. Today’s Fulfillment

      1. Representative Name

    2. Order Types Processed

      1. Order Type

    3. Order Types

      1. Order Type

      2. Days Old

    4. Fulfillment

      1. Days Old

  5. Intentions for printing vs. online viewing

    1. The report is delivered via SSRS

    2. This report can be accessed here: TBPortal → SSRS Reports → Operations → Fulfillment Hourly Dashboard

  6. Intended delivery mechanism (run on demand vs. delivered by subscription)

    1. On-Demand

  7. Future maintenance tasks or manually maintained items

    1. N/a

Data Source(s)

The data sources for this report are the DataWarehouse_209 Database and the Eibo-215 Database.

View:
[DataWarehouse].[dbo].[FulfillmentView]

Filters

Filter Name

Description

Filter Name

Description

Date

This field lets you select from a datepicker the desired date.

Calculations

 

Calculation

Description

 

Calculation

Description

Today’s Fulfillment

Hours

SUM(CASE
WHEN cte.RepresentativeName LIKE '%AUTOMATED%' THEN 0
ELSE cte.TimeMin/60
END)

Returns the total of hours processing the invoices made by each representative

Workload Weight

SUM(cte.TimeMin) / (SELECT SUM(cte2.TimeMin) FROM CTE cte2)

Returns the percentage of the workload weight for each representative

Order Types Processed

Invoice Count

SUM(InvoiceCount)

Returns the total invoices for each order type

% Complete

COUNT(DISTINCT YesterdaysProcessedInvoices) / SUM(InvoiceCount)

Calculates the percentage of processed invoices from the number of Total Invoices for each order type.

Labor Hours

SUM(LaborHrs)

Adds all the labor hours for each order type.

Labor Hours Needed

SUM(LaborHoursNeeded)

Adds all the labor hours needed for each order type.

Labor Hours Diff

SUM(LaborHoursNeeded) - SUM(LaborHrs)

Subtracts the total labor hours needed from the total hours for each order type.

Grand Total (row)

SUM()

The last row in the table that adds all the value for each column.

Just In Time (JIT) Production

Order Types

Order Type

SUM(cte2.InvoiceCount)

Gives the total for each order type.

Fulfillment

Total How Old

SUM(cte.HowOld)

Gets the total how old.

Count of How Old

SUM(cte2.HowOld)

Counts the number of invoices aged on each day.

 

Related content