Exact Globe+

Creating and modifying cost price calculation scenarios

The Calculation scenario: BOM screen will be displayed when New or Open is clicked at Manufacturing ➔ Setup ➔ Scenarios. Scenarios are sometimes used in production orders when you click Calculate. For more information, see Creating and maintaining production orders.

Fields

Scenario

By default, this is the scenario name you have defined earlier in the criteria. This is mandatory.

Description

Type the description for the cost price calculation scenario. This is mandatory.

Include: Suborders

Select this check box to use the latest calculated cost price for suborders as the cost price for the subassembly item. This can happen, for instance, if there is a change in the negotiation with suppliers about the pricing for suborders.

Note: This is available only if you select Production order at Used in in the overview of scenarios screen before clicking New or Open. Selecting this check box enables Maximum number of levels and Explode: Stock controlled. By default, Calculated cost price(Main version) will be selected at Item price: Make and cannot be changed if this check box is selected.

Maximum number of levels

Select the lowest BOM level to be included in the cost price calculation. Select All to calculate the cost price in every level of the BOM, and to sum up and reflect the changes in the total cost price of the end product. Alternatively, select 1 to calculate only one level up.

Explode: Stock controlled

Select this to include stock controlled component materials in the cost price calculation.

Round off to: Batch quantity

Select this to include the BOM batch size in the cost price calculation. The batch size for subassembly item will be taken into consideration in the cost price calculation.

Round off to: Purchase order

Select one of the following options to calculate the cost price based on the purchase unit or purchase order size as specified in item maintenance:

None — Select this option if you do not wish to use the purchase price in the cost price calculation.
Purchase unit — Select this option to use the purchase unit in the cost price calculation.
Purchase order size — Select this option to use the purchase order size in the cost price calculation.

Note: To define Purchase unit and Purchase order size, go to Manufacturing ➔ Setup ➔ Items. Select the item code and click Open. Under the Purchase/Sales tab, select the supplier you want, and then click Edit in the Suppliers section. You will be able to see the Items by supplier screen. In the Purchase section, type the purchase unit in Purchase unit and the purchase order size in PO size.

Make/Buy

Select one of the following options to calculate the cost price based on the manufactured or purchased items. This option applies to component items that can be purchased or manufactured. If a component item can only be purchased or can only be manufactured, the respective purchase or manufactured cost price will be used instead.

Produce — Select this option to use the production cost in the cost price calculation.
Purchase — Select this option to use the purchase cost in the cost price calculation.

Item price: Buy

Select one of the following options to calculate the cost price:

Cost price — Select this option to calculate the cost price using the cost price of purchased items.
Purchase price (Main supplier) — Select this option to calculate the cost price using the purchase price of the main supplier.
Sales price — Select this option to calculate the cost price using the sales price of the purchased items.

Note: To define Cost price and Sales price, go to Manufacturing ➔ Setup ➔ Items. Select the item code and click Open. Under the Basics tab, type the cost price in Cost price and the sales price in Sls. unit, Price. To define the Purchase price (Main supplier), click the Purchase/Sales tab. Select the main supplier, and then click Edit in the Suppliers section. You will be able to see the Items by supplier screen. In the Purchase section, type the purchase price in Purchase unit and the purchase order size in PO size.

Item price: Make

Select one of the following options to calculate the cost price:

Cost price — Select this option to calculate the cost price using the cost price of manufactured items.
Sales price — Select this option to calculate the cost price using the sales price of the manufactured items.

Note: To define Cost price and Sales price, go to Manufacturing ➔ Setup ➔ Items. Select the item code and click Open. Under the Basics tab, type the cost price in Cost price and the sales price in Sls. unit, Price. The Calculated cost price (Main version) option is calculated automatically in Cost price in Manufacturing ➔ Setup ➔ BOM. This option is automatically selected when you select Include: Suborders. It calculates the cost price using the calculated cost price of the main BOM version.

Margin %

Type the margin in percentage. This will be used in the total sales margin in the cost price calculation.

Buttons

New

Click this to create another scenario. If changes have been made to the current scenario, you will be asked if you want to save these changes before a new scenario can be created.

Save

Click this to save any changes made to the current scenario.

Close

Click this to close.