Cost Sheet Attributes

You can create and use attribute groups to separate different types of information on the cost sheet. Examples of how information might be organized on cost sheets include:

• Variable rates, such as those that vary by product, vendor, or country. These are typically pulled from tables using customization.

• Vendor costs, which may use the variable rates above, as they apply to vendor-specific costs.

• Any numbers that are rolled up from actual cost values, target values, and volume.

• Converted calculations, in the case where you want to keep values of a different currency in a separate group. See Calculated Value Attributes for information on calculated values.

PTC FlexPLM provides for automatic colorway costing. Attributes specific to any of these type contexts can be managed in the cost sheet.

Colorway costing is most common among footwear producers where different colorways, often called styles, commonly use different materials and costs of materials.

Cost sheet types are handled by two synchronized types:

• Colorway attributes are entered on the Cost Sheet Colorway type.

• Product attributes are entered on the Cost Sheet Product type.

This synchronized type pairing supports synchronized attributes.

For example, the manufacturing costs could vary by color, and be managed on the Cost Sheet Colorway type. The duty or shipping costs, on the other hand, would most likely not vary by color, and would therefore be managed on the Cost Sheet Product type.

Attributes can be added to one type and marked as synchronized, and any changes to the attribute on one type are automatically changed on the attribute on the other type. If an attribute is not marked as synchronized, changes to an attribute on one type are not automatically changed on the attribute on the other type.

Users can enable updated costing functionality through a property setting.

Using this functionality, you can create a cost sheet to represent a specific colorway, and change an attribute value for each colorway. You can also create a cost sheet that represents multiple colorways, and edit an attribute value that applies to all colors included in that cost sheet.

Using the Type and Attribute Management utility, you can calculate values using other cost sheet values. An example is adding the material costs, the labor costs, and the shipping and handling costs into one value.

As with derived string attributes, you can derive calculations by connecting multiple attribute values. Numerical attribute values that can be used in calculations are currency, float, and integer. Using these derived numerical attributes, you can create any number of calculations, ranging from simple to complex.

For example, you can calculate a price using the suggestedWholesalePrice and minimumRetailMarkup attributes.

(suggestedWholesalePrice * minimumRetailMarkup * .01) + suggestedWholesalePrice

This equation multiplies the value of the suggestedWholesalePrice attribute by the value of the minimumRetailMarkup attribute, and then by the literal value of .01. The equation then adds this value to the value of the suggestedWholesalePrice attribute.

For more information on creating these attributes, including additional examples, see Formulas.