Go back to VendorPlanningAccess
Return to ResourcePlanning home

Vendor Planning Field Definitions

LY Act Turn	Last year's actual turns. Turns are defined as the number of cost of goods sold divided by the closing inventory value.
TY Plan Turn	This year's planned turns. More specifically, this plan period's planned turns. Indicates the turn goal for the plan session.
TY Proj Turn	This year's projected turns. More specifically, this plan period's projected turns based on planned purchases and sales.
LY Purchase MU	Last year's markup based on purchase costs.
TY Plan MU	This year, or this planning session's planned markup based on purchase costs.
STD MU	Standard markup - a planned markup amount across all vendors and items.
LY Actual GM	Last year's actual gross margin.
TY Plan GM	This year's, or this planning session's planned gross margin.
Proj GM	A calculated projected gross margin based on projections indicated in vendor and item level plans.
Proj GM w/STD Subsidy	Projected gross margin with standard subsidy. The standard subsidy is the expected or goal amount of vendor subsidy. This projection is based on plans from vendors and items.
Proj GM w/Proj Subsidy	Projected gross margin with projected subsidy. A projected subsidy is based on sales projections in vendor and item plans.
LY Season Subsidy	Last year's season collected subsidy amount.
STD Subsidy	Standard subsidy amount.
Projected Subsidy	Projected subsidy amount based on projected cost of goods.
LY Actual BOM (cost)	For months in the planning period, season/period summary and year to end of planning period summary. Indicates the beginning on-hand cost of goods for last year during the same period.
TY Plan BOM (cost)	For months in the planning period, season/period summary and year to end of planning period summary. Indicates the planned beginning on-hand cost of goods for this year.
TY Proj BOM (cost)	For months in the planning period, season/period summary and year to end of planning period summary. Indicates the projected beginning on-hand cost of goods for this year based on vendor and item plans.
LY Actual Sales (retail)	For months in the planning period, season/period summary and year to end of planning period summary. Indicates last year's sales in the period indicated.
LY Actual Sales (cost)	For months in the planning period, season/period summary and year to end of planning period summary. Indicated last year's cost of goods sold for the period indicated.
TY Plan Sales (retail | cost)	For months in the planning period, season/period summary and year to end of planning period summary. Indicates the sales goal dollars for the period if shown as retail. Indicates the sales goal dollars in cost of goods if shown as cost.
% TY Plan to LY Act	For months in the planning period, season/period summary and year to end of planning period summary. Indicates this year's plan to last year's plan for the indicated period. Reports the percentage of this years plan to last year's actuals.
TY Proj Sales (retail)	For months in the planning period, season/period summary and year to end of planning period summary. Projected sales based on vendor and/or item plans.
TY Proj Sales (cost)	For months in the planning period, season/period summary and year to end of planning period summary. Projected cost of goods sold based on vendor and/or item plans.
% TY Proj to TY Plan	For months in the planning period, season/period summary and year to end of planning period summary. A calculated percentage indicating a negative or positive percentage to goal.
LY Actual MD $	For months in the planning period, season/period summary and year to end of planning period summary.
TY Plan MD $	For months in the planning period, season/period summary and year to end of planning period summary.
TY Plan MD %	For months in the planning period, season/period summary and year to end of planning period summary.
TY Proj MD $	For months in the planning period, season/period summary and year to end of planning period summary.
TY Proj MD %	For months in the planning period, season/period summary and year to end of planning period summary.
LY Actual Receipts (retail)	For months in the planning period, season/period summary and year to end of planning period summary. Indicates last year's received inventory for the reporting period based on the item retail price -- the normal price used for selling the item.
LY Actual Receipts (cost)	For months in the planning period, season/period summary and year to end of planning period summary. Cost of goods received for the reporting period using standard cost.
TY Plan Receipts (cost)	For months in the planning period, season/period summary and year to end of planning period summary. This year/planning period planned/goal cost of goods received for reporting period.
TY Actual Receipts (cost)	For months in the planning period, season/period summary and year to end of planning period summary. Historical calculation for cost of goods received in the reporting period.
Proj On Order (cost)	For months in the planning period, season/period summary and year to end of planning period summary. Projected on-order or due-in for a given reporting period based on vendor and/or item plans.
Proj Advertising	For months in the planning period, season/period summary and year to end of planning period summary. Projected advertising spend for a given period.
Proj Shipping $	For months in the planning period, season/period summary and year to end of planning period summary. Projected dollar amount spent on outbound shipping for the period when inbound freight is part of cost.
Proj RTV	For months in the planning period, season/period summary and year to end of planning period summary. Projected return-to-vendor dollar amount for the reporting period.
Proj CLRX MDs	For months in the planning period, season/period summary and year to end of planning period summary. Projected dollar amount of inventory to be put on clearance/at or near cost for the reporting period.
Comments	Notes or comments pertaining to this plan.

Go to VendorPlanningMakingChanges