Skip Headers
Oracle® Retail Data Model Reference
Release 11.3.2

Part Number E20361-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

12 Oracle Retail Data Model Sample Reports

This chapter provides Oracle Retail Data Model sample reports.

This chapter includes the following sections:

Customer Reports

The customer reports include the following:

Demography

The demography area includes the following reports.

Customer Demographics by Income Band and Household Size

Figure 12-1 provides count and sales information based on income band range. You can compare customer sales count, sales amount and % sales amount for each income band range.

Report dimensions are:

  • Business Time

  • Household Size Band Range

  • Organization

Figure 12-1 Customer Demographics by Income Band and Household Size Report

Description of Figure 12-1 follows
Description of "Figure 12-1 Customer Demographics by Income Band and Household Size Report"

Frequent Shopper

The frequent shopper area includes the following reports: Frequent Shopper Penetration, Frequent Shopper Sales Analysis, Frequent Shopper Transactions, and Frequent Shopper Distribution.

Frequent Shopper Penetration

Figure 12-2 shows frequent shopper transaction as percent of total transactions (time series analysis).

Report dimensions are:

  • Business Time

  • Organization

Figure 12-2 Frequent Shopper Penetration Report

Description of Figure 12-2 follows
Description of "Figure 12-2 Frequent Shopper Penetration Report"

Frequent Shopper Sales Analysis

Figure 12-3 shows how much the frequent shoppers contribute to total sales (by item-class).

Report dimensions are:

  • Business Time

  • Product

Figure 12-3 Frequent Shopper Sales Analysis

Description of Figure 12-3 follows
Description of "Figure 12-3 Frequent Shopper Sales Analysis"

Frequent Shopper Transactions

Figure 12-4 provides frequent shopper transactions.

Report dimensions are:

  • Business Time

  • Organization

Figure 12-4 Frequent Shopper Transactions

Description of Figure 12-4 follows
Description of "Figure 12-4 Frequent Shopper Transactions"

Frequent Shopper Distribution

Figure 12-5 frequent shopper distribution.

Report dimensions are:

  • Business Time

  • Customer

Figure 12-5 Frequent Shopper Distribution Report

Description of Figure 12-5 follows
Description of "Figure 12-5 Frequent Shopper Distribution Report"

RFMP and Cluster

The RFMP & Cluster area includes the following reports: RFM Scoring, RFMP Trending, Cluster Analysis, and Frequency Defection.

RFM Scoring

Figure 12-6 provides RFMP groupings statistics over time.

Report dimensions are:

  • Business Time

  • Customer

Figure 12-6 RFM Scoring Report

Description of Figure 12-6 follows
Description of "Figure 12-6 RFM Scoring Report"

RFMP Trending

This report, as shown in Figure 12-7 provides month to month RFMP group migration.

Report dimensions are:

  • Business Time

  • Customer

Figure 12-7 RFMP Trending Report

Description of Figure 12-7 follows
Description of "Figure 12-7 RFMP Trending Report"

Cluster Analysis

This report, as shown in Figure 12-8 provides sales and time information by customer cluster and product cluster.

Report dimensions are:

  • Business Time

  • Customer

  • Product

Figure 12-8 Cluster Analysis

Description of Figure 12-8 follows
Description of "Figure 12-8 Cluster Analysis"

Frequency Defection

Figure 12-9 provides customer information for those at risk of defection based on frequency segment. The end user can view a list of frequency detection value and frequency segment of customers.

Report dimensions are:

  • Business Time

  • Customer

Figure 12-9 Frequency Defection

Description of Figure 12-9 follows
Description of "Figure 12-9 Frequency Defection"

Customer Analysis

The customer analysis area includes the following reports: Customer Loyalty DT Profile, Customer Loyalty Factor Rank, Customer Loyalty Prediction, Customer Segmentation, and Customer Segmentation Details.

Customer Loyalty DT Profile

Figure 12-10 shows customer loyalty prediction Value Decision Tree rules generated by DT mining model (by DT).

Report dimensions are:

  • Business Time

  • Customer

Figure 12-10 Customer Loyalty DT Profile

Description of Figure 12-10 follows
Description of "Figure 12-10 Customer Loyalty DT Profile"

Customer Loyalty Factor Rank

Figure 12-11 provides customer information for customer loyalty analysis with attribute ranking with SVM Factors.

Report dimensions are:

  • Business Time

  • Customer

Figure 12-11 Customer Loyalty Factor Rank

Description of Figure 12-11 follows
Description of "Figure 12-11 Customer Loyalty Factor Rank"

Customer Loyalty Prediction

Figure 12-12 shows customer loyalty prediction (by SVM and DT).

Report dimensions are:

  • Business Time

  • Customer

Figure 12-12 Customer Loyalty Prediction Report

Description of Figure 12-12 follows
Description of "Figure 12-12 Customer Loyalty Prediction Report"

Customer Segmentation

Figure 12-13 provides This report provides segment analysis of customers.

Report dimensions are:

  • Business Time

  • Customer

Figure 12-13 Customer Segmentation Report

Description of Figure 12-13 follows
Description of "Figure 12-13 Customer Segmentation Report"

Customer Segmentation Details

Figure 12-14 provides customer information by a selected segment.

Report dimensions are:

  • Business Time

  • Customer

Figure 12-14 Customer Segmentation Details Report

Description of Figure 12-14 follows
Description of "Figure 12-14 Customer Segmentation Details Report"

Promotion Reports

The promotion reports include the following:

Actual and Plan

The actual and plan area includes the following reports: Promotion Planning, Promotion Comparison, and Promotional Forecast Planning.

Promotion Planning

Figure 12-15 provides promotion planning information.

Report dimensions are:

  • Business Time

Figure 12-15 Promotional Planning

Description of Figure 12-15 follows
Description of "Figure 12-15 Promotional Planning"

Promotion Comparison

Figure 12-16 provides response rate information for customers in the target group, all of whom received promotion, by frequency segment.

Report dimensions are:

  • Business Time

  • Promotion

Figure 12-16 Promotion Comparison

Description of Figure 12-16 follows
Description of "Figure 12-16 Promotion Comparison"

Promotional Forecast Planning

Figure 12-17 provides response rate information for customers in the target group, all of whom received promotion, by frequency segment.

Report dimensions are:

  • Business Time

  • Promotion

Figure 12-17 Promotional Forecast Planning

Description of Figure 12-17 follows
Description of "Figure 12-17 Promotional Forecast Planning"

Performance

The performance area includes the following reports: Contribution by Promotion Event Type, Promotion Scorecard, Promotional Performance, and Promotion Impact.

Contribution by Promotion Event Type

Figure 12-18 provides response rate information for customers in the target group, all of whom received promotion, by frequency segment.

Report dimensions are:

  • Business Time

  • Organization

  • Promotion

Figure 12-18 Contribution by Promotion Event Type Store

Description of Figure 12-18 follows
Description of "Figure 12-18 Contribution by Promotion Event Type Store"

Promotion Scorecard

Figure 12-19 provides information on promotion sales and results.

Report dimensions are:

  • Business Time

  • Organization

  • Promotion

Figure 12-19 Promotion Scorecard Report

Description of Figure 12-19 follows
Description of "Figure 12-19 Promotion Scorecard Report"

Promotional Performance

Figure 12-20 provides response rate information for customers in the target group, all of whom received promotion, by frequency segment.

Report dimensions are:

  • Business Time

  • Promotion

Figure 12-20 Promotional Performance Report

Description of Figure 12-20 follows
Description of "Figure 12-20 Promotional Performance Report"

Promotion Impact

Figure 12-21 provides on promotion sales and results.

Report dimensions are:

  • Business Time

  • Promotion

Figure 12-21 Promotion Impact Report

Description of Figure 12-21 follows
Description of "Figure 12-21 Promotion Impact Report"

Response

Figure 12-22 provides response rate information for customers in the target group, all of whom received promotion, by frequency segment.

Report dimensions are:

  • Business Time

  • Promotion

Figure 12-22 Response Report

Description of Figure 12-22 follows
Description of "Figure 12-22 Response Report"

Category Reports

The category reports include the following areas:

Contribution

The contribution area includes the following reports: Scorecard, Item Profit on Cost, Pack Sales, Profit on Net Cost, Cost Trend, Class Item Level Profit.

Scorecard

This report, as shown in Figure 12-23 provides sales contribution information based on department. The end user can compare last year compared to current year scorecard sales contribution for each department, class and subclass.

Report dimensions are:

  • Business Time

  • Product

Figure 12-23 Contribution Scorecard

Description of Figure 12-23 follows
Description of "Figure 12-23 Contribution Scorecard"

Item Profit on Cost

This report, as shown in Figure 12-24 provides item percent profit on base cost and net cost to department information. The end user can compare the %Contribution Profit on Base Cost and Net Cost of a department with last year's metrics.

Report dimensions are:

  • Business Time

  • Product

Figure 12-24 Item Profit on Cost Report

Description of Figure 12-24 follows
Description of "Figure 12-24 Item Profit on Cost Report"

Pack Sales

Figure 12-25 provides the yearly sales information of packaged items for each item.

Report dimensions are:

  • Business Time

  • Product

  • Organization

Figure 12-25 Pack Sales Report

Description of Figure 12-25 follows
Description of "Figure 12-25 Pack Sales Report"

Profit on Net Cost

Figure 12-26 provides item percent profit on net cost information for each in a department. The end user can compare the %Profit Contribution on Net Cost for stores in a department with last year's metrics.

Report dimensions are:

  • Business Time

  • Product

  • Organization

Figure 12-26 Profit on net Cost Contribution Report

Description of Figure 12-26 follows
Description of "Figure 12-26 Profit on net Cost Contribution Report"

Cost Trend

Figure 12-27 provides information on item to category sales and market sales contribution. The end user can see a list of %base cost, net cost, net-net cost and dead net cost for each item.

Report dimensions are:

  • Business Time

  • Product

  • Organization

  • Vendor

Figure 12-27 Cost Trend Report

Description of Figure 12-27 follows
Description of "Figure 12-27 Cost Trend Report"

Class Item Level Profit

Figure 12-28 provides class-wise item level profit information. The end user can compare the %Profit on Net Cost, %Profit on Net-Net Cost and %Profit on Dead Net Cost for item in a class with last year's metrics.

Report dimensions are:

  • Business Time

  • Product

Figure 12-28 Class Item Level Profit Contribution Report

Description of Figure 12-28 follows
Description of "Figure 12-28 Class Item Level Profit Contribution Report"

Performance

The performance area includes the following reports: Bottom Performance by Sales, Space Performance, Bottom Performance % Profit, Top Performance, and Top by Store.

Bottom Performance by Sales

Figure 12-29 provides "Bottom 10 Performing Items By Sales Amount information for each year. The end user can compare EOH and BOH retail value and %Profit Amount for items with last year's metrics.

Report dimensions are:

  • Business Time

  • Product

Figure 12-29 Bottom Performance by Sales

Description of Figure 12-29 follows
Description of "Figure 12-29 Bottom Performance by Sales"

Space Performance

Figure 12-30 provides information on space allocation, sales, profit and contribution for items of current year compared to last year.

Report dimensions are:

  • Business Time

  • Product

Figure 12-30 Space Performance

Description of Figure 12-30 follows
Description of "Figure 12-30 Space Performance"

Bottom Performance % Profit

Figure 12-31 provides "Bottom Performing Items By % Profit" information for each year. The end user can compare EOH and BOH retail value and %Profit Amount for items with last year's metrics.

Report dimensions are:

  • Business Time

  • Product

Figure 12-31 Bottom Performing Items by % Profit Report

Description of Figure 12-31 follows
Description of "Figure 12-31 Bottom Performing Items by % Profit Report"

Top Performance

Figure 12-32 provides list of the top ten items based on sales. The information enables effective assortment efficiency and product positioning initiatives. The end user can compare the performer with last year's metrics such as: Sales Value, Sales Value LY, %Chg Sales Value Vs LY, Profit Amt, Profit Amt, Profit LY, %Contrib. Sales Value to Category, % Chg Profit Vs LY, %Contrib. Profit to Category.

Report dimensions are:

  • Business Time

  • Product

Figure 12-32 Top Performance Report

Description of Figure 12-32 follows
Description of "Figure 12-32 Top Performance Report"

Top by Store

Figure 12-33 provides the top store performance.

Report dimensions are:

  • Business Time

  • Product

Figure 12-33 Top Selling Department by Store Report

Description of Figure 12-33 follows
Description of "Figure 12-33 Top Selling Department by Store Report"

Pricing

The pricing area includes the following reports: Product Pricing and Organization Pricing.

Product Pricing

Figure 12-34 provides pricing information based on sales, price, and inventory measures, by product.

Report dimensions are:

  • Business Time

  • Organization

Figure 12-34 Product Pricing Detail Report

Description of Figure 12-34 follows
Description of "Figure 12-34 Product Pricing Detail Report"

Organization Pricing

Figure 12-35 provides pricing information based on sales, price and inventory measures, by organization.

Report dimensions are:

  • Business Time

  • Organization

Figure 12-35 Organization Pricing Detail Report

Description of Figure 12-35 follows
Description of "Figure 12-35 Organization Pricing Detail Report"

Price Analysis

Figure 12-36 provides price analysis information. The report enables comparison of product pricing for stores and items.

Report dimensions are:

  • Business Time

  • Product

Figure 12-36 Price Analysis Report

Description of Figure 12-36 follows
Description of "Figure 12-36 Price Analysis Report"

Product Analysis

The product analysis area includes the following reports: Sales by Banner, Listing (Bottom), Sales by Channel, and Listing by Category.

Sales by Banner

Figure 12-37 provides sales value organized by department and banner. The end user can compare the department, sales value and organization banner with last year's metrics.

Report dimensions are:

  • Business Time

  • Product

  • Organization

Figure 12-37 Department Sales By Banner Report

Description of Figure 12-37 follows
Description of "Figure 12-37 Department Sales By Banner Report"

Listing (Bottom)

Figure 12-38 provides list of the bottom ten percent of items per category a retailer carries, based on sales value.

The end user can view a list of category-wise items, EOH units, no of days with stocks, sales value, sales value LY, %chg sales value compared to LY, % contrib. sales value to department, percent contrib. profit amt to department, profit amt, profit LY, %chg profit against LY, % contrib. profit amt department for a given year.

Report dimensions are:

  • Business Time

  • Product

  • Organization

Figure 12-38 Candidates for Delisting (Bottom 10% SV) Report

Description of Figure 12-38 follows
Description of "Figure 12-38 Candidates for Delisting (Bottom 10% SV) Report"

Sales by Channel

Figure 12-39 provides sales value information by department and channel. You can compare the sales values in lieu of channel type and department with last year's metrics.

Report dimensions are:

  • Business Time

  • Product

  • Channel Type

Figure 12-39 Sales by Channel Report

Description of Figure 12-39 follows
Description of "Figure 12-39 Sales by Channel Report"

Listing by Category

Figure 12-40 provides list of the bottom ten percent of items per category a retailer carries, based on sales value.

Report dimensions are:

  • Business Time

  • Product

  • Organization

Figure 12-40 Listing by Category Report

Description of Figure 12-40 follows
Description of "Figure 12-40 Listing by Category Report"

Sales Analysis

The sales analysis area includes the following reports: Sales by Channel, Cross Sell Analysis, and Vendor Sales by Channel.

Sales by Channel

This report, as shown in Figure 12-41 provides sales information by channel. You can view a list of customer and sales value for each channel type for a business year.

Report dimensions are:

  • Business Time

  • Channel Type

Figure 12-41 Sales by Channel Report

Description of Figure 12-41 follows
Description of "Figure 12-41 Sales by Channel Report"

Cross Sell Analysis

This report, as shown in Figure 12-42 provides potential of items that have affinity to the customer selected.

Report dimensions are:

  • Business Time

  • Product

Figure 12-42 Cross Sell Profit Potential by Item

Description of Figure 12-42 follows
Description of "Figure 12-42 Cross Sell Profit Potential by Item"

Vendor Sales by Channel

This report, as shown in Figure 12-43 provides vendor sales by channel information. The end user can compare vendor sales value for each channel type with last year's metrics.

Report dimensions are:

  • Business Time

  • Vendor

  • Channel Type

Figure 12-43 Vendor Sales by Channel Report

Description of Figure 12-43 follows
Description of "Figure 12-43 Vendor Sales by Channel Report"

Sales and Profit

The sales and profit area includes the following reports: Gross Profit, Sales Profit Return by Channel (with store for local values), Sales Profit & Return by Channel, Sales Profit by Product Cluster, Product Cluster Sales and Profit, Sales & Profit by Customer Cluster, and Sales Profit & Return by Location Trait.

Gross Profit

This report, as shown in Figure 12-44, provides "gross profit by department" information. The end user can compare the current year to the previous year profit on net-net cost measures at the item department level.

Report dimensions are:

  • Business Time

  • Product

Figure 12-44 Gross Profit by Department Report

Description of Figure 12-44 follows
Description of "Figure 12-44 Gross Profit by Department Report"

Sales Profit Return by Channel (with store for local values)

This report, as shown in Figure 12-45 provides sales, profit and returns information by channel. The end user can compare sales value, profit, %profit, return value for channel type and stores with last year's metrics.

Report dimensions are:

  • Business Time

  • Channel Type

  • Organization

Figure 12-45 Sales, Profit, and Returns by Channel (Local) Report

Description of Figure 12-45 follows
Description of "Figure 12-45 Sales, Profit, and Returns by Channel (Local) Report"

Sales Profit & Return by Channel

This report, as shown in Figure 12-46 provides sales, profit, and returns information by channel in local currency. The end user can compare sales value, profit amt, and return value, % profit amt for channel types with last year's metrics.

Report dimensions are:

  • Business Time

  • Channel Type

Figure 12-46 Sales, Profit and Returns by Channel Report

Description of Figure 12-46 follows
Description of "Figure 12-46 Sales, Profit and Returns by Channel Report"

Sales Profit by Product Cluster

This report, as shown in Figure 12-47 provides sales and profit information by product cluster. The end user can view a list of sales value, profit amt, %profit amt for items in a product cluster.

Report dimensions are:

  • Business Time

  • Product

Figure 12-47 Item Sales and Profit by Product Cluster Report

Description of Figure 12-47 follows
Description of "Figure 12-47 Item Sales and Profit by Product Cluster Report"

Product Cluster Sales and Profit

This report, as shown in Figure 12-48 provides sales and profit information by product cluster. The end user can view a list of sales value, profit amt, %profit amt for items in a product cluster.

Report dimensions are:

  • Business Time

  • Product

Figure 12-48 Product Cluster Sales & Profit Report

Description of Figure 12-48 follows
Description of "Figure 12-48 Product Cluster Sales & Profit Report"

Sales & Profit by Customer Cluster

This report, as shown in Figure 12-49 provides sales and profit information by customer cluster and customer spending habits. The end user can compare sales value, profit amt and %profit amt for each customer cluster with last year's metrics.

Report dimensions are:

  • Business Time

  • Customer

Figure 12-49 Sales and Profit by Customer Cluster Report

Description of Figure 12-49 follows
Description of "Figure 12-49 Sales and Profit by Customer Cluster Report"

Sales Profit & Return by Location Trait

This report, as shown in Figure 12-50 provides sales, profit and returns information based on location trait. The end user can compare current year against last year sales value, profit amount, return value, %profit amt for the store types.

Report dimensions are:

  • Business Time

  • Organization

Figure 12-50 Sales Profit and Returns by Location Trait Report

Description of Figure 12-50 follows
Description of "Figure 12-50 Sales Profit and Returns by Location Trait Report"

Product Price Elasticity

The product price elasticity area includes the following reports: Sales Prediction - Batch Mode and Dynamic Sales Prediction.

Sales Prediction - Batch Mode

This report, as shown in Figure 12-51 provides sales prediction.

Report dimensions are:

  • Product

  • Organization

  • Business Time

Figure 12-51 Product Price Elasticity Sales Prediction Batch Mode Report

Description of Figure 12-51 follows
Description of "Figure 12-51 Product Price Elasticity Sales Prediction Batch Mode Report"

Dynamic Sales Prediction

This report, as shown in Figure 12-52 provides dynamic sales prediction.

Report dimensions are:

  • Product

  • Organization

  • Business Time

Figure 12-52 Product Price Elasticity Dynamic Sales Prediction Report

Description of Figure 12-52 follows
Description of "Figure 12-52 Product Price Elasticity Dynamic Sales Prediction Report"

Product Category Mix

The product category mix area includes the following reports: Product Category Mix, Product Set Rank by Support, and Product Set Rank by Probability.

Product Category Mix

This report, as shown in Figure 12-53 provides information on product categories.

Report dimensions are:

  • Product

  • Organization

  • Business Time

Figure 12-53 Product Category Mix Report

Description of Figure 12-53 follows
Description of "Figure 12-53 Product Category Mix Report"

Product Set Rank by Support

This report, as shown in Figure 12-54 provides sales prediction.

Report dimensions are:

  • Product

  • Organization

  • Business Time

Figure 12-54 Product Category Mix Product Set Rank by Support Report

Description of Figure 12-54 follows
Description of "Figure 12-54 Product Category Mix Product Set Rank by Support Report"

Product Set Rank by Probability

This report, as shown in Figure 12-55 provides sales prediction.

Report dimensions are:

  • Product

  • Organization

  • Business Time

Figure 12-55 Product Category Mix Product Set Rank by Probability Report

Description of Figure 12-55 follows
Description of "Figure 12-55 Product Category Mix Product Set Rank by Probability Report"

Merchandise Reports

The merchandise reports include the following:

Flow Analysis

The flow analysis area includes the following reports: Fast Moving Items, Store Sales Flash Compared with Last Year, Department Chain Sales Flash, and Store Sales Flash.

Fast Moving Items

This report, as shown Figure 12-56 provides the year week-level "Fast Moving Items" information for each Store which can be compared with last year's metrics such as "Sales Units", "CP Sales Units", or "% Increase in Sales to Planned".

Report dimensions are:

  • Business Time

  • Product

  • Organization

Figure 12-56 Merchandise Flow Analysis Fast Moving Items Report

Description of Figure 12-56 follows
Description of "Figure 12-56 Merchandise Flow Analysis Fast Moving Items Report"

Store Sales Flash Compared with Last Year

This report, as shown Figure 12-57 provides the store sales flash comparison.

Report dimensions are:

  • Business Time

  • Product

  • Organization

Figure 12-57 Store Sales Flash Compared with Last Year Report

Description of Figure 12-57 follows
Description of "Figure 12-57 Store Sales Flash Compared with Last Year Report"

Department Chain Sales Flash

This report, as shown Figure 12-58 provides the department chain sales flash.

Report dimensions are:

  • Business Time

  • Product

  • Organization

Figure 12-58 Department Chain Sales Flash Report

Description of Figure 12-58 follows
Description of "Figure 12-58 Department Chain Sales Flash Report"

Store Sales Flash

This report, as shown Figure 12-59 provides provides the store sales flash.

Report dimensions are:

  • Business Time

  • Product

  • Organization

Figure 12-59 Store Sales Flash Report

Description of Figure 12-59 follows
Description of "Figure 12-59 Store Sales Flash Report"

Margin Contribution

The margin contribution area includes the following reports: Sales Analysis, Contribution to Chain, Organization Sales and Profit, Sales and Stock, Sales, Profit and Return Store, and Sales, Return and Profit Channel.

Sales Analysis

This report, as shown in Figure 12-60 provides sales and profit information compared to last year, by product.

Report dimensions are:

  • Business Time

  • Product

Figure 12-60 Margin Contributions Product, Sales, Profit Value Against Last Year Report

Description of Figure 12-60 follows
Description of "Figure 12-60 Margin Contributions Product, Sales, Profit Value Against Last Year Report"

Contribution to Chain

This report, as shown in Figure 12-61 provides area contribution to sales value for a chain.

Report dimensions are:

  • Business Time

  • Organization

Figure 12-61 Margin Contribution to Chain Report

Description of Figure 12-61 follows
Description of "Figure 12-61 Margin Contribution to Chain Report"

Organization Sales and Profit

This report, as shown in Figure 12-62 provides sales, inventory and variance measures chain Manager and department.

Report dimensions are:

  • Business Time

  • Organization

Figure 12-62 Margin Contribution Organization Sales and Profit Report

Description of Figure 12-62 follows
Description of "Figure 12-62 Margin Contribution Organization Sales and Profit Report"

Sales and Stock

This report, as shown in Figure 12-63 provides sales, inventory and variance measures chain Manager and department.

Report dimensions are:

  • Business Time

  • Organization

  • Product

Figure 12-63 Margin Contribution Sales and Stock

Description of Figure 12-63 follows
Description of "Figure 12-63 Margin Contribution Sales and Stock"

Sales, Profit and Return Store

This report, as shown in Figure 12-64 provides sales, profit and return information based on store trait.

Report dimensions are:

  • Business Time

  • Organization

Figure 12-64 Margin Contribution Sales, Profit and Return by Store Trait Report

Description of Figure 12-64 follows
Description of "Figure 12-64 Margin Contribution Sales, Profit and Return by Store Trait Report"

Sales, Return and Profit Channel

This report, as shown in Figure 12-65 provides sales, profit and return information by channel.

Report dimensions are:

  • Business Time

  • Organization

Figure 12-65 Margin Contribution Sales, Profit and Returns by Channel Report

Description of Figure 12-65 follows
Description of "Figure 12-65 Margin Contribution Sales, Profit and Returns by Channel Report"

Performance

The performance area includes the following reports: Contract Detail by Item, Vendor, Top Performance, Vendor Product Summary, Commitment Summary, Daily Performance, Monthly Performance, Pack Compared to Standalone Sales, Vendor Performance, Delivery and Timeliness, and Zero Selling.

Contract Detail by Item

This report, as shown in Figure 12-66 contract detail by item. performance.

Report dimensions are:

  • Business Time

  • Product

  • Contract

Figure 12-66 Contract Detail by Item Report

Description of Figure 12-66 follows
Description of "Figure 12-66 Contract Detail by Item Report"

Vendor

This report, as shown in Figure 12-67 provides comparison for all supplier compliance and rating measure for current year compared to last year.

Report dimensions are:

  • Business Time

  • Vendor

  • Product

Figure 12-67 Performance Vendor Report

Description of Figure 12-67 follows
Description of "Figure 12-67 Performance Vendor Report"

Top Performance

This report, as shown in Figure 12-68 provides the information about the top performance by vendors in delivery accuracy & timeliness.

Report dimensions are:

  • Business Time

  • Vendor

Figure 12-68 Margin Contribution Top Performance

Description of Figure 12-68 follows
Description of "Figure 12-68 Margin Contribution Top Performance"

Vendor Product Summary

This report, as shown in Figure 12-69 provides unit sales, inventory and return measures by supplier, item and vendor product number.

Report dimensions are:

  • Business Time

  • Vendor

  • Product

Figure 12-69 Vendor Product Summary Report

Description of Figure 12-69 follows
Description of "Figure 12-69 Vendor Product Summary Report"

Commitment Summary

This report, as shown in Figure 12-70 provides commitment summary.

Report dimensions are:

  • Business Time

  • Vendor

  • Department

Figure 12-70 Performance Commitment Summary

Description of Figure 12-70 follows
Description of "Figure 12-70 Performance Commitment Summary"

Daily Performance

This report, as shown in Figure 12-71 provides daily store performance information based on transaction sales and profit measures for this day, last week, and last year.

Report dimensions are:

  • Business Time

  • Organization

Figure 12-71 Daily Performance Report

Description of Figure 12-71 follows
Description of "Figure 12-71 Daily Performance Report"

Monthly Performance

This report, as shown in Figure 12-72 provides monthly store performance information based on transaction sales and profit measures compared to last year and plan.

Report dimensions are:

  • Business Time

  • Organization

Figure 12-72 Monthly Performance Trend Report

Description of Figure 12-72 follows
Description of "Figure 12-72 Monthly Performance Trend Report"

Pack Compared to Standalone Sales

This report, as shown in Figure 12-73 compares and provides the yearly sales information of packed items with standalone items.

Report dimensions are:

  • Business Time

  • Product

Figure 12-73 Pack Compared to Standalone Sales

Description of Figure 12-73 follows
Description of "Figure 12-73 Pack Compared to Standalone Sales"

Vendor Performance

This report, as shown in Figure 12-74 compares and provides the yearly sales information of packed items with standalone items. This report provides the yearly, monthly "Vendor's performance" information for each vendor and item.

Report dimensions are:

  • Business Time

  • Product

Figure 12-74 Vender Performance Report

Description of Figure 12-74 follows
Description of "Figure 12-74 Vender Performance Report"

Delivery and Timeliness

This report as shown in Figure 12-75, provides the timeliness details for each product division vendor.

Report dimensions are:

  • Business Time

  • Vendor

Figure 12-75 Delivery and Timeliness Report

Description of Figure 12-75 follows
Description of "Figure 12-75 Delivery and Timeliness Report"

Zero Selling

This report as shown in Figure 12-76 provides the timeliness details for each product division vendor.

Report dimensions are:

  • Business Time

  • Vendor

Figure 12-76 Zero Selling Report

Description of Figure 12-76 follows
Description of "Figure 12-76 Zero Selling Report"

Sales Analysis

The sales analysis area includes the following reports: Product Sales & Return, Item Profit, Net Cost, Net Profit, Department Sales, Vendor Sales, Spatial Sales, and Markdown.

Product Sales & Return

This report, as shown in Figure 12-77 provides sales, return and profit by product.

Report dimensions are:

  • Business Time

  • Product

Figure 12-77 Sales Analysis Product Sales and Return Report

Description of Figure 12-77 follows
Description of "Figure 12-77 Sales Analysis Product Sales and Return Report"

Item Profit

This report, as shown in Figure 12-78 provides the item profit of net cost contribution and base cost contribution.

Report dimensions are:

  • Business Time

  • Product

Figure 12-78 Sales Analysis Item, Profit Base Cost Contribution and net Cost Contribution Report

Description of Figure 12-78 follows
Description of "Figure 12-78 Sales Analysis Item, Profit Base Cost Contribution and net Cost Contribution Report"

Net Cost, Net Profit

This report, as shown in Figure 12-79 provides yearly, monthly net sales and profit details for each vendor, item.

Report dimensions are:

  • Business Time

  • Organization

  • Product

  • Vendor

Figure 12-79 Sales Analysis Net Cost and Net Profit Report

Description of Figure 12-79 follows
Description of "Figure 12-79 Sales Analysis Net Cost and Net Profit Report"

Department Sales

This report, as shown in Figure 12-80 provides sales value organized by department and banner. This report allows analysis of banner sales by department.

Report dimensions are:

  • Business Time

  • Product

Figure 12-80 Sales Analysis Department Sales Report

Description of Figure 12-80 follows
Description of "Figure 12-80 Sales Analysis Department Sales Report"

Vendor Sales

This report, as shown in Figure 12-81 provides the sales value by different channel like distribution and selling.

Report dimensions are:

  • Business Time

  • Product

Figure 12-81 Sales Analysis Vendor Sales Report

Description of Figure 12-81 follows
Description of "Figure 12-81 Sales Analysis Vendor Sales Report"

Spatial Sales

This report, as shown in Figure 12-82 provides the sales value by different channel like distribution and selling.

Report dimensions are:

  • Business Time

  • Product

Figure 12-82 Sales Analysis Spatial Sales Report

Description of Figure 12-82 follows
Description of "Figure 12-82 Sales Analysis Spatial Sales Report"

Markdown

This report, as shown in Figure 12-83 provides the sales value by different channel like distribution and selling.

Report dimensions are:

  • Business Time

  • Product

Figure 12-83 Sales Analysis Markdown Report

Description of Figure 12-83 follows
Description of "Figure 12-83 Sales Analysis Markdown Report"

Scorecard

The scorecard area includes the following reports: Sales Scorecard, Store Sales Scorecard, Vendor Scorecard, and Markdown Scorecard.

Sales Scorecard

This report, as shown in Figure 12-84 provides (by store) department sales transaction sales units.

Report dimensions are:

  • Business Time

  • Product

  • Organization

Figure 12-84 Scorecard Sales Scorecard Report

Description of Figure 12-84 follows
Description of "Figure 12-84 Scorecard Sales Scorecard Report"

Store Sales Scorecard

This report, as shown in Figure 12-85 provides (by store) department sales quantity, value and variance information compared to last year.

Report dimensions are:

  • Business Time

  • Product

  • Organization

Figure 12-85 Scorecard Store Sales Scorecard Report

Description of Figure 12-85 follows
Description of "Figure 12-85 Scorecard Store Sales Scorecard Report"

Vendor Scorecard

This report, as shown in Figure 12-86 provides (by vendor) department quality rating, sales value, margin and rebate.

Report dimensions are:

  • Business Time

  • Product

  • Vendor

Figure 12-86 Scorecard Vendor Scorecard Report

Description of Figure 12-86 follows
Description of "Figure 12-86 Scorecard Vendor Scorecard Report"

Markdown Scorecard

This report, as shown in Figure 12-87 provides (by vendor) department quality rating, sales value, margin and rebate.

Report dimensions are:

  • Business Time

  • Product

  • Vendor

Figure 12-87 Scorecard Markdown Scorecard Report

Description of Figure 12-87 follows
Description of "Figure 12-87 Scorecard Markdown Scorecard Report"

Stock Movement

The stock movement area includes the following reports: Receipts, Stock Ledger, and Inventory Actual Comparison by Week.

Receipts

This report, as shown in Figure 12-88 provides "receipts by vendor" information such as items, stores, business date, business week day and receipt units listed by business year for a vendor.

Report dimensions are:

  • Business Time

  • Vendor

  • Organization

Figure 12-88 Stock Movement Receipts Report

Description of Figure 12-88 follows
Description of "Figure 12-88 Stock Movement Receipts Report"

Stock Ledger

This report, as shown in Figure 12-89 provides "Product, Stock Ledger Gross Margin" and Product, Stock Ledger Sales and Inventory information.

Report dimensions are:

  • Business Time

  • Organization

Figure 12-89 Stock Movement Stock Ledger Report

Description of Figure 12-89 follows
Description of "Figure 12-89 Stock Movement Stock Ledger Report"

Inventory Actual Comparison by Week

This report, as shown in Figure 12-90 provides the organization, inventory movement details.

Report dimensions are:

  • Business Time

  • Organization

Figure 12-90 Stock Movement Inventory Report

Description of Figure 12-90 follows
Description of "Figure 12-90 Stock Movement Inventory Report"