Расчеты Costing-а

Costing – сезональный workflow, который зависит от данных в BoM-е и BoL-е. Так, при создании нового costing-а, пользователь выбирает BoM/BoL из текущего стиля. Данные из этих баблов (стоимость материалов, операций) «подтягиваются» в costing и учитываются при расчетах. Также, расчет значений в costing-е зависит от его типа (Costing Type).

Шапка/header....

РАСЧЕТЫ

IMPORT

First Cost = BOMcost +BOLcost+additional cost

Duty$ = First Cost*Duty%

Commission$= First Cost*Commission%

Agent$ = First Cost*Agent%

Total COST/LDP = First Cost+Duty$+Commission$+Agent$+Freight

Wholesale Mark Up% = (Wholesale Unit - Total COST/LDP ) / Wholesale Unit

Retail Mark Up% = (Retail Unit - Total COST/LDP) / Retail Unit

Ecom Margin% = (Ecom Unit - Total COST/LDP) / Ecom Unit

Proposed UNITS = Wholesale Units+ Retail Units+ Ecom Units

COST/LDP Extended = Total COST/LDP*Proposed UNITS

Wholesale Extended = Wholesale Unit* Wholesale Units

Retail Extended = Retail Unit* Retail Units

Ecom Extended = Ecom Unit*Ecom Units

Wholesale Margin Unit = Wholesale Unit- Total COST/LDP

Retail Margin Unit = Retail Unit - Total COST/LDP

Ecom Margin Unit = Ecom Unit - Total COST/LDP

Wholesale Margin Extended = Wholesale Extended - (Total COST/LDP * Wholesale Units)

Retail Margin Extended = Retail Extended - (Total COST/LDP * Retail Units)

Ecom Margin Extended = Ecom Extended - (Total COST/LDP * Ecom Units)

Total Sales $ Extended = Wholesale Extended+Retail Extended+Ecom Extended

Total Margin $ Extended = Wholesale Margin Extended+Retail Margin Extended+Ecom Margin Extended

Weighted Price Unit = Total Sales $ Extended / Proposed UNITS

Weighted Margin Unit = Total Margin $ Extended / Proposed UNITS

Weighted Mark Up = Weighted Margin Unit / Weighted Price Unit