Setting and Tracking Costs - Costing Configuration Follow

From the Costing menu, select Costing Fallback to display the following window.

Behold the Costing Fallback. These are listed in descending order of priority.

1. Standard Costing – Users can set a fixed cost for a specific part (item) numbers. If they have done so that cost will be used regardless of any other possible costing associations. The way a standard cost is loaded for an item depends on whether that item is a NAGS item or not.

A. NAGS Standard Costs are loaded under the Costing menu. NAGS>Auto Glass Standard Cost List. They can be manually entered or imported from a CSV file.

B. All other product items will have their own maintenance windows. Within that window is a button labeled [Advanced]. Clicking this button opens the Standard Cost field.

2. WMA – OR (Specific Costing) Effects all branches. For users who are taking advantage of the inventory sourcing features in GlasPacLX, creating and receiving purchase orders, this will be the most common source of an item’s cost against an order. As items are received on purchase orders, the cost is recorded and will be applied to orders based on either Specific or Weighted Moving Average (WMA). 

WMA = the average cost of all items that have been received into inventory, using the following formula:

(Current Avg. Cost x Previous Quantity) + (New Cost x New Quantity) = Total Cost

Total Cost / (Previous Quantity + New Quantity) = New Avg. Cost

For example, say that an item's current average cost is $50 and that you have 40 on hand. Now you receive in a shipment of 100 @ $52 each. The calculation of the new average cost is:

[(50 x 40) + (52 x 100)] / (40 + 100) = [7200] / 140 = $51.43

Specific = the exact cost of the item as it was received. It will be tracked either First In First Out (FIFO) or Last In First Out (LIFO), depending on the preference selected in the IC Configuration (Inventory>IC Configuration).

3. Vendor Costing – Users have the option of loading a specific cost at the vendor level for an item. These costs are loaded in the Vendor Maintenance window found under the Purchasing Menu.

In the General tab of a vendor there is a button labeled [Edit Vendor Cost]. Typically, when this is used a user will use the import option and load a csv file provided from a vendor.

4. Default Costing

If an order has nothing else to go on it will use the default cost settings. The first field is the selector for the Default Cost Discount. Any instance of GlasPacLX should have a Cost discount for this very purpose. This can be confusing because all other discount profiles play a pricing role, not a costing one. But in this one case the discount informs regarding the cost of an item. Example:

Default Auto Labor Cost and Default Non-Auto Labor Cost.

The first option applies to any job using NAGS labor hours. The second applies to any job using a labor code that was set up manually in the Labor finder.

Get PO Cost

Stock Adjustments

Checking the box for ‘Use Current Cost for Positive Stock Adjustments’ affect Standard Stock Adjustment (Inventory>Standard Stock Adjustment). When this is checked a positive standard stock adjustment will default to the items current inventory pic cost. Otherwise a positive standard stock adjustment will call for a cost to be hand entered.

Sales Margin

When a Sales Margin Limit is set here, users will be warned if they have set the pricing on an order below this limit. This is what they will see when saving such an order.

The Display Margin on Order checkbox enables a visual display on the order that indicates whether the price covers the set margin or not. A radio button will display next to the Total Cost field. It will be green on orders whose price meets or exceeds the set margin, it will be red on those order that do not.

 

 

 

Have more questions? Submit a request

Comments

Powered by Zendesk