• Created by Unknown User (wojsy@eg.dk), last modified on May 30, 2022

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 26 Next »

Description:

  • Report allows to follow up cashiers sale performance.

Selections:

  • Date from - Default today
  • Date to - Default today
  • Retail store from - Default 1
  • Retail store to - Default 1
  • Operator from - Default 0
  • Operator to - Default 999999

Output:

Item sale statistics showed individually per each cashier (with number between Operator from and Operator to) per each stores (with number between Retail store from and Retail store to).

Additionally there are totals for each cashier and each store.

Columns:

  • EAN
  • Item name
  • Quantity
  • Discount % - Share of discount amount in original prize
  • Gross profit
  • Gross profit % - (gross profit)/(sales ex. VAT)
  • Sales amount

Sorting:

  • EAN (default)
  • Qunatity (interactive)
  • Gross profit (interactive)

Source: Lindbak POS Reporting DW

Description:

Report allows to follow up bonus rollout checks usage and sales made using bonus checks.

Selections:

  • Year from (default last year)
  • Year to (default current year)
  • Bonus rollout name (default all) - report shows data for available rollouts within selected period
  • Loyalty program

Output:

Bonus checks usage and sales statistics grouped per store. Report lists all the stores in which checks were issued or redeemed.

Columns:

  • Store - StoreNumber - Store name
  • Number redeemed - Number of redeemed bonus checks issued in selected rollout(s)
  • Sum redeemed - Sum of redeemed bonus checks
  • Redeemed of total issued % - Share of redeemed bonus checks number for store compared to issued bonus checks number for all stores
  • Average sale - Average sale made using bonus checks

Sorting:

  • StoreNumber

Clarifications:

  • Check is considered redeemed even if it was only partialy used
  • Check is conntected to the store in which it was redeemed, not issued

Source: Lindbak POS Reporting cube (OLAP)

Description:

Report allows to follow up meber and member sale statistics divided by member age and member gender.

Selections: 

  • Date from - Default today
  • Date to - Default today
  • Retail store - Default all
  • Loyalty program

Output:

Report is devided in 5 sections:

  1. Graph and table showing number of members who joined in the selected date range, compared to the number of members who joined the year before.
  2. Sales statistics divided between members and not member customers
  3. Graph and table showing sales amount by gender and age groups
  4. Sale statistics divided by member seniority level
  5. Sale amount grouped per department, divided by gender

Columns: 

  • Section 1
    • This year - number of members who joined in the selected date range,
    • Last year - number of members who joined the year before selected date range 
  • Section 2
    • Num of receipts
    • Avg amount - (Sale amount)/(Num of receipts)
    • Items - number of items sold
    • Items/Cust - average number of sold items per customer
    • Gross profit
    • Gross profit % - Share of Gross profit in Sale amount
  • Section 3
    • Age group
    • Sales
    • Gross profit
    • Gross profit % - Share of Gross profit in Sale amount
  • Section 4
    • level - member characteristic
    • Num of receipts
    • Avg amount - (Sale amount)/(Num of receipts)
    • Items - number of items sold
    • Items/Cust - average number of sold items per customer
    • Gross profit
    • Gross profit % - Share of Gross profit in Sale amount
  • Section 5
    • Department - Department name
    • Female - Sale amount for scpecific department generated by women
    • Female % - Share of sale amount for scpecific department generated by women in all sales across all departments and all genders
    • Total -Sale amount for scpecific department
    • Total % - Share of sale amount for scpecific department  in all sales across all departments

Sorting:

  • Section 3 - Age group
  • Section 4 - Level
  • Section 5 - Department name

Clarifications:

  • This year, las year - if date range is 2020/01/01 - 2022-/01/01, then This year is 2020/01/01 - 2022-/01/01 and Last year is 2019/01/01 - 2021/01/01

Source:

  • Lindbak POS Reporting cube (OLAP)
  • Lindbak POS Reporting DW

Description:

Report allows to follow up article sales on multiple levels with possibility to select specific hourly intervals and exclude specific item groups.

Selections: 

  • Date from - Default today
  • Date to - Default today
  • Hour from - Default 0:00
  • Hour to - Default 24:00
  • Team - Default all
  • Store - Default all
  • Department - Default all
  • Article area - Default all
  • Article group - Default all
  • Include VAT - Default on
  • Exclude groups - Default false
  • Excluded groups - Appears when Exclude groups is switched to true

Output:

Article sale statistics for selected stores, for selected date interval and for selected time interval grouped by department, area and group.

By default data is shown for department and it is possible to drill down to item level manually by clicng plus button or by using expand all button to expand everithing to item level at once.

Columns: 

  • Buttons for expanding and collapsing all drilldowns.
  • EAN - EAN code
  • Item name - Article name
  • Quantity
  • Total- Quantity sold
  • Turnover inc. VAT or Turnover ex. VAT depending on selection.
  • Total - Amount sold. Inc. or ex. VAT depending on selection
  • Share - Share of this department / area / group / item related to total sale.
  • Cost price - Cost price
  • Gross profit
  • Total - Gross profit amount
  • Total % - Gross profit percentage.

Sorting:

  • Department number - age group
  • Item Area number - 
  • Item Group number
  • EAN

Clarifications:

  • Hour selection applies to each day in selected date period

Source: Lindbak POS Reporting cube (OLAP)

Description:

Report allows to find given number of best or worst selling items on multiple levels (amount, quantity, gross profit) in two date intervals. Possible to select specific hourly interval.

Selections: 

  • Date from - Default today
  • Date to - Default today
  • Compare date from - Default the same day of week as Date from year before
  • Compare date to- Default the same day of week as Date to but year before
  • Hour from - Default 0:00
  • Hour to - Default 24:00
  • Team - Default all
  • Store - Default all
  • Department - Default all
  • Article area - Default all
  • Article group - Default all
  • Number of items - Number of best or worst items to display - default 10
  • Sort type - worst or best - report will display given number of worst or best selling items - default best
  • Sort measure - amount/quantity/net cost/gross profit/gross profit % - set the measure on which the items are sorted. - default amount
  • Vendor - default all
  • Subvendor- default all
  • Include VAT - Default on
  • Exclude groups - Default false
  • Excluded groups - Appears when Exclude groups is switched to true

Output:

Sale statistics for selected number of best or worst items per store sorted by selected sort measure devided in two selected date intervals in selected hour range.

Columns: 

  • Store
  • Dept. - Department
  • Area
  • Grp. - Item group
  • EAN
  • Item name
  • Quantity
  • Turnover ex. VAT
  • Gross profit
  • Gross profit %
  • Num of receipts

Sorting:

  • Selected sort measure

Clarifications:

  • Hour selection applies to each day in selected date period

Source:

  • Lindbak POS Reporting cube (OLAP)
  • Lindbak POS Reporting DW
  • No labels