Product Current Cost

Description

This module is configured to calculate the current cost for BOM and non BOM products.

Functionality

After installing the Product Current Cost application , the feature will be enabled.

Go to Inventory - - > Products - - > Product Variants.

There are three scenarios for determining the Current Cost in the following ways:

Scenario 1:

“For product variants without a Bill of Materials or a vendor price, the Current Cost field will be equal to Odoo’s standard Cost field”

Scenario  2:

“For product variants with a vendor price and no Bill of Materials, the Current Cost will equal the highest vendor price that is applicable on the variant and valid in the current date range

If there is more than one vendor rule, use the price from the topmost rule for Current Cost in this calculation, ignoring secondary “price break” price rules”

Note:  It Calculates highest vendor price with the lowest Threshold Quantity that is valid within the current date range.

In this case UoM is greater than Purchase UoM.

Ratio between UoM and Purchase UoM is 10 as the ratio for mm = 1000 and cm = 100.

More than one vendor is added with selected date ranges and variation in Price and Quantity.

C = (P / R)

P = 150, R = 1000/100 = 10 [For Units of Measure > Purchase UoM]

So, Current Cost C = (150 / [1000/100]) = 15 as the vendor Anita Oliver is with the highest vendor price with the lowest Threshold Quantity that is valid within the current date range.

Scenario 3:

“For product variants with a Bill of Materials, the Current Cost will equal the Current Costs of the component products plus the costs of any associated operations”

Below is the component for the product.

Current Cost of the Component = 250

Operation Cost = 34.59

So, Current Cost = 250 + 34.59 = 284.59

Current Cost field is also added in the form view of the Product Variants.

To Calculate Sales Price:

An action is added to the product variant list and form views called "Update Sales Price from Current Cost".

On clicking, it calculates the Sales Price for all selected products using the following formula: Sales Price = (1 + (Margin/100)) * Current Cost.

It shows a wizard with the Product Name, the current Sales Price, the calculated new Sales Price, and an Update Price column with Boolean checkboxes that default to True. If the user unchecks the box, *do not* update the Sales Price on the lines marked False.

The products are updated with the new Sales Price as shown below.

Nearest Rounding Value:

“Nearest Rounding Value” field is added under the Sales configuration settings.

Let’s consider the below product variant whose Current Cost is 42.80 and the Sales Price is 40. Nearest Rounding Value is set as 5 which will round off the new Sales Price to 5 when we select “Update Sales Price from Current Cost" button.

After clicking on “Update Sales Price” the new rounded off Sales Price will be updated in the product variant form.

To Calculate Markup %:

“Calculate markup using the current cost and the sales price”

Markup % is a read-only field on the product variant that calculates the margin using the current cost field and the sales price.

Markup % = 100 * (Sales Price - Current Cost)/Current Cost

For the below product, Markup % = 100 * (0.20 - 30) / 30 = -99.33

Link Variant to BoM Overview:

A smart button is added on product variants that links directly to the specific variant's BoM Overview.

After clicking on the BoM Overview, the specific product’s BoM overview will be visible as shown below.

Credits

Contributors

• Sodexis < apps@sodexis.com >

This module is maintained by Sodexis.