ITrack/Enterprise/Costing

Costing

"Costing" is a feature that was added when the Interchange Branch was created; costing can happen for both parts and vehicles.

Vehicles

• Any work order that has a vehicle as its Master Part will have its total price attributed to the cost of the vehicle. In other words: When it is on a work order, cost is 100% of the vehicle.

Tip

A Master Part is the part being modified with labor OR having parts consumed toward it. Examples: Engine being fixed - Master Part Turtle Wax shining a truck hood; Truck Hood - Master Part, Turtle Wax - Part consumed

• When the unit is sold, the entire cost of the vehicle is attributed to the part.

Vehicle costs are calculated by elements from the Purchase Order Screen (adjustments and purchases) and the Work Order Screen (price after taxes/labor/etc).

Parts

• Parts that are tied to a vehicle have zero cost until they are sold and finalized.

The Average Cost field may have a value in it, but any value other than zero is incorrect. If the Average Cost field has anything other than zero in it, then it should be ignored. It won't hurt anything and it is most likely the artifact of a Pro-to-Enterprise conversion.

• When a part is sold, cost is taken from a percentage of the part's price at the time of sale. The percentage is determined from the item's 'GLCategoryID' and 'percentofprice' column in the 'GLCategory' table.

Tip

GLCategory has its percentage based from 0 to 1. 0 - 0% 1 - 100% 0.5 - 50% 0.25 - 25% etc.

• Parts not tied to a vehicle and are NOT replenishable are given a cost of $0.00.

• Parts not tied to a vehicle and ARE replenishable will have their "Average Cost Increased" based on their purchase price and quantity. "Average Cost Reduced" will be based on price at the time of sale on Sales Orders.

Average Cost Increased/Decreased

Average Cost Increased/Decreased is a little bit of a complicated concept. First, let's say we have a replenishable item called Screws. At first we have zero screws, but we purchase 10 Screws for $1 each. The average cost is now $1 ($10 divided by 10 Screws). Now let's say we buy another 10 Screws for $2 each. The average cost has now increased from $1 to $1.5 ($30 divided by 20 Screws). This increase in the average cost is known as Average Cost Increased.

Average Cost Reduced works the same way, only it is a decrease instead of an increase.

Additional Questions

If you have any additional questions, please contact Justin or Dillon, or search the Enterprise Wiki for costing. We'll be glad to help!