5 Load Validate Task

The MFP Maintenance activity consists of the following tasks:

• MFP Setup

• Location Setup

• Enable Op Approval

• Load Validate

This chapter focuses on the steps within the Load Validate task, which include:

• Actuals

• Merch Target

• Merch Plan

• Location Target

• Location Plan

To use the Load Validate task, you must first build the workbook.

Once built, the workbook contains all measures that are either loaded or touched during the batch calculation process, providing an avenue by which an administrator can verify data loads and batch processes.

Building the Workbook

To build a Load Validate workbook, perform the following steps:

1. Click the New Workbook icon in the Load Validate step.

   Figure 5-1 Load Validate

   
   

2. The Calendar Selection step appears. Select the years and click Next.

   Figure 5-2 Workbook Wizard: Calendar Selection

   
   

3. The Location Selection step appears. Select the channel and click Next.

   Figure 5-3 Workbook Wizard: Location Selection

   
   

4. The Product Selection step appears. Select the items and click Next.

   Figure 5-4 Workbook Wizard: Product Selection

   
   

5. The Data Load Validation workbook is built.

Actuals

The Actuals step includes a single view of the same name, the Actuals view. Use this view to validate that the actuals data was loaded in the batch process.

Figure 5-5 Actuals View

Table 5-1 Actuals View Worksheet Measures

Measure	Description
Ty Sales Reg+Promo R	This Year Reg+Promo Sales Retail
Ty Sales Reg+Promo U	This Year Reg+Promo Sales Units
Ty Sales Clr R	This Year Clearance Sales Retail
Ty Sales Clr U	This Year Clearance Sales Units
Ty Returns Reg+Promo R	This Year Reg+Promo Returns Retail
Ty Returns Reg+Promo U	This Year Reg+Promo Returns Units
Ty Returns Clr R	This Year Clearance Returns Retail
Ty Returns Clr U	This Year Returns Clearance Units
Ty Markdown Reg+Promo R	This Year Markdown Reg+Promo Retail
Ty Markdown Clr R	This Year Markdown Clearance Retail
Ty Markdown due to W/F R	This Year Markdown W/F Retail
Ty EOP Reg+Promo C	This Year Reg+Promo End of Period Inventory Cost
Ty EOP Reg+Promo R	This Year Reg+Promo End of Period Inventory Retail
Ty EOP Reg+Promo U	This Year Reg+Promo End of Period Inventory Unit
Ty EOP Clr C	This Year End of Period Inventory Clearance Cost
Ty EOP Clr R	This Year Clearance End of Period Inventory Retail
Ty EOP Clr U	This Year Clearance End of Period Inventory Unit
Ty Receipts C	This Year Receipts Cost
Ty Receipts R	This Year Receipts Retail
Ty Receipts U	This Year Receipts Units
Ty Shrink C	This Year Shrink Cost
Ty Shrink R	This Year Shrink Retail
Ty Shrink U	This Year Shrink Units
Ty MOS C	This Year Marked Out of Stock Cost represents the Cost value of inventory reductions other than markdowns or sales.
Ty MOS R	This Year Marked Out of Stock Retail represents the Retail value of inventory reductions other than markdowns or sales.
Ty MOS U	This Year Marked Out of Stock Units represents the Units value of inventory reductions other than markdowns or sales.
Ty Misc Adj R	This Year Miscellaneous Adjustments Retail
Ty Misc Adj U	This Year Miscellaneous Adjustments Unit
Ty Royalties R	This Year Royalties Retail
Ty Vendor Funds R	This Year Vendor Funds (Rebates + Deals) Retail
Ty W/F Markdown R	This Year Wholesale Franchise Markdown Retail
Ty W/F Markup R	This Year Wholesale Franchise Mark Up Retail
Ty Cons Inv C	This Year Consignment Inventory as % of Total EOP Cost
Ty Sales Reg+Promo R	This Year Reg+Promo Sales Retail
Ty Sales Reg+Promo U	This Year Reg+Promo Sales Unit
Ty Sales Clr R	This Year Clearance Sales Retail

Merch Target

The Merch Target step includes a single view of the same name, the Merch Target view.

Figure 5-6 Merch Target View

Merch Plan

The Merch Plan step includes a single view of the same name, the Merch Plan view.

Figure 5-7 Merch Plan View

Location Target

The Location Target step includes a single view of the same name, the Location Target view.

Figure 5-8 Location Target View

Location Plan

The Location Plan step includes a single view of the same name, the Location Plan view.

Figure 5-9 Location Plan View