10 Data Validation

The Data Validation workbook contains all measures that are either loaded or selected during the batch calculation process. This template is used by the administrator only to verify the results of data loads and batch processes.

The Data Load Validation workbook contains the following tabs:

• Item Planning Measures Worksheet

• MFP Measures Worksheet

• Default Measures Worksheet

• Assortment Planning Measures Worksheet

Building the Data Load Validation Workbook

To build a Data Load Validation workbook, perform the following steps:

1. Click the New icon in the toolbar.

2. The New Workbook dialog box appears. On the Item Planning Administration tab, select Data Validation and click OK.

   Figure 10-1 New Workbook Dialog Box

   
   

3. The Data Validation Wizard appears at the Select Calendar step. Select the weeks you want to validate and click Next.

   Figure 10-2 Data Validation Wizard: Select Calendar

   
   

4. The Select Product step appears. Select the products you want to validate and click Next.

   Figure 10-3 Data Validation Wizard: Select Product

   
   

5. The Select Location step appears. Select the channels you want to validate and click Finish.

   Figure 10-4 Data Validation Wizard: Select Location Step

   
   

The Data Load Validation workbook is built.

Item Planning Measures Worksheet

Use the Item Planning Measures worksheet to validate that the Item Planning data was updated in the batch process.

Figure 10-5 Item Planning Worksheet

Table 10-1 lists the measures available on this worksheet.

Table 10-1 Item Planning Measures Worksheet Measures

Measure	Description
Wp BOP Inv C	Working Plan Beginning of Period Inventory Cost.
Wp BOP Inv R	Working Plan Beginning of Period Inventory Retail.
Wp BOP Inv U	Working Plan Beginning of Period Inventory Units.
Wp EOP Inv C	Working Plan End of Period Inventory Cost.
Wp EOP Inv R	Working Plan End of Period Inventory Retail.
Wp EOP Inv U	Working Plan End of Period Inventory Units.
Wp MD Allowance R	Working Plan Markdown Allowances Retail.
Wp On Order C	Working Plan On Order Cost.
Wp On Order R	Working Plan On Order Retail.
Wp On Order U	Working Plan On Order Units.
Wp Receipts C	Working Plan Receipts Cost.
Wp Receipts R	Working Plan Receipts Retail.
Wp Receipts U	Working Plan Receipts Units.
Wp Sls Clr C	Working Plan Clearance Sales Cost.
Wp Sls Clr R	Working Plan Clearance Sales Retail.
Wp Sls Clr U	Working Plan Clearance Sales Units.
Wp Sls Promo C	Working Plan Promotional Sales Cost.
Wp Sls Promo R	Working Plan Promotional Sales Retail.
Wp Sls Promo U	Working Plan Promotional Sales Units.
Wp Sls Reg C	Working Plan Regular Sales Cost.
Wp Sls Reg R	Working Plan Regular Sales Retail.
Wp Sls Reg U	Working Plan Regular Sales Units.

MFP Measures Worksheet

Use the MFP Measures worksheet to validate that the MFP data was updated in the batch process.

Figure 10-6 MFP Measures Worksheet

Table 10-2 lists the measures available on this worksheet.

Table 10-2 MFP Measures Worksheet Measures

Measure	Description
MFP Cp BOP Inv C	MFP Current Plan Beginning of Period Inventory Cost.
MFP Cp BOP Inv R	MFP Current Plan Beginning of Period Inventory Retail.
MFP Cp BOP Inv U	MFP Current Plan Beginning of Period Inventory Units.
MFP Cp COGS C	MFP Current Plan Cost of Goods Sold Cost.
MFP Cp EOP Inv C	MFP Current Plan End of Period Inventory Cost.
MFP Cp EOP Inv R	MFP Current Plan End of Period Inventory Retail.
MFP Cp EOP Inv U	MFP Current Plan End of Period Inventory Units.
MFP Cp GPM	MFP Current Plan Gross Margin.
MFP Cp MD Clr R	MFP Current Plan Clearance Markdowns Retail.
MFP Cp MD Perm R	MFP Current Plan Permanent Markdowns Retail.
MFP Cp MD Promo R	MFP Current Plan Promotional Markdowns Retail.
MFP Cp MD R	MFP Current Plan Total Markdowns (Clearance + Promotional + Regular) Retail.
MFP Cp Receipts C	MFP Current Plan Receipts Cost.
MFP Cp Receipts R	MFP Current Plan Receipts Retail.
MFP Cp Receipts U	MFP Current Plan Receipts Units.
MFP Cp Ttl Sls C	MFP Current Plan Total Sales Cost.
MFP Cp Sls Clr C	MFP Current Plan Clearance Sales Cost.
MFP Cp Sls Clr R	MFP Current Plan Clearance Sales Retail.
MFP Cp Sls Clr U	MFP Current Plan Clearance Sales Units.
MFP Cp Sales Net VAT R	MFP Current Plan Sales Net Value Added Tax Retail.
MFP Cp Sls Promo C	MFP Current Plan Promotional Sales Cost.
MFP Cp Sls Promo R	MFP Current Plan Promotional Sales Retail.
MFP Cp Sls Promo U	MFP Current Plan Promotional Sales Units.
MFP Cp Ttl Sls R	MFP Current Plan Total Sales Retail.
MFP Cp Sls Reg C	MFP Current Plan Regular Sales Cost.
MFP Cp Sls Reg R	MFP Current Plan Regular Sales Retail.
MFP Cp Sls Reg U	MFP Current Plan Regular Sales Units.
MFP Cp Ttl Sls U	MFP Current Plan Total Sales Units.
MFP Op BOP Inv C	MFP Original Plan Beginning of Period Inventory Cost.
MFP Op BOP Inv R	MFP Original Plan Beginning of Period Inventory Retail.
MFP Op BOP Inv U	MFP Original Plan Beginning of Period Inventory Units.
MFP Op COGS C	MFP Original Plan Cost of Goods Sold Cost.
MFP Op EOP Inv C	MFP Original Plan End of Period Inventory Cost.
MFP Op EOP Inv R	MFP Original Plan End of Period Inventory Retail.
MFP Op EOP Inv U	MFP Original Plan End of Period Inventory Units.
MFP Op GM	MFP Original Plan Gross Margin.
MFP Op MD Clr R	MFP Original Plan Clearance Markdowns Retail.
MFP Op MD Perm R	MFP Original Plan Permanent Markdowns Retail.
MFP Op MD Promo R	MFP Original Plan Promotional Markdowns Retail.
MFP Op MD R	MFP Original Plan Total Markdowns (Clearance + Promotional + Regular) Retail.
MFP Op Receipts C	MFP Original Plan Receipts Cost.
MFP Op Receipts R	MFP Original Plan Receipts Retail.
MFP Op Receipts U	MFP Original Plan Receipts Units.
MFP Op Ttl Sls C	MFP Original Plan Total Sales Cost.
MFP Op Sls Clr C	MFP Original Plan Clearance Sales Cost.
MFP Op Sls Clr R	MFP Original Plan Clearance Sales Retail.
MFP Op Sls Clr U	MFP Original Plan Clearance Sales Units.
MFP Op Sales Net VAT R	MFP Original Plan Sales Net Value Added Tax Retail.
MFP Op Sls Promo C	MFP Original Plan Promotional Sales Cost.
MFP Op Sls Promo R	MFP Original Plan Promotional Sales Retail.
MFP Op Sls Promo U	MFP Original Plan Promotional Sales Units.
MFP Op Ttl Sls R	MFP Original Plan Total Sales Retail.
MFP Op Sls Reg C	MFP Original Plan Regular Sales Cost.
MFP Op Sls Reg R	MFP Original Plan Regular Sales Retail.
MFP Op Sls Reg U	MFP Original Plan Regular Sales Units.
MFP Op Ttl Sls U	MFP Original Plan Total Sales Units.

Default Measures Worksheet

Use the Default Measures worksheet to validate that the default measure data was updated in the batch process.

Figure 10-7 Default Measures Worksheet

Table 10-3 lists the measures available on this worksheet.

Table 10-3 Default Measures Worksheet Measures

Measure	Description
DR Ty EOP Clr C	Default Role Used for Loading Measures This Year End of Period Clearance Inventory Cost.
DR Ty EOP Clr R	Default Role Used for Loading Measures This Year End of Period Clearance Inventory Retail.
DR Ty EOP Clr U	Default Role Used for Loading Measures This Year End of Period Clearance Inventory Units.
DR Ty EOP Reg C	Default Role Used for Loading Measures This Year End of Period Regular Inventory Cost.
DR Ty EOP Reg R	Default Role Used for Loading Measures This Year End of Period Regular Inventory Retail.
DR Ty EOP Reg U	Default Role Used for Loading Measures This Year End of Period Regular Inventory Units.
DR Ty On Order C	Default Role Used for Loading Measures This Year On Order Cost.
DR Ty MD Allowance R	Default Role Used for Loading Measures This Year Markdown Allowances Retail.
DR Ty On Order R	Default Role Used for Loading Measures This Year On Order Retail.
DR Ty On Order U	Default Role Used for Loading Measures This Year On Order Units.
DR Ty Receipts C	Default Role Used for Loading Measures This Year Receipts Cost.
DR Ty Receipts R	Default Role Used for Loading Measures This Year Receipts Retail.
DR Ty Receipts U	Default Role Used for Loading Measures This Year Receipts Units.
DR Ty Sls Clr C	Default Role Used for Loading Measures This Year Clearance Sales Cost.
DR Ty Sls Clr R	Default Role Used for Loading Measures This Year Clearance Sales Retail.
DR Ty Sls Clr U	Default Role Used for Loading Measures This Year Clearance Sales Units.
DR Ty Sls Promo C	Default Role Used for Loading Measures This Year Promotional Sales Cost.
DR Ty Sls Promo R	Default Role Used for Loading Measures This Year Promotional Sales Retail.
DR Ty Sls Promo U	Default Role Used for Loading Measures This Year Promotional Sales Units.
DR Ty Sls Reg C	Default Role Used for Loading Measures This Year Regular Sales Cost.
DR Ty Sls Reg R	Default Role Used for Loading Measures This Year Regular Sales Retail.
DR Ty Sls Reg U	Default Role Used for Loading Measures This Year Regular Sales Units.

Assortment Planning Measures Worksheet

Use the Assortment Planning Measures worksheet to validate that the Assortment Planning data was updated in the batch process.

Figure 10-8 Assortment Planning Worksheet

Table 10-4 lists the measures available on this worksheet.

Table 10-4 Assortment Planning Measures

Measure	Description
Ap Cp BOP Inv Cost	Assortment Planning Current Plan Beginning of Period Inventory Cost.
Ap Cp BOP Inv Retail	Assortment Planning Current Plan Beginning of Period Inventory Retail.
Ap Cp BOP Inv Units	Assortment Planning Current Plan Beginning of Period Inventory Units.
Product Cost	The cost of the product.
Ap Cp EOP Inv Cost	End of Period Inventory Cost.
AP Cp EopPerStr U%	Assortment Planning Current Plan EOP Per Store Unit %.
Ap Cp EOP Inv Retail	Assortment Planning Current Plan End of Period Inventory Retail.
Ap Cp EOP Inv Units	Assortment Planning Current Plan End of Period Inventory Units.
Exit Date	Date that inventory should be removed from sales floor.
AP Cp Gross Margin	Assortment Planning Current Plan Gross Margin.
AP Cp GP R%	Assortment Planning Current Plan Gross Profit Retail %.
Ap Cp Clearance Markdown Retail	Assortment Planning Current Plan Clearance Markdowns - Price reduction used to clear aged or slow moving inventory at Retail.
Ap Cp First Markdown % Off	Assortment Planning Current Plan Initial Markdown Taken expressed as a rate.
Ap Cp Perm Markdown Retail	Permanent Markdowns representing a permanent retail decrease to the owned inventory price of merchandise for strategic downward re-pricing decisions at Retail.
Ap Cp Promo Markdown Retail	Promotional Markdowns representing the temporary reduction to the owned inventory price for promotional purposes expressed at Retail.
Pack Size	Quantity of style / color or styles purchased from Supplier as a pack.
Ap Cp Clearance Price Change %	Assortment Planning Current Plan Clearance Price Change %.
Ap Cp Clearance Price Retail	Assortment Planning Current Plan Clearance Price Retail.
Ap Cp Perm Price Change %	Permanent Price Change expressed as a rate.
Ap Cp Product Original Ticket Price	Initial retail of product.
Ap Cp Promo Price Change %	Assortment Planning Current Plan Promotional Price Change %.
Ap Cp Promo Price Retail	Promotional Price Average Unit Retail.
Ap Cp Perm Price Retail	Average Unit Retail resulting from a Permanent Price Change.
AP Cp Receipts AUC	Assortment Planning Current Plan Receipts Average Unit Cost.
AP Cp Receipts AUR	Assortment Planning Current Plan Receipts Average Unit Retail.
Ap Cp Receipts Cost	Assortment Planning Current Plan Receipts Cost.
AP Cp Average Recpts Per Str	Assortment Planning Current Plan Average Receipts per store.
Ap Cp Receipts Retail	Assortment Planning Current Plan Receipts Retail.
Ap Cp Receipts Units	Receipts expressed as Units.
AP Cp Receipts U%	Assortment Planning Current Plan Receipts Units rate.
Ap Cp Ttl Sls AUC	Assortment Planning Current Plan Total Sales Average Unit Cost.
Ap Cp Ttl Sls AUR	Assortment Planning Current Plan Total Sales Average Unit Retail.
Ap Cp Ttl Sls C	Assortment Planning Current Plan Total Sales Cost.
Ap Cp Sls Clr AUC	Assortment Planning Current Plan Clearance Sales Average Unit Cost.
Ap Cp Sls Clr AUR	Assortment Planning Current Plan Clearance Sales Average Unit Retail.
Ap Cp Clearance Sales Cost	Assortment Planning Current Plan Clearance Sales Cost.
Ap Cp Clearance Sales Retail	Assortment Planning Current Plan Clearance Sales Retail.
Ap Cp Clearance Sales Units	See Clearance Sell Thru %.
AP Cp Avg Sls Per Str U	Assortment Planning Current Plan Average Sales per store represented in units.
Ap Cp Ttl Sls R	Assortment Planning Current Plan Total Sales Retail.
Ap Cp Sls Reg AUC	Assortment Planning Current Plan Regular Sales Average Unit Cost.
Ap Cp Sls Reg AUR	Assortment Planning Current Plan Regular Sales Average Unit Retail.
Regular Sales Cost	Assortment Planning Current Plan Regular Sales Cost.
Regular Sales Retail	Assortment Planning Current Plan Regular Sales Retail.
Regular Sales Units	Assortment Planning Current Plan Regular Sales Units.
Start Sales Date	The date the product is expected to start selling.
Ap Cp Ttl Sls U	Assortment Planning Current Plan Total Sales Units.
Sell Thru %	Assortment Planning Current Plan Sell Thru representing the percent of total available Inventory sold in a period of time Change %.
Store Count	Count of Stores.
Number of weeks at Clearance Price	Number of weeks the item is expected to sell at Clearance Price.
Number of Weeks at Regular Price	Number of weeks the item is expected to sell at Regular Price.