Compare the average cost, last cost, landed average cost, and landed cost for products in your branches. These costs are maintained at the branch level because buying patterns may differ from branch to branch.
Each branch may pay a different price for the same product. For example, branch 1 buys a product every week, while branch 2 buys the same product once every three weeks. Also, the prices at the time of purchase may be different between branches because of the date that vendor price changes go into effect.
Average cost and last cost are maintained by the costs entered on purchase, transfer, and inventory adjustment orders. The landed cost and landed average cost include freight charges. Freight charges may vary from branch to branch due to location.
You must be assigned the PRODUCT.MAINT authorization key to view or edit data on the Branch Costs window.
To view or edit branch costs:
From the Maintenance menu, select Product to display the Product Maintenance window, and enter the product ID to display the product record.
Select Pricing > Product Price Maintenance to display the Product Price Maintenance dialog box.
Select Pricing >Branch Costs to display the Branch Costs dialog box.
In the Branch/Territory/All field, enter the branch or territory ID, or enter All to view all branches available to the user.
The remaining fields display the following information:
|
The field... |
displays... |
|
UM (unit of measure) |
the unit of measure from the Price Sheet Maintenance window. |
|
Qty |
the quantity from the Price Sheet Maintenance window. |
|
Average Cost |
the |
|
Last Cost |
the last incoming cost for the product. For child branches, this is the last transfer cost. |
|
Landed Average |
the landed average cost, which is the average of landed cost, based on quantity. |
|
Landed Cost |
the landed cost, which is the cost on the purchase order plus freight. |
Use the following menu items as needed:
|
Menu item |
Description |
|
Edit > Freight Factor |
A freight factor is an estimated freight charge for a product, applied as a percentage of the purchase price. The system uses the freight factor to estimate freight charges on the purchase order if the actual freight charge is not known. |
|
Edit > Maintenance Log |
Displays the Maintenance Log Viewing window, which shows a history of comments made regarding changes to Branch Costs window. |
|
Edit > Activity Log |
Displays the history of all changes made to the Branch Costs window and who made them. To view branch cost activity, you must be assigned the BR.COST.ACTIVITY.VIEW authorization key. |
See Also:
average
cost