Worksheet¶
Worksheets are custom reports in which user can select what data to show for what item/customer/facilities and how it will be aggregated.
DISPLAY¶
Name: User needs to provide a unique name for each worksheet in the model.
Description: User may provide some description for the defined worksheet, this is an optional field.
Show Summary: User may check this option to show grant totals for row/columns.
SERIES¶
Series are different network metrics like weight/cubic/quantity/cost.
Transportation Cost: It represents freight cost in ‘000 INR.
Duty Cost: It represent total of duties and levies cost in ‘000 INR.
Production Cost: It represent total cost of production derived from COP in the model in ‘000 INR.
Strong Volume: It includes strong volume in ‘000 of Case Equivalent
Mild Volume: It includes mild volume in ‘000 of Case Equivalent
Strong Salience: It includes string salience in %
Opening Stock: It represent opening stock in ‘000 of case equivalent
Closing Stock: It represent closing stock in ‘000 of case equivalent
Production Quantity: It represent production quantity in ‘000 of case equivalent
AGGREGATION¶
User may choose how to aggregate data, for instance one user may look at brand level data and other may look at zone specific data. User may aggregate based on user defined column in Item or Location table, period, mode, geography etc.
