Item Costing#
With the help of KUMAVISION Item Costing (item costing) you can perform the following business evaluations and calculations:
- Regular item costing with the identification of variances.
- Calculation up to the target price
- Access protection of the costing data
- Separate display of costs
- Extension by the cost types in the single-level as well as multi-level range (e.g. "material overhead costs")
Production costing#
The production costing is primarily used to determine the production costs / cost of goods sold as well as the sales price for an article. These values can then be transferred to the corresponding price fields on the article card.
The result of this calculation can also be used for the valuation method "Standard" for the stock valuation.
Bearing evaluation#
The material overhead costs can be entered separately with the use of the costing solution. This means that costing can now also activate the material overheads based on consumption. This makes the inventory values transparent and traceable and also ensures clarity in the balance sheet. Thus, this addition to the standard Microsoft Dynamics 365 Business Central1 not only makes the calculation of sales prices more comprehensible.
Cost types#
In Microsoft Dynamics 365 Business Central1, there are a wide variety of cost types. These fields are visible in several masks. The explanation of these will now take place at this point. Basically, Microsoft Dynamics 365 Business Central1 distinguishes between single-level costs and multi-level costs.
Single stage costs#
Single-level costs are costs that are only incurred for the respective item. This means that only the cost price of the articles from the bill of materials or the prices and overhead costs directly from the routing are used for the calculation. No structures are exploded in the process.
Example:
An assembly in the bill of materials is displayed with the cost price in the material costs.
Multilevel costs#
Multi-level costs, are costs that are broken down to the lowest level and then presented in the respective cost pools.
Example:
An assembly in the bill of materials, is not shown with the cost price in the material costs, but is broken down to the purchase item. Only the purchase item is shown as a material cost. The remaining costs fall under capacity/external labor or production costs.
Consumption capitalized material overhead#
The material costs can be included directly in the cost price of the raw material at the time of the stock receipt, but they can also be included in the product as consumption-capitalized material costs during production.
Overhead and Consumption Activated Costs can be mixed on the item card and in the pricing condition line.
Hierarchy Consumption Activated Overhead:
a) Costing condition consumption activated
b) Costing condition line
c) Item
Hierarchy Overhead:
a) Costing conditions not consumption activated
b) Costing condition line
c) Article
Note
Overhead and Consumption Activated overhead can be used in parallel. The only difference is that only either a Costing Condition or a Costing Condition Consumption Activated can be defined. Both will not work.
Cost elements#
Below you will find an overview of the cost types that exist in Microsoft Dynamics 365 Business Central1 in connection with KUMAVISION Item Costing:
| field | description |
|---|---|
| Single-level material cost | All costs (cost price - overhead) that come from the bill of material. |
| Single-level material overhead | All overhead costs that result from purchased items in the bill of material. |
| Single-Level Capacity Costs | All costs (Cost Price - Overhead) that come from the routing.(No Outside Labor) |
| Single-Level Capacity Overhead | All overhead costs that come from the item's routing. (No external labor operations) |
| Single-Level Production Overhead | Production overhead costs that are associated with the item being costed. |
| Single-level external labor costs | All external labor costs (Cost price - Overhead) of external labor operations, from the corresponding routing. |
| Single-level external labor overhead costs | All external labor overhead costs (cost price - overhead) of external labor operations from the corresponding routing. |
| Multilevel Material Cost | All material costs (cost price - overhead) of purchased items summed across all levels. |
| Multilevel Material Overhead | All material overhead costs of purchased items summed over all levels. |
| Multilevel Capacity Costs | All capacity costs (cost price - overhead) of all routings summed over all levels. |
| Multilevel capacity overhead | All capacity overhead costs of all operations summed over all levels. |
| Multilevel production overhead | All production overhead costs of all items summed over all levels. |
| Multi-level external labor costs | All external labor costs (cost price - overhead) of all external labor operations summed over all levels. |
| Multi-level external labor overhead costs | All external labor overhead costs from all external labor operations summed over all levels. |
Note
The totals of the single-level and multi-level prices will match as long as no postings or price changes are made. As soon as bookings have taken place, these values diverge. They can then be made equal again by means of a new cost price calculation across all levels. (Depending on the settings)
Setup#
Evaluation & calculation setup#
In the "Valuation & Costing Facility", the basic facilities for controlling the operation of the costing facility are defined first.
Inforegister General#
| field | description |
|---|---|
| Basic Std. price calculation (make-to-stock) | The selection you make here will only be used for items with the production type "make-to-stock". The following selection options are available: Cost price: The value of the field "Cost price" from the master data of the item will be used. Cost price (newest): The value of the field "Cost price (newest)" from the master data of the item will be used. Cost price (newest): The value of the field "Cost price (newest)" from the master data of the item will be used. |
| Basic Std. Price Calculation (Order Production) | The selection you make here will only be used for items with the production type "Order Production". The following selections are available: Cost Price: The value of the "Cost Price" field from the item's master data will be used. Cost Price (Latest): The value of the "Cost Price (Latest)" field from the item's master data will be used. Purchase price (purchase prices): If the item has the procurement method "Purchase", the purchase price valid for the vendor no. of the item is first determined from the Purchase price table and the valid line discount % from the Purchase line discount table (both best price determination according to calculation date and quantity to be calculated). The combination of both fields results in the cost price to be used. If the item has the procurement method "Production order", the determination of the cost price to be used is based on the option value of the field "Basis Std. Cost Price Calculation (Make-to-stock)" of the Valuation and Costing Setup. |
| Default Transfer of cost price (fixed)/ target price Transfer proposal | At this point, you can decide whether the results of these calculations are to be written back for the respective items. At this point, you can decide whether the results of these calculations are to be written back for the respective items. The following selection options are available: One level: The cost price (fixed) is only written back for the article for which the calculation was carried out. All levels: The cost prices (fixed) are written back for all assemblies / components determined by the calculation. |
| Unit price decimal places | This is where you specify the minimum and maximum number of decimal places to be specified for unit prices in the cost estimate. Example: 2:5 means: minimum 2 decimal places and maximum 5 decimal places. For more detailed information, see "Decimal precision in currency and pricing". |
| Decimal places | This is where you specify the minimum and maximum number of decimal places to be specified for quantities in the cost estimate. Example: 2:5 means: minimum 2 decimal places and maximum 5 decimal places. For more information, see "Decimal precision in currency and pricing". |
| Default Cost Selection Costing Structure BOMs | The costing structure BOM (called up as a window or via a report) is used to display the costing values of a costing proposal in condensed form. The selection you make in this field simply sets a default for how the costing structure BOM is called up. The following selection options are available: Single level: Only the corresponding level 0 is exploded, all other levels are not. Multi-level: All levels up to the purchasing level are exploded. |
*If one assumes that consumption-controlled items (make-to-stock production) are procured on a regular basis, the cost price or cost price (most recent) provides a good basis for costing because the prices usually represent realistic values.
The current price is - except for the stock retirement method standard - an average value over all cost prices of the quantities currently in stock.
The Current price (latest), on the other hand, is not an average price. It refers to the last value at which the item was added. For more information about the cost price fields on the item card, see "About Cost Price Calculation".
On the other hand, items that are procured on an order-related basis (make-to-order production) can either also be costed on the basis of the cost prices, or - and this makes particular sense for items that are procured infrequently - on the basis of the currently valid purchase prices.
Note
The cost prices are always "adjusted" prices, i.e. freight costs or precious metal surcharges that were entered per article surcharge/discount are added, purchase discounts or similar are deducted. The purchase price, on the other hand, is the pure purchase price without taking into account any surcharges, discounts or rebates. The final costing always calculates only with the cost prices.
Note
A production type must be stored for each article - also for pure purchase articles, for which the production type is irrelevant by default.
Inforegister numbering#
| field | description |
|---|---|
| Calculation Condition Numbers | Enter the code of the number series to be used to assign the records of the Calculation Condition Numbers table. |
| Calculation Condition Numbers | Enter here the code of the number series to be used to assign the records to the Calculation Condition Numbers table. |
Note
If you want to use more than one number series for this table, you can set up a connection between the corresponding series in the via the "Connections" call in the number series,. This way you can use one code for two or more number series.|
Inforegister Assembly#
| field | description |
|---|---|
| Costing Item Direct Costs (Resource Assembly) | Select a costing item from the costing item plan to which the direct costs incurred when a resource is used in an assembly order are assigned. |
| Description of Costing Item Direct Costs (Resource Assembly) | Indicates the description of the selection in the field "Costing Item Direct Costs (Resource Assembly)". |
| Costing Item Overhead (Resource Assembly) | Select a costing item from the costing item plan to which the overhead costs incurred when a resource is used in an assembly order are assigned. |
| Description of Costing Item Overhead (Assembly Resource) | Indicates the description of the selection in the Costing Item Overhead (Assembly Resource) field. |
Costing Components Plan#
The costing components chart is the foundation of the cost estimate and is comparable to a chart of accounts. It takes over the task of standardizing and grouping the components of a cost estimate and thus ultimately making them comparable with each other.
In principle, the costing components chart is structured analogously to the chart of accounts of the financial accounting application area.
KUMAVISION Item Costing already provides you with a set up costing item plan. You can either use this directly in the form or further adapt it to the requirements of your company. Of course, you also have the option to create your own complete component plan.
Note
If you want to use more than one number series for this table, you can set up a connection between the corresponding series in the via the call "Connections" in the number series. This way you can use one code for two or more number series.
| field | description |
|---|---|
| No. | The "No." field is used to identify the costing element. You can enter up to 20 characters, both numbers and letters. Each number may be assigned only once. You can set up as many costing items as you like. Note: Select sufficient intervals between the numbers of each costing item. This will allow you to add more costing items later if needed. For example, you could assign only the ending digits 00 to all account groups and only the ending digits 0 to all accounts. |
| Description | You can enter any text here to describe the content of the costing item. |
| Cost area | Articles and capacities will later be assigned to the table of costing items via the costing conditions. The Cost area field specifies the application area of the respective costing item. The following selection options are available: Material costs and material overhead: The costing items with these options are used in costing conditions of the type "Material" (procurement method of the item = purchase). Material costs describe the direct costs (from the field EK price (latest)). Material overhead describes the indirect costs (from the fields Cost %, Overhead rate, Cost % (Consumption capitalization), Overhead rate (Consumption capitalization)). Capacity costs and capacity overhead: The costing items with these options are used in costing items of type "Capacity". Capacity costs describe the direct costs (field EK price of the used work center or work center group). Capacity overhead describes the indirect costs (Cost %, Overhead rate) of the work center or work center group used. External labor costs and external labor overhead: The costing items with these options are used in costing items of type "Capacity" if it is an external labor work center group (or assigned external work center) (Vendor number field is not equal to "blank"). External labor costs describe the direct costs (EK price field of the external labor work center group used or the assigned external work center). External labor overhead costs describe the indirect costs (cost %, overhead rate) of the used external work center group or the assigned external work center. |
| Cost area | Production overhead: The costing items with these options are used in costing conditions of the type "Production" (procurement method of the item = production order). Costing items of the cost area production overhead describe the indirect costs (fields cost %, overhead rate) of the item used (production item or assembly). Sales overhead, administrative overhead, risk/profit, commission, discount, rebate: The costing items with these options are used in costing conditions of the type "markup". Costing items of these four cost areas describe the non-capitalizable costs of an item, i.e. the difference between the sales price and the cost price of the item. |
| Type | With this field you specify the type of record. You can choose from: Costing item: This option is used for the actual costing items. Subsequent assignment will only be made using these records. Header: A header for a group of costing components. Total: The Total option is used when you want the application to total individual costing components. In this case, please enter a filter text in the "Sum" field to specify the costing components to be included. From-Sum/To-Sum: The From-Sum option marks the beginning of a continuous series of costing components to be summed. The end of this series is a costing element of the type To-Sum. In this case, please also enter a filter text in the "Totalization" field to specify the costing items to be included. |
| Counting up | Here you can specify the interval or other filter specification of the numbers of the costing items. The results of the specified costing items will be added to a total balance. For the type "Costing item", "From-total" or "Heading", this field must remain empty. For the type "To-total", the field will be filled automatically when the chart of accounts is indented (function in the menu ribbon). Only the costing items that fall between a From-Total and a To-Total will be totaled. For the "Total" type, you must manually specify the costing items to be totaled. |
Note
You must assign a cost range to each record in the Costing Item table with the type "Costing Item". For all other costing items (headings, totals, from-totals or to-totals), the Cost range field remains empty.
Supplied Costing Item Schedule:
| No. | Description | Cost area | Type | Counting |
|---|---|---|---|---|
| 1 | Energy overhead | Material overhead | Costing item | |
| 10000 | manufacturing costs | from-total | ||
| 10001 | Material costs | From-total | ||
| 10010 | Direct material costs | Material costs | Costing element | |
| 10011 | Direct material costs 2 | Material costs | Costing item | |
| 10020 | Special direct costs material | Material overhead | Costing item | |
| 10030 | Material overhead | Material overhead | Costing item | |
| 10040 | Material surcharges | Material overhead | Costing element | |
| 10045 | Freight costs | Material overhead | Costing item | |
| 10046 | handling costs | material overheads | costing element | |
| 10049 | Total material costs | To-total | 10001 ..10049 | |
| 10100 | Capacity costs | From-total | ||
| 10110 | individual costs elm | capacity costs | costing element | |
| 10120 | Single cost worker | Capacity cost | Calculation item | |
| 10130 | individual costs machine | capacity costs | costing element | |
| 10150 | Overhead costs elm | Capacity overhead | Costing element | |
| 10160 | overhead labor | capacity overhead | costing element | |
| 10170 | machine overhead | capacity overhead | costing item | |
| 10180 | electricity/buildings | capacity overhead | costing element | |
| 10210 | Individual costs external labor | External labor costs | Costing item | |
| 10250 | Overhead costs external labor | External labor overhead | Costing element | |
| 10299 | Total capacity costs | To-total | 10100 ..10299 | |
| 10300 | Individual costs assembly res. | Capacity costs | Calculation component | |
| 10305 | Overhead assembly res. | Capacity overhead | Costing element | |
| 10310 | Tools | Production Overhead | Costing Item | |
| 10320 | Certifications | Production Overhead | Costing Item | |
| 10400 | Total cost of goods sold | To-total | 10000 ..10400 | |
| 10410 | Shipping | Sales overhead | Costing item | |
| 10420 | Quality Control | Sales Overhead | Costing Item | |
| 10430 | Sales | Sales overhead | Costing item | |
| 10510 | Administration | Administrative overhead | Costing item | |
| 10520 | Special direct costs of technology | Administrative overhead | Costing item | |
| 10600 | Selbstkosten | Summe | 10000..10599 | |
| 10610 | Risk/profit surcharge | Risk/profit | Calculation component | |
| 10620 | Special direct costs other | Risk/profit | Costing item | |
| 10700 | Mindestrichtpreis | Summe | 10000..10699 | |
| 10710 | Commission | Commission/Discount | Calculation Item | |
| 10720 | Discounts | Commission/Discount/Discount | Calculation Item | |
| 10730 | Discounts | Commission/Discount | Calculation Item | |
| 10800 | Richtpreis | Summe | 10000..10799 | |
| 10810 | Rounding income/costs | Commission/discount/discount | Calculation component | |
| 10900 | Guide price (rounded) | Sum | 10000 ..10899 |
Actions via the ribbon#
Indentation of the component plan#
By executing the "Component plan indentation" function, the filter text in the "Totalization" field is automatically determined by the system for the costing components of the "To total" type.
Remarks#
Date-dependent information can be stored for the respective costing element via the remarks.
Costing conditions#
The costing conditions create the link between the master data tables such as article, work center group, etc. and the costing components and thus enable the results of a cost estimate to be assigned to an account.
In the header of a costing condition the assignment to the costing element costs and the costing element overhead costs is made. The lines of the costing condition allow the costing costs to be defined more precisely over any number of lines. This applies to both direct costs (field EK price) and indirect costs (fields Cost %, Overhead rate) of the respective master data table.
The following costing condition types are distinguished:
Calculation condition (material)#
The calculation condition is used in the "Article calculation condition" with the calculation type "Material". This means that you define calculation conditions here which you then assign to some of your articles. The condition is taken into account in the calculation if it is the calculation of raw materials (purchase items).
Inforegister General#
| field | description |
|---|---|
| No. | Number of the calculation condition. |
| Description | Description of the calculation condition. |
| Costing element costs | Select the appropriate costing element in the field "Costing element costs". For the costing condition "Material" this is usually the material direct costs. |
| Description of costing item cost | Gives the description of the selected costing item from the field "Costing item cost". |
| Costing item overhead | Select the appropriate costing item in the "Costing item overhead" field. For the costing condition "Material", this is usually the material overhead. |
| Description of costing item overhead | Indicates the description of the selected costing item from the "Costing item overhead" field. |
Inforegister lines#
| Field | Description |
|---|---|
| Description | Please enter a description of your calculation condition line here. |
| Costing element | A costing element is assigned to each costing condition line. In principle, a costing item with any cost range can be assigned to a costing condition line. However, you should make sure that you use a costing item whose cost range corresponds to the intended application area of the respective costing condition. |
| Costing Element Description | This field is filled automatically by the selection of the costing item. |
| Heading No. | The Heading No. field is used to relate calculation condition lines to each other to define a calculation base for percentage surcharges. |
| Calculation | This field is an optional field and controls the meaning of the Value field with its option value: Amount If you select the "Amount" option, then the specification in the "Value" field is understood to be an absolute number entry. So here you have the option to enter fixed values that will be taken into account in the calculation. In addition, you can provide this line with a rubric number to refer to this line in another line with the setting Percent - so, for example, to take into account an additional overhead. Percent If you select the option "Amount", then the specification in the field "Value" is understood as a percentage number input. If the line has been assigned a heading number, then the basis of the percentage is the sum of all pricing condition lines of the same pricing condition with the same heading number and calculation amount. Note If the line has not been assigned a heading number, then the application will use as the basis for the percentage either the EK price of the origin line of the corresponding pricing value or (if available) the sum of all pricing condition lines of the same pricing condition with the calculation value. The heading numbers of these lines are then ignored. |
| Value | The meaning of the field depends on the value you have selected in the Calculation field. Amount In this case, the field contains an absolute amount. Depending on the selected costing item, this amount is part of the EK cost or part of the overhead rate. Percent In this case, the Value field contains a percentage value. The basis of the percentage value is the sum of all costing values with the same heading number. If the line has not been assigned a rubric number, the application will use as a basis either the EK price of the origin line of the corresponding costing value or (if available) the sum of all costing condition lines with calculation value and specification of any rubric number (but only if these costing condition lines have been interpreted as part of a EK price). |
KUMAVISION Item Costing provides you with predefined costing conditions (material) for use or further individual additions:
Material (simple) and Material (simple2):
| Field | Material (simple) | Material (simple2) |
|---|---|---|
| No. | KK0000 | KK0010 |
| Description | Material (simple) | Material (simple2) |
| Costing item cost | 10010 | 10011 |
| Description of costing item costs | Direct material costs | Direct material costs 2 |
| Costing item overhead | 10030 | 10030 |
| Description of Costing Item Overhead | Material Overhead | Material Overhead |
Material (complex) and Material (complex2):
| Field | Material (complex) | Material (complex2) |
|---|---|---|
| No. | KK0011 | KK0001 |
| Description | Material (complex) | Material (complex2) |
| Costing item cost | 10010 | 10010 |
| Description of Costing Item Costs | Direct Material Costs | Direct Material Costs |
| Costing item overhead costs | 10030 | 10030 |
| Description of Costing Item Overhead | Material Overhead | Material Overhead |
| Field | Material (complex) | ||||
|---|---|---|---|---|---|
| Description | Handling | Freight | Overhead costs | Special direct costs Material surcharges | |
| Calculation component | 10046 | 10046 | 10046 | 10046 | 10046 |
| Costing item description | Handling costs | Freight costs | Material overhead | Special direct material costs | Material surcharges |
| heading no. | R1+R2 | R1 | R2 | ||
| calculation/value | 7.00 MW | 6.00 % | 4.00 % | 5.00 MW | 2.00 MW |
| Field | Material (complex2) | ||
|---|---|---|---|
| Description | Handling | Freight | Overhead costs |
| calculation component | 10046 | 10045 | 10030 |
| Calculation Item Description | Handling Costs | Freight Costs | Material Overhead |
| heading no. | |||
| calculation/value | 1.00 MW | 6.00 % | 4.00 % |
Calculation condition (Production)#
The calculation condition is used in the "Article calculation condition" with the calculation type "Production". This means that you define here calculation conditions which you then also assign to some of your articles. The condition is taken into account in the calculation when it comes to the calculation of products (production items).
Inforegister General#
| field | description |
|---|---|
| No. | Number of the calculation condition. |
| Description | Description of the calculation condition. |
| Costing element costs | Select the appropriate costing element in the field "Costing element costs". In the case of the costing condition "Production", these are usually the direct material costs or the special direct costs of production. |
| Description of costing item cost | Specifies the description of the selected costing item from the field "Costing item cost". |
| Costing item overhead | Select the appropriate costing item in the "Costing item overhead" field. In the case of the costing condition "Production", these are usually the costs for tools, special direct costs or similar. |
| Description of costing item overhead | Indicates the description of the selected costing item from the field "Costing item overhead". |
Inforegister lines#
| Field | Description |
|---|---|
| Description | Description of the calculation condition. |
| Costing element | Each calculation condition line is assigned a calculation component. In principle, a costing item with any cost range can be assigned to a costing condition line. However, you should make sure that you use a costing item whose cost range corresponds to the intended application area of the respective costing condition. |
| Costing Element Description | This field is filled automatically by the selection of the costing item. |
| Heading no. | The field "Heading No." is used to relate calculation condition lines to each other in order to define a calculation base for percentage surcharges. |
| Calculation | The field is a choice field and controls with its option value the meaning of the field Value: Amount If you select the option "Amount", then the specification in the field "Value" is understood as an absolute number input. So here you have the option to enter fixed values that will be taken into account in the calculation. In addition, you can provide this line with a rubric number to refer to this line in another line with the setting Percent - so, for example, to consider an additional overhead. Percent If you select Amount, then the specification in the field "Value" is understood as a percentage number entry. If the line has been given a rubric number, then the basis of the percentage is the sum of all pricing condition lines of the same pricing condition with the same rubric number and calculation amount. Note If the line has not been given a rubric number, then the application uses as the basis for the percentage either the EK price of the origin line of the corresponding pricing value or (if available) the sum of all pricing condition lines of the same pricing condition before the current line with the calculation value. The heading numbers of these lines are then ignored. |
| Value | The meaning of the field depends on the value you have selected in the "Calculation" field. Amount In this case, the field contains an absolute amount. Depending on the selected costing element, this amount is part of the EK cost or part of the overhead rate. Percent In this case, the "Value" field contains a percentage value. The basis of the percentage value is the sum of all costing values with the same heading number. If the line has not been assigned a rubric number, the application will use as a basis either the EK price of the origin line of the corresponding calculation value or (if available) the sum of all calculation condition lines before the current line with calculation value and specification of any rubric number (but only if these calculation condition lines have been interpreted as part of an EK price). |
KUMAVISION Item Costing provides you with predefined costing conditions (production) for use or further individual additions:
| Field | Production (simple) | Production (complex) |
|---|---|---|
| No. | KK1000 | KK1001 |
| Description | Production (simple) | |
| Calculation item costs | 10011 | |
| Description of costing element costs | Direct material costs 2 | |
| Costing item overhead | 10310 | 10320 |
| Description of costing item overhead costs | Tools | Certifications |
No further information is defined in the calculation condition lines of the condition "Production (simple)".
| Field | Production (complex) | |
|---|---|---|
| Description | Tool | Certification |
| calculation component | 10310 | 10320 |
| Calculation Component Description | Certification Tool | |
| Category No. | ||
| Calculation / Value | 2.00 % | 5.00 MW |
Costing condition (capacity)#
The costing condition is used for the capacity costing condition. That means, you define here costing conditions which you assign afterwards to your capacities (work center groups and work centers). The condition is taken into account in the calculation as soon as a capacity is addressed (e.g. because a routing is stored for a production article).
Inforegister General#
| field | description |
|---|---|
| No. | Number of the calculation condition. |
| Description | Description of the costing condition. |
| Costing element costs | Select the appropriate costing element in the field "Costing element costs". For the costing condition "Capacity" this is usually the direct production costs. |
| Description of costing item cost | Specifies the description of the selected costing item from the field "Costing item cost". |
| Costing item overhead | Select the appropriate costing item in the "Costing item overhead" field. For the costing condition "Capacity", this is usually the production overhead. |
| Description of costing item overhead | Indicates the description of the selected costing item from the "Costing item overhead" field. |
Inforegister lines#
| Field | Description |
|---|---|
| Description | Please enter a description of your calculation condition line here. |
| Costing element | A costing element is assigned to each costing condition line. In principle, a costing item with any cost range can be assigned to a costing condition line. However, you should make sure that you use a costing item whose cost range corresponds to the intended application area of the respective costing condition. |
| Costing Element Description | This field is filled automatically by the selection of the costing item. |
| Heading No. | The field "Heading No." is used to relate calculation condition lines to each other in order to define a calculation base for percentage surcharges. |
| Setup time | This field is only included in costing conditions of the type "Capacity" or "External labor". This field can be used to define costing elements that only refer to the setup time in their calculation. |
| Percentage | The content of this field is used as a percentage in the formula for calculating the "Costing price" field of the costing value. |
| Calculation | The field is a choice field and controls with its option value the meaning of the field "Value": Amount If you select the option "Amount", then the specification in the field "Value" is understood as an absolute number input. So here you have the option to enter fixed values that will be taken into account in the calculation. In addition, you can provide this line with a rubric number to refer to this line in another line with the setting "Percent" - so, for example, to take into account an additional overhead. Percent If you select the option "Amount", then the specification in the field "Value" is understood as a percentage number input. If the row has been assigned a rubric number, then the basis of the percentage is the sum of all pricing condition rows of the same pricing condition with the same rubric number and calculation amount. Note If the row has not been assigned a rubric number, then the application uses as the basis for the percentage either the EK price of the origin row of the corresponding pricing value or (if available) the sum of all pricing condition rows of the same pricing condition before the current row with the calculation value. The heading numbers of these lines are then ignored. |
| Value | The meaning of the field depends on the value you have selected in the "Calculation" field. Amount In this case, the field contains an absolute amount. Depending on the selected costing element, this amount is part of the EK cost or part of the overhead rate. Percent In this case, the "Value" field contains a percentage value. The basis of the percentage value is the sum of all costing values with the same heading number. If the line has not been assigned a rubric number, the application will use as a basis either the EK price of the origin line of the corresponding calculation value or (if available) the sum of all calculation condition lines before the current line with calculation value and specification of any rubric number (but only if these calculation condition lines have been interpreted as part of an EK price). |
KUMAVISION Item Costing provides you with predefined costing conditions (capacity) for use or further individual additions:
| Field | Capacity (Energy) | Capacity (Simple) | Capacity (Complex) |
|---|---|---|---|
| No. | 01 | KK2000 | KK2001 |
| Description | Capacity (energy) | Capacity (simple) | Capacity (complex) |
| Calculation item cost | 10130 | 10130 | |
| Description of Costing Component Costs | Machine Unit Cost | Machine Unit Cost | |
| Costing item overhead costs | 1 | 10170 | 10170 |
| Description of costing item overhead costs | Overhead costs energy | Overhead costs machine | Overhead costs machine |
No further information is defined in the calculation condition lines of the conditions "Capacity (energy)" and "Capacity (simple)".
| Field | Capacity (complex) | |||||
|---|---|---|---|---|---|---|
| Description | Machine | Worker | Costing component | 10110 | 10120 | 10110 |
| calculation component | 10130 | 10120 | 10110 | 10170 | 10160 | |
| Calculation Item Description | Unit Cost Machine | Unit Cost Worker | Unit Cost Elm | Unit Cost Worker | Unit Cost Machine | Unit Cost Worker |
| heading number | M1 | A | A | M1 | A | |
| time | Yes | |||||
| Share % | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 |
| Calculation / Value | 2.20 MW | 1.20 MW | 1.50 MW | 0.90 MW | 20.00 % | 10.00 % |
| Field | External labor (simple) | External labor (complex) |
|---|---|---|
| No. | KK2050 | KK2051 |
| Description | External labor (simple) | External labor (complex) |
| Calculation item costs | 10210 | 10210 |
| Description of costing item costs | Direct costs for external labor | Direct costs for external labor |
| Costing item overhead costs | 10250 | 10250 |
| Description of Costing Item Overhead Costs | Overhead Costs External Labor | Overhead Costs External Labor |
No further information is defined in the calculation condition lines of the condition "External labor (simple)".
| Field | External labor (simple) | External labor (simple) |
|---|---|---|
| Description | Freight | Overhead costs |
| Calculation element | 10250 | 10250 |
| Costing item description | External labor overhead | External labor overhead |
| heading number | ||
| setup time | ||
| Share % | 100.00 % | 100.00 % |
| Calculation / Value | 5.00 % | 15.00 % |
Calculation condition (markup)#
The calculation condition is used for the "Article calculation condition (cannot be activated)" with the calculation type "markup". That means you define here calculation conditions which you assign afterwards to some of your articles. The condition will be taken into account in the calculation if it is the calculation of "end products". Here you no longer define the cost price of the article, but the markup up to the target price.
Inforegister General#
| field | description |
|---|---|
| No. | Number of the calculation condition. |
| Description | Description of the calculation condition. |
| Transfer target price | In an article calculation, you can transfer the target price determined from a calculation proposal to the master data of the calculated article. You indicate here, into which field of the master data the determined target price is to be transferred: None There is no transfer. Target price The value is transferred into the field "Target price" of the article. Sales price The value is transferred into the field Sales price. Sales price The value is transferred into the sales price table of the article. The entry is made taking into account the sales type and the sales code. Price + Sales Price The value is transferred to both the Price field and the record of the Sales Price table. |
| Sale Type | This field is taken into account when entering the target price in the sales price table. The following selection options are available: - Customer, - Customer Price Group, - All Customers - Campaign It can only be edited if "Sales Price" or "Target Price+Sales Price" has been selected in the "Transfer Target Price" field. |
| Sales code | This field is also taken into account when entering the guide price in the sales price table. What you can select here depends on what you have specified in the "Sales type" field. For example, if you have selected customer price group there, all your customer price groups will be displayed for selection in the "Sales code" field. This makes it possible to define individual markup calculations for special customer groups, campaigns or even for individual customers. |
Inforegister lines#
| Field | Description |
|---|---|
| Category No. | The field "Category No." is used to relate calculation condition lines to each other in order to define a calculation basis for percentage surcharges. |
| Description | This is where you enter a description of the content of your calculation condition line. |
| Calculation | The field is an optional field and controls the meaning of the "Formula/Code" field with its option value: empty If the field is left "empty", the line has no influence on the execution of the calculation. For example, it can be used for a heading or explanation line. Value If you select "Value", the "Formula/Code" field will contain an absolute number entry. In addition, you can assign a heading number to this line to refer to it in another line with the Percent setting. Formula If you select the "Formula" option, the "Formula/Code" field will contain an arithmetic formula. The parts of the formula refer to the heading number of other costing condition lines. Costing component If you select the "Costing component" option, the "Formula/Code" field will contain a costing component. Thus, this setting allows you to determine a markup line based on the costing values of a specific costing ingredient. This costing component can also be a to-total. Project Planned Line If you select the "Project Planned Line" option, the "Formula/Code" field will contain a project task number. |
| Formula/Code | The meaning of the field depends on the value you selected in the "Calculation" field. empty In this case, the "Formula/Code" field is also empty. The calculation condition line has no influence on the execution of the calculation. For example, it can be used for a heading or explanation line. value In this case, the field contains a constant (decimal number). You can also use this constant by assigning a rubric number to the line and referring to it in another calculation condition line with the calculation formula. FormulaIn this case, the field contains an arithmetic formula. A rubric no. can also be used here to determine the calculation basis. In the arithmetic formula, the basic arithmetic operations +, -, *, /, multilevel brackets () and the two special characters % and § can be used. % stands for "percent of one hundred". Example 5% A means "5 percent of the sum of all markup lines with rubric no. A". Suppose the total is 100, then the markup is 5 (100/100*5) § stands for "percent of one hundred". Example 5 § B means "5 percent from the total of all markup lines with rubric no. B". Let's say the total is 100, then the markup is 4.76 (100/105*5). Calculation Item In this case, a calculation item is selected. If this line is used in a calculation, the application will calculate the calculated field "Multi-level amount per 1 unit". For example, the Costing Ingredient option value allows you to calculate a markup line based on the costing values of a specific costing ingredient. This costing ingredient can also be a to-total. |
| Rounding method code | This field specifies whether to round the costing price of the costing value that will result when the costing condition is applied in a costing proposal. The method of the desired rounding is controlled by a rounding method defined in the master data. This table is a standard table. You have the option to always round amounts up or down or to round them commercially (here, amounts are only rounded up if the digit to be rounded is >=5). Otherwise amounts are rounded down. For more information, see Rounding methods. |
| Costing element | A costing element is assigned to each costing condition line. In principle, a costing item with any cost range can be assigned to a costing condition line. However, you should make sure that you use a costing item whose cost range corresponds to the intended application area of the respective costing condition. |
| Indicative price | Check this field only for the line that is to determine your indicative price. |
| Error text | If you enter an incorrect formula, the corresponding error message will appear in this field. |
KUMAVISION Item Costing provides you with predefined costing conditions (markup) for use or further individual additions:
| Field | Impact | Impact Calculation |
|---|---|---|
| Surcharge | Surcharge Calculation | |
| Description | Surcharge | Surcharge calculation |
| guideline price | guideline price | guideline price |
| sales code | customer | customer |
| sales code |
No further details are defined in the calculation condition lines of the condition "Surcharge".
| Rubric no. | Description | Calculation | Formula/Code | Rounding Code | Calcul. Component | Calcul. Component Description | Price |
|---|---|---|---|---|---|---|---|
| HK | Manufacturing costs | Calc. cost | 10400 | ||||
| Shipping | Formula | HK * 0,5/100 | 10410 | Shipping | |||
| Quality Control | Formula | 00.70 % HK | 10420 | Quality Control | |||
| Sales Overhead | Formula | 03.00 % HK | 10430 | Sales | |||
| Administration formula | 02.50 % HK | 10510 | Administration | ||||
| SEK d. Technic | Calculationb. | 10520 | |||||
| SK | Self-cost | Calc. | 10600 | ||||
| risk | formula | 02.00 % SK | 10610 | risk/profit surcharge | |||
| profit | formula | 30.00 % SK | 10610 | risk/profit surcharge | |||
| MRP | Minimum Reference Price | Calculationb. | 10700 | ||||
| commission 1 | formula | 03,00 § MRP | 10710 | commission | |||
| Commission 2 | Formula | 01,00 § MRP | 10710 | Commission | |||
| Saccount | Formula | 03,00 § MRP | 10720 | Skonti | |||
| Discount | Formula | 10.00 § MRP | 10730 | Discounts | |||
| RP | Guide price | Calculation | 10800 | ||||
| RPG | Rounded target price | Calculation item | 10800 | PRICE | |||
| Rounding | Formula | RPG-RP | 10810 | Rounding income/cost | |||
| Guideline price (incl. rounding) | Calculation item | 10900 | Yes |
| Heading no. | Description | Calculation | Formula / Code | Rounding code | Lime. Component | Lime. Component Description | Indicative price |
|---|---|---|---|---|---|---|---|
| HK | Manufacturing costs | Calculation cost | 10400 | ||||
| Shipping | Formula | HK * 0,5/100 | 10410 | Shipping | |||
| Quality Control | Formula | 00.70 % HK | 10420 | Quality Control | |||
| Sales Overhead | Formula | 03.00 % HK | 10430 | Sales | |||
| Administration formula | 02.50 % HK | 10510 | Administration | ||||
| SEK d. Technic | Calculationb. | 10520 | |||||
| SK | Self-cost | Calc. | 10600 | ||||
| risk | formula | 02.00 % SK | 10610 | risk/profit surcharge | |||
| profit | formula | 30.00 % SK | 10610 | risk/profit surcharge | |||
| MRP | Minimum Reference Price | Calculationb. | 10700 | ||||
| commission 1 | formula | 03,00 § MRP | 10710 | commission | |||
| Commission 2 | Formula | 01,00 § MRP | 10710 | Commission | |||
| Saccount | Formula | 03,00 § MRP | 10720 | Skonti | |||
| Discount | Formula | 10.00 § MRP | 10730 | Discounts | |||
| RP | Guide price | Calculation | 10800 | ||||
| RPG | Rounded target price | Calculation item | 10800 | PRICE | |||
| Rounding | Formula | RPG-RP | 10810 | Rounding income/cost | |||
| Guideline price (incl. rounding) | Calculation item | 10900 | Yes |
Calculation scheme#
The application area "Costing" allows you to evaluate the results of the article costing and the order costing in so-called costing sheets. Costing schemas have the form of a matrix with a freely definable row layout and a freely definable column layout and are comparable to the account schemas (Microsoft Dynamics 365 Business Central1 Standard).
A costing sheet can be basically the same as the structure of the costing sheet, but it is usually presented in slightly less detail by grouping certain items together. For example, you can display total material costs in the chart of accounts; without subdividing them into direct material costs and material overhead costs. This is possible because when you create a costing proposal, the application automatically assigns each costing value to a costing item.
Any number of costing sheets can be created. Two costing sheets are already included in the basic costing setup - namely the standard costing sheet and the overview sheet. Of course, these schemes can be further customized according to your requirements.
Via the search term "Calculation schema names" you can call up the overview.
Via "New" in the menu ribbon you can define a new scheme with the help of the table below.
| field | description |
|---|---|
| Name | In this field, enter a name for the calculation schema. |
| Description | In this field, enter a description for the calculation schema. |
| Standard column layout | In the field "Standard column layout" you can define the criteria for the calculation in the column view. The column layout stored there will always be used as the basis for the calculation. |
Via "Calc. Edit scheme" in the ribbon you have the possibility to define the scheme in detail.
| field | description |
|---|---|
| CategoryNo. | Give a category number to describe the row uniquely or to be able to use this row for a calculation later on. |
| Description | Enter a description for the row. |
| Summary Type and Summary Count | The Summary Type field is a choice field. It determines which records will be included: Ingredient Total The total is made up of the amounts taking into account the costing ingredients of the Costing Ingredient type. To do this, specify an expression in the "Totaling" field to filter the costing components to be used. Example The "Totaling" field contains the expression 10100..10299. Specifying this causes the costing sheet row to display amounts resulting from the costing components in the range 10100 to 10299. Only costing items of the type costing item are taken into account. Total The total is formed from the amounts taking into account the costing item of the type "Total" or "To total". To do this, specify an expression in the "Sum Total" field to filter the costing items to be used. Example The "Sum Total" field contains the expression 10100..10299. Specifying this causes the costing sheet row to display amounts resulting from the costing items in the range 10100 to 10299. Only costing items of the type "Total" or "To total" are taken into account. Formula The total is formed from the calculated amounts in other lines of the same costing sheet. To do this, specify an arithmetic formula in the "Total" field. When doing so, use the "Heading No." field to refer to the other lines in the schema in the formula. Example The "Add Up" field contains the expression A+B. The amounts from all other calculation schema rows of the same schema, which have the value A or B in the "Rubric no." field, are added together. |
| Display | This field is relevant for the "Calculation schema" report. You have the following choices: Yes The row will be printed in the report. No The row will not appear in the report. For example, you can use this option to define a calculation scheme row that contains subtotals of a longer calculation scheme. If a column is not 0: The row will only be printed in the report if it is not 0. Thus, rows with no amount will not be printed at all. |
| New Page | If you mark the calculation scheme row with a check mark, the report will make a page turn at this point. |
| Bold | If you mark the calculation schema line with a check mark, the line will be displayed in bold in the report. |
| Italic | If you mark the calculation schema line with a check mark, the line will be displayed in italics in the report. |
| Underlined | If you mark the calculation schema row with a check mark, the row will be underlined in the report. |
| Invert sign. | If you mark the field of the calculation scheme row with a check mark, all calculated amounts of the row will be displayed with reversed sign in the "Calculation scheme matrix". |
Delete#
You can delete the calculation schema using the "Delete" menu item.
Print#
With the menu item "Print" you have the possibility to print the calculation schema considering a defined column layout and the specification of at least one calculation proposal line.
Set up account#
The "Insert accounts" function transfers the records of the Costing item table to the present book sheet, creating exactly one costing item row for each costing item. The number of the costing item is then placed in the "Total" field of the costing sheet row.
You can select the costing elements to be transferred individually after starting the function. All costing elements are displayed in an overview. Select the data records you want and then click OK to start the transfer.
Set up column layouts#
The menu item "Set up column layouts" allows you to define a column layout for the defined calculation schema.
KUMAVISION Item Costing already provides you with two predefined calculation schemes for use or further individual additions:
Calculation scheme standard:
| Heading no. | Description | Counting type | Counting | Advertisements |
|---|---|---|---|---|
| 10010 | Direct material cost | Component total | 10010 | Yes |
| 10011 | Direct material costs 2 | Inventory total | 10011 | Yes |
| 10020 | Special direct material costs | Inventory subtotal | 10020 | Yes |
| 10030 | Material overhead | Inventory total | 10030 | Yes |
| 10040 | Material surcharges | Inventory sum | 10040 | Yes |
| 10045 | Freight costs | Inventory sum | 10045 | Yes |
| 10046 | Handling costs | Inventory sum | 10046 | Yes |
| 10049 | Sum of material costs | Sum total | 10049 | Yes |
| Components total | Yes | |||
| 10110 | Individual cost of elm | Component total | 10110 | Yes |
| 10120 | Single cost worker | Component total | 10120 | Yes |
| 10130 | Individual costs machine | Component total | 10130 | Yes |
| 10150 | Overhead cost elm | Component total | 10150 | Yes |
| 10160 | Overhead Costs Workers | Component Total | 10160 | Yes |
| 10170 | Machine overhead | Component total | 10170 | Yes |
| 10180 | Electricity/Building | ComponentSum | 10180 | Yes |
| 10210 | External labor costs | Component total | 10210 | Yes |
| 10250 | Overhead costs external labor | Component total | 10250 | Yes |
| 10299 | Total capacity costs | Grand total | 10299 | Yes |
| Component sum | Yes | |||
| 10300 | Individual costs assembly res. | Component total | 10300 | Yes |
| 10305 | Overhead cost of assembly Res. | Component total | 10305 | Yes |
| Component sum | Yes | |||
| 10310 | Tools | Component Sum | 10310 | Yes |
| 10320 | Certifications | ComponentSum | 10320 | Yes |
| Components total | Yes | |||
| 10400 | Cost of goods sold | Grand total | 10400 | Yes |
| Components | Yes | |||
| 10410 | Shipping | Inventory | Total | 10410 |
| 10420 | Quality control | Component total | 10420 | Yes |
| 10430 | Distribution | ComponentSum | 10430 | Yes |
| 10510 | Administration | ComponentSum | 10510 | Yes |
| 10520 | Special direct costs for technology | Inventory subtotal | 10520 | Yes |
| (Sales overhead) | Inventory subtotal | 10400..10499 | Yes | |
| (Administrative overhead) | Component total | 10500..10599 | Yes | |
| 10600 | Self-costs | Sum total | 10600 | Yes |
| 10610 | Risk/profit surcharge | Components sum | 10610 | Yes |
| 10700 | Minimum reference price | Sum total | 10700 | Yes |
| 10710 | Commission | Component sum | 10710 | Yes |
| 10720 | Discounts | Cumulative total | 10720 | Yes |
| 10730 | Discounts | Cumulative total | 10730 | Yes |
| (commission/discount/discounts) | Cumulative total | 10710..10799;10810 | Yes | |
| 10800 | Direct price | Sum total | 10800 | Yes |
| 10900 | Guideline price (rounded) | Sum total | 10900 | Yes |
| Component sum | Yes | |||
| Component sum | Yes | |||
| Total markup | Component total | 10401..10499 10501..10599 10601..10699 10701..10799 10810 |
Yes |
Calculation scheme overview:
| Heading no. | Description | Counting type | Counting | Advertisements |
|---|---|---|---|---|
| MAT | Sum of material costs | Sum of components | 10010..10048 | Yes |
| KAP | Sum of capacity costs | Sum of components | 10110..10199 | Yes |
| FREMD | Sum External Labor Costs | Inventory Sum | 10210..10298 | Yes |
| PROD | Sum Production Overhead | Inventory Sum | 10300..10399 | Yes |
| Total material costs | Sum total | 10049 | Yes | |
| Component sum | Yes | |||
| 10410 | Shipping | Component sum | 10410 | Yes |
| 10420 | Quality control | Component total | 10420 | Yes |
| 10430 | Distribution | ComponentSum | 10010 | Yes |
| 10510 | Administration | ComponentSum | 10010 | Yes |
| 10520 | Special direct costs for technology | Inventory subtotal | 10010 | Yes |
| 10600 | Self-costs | Sum total | 10600 | Yes |
| 10610 | Risk/profit surcharge | Sum total | 10610 | Yes |
| 10700 | Minimum reference price | Sum total | 10700 | Yes |
| 10720 | Discounts | Component sum | 10720 | Yes |
| 10730 | Discounts | Component sum | 10730 | Yes |
| 10900 | Price (rounded) | Grand total | 10900 | Yes |
| Component sum | 10010 | Yes | ||
| Sum of markups | Component total | 10401..10499 10501..10599 10601..10699 10701..10799 10810 |
Yes |
Item card#
Item Calculation Conditions#
You can call up the article calculation conditions via the article card. Here you can define the calculation conditions specifically for a certain article or a species group for later calculation.
In the "General" area of the article calculation conditions, you will first find filters that you can use to control your view. When you open the mask, the filters are initially always preset to the article from which you have called up the mask.
| Field | Description |
|---|---|
| Sales type filter | Using the sales type filter, you can restrict your view to lines of a specific calculation type or none. The following selection options are available: - Material - Production - None |
| Type filter | Use the type filter to limit your view to rows of a specific type. The following selections are available: - Item - Item category - Product posting group - Stock posting group - All items - None |
| Code Filter | Use the code filter to further narrow your view in addition to the type filter on a specific item or similar . |
| Start Date Filter | Using the start date filter, you can narrow your view to specific validity lines. |
Via the lines you can directly define the calculation conditions with the help of the table below.
| Field | Description |
|---|---|
| Costing type | In this field you define for which costing type you want to define the line. You can choose from: Material: The condition will be considered in the calculation, if it is the calculation of raw materials (purchase items). Production: The condition will be considered in the calculation, if it is the calculation of products (production items). |
| Type | Using the "Type" field, you have the option of defining the condition line for an item or for faster entry of a type group. The following options are available: - Item - Item category - Product posting group - Stock posting group - All items |
| Code | You can limit each selection in the "Type" field to a specific item number or type group number in this field. |
| Indirect Cost % | Enter the indirect cost of the item as an absolute amount at this point. Note If you are working with costing, it is recommended that you do not maintain the default field on the item card. |
| Indirect Cost % | Indicate the indirect cost of the item as a percentage value at this point. Note This field is identical to the field on the item card. However, if you are working with costing, it is recommended that you do not maintain the default field on the item card, and instead maintain only this one. |
| Overhead Cost Rate (Consumption Capitalization) | Enter the consumption capitalized overhead as an absolute amount at this point. Note Overhead and consumption capitalized overhead can be used in parallel. The only difference is that only either a Costing Condition or a Costing Condition Consumption Activated can be defined. Both will not work<br |
| Cost % (Consumption Activated) | Enter the consumption activated costs as a percentage value at this point. |
| Calculation Condition No. | Enter the corresponding calculation condition. |
| Start Date | Indicates the date from which the calculation line is valid. |
| End date | Specify the date until when the calculation line is valid. |
Via "Manage" > "Delete" you can delete a selected calculation row.
Article calculation conditions (cannot be activated)#
The article costing conditions (cannot be activated) are called up via the article card. This allows you to specify the non-activatable costs (costs that are not included in the cost price) specifically for a particular article or species group for later costing.
In the "General" area of the article calculation conditions (cannot be activated) mask, there are initially filters that you can use to control your view. When you open the mask, the filters are initially always preset to the article from which you have called up the mask.
| Field | Description |
|---|---|
| Sales Type Filter | Use the sales type filter to limit your view to lines of a specific costing type or none. The following selections are available: - markup - special direct cost - none |
| Type Filter | Use the type filter to limit your view to lines of a specific type. The following selections are available: - Item - Item category - Product posting group - Stock posting group - All items - None |
| Code Filter | Use the code filter to further narrow your view in addition to the type filter on a specific item or similar . |
| Start date filter | Using the start date filter you can limit your view to certain validity lines. |
Using the rows you can directly define the calculation conditions with the help of the table below.
| Field | Description |
|---|---|
| Calculation type | In this field you define for which calculation type you want to define the line. You can choose from: Surcharge The condition is taken into account in the calculation if it is the calculation of "end products". Here you no longer define the cost price of the item, but the markup up to the target price. Special direct costs The condition is defined for the costs that are incurred for a product, but are not quantity-dependent. |
| Type | Using the "Type" field, you have the option of defining the condition line for an item or for faster entry of a type group. The following options are available: - Item - Item category - Product posting group - Stock posting group - All items |
| Code | You can narrow down each selection in the "Type" field to a specific item number or type group number in this field. |
| Calculation condition number | Indicates the corresponding calculation condition. |
| Calculation Condition Description | Gives the description for the calculation condition selected in the "Calculation Condition No." field. |
| Start Date | Indicates the date from which the calculation line is valid. |
| End date | Indicates the date until when the costing line is valid. |
| Special direct costs | Indicates possible special direct cost values. |
| Quantity per unit | Indicates the quantity per unit. |
| Special direct costs per unit | Indicates the special direct costs per unit. |
| Costing Item No. | Specifies the costing item for the special direct costs. |
| Costing Item Description | Specifies the description for the costing item selected in the "Costing Item No." field. |
| Project No. | Indicates a possible project number. |
Via "Manage" > "Delete" you can delete a selected calculation row.
Calculation specifications#
You can use the "Costing specifications" to specify different lot sizes in advance for the cost of goods manufactured simulations, which will be taken into account in the subsequent costing.
| Field | Description |
|---|---|
| No. | This number is automatically assigned on the basis of a stored number series. |
| ArticleNo. | This is automatically assigned with the article number from which you started the call. |
| Description | Corresponds to the article description. |
| Start date | From when should this calculation specification be valid. |
| End date | To when should this costing specification be valid. |
| Lot Size | Indicates the lot size number. |
| Standard | This field is queried when calculating the cost price. If this field is set and also in the function "Calculate cost price (fixed)/Directive price for item" the switch "Only standard costing specifications" is set, then only lot sizes are used that have the check mark set in the costing specifications. |
Capacity costing conditions#
You call up the "Capacity costing conditions" via the work center group card. Via this screen you can define the costing conditions you want to assign to your capacities (work center groups and work centers). The condition is taken into account during costing as soon as a capacity is addressed (e.g. because a routing is stored with a production article).
In the area "General" of the capacity calculation conditions you will find filters that you can use to control your view. When you open the mask, the filters are always preset to the work center group from which you have called the mask.
| Field | Description |
|---|---|
| Type filter | Using the type filter, you can limit your view to lines of a specific type or none. The following selections are available: - Department - Workstation group - Workstation - Workstation line - None |
| Start date filter | Using the start date filter, you can limit your view to certain validity lines. |
Via the lines you can directly define the calculation conditions using the table below.
| Field | Description |
|---|---|
| Type | Using the "Type" field, you have the option of defining the condition line for a workstation group or similar. The following options are available: - Department - Workstation group - Workstation - Work plan lines |
| Code | You can limit each selection in the "Type" field to a specific workstation group or similar in this field. |
| Version Code | Indicate the corresponding version code. |
| Work operation no. | Indicate a corresponding work operation. |
| Indirect Cost % | Enter the indirect costs as an absolute amount here. |
| Indirect costs % | Enter the indirect costs as a percentage value here. |
| Calculation Condition No. | Enter the corresponding calculation condition. |
| Calculation Condition Description | Give the description for the calculation condition selected in the "Calculation Condition No." field. |
| Start Date | Indicates the date from which the calculation line is valid. |
| End Date | Indicates the date until when the calculation line is valid. |
Via "Manage" > "Delete" you can delete a selected calculation row.
Article costing#
The costing proposal is used for the cost of goods manufactured calculation. You can call this up directly from the respective article card via the menu ribbon.
Calculation proposal#
In the costing proposal lines, (if available) historically previous costings are displayed.
In the calculation proposal lines (if available) historically already previous calculations are displayed.
| Field | Description |
|---|---|
| Warning | blank The proposal line does not contain any errors and can be accepted if required. Errors The proposal line contains errors which can be viewed and corrected via the error log. After correction, the proposal must be run through again. |
| Calculation Run Ref. No. | Indicates a sequential number per proposal line. For proposal lines that contain different article costing specifications (lot sizes), these are displayed with the same sequential number. |
| Costing Run Description | Gives the description that has been specified for the respective costing run. |
| Item No. | Indicates the item number for which the suggestion line has been calculated. |
| Description | Specifies the description of the item. |
| Procurement method | Indicates the stored procurement method of the item. |
| Status | Indicates the status of the suggestion line. Here it is distinguished in: - empty - Preferred - Rejected - Accepted For further information, please refer to the section "Change status" |
| Lot Size | Indicates the lot size on which the proposal line was costed. Note Please note that the lot sizes on the item card as well as in the costing specifications can be used for costing. |
| Calculation Date | Indicates the date on which the proposal line was costed. |
| Cost price (fixed) | Indicates the stored "Cost price (fixed)" on the article card. |
| New cost price (fixed) | Displays the new cost price (fixed) of the suggestion line. |
| Cost % (Consumption Activation) | Displays, (if available) the "Cost % (Consumption Activation)" determined from the costing definitions. |
| Overhead Rate (Consumption Activation) | Gives, (if available) the "Overhead Rate (Consumption Activation)" calculated from the costing definitions. |
| Target price | Gives the previous target price. |
| New target price | Displays the newly calculated target price. |
Calculate set price (fixed)/direct price for article#
When this function is executed, the cost price for the corresponding items is calculated.
| Field | Description |
|---|---|
| Calculation date | Specifies the calculation date. This is used to take into account the start and end date of purchase prices, costing conditions or even parts lists and routings for the costing. |
| Costing Run Description | This entry is a mandatory entry and defines what kind of costing it is. |
| Standard calculation specifications only | Here you can define whether the lot size of the article to be calculated should be taken from the article card or the calculation specification. If the switch is not activated, (if available) the stored lot size of the calculation specification is treated with priority than that of the article card. If the switch is set, (if available) only the deposited lot size with the identifier=standard is treated with priority than that of the article card. Note This applies only to the first level, i.e. the article to be costed. |
| Costing Proposal Name (Plan) | Indication of the costing proposal (plan) if simulations are carried out. Note In order to determine the correct cost price based on the structure, which is then also written back to the item card, this field must not be filled in. |
Change status#
With this function you can set the status of the costing proposal line in the "Status" field according to the selection (Preferred or Rejected).
The status is relevant for the function execution "Adopt costing proposal (preferred)". Only costing proposal lines with the "Preferred" status are adopted.
If the price has been adopted, the "Status" field is set to "Adopted".
Adopt costing proposal (preferred)#
With this function, the values from the calculation proposal lines with the status=Preferred are used and transferred to the article card.
When executing the function, it is also possible to carry out a revaluation at the recalculated price for the article items that are still open.
| Field | Description |
|---|---|
| Posting Date | Required for the revaluation ledger sheet. Corresponds to the valuation date. |
| Fill revaluation book.sheet | Will be selected if you want to revaluate the currently still open article items. Depending on the selection of the field "Transferred from" either the whole structure can be revaluated or only the article from the calculation proposal. The revaluation book sheet can still be controlled afterwards. It must always be posted manually. |
| Voucher No. | Indicates which voucher number is to be written into the revaluation ledger sheet.<br |
| Article book. sheet template | Indication of the revaluation book sheet. |
| Article Book Sheet Name | Specify the revaluation book sheet name. |
| Transfer from | One level Only the prices from the article from the calculation proposal line will be updated. The items in lower levels will not be updated. All levels All prices and price fields of all items that occur in the structure will be updated. |
Article costing specifications#
The "Article costing specifications" can be used to carry out manufacturing cost simulations with different batch sizes. As a rule, these defaults are already defined in advance in the "Costing defaults" on the respective article card and displayed accordingly at this point. If necessary, changes and/or entries can be made here.
Note
This always only affects the article that is currently being costed. If also costing defaults are defined for assemblies in subset levels, these are not considered. Here always the lot size is drawn from the article card.
| Field | Description |
|---|---|
| No. | This is automatically assigned based on a stored number series. |
| Item No. | This is automatically assigned with the article number from the data record of the calculation proposal line. |
| Description | Corresponds to the article description. |
| Start date | From when this calculation default should apply. Reference date is the "Calculation date" when executing the function "Calculate set price (fixed)/Directive price for article". |
| End date | To when should this calculation specification be valid. Reference date is the "Calculation date" when executing the function "Initial price (fixed)/Calculate target price for article". |
| Default | This field is requested when calculating the cost price. If this is set and also in the function "Calculate cost price (fixed)/Price for article" the hook "Only standard costing specifications" is set, then only lot sizes are used, which have the hook set in the costing specifications. Note Lot size from the article is not used, if valid costing specifications were found. |
| Remark | Indicates whether a remark exists for this calculation specification. Remarks can also be entered here. |
| Corrected on | Set by the system when the record is created or corrected. |
Note
If there are several valid entries, the system automatically creates a separate calculation for each valid entry.
Retrieve error log#
The error log lists all errors that occurred during the calculation. By clicking on the integrated lookups or calling up "Display" in the menu ribbon, the errors can be edited directly from the mask.
Note
Please note that you have to recalculate the calculation after fixing the errors.
Calculation values (matrix)#
In this view the rows of the account scheme are superimposed with the columns of the column layout. According to the filters entered, the values are displayed. By selecting a predefined column layout for comparison, a comparison of two calculation proposals is possible at this point.
Costing values (structure)#
In this view you can see all considered costing values in a structure detailed on cost type level. Thereby you have the possibility to view the origin documents on row level via the call of the same name.
Structure list#
The structure list allows you to view a costing proposal aggregated over all costed levels and their costs.
| Field | Description |
|---|---|
| Costing proposal 1 Filter | Select a costing proposal you want to have displayed. |
| Include overhead | Activate the check box if you want to consider the overhead costs included in the respective costs. |
| Material only | Activate the check box if you want to view only the material costs. |
| Cost selection | Use the cost selection, you can specify the BOM depth over which you want to display the costs. Single level Displays the costs of the top level of the BOMs. Multi-level Displays the costs multi-level, broken down to the last assembly/component. Single level Displays the costs of the top level of the BOMs. |
Structure list comparison#
With the help of the structure list comparison you can directly compare two costing proposals. This structure list comparison allows you to see at a glance, through visualized representation in the "Symbol Deviation" fields, at which level a change to the previous proposal has taken place.
| Field | Description |
|---|---|
| Calculation Proposal 1 Filter | Select a calculation proposal that you want to compare with another proposal. |
| Costing Proposal 2 Filter | Select another costing proposal that you want to compare with the one already selected from the Costing Proposal 1 Filter field. |
| Include overhead | Activate the checkbox if you want to include overhead in the respective costs in the comparisons. |
| Material only | Activate the check box if you only want to compare the material costs. |
| Cost selection | Use the cost selection, you can specify the BOM depth over which you want to display the costs. Single-level Displays the costs of the top level of the BOMs. Multi-level Displays the costs multi-level, broken down to the last assembly/component. |
After your selection, you then execute the "Compare" function in the ribbon to compare the values in the row display.