2 MFP Setup 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 MFP Setup Task, which include:

• History Mapping

• Local Currency

• VAT Setup

• Manage Export

Opening the MFP Setup Workbook

To open a MFP Setup workbook:

1. Click the New Workbook icon in the MFP Setup task.

   Figure 2-1 MFP Setup Task

   
   

The workbook is built.

History Mapping

The History Mapping step is used by the administrator to map weeks for the last year and the last last year (two years ago). Using History Mapping, the administrator can map up to two years back.

Figure 2-2 History Mapping

History Mapping contains only the History Mapping view.

History Mapping View

Within this view, you can set the mapping for up to two years back. The previous year's mapping is used to identify which week to map to when determining the last year's values in a workbook. The mappings from the last last year are used to identify which weeks to map to when determining the values from two years back in a workbook.

The left-most column is the Week Label. The right-most column is the associated Week ID.

Figure 2-3 History Mapping

Table 2-1 Mapping View Measures

Measure	Description
Lag Ly	Identifies the week that is being used for mapping as adjusted last year.
Lag Lly	Identifies the week that is being used for mapping as last last year (two years ago).
Week ID	Identifies the internal week position for the current week for reference. This is useful for copying the week positions when manually setting Lag Ly and Lag Lly.

Local Currency

The Local Currency step provides support for administering local currency configuration. This view is only available when the provision option with local currency is implemented.

Figure 2-4 Local Currency

The Local Currency step consists of two views:

• Local Currency Rate

• Local Currency Symbol

Local Currency Rate

Within this view, you can set the local currency conversion rate for each Channel by Week.

Figure 2-5 Local Currency Rate View

Table 2-2 Local Currency Rate View Measures

Measure	Description
Local Currency Rate	The rate used to convert values to the local currency for a given Channel/Week.

Local Currency Symbol View

Within this view, the planning administrator sets the local currency symbol for each channel. This currency symbol can be included as the Location attribute in all Local Currency views.

For example, in Figure 2-6 the BRA Brick & Mortar channel has R$ as its local currency symbol, which indicates that local currency values for this channel are in Brazilian Real. All local currency BRA Brick & Mortar monetary values are displayed with R$.

Figure 2-6 Local Currency Symbol View

Table 2-3 Local Currency Symbol View Measures

Measure	Description
Local Currency Symbol	The graphic symbol associated with the channel's local currency.

VAT Setup

The VAT Setup step allows a planning administrator to enter the Value Added Tax (VAT) rate for each subclass by week.

Figure 2-7 VAT Setup

The VAT Setup step contains the VAT Setup view.

VAT Setup View

In this view, the planning administrator can input the VAT% rate for each subclass by week.

When sales costs are planned, the VAT% rate is applied to gross sales and then returns are subtracted to calculate net sales. If no VAT% rate is planned, then net sales are simply determined as gross sales less returns.

VAT Rate% is stored at Week/Subclass/Channel.

Figure 2-8 VAT Administration - VAT Setup Workbook

Table 2-4 VAT Administration - VAT Setup Workbook Measures

Measures	Description
VAT%	The default value-added tax (VAT) rate percentage for the Subclass/Channel.

Manage Export

The Manage Export step provides the ability to control which periods and positions are included when plans are exported. The values set in this step are employed in batch (along with corresponding Approved/Submitted/Seeded Info measures) to set export flags for all the plan versions that are exportable from MFP Cost Cloud Service:

• Merch Plan Current Plan (MP Cp)

• Merch Plan Original Plan (MP Op)

• Merch Plan Waiting for Approval Plan (MP Wa)

• Merch Plan Working Plan (MP Wp)

• Location Plan Current Plan (LP Cp)

• Location Plan Original Plan (LP Op)

• Location Plan Working Plan (LP Wp)

• Merch Targets Target (MT Tgt)

• Merch Targets Working Plan (MT Wp)

• Location Targets Target (LT Tgt)

• Location Targets Working Plan (LT Wp)

  Figure 2-9 Manage Export

  
  

The planner or administrator indicates whether elapsed periods should be included and which positions should be exported in the following two views:

• Export Elapsed Setting

• Manage Export

Export Elapsed Setting View

Within this view, the planner or administrator designates whether or not elapsed periods should be included when exporting plan data.

Figure 2-10 Export Elapsed Setting View

Table 2-5 lists the measures available in this view.

Table 2-5 Export Elapsed Setting View Measures

Measure	Description
Export Elapsed Periods	When selected, this flag indicates that data for elapsed periods should be exported. By default, this value is unchecked, meaning that only data for un-elapsed periods is included in exported plan data.

Manage Export View

Within this view, the planning administrator selects the positions that should be included when exporting plan data for all versions.

Figure 2-11 Manage Export View

Table 2-6 lists the measures available on this view.

Table 2-6 Manage Export View Measures

Measure	Description
Export Mask	Allows the user to control which positions are exported for all plan versions. When selected, the Department/Channel/Half is included when exporting plan data. By default, this boolean is checked for all positions. If the user wants to exclude any Department/Channel/Half from exporting, the user must un-check this boolean.

The export flags are set based on Export Mask and the Approved or Submitted Info for Approved or Submitted Plans and Seeded Info for Working Plans.