Calculation#
General#
With the help of the calculation you can make the following business evaluations and calculations directly in KUMAVISION factory365:
- Regular item costing with highlighting of variances.
- Quotation costing
- Development calculation
- Co-calculation
- Calculation up to the target price
- Access protection of the calculation data
- Separate reporting of costs
- Calculation with planned values
- Extension to include cost elements in the single-level as well as multi-level area (e.g. "material overhead")
Note
You need separate licenses before you can use Calculation function.
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 bearing valuation.
Furthermore, simulations can also be carried out in the cost of goods manufactured in the event of changes in purchase prices, labor time prices or overhead rates.
Development calculation#
When creating new products, not all parts list items or work plan items are always known or their prices have not yet been determined. However, it is necessary to know the approximate manufacturing costs at an early stage and also to determine a sales price.
To make this possible, a "Simulated production order (cost estimate)" can be created manually for such an article. The known information from the routing and bill of materials is used. These values can then be changed as desired.
In addition, there is the possibility to manually. "Additional costs" with quantities, times and prices and, if required, the "Overhead rates" can be adjusted or supplemented.
Quotation costing#
For make-to-order manufacturers, the challenge is to perform calculations for individual customer orders as efficiently and accurately as possible. Therefore, KUMAVISION factory365 can provide the calculations for similar projects or articles as a basis via the Smart Start packages. Based on this, employees can calculate different variants without having to start from scratch. This means a significant time saving compared to before. This also comes into play for old, already expired offers. A new calculation can be created with just a few entries, as only the new prices need to be transferred. For contract manufacturers, transparency is another important factor. With the old calculations stored, sales staff can explain to customers, item by item, why there is a price difference compared to previous quotations. This is also important for projects that run over a longer period of time: If deviations from the original quotation occur during the course of the project, the customer can be told in detail what the causes are at the touch of a button. This is because the concurrent costing does not use the theoretical planned values, but the current actual values.
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, these additions to the Microsoft Dynamics 365 Business Central1 standard not only make 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 level costs#
Single-level costs are costs that are incurred only for this item. This means that for the calculation only the respective cost price of articles from the bill of materials or the prices and overhead costs are taken directly from the routing. No structures are exploded in the process.
Example:
An assembly in the bill of materials, is shown 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 further to the purchase item. Only the purchase item is shown as material cost, the rest is capacity/external labor or production cost.
Consumption-capitalized material overheads#
The material costs can be included directly in the cost price of the raw material at the time of stock receipt, but also as consumption-capitalized material costs that are not included in the product until production.
The overhead and consumption capitalized costs can be mixed on the item card and in the costing condition lines.
Hierarchy of Consumption Capitalized Overhead:
a) Calculation conditions consumption activated
b) Calculation condition line
c) Article
Hierarchy Overhead:
a) Calculation conditions not consumption activated
b) Calculation condition line
c) Article
Note
Overhead costs and consumption activated overhead costs can be used in parallel. The only difference is that you can only define either a costing condition or a consumption activated costing condition. Both do not work.
Cost types#
Below you will find an overview of the cost types that exist in Microsoft Dynamics 365 Business Central1 in connection with KUMAVISION factory365:
| Field | Description |
|---|---|
| Single-level material costs | All costs (cost price - overhead) that come from the bill of material. |
| Single-Level Material Overhead | All overhead costs resulting from purchased items in the bill of material. |
| Single-level capacity costs | All costs (cost price - overhead) that come from the routing.(No external labor operations) |
| Single-level capacity overhead | All overhead costs that come from the item's routing. (No outside labor operations) |
| Single-Level Production Overhead | Production overhead stored 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 | All overhead costs of external labor operations, from the corresponding routing. |
| Multi-level material costs | All material costs (cost price - overhead) of purchasing items totaled over all levels. |
| Multi-level material overhead | All material overhead costs of purchase items summed over all levels. |
| Multi-level capacity costs | All capacity costs (cost price - overhead) from all routings summed over all levels. |
| Multi-level capacity overhead | All capacity overhead costs of all operations summed over all levels. |
| Multi-level 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 | All external labor overhead costs from all external labor operations totaled across all levels. |
Note
The totals of the single-level and multi-level prices only match as long as no bookings 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)
Establishment#
Evaluation & calculation facility#
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 is only used for items with the production type "make-to-stock". The following selections are available: Cost price: The value of the "Cost price" field from the item's master data is used. Cost price (latest): The value of the "Cost price (latest)" field from the item's master data is 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 field "Cost price" from the master data of the item will be used. Cost price (latest): The value of the "Cost price (latest)" field from the item's master data is used. Purchase price (purchase prices): If the article has the procurement method "Purchase", first the purchase price valid for the vendor no. of the article is determined from the table Purchase price and the valid line discount % from the table Purchase line discount (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 Adopt proposal | At this point, you can decide whether the results of these calculations are written back for the respective articles. The following selection options are available: One level: The cost price (fixed) is only written back at the article for which the calculation was performed. All levels: The cost prices (fixed) are written back at all assemblies / components that were 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 calculation. Example: 2:5 means: minimum 2 decimal places and maximum 5 decimal places. For further information, use the Microsoft Dynamics 365 Business Central1 Helpsite on the topic "Unit price decimal places field". . |
| Quantity Decimal Places | At this point you define how many decimal places should be specified in the calculation minimum and maximum for the quantities. Example: 2:5 means: Minimum 2 decimal places and maximum 5 decimal places. For further information use the Microsoft Dynamics 365 Business Central1 Helpsite on the topic "Unit price decimal places field". |
| Fixed costing sheet name for costing proposal (E+D) | This setting applies to the costing sheets matrix that can be called up from the costing proposal (E+D) - i.e. via the production orders. With this field you have the option of specifying a standard costing sheet. If you enter a schema at this point, the user can only work with this schema and no longer select another (lock function). If the user should have the option to select other calculation schemas, then do not put anything in this field. |
| Calculate E+D Order (Sales) | This field refers to the calculation from a sales quotation or a sales order. The following options are available: Calculate only: The system creates the calculation, but does not perform any further action afterwards. If you want to display the newly created Simulated E+D Order, you must call it up manually. Calculate+Display: After the system creates the calculation, the created Simulated E+D Order is displayed directly in a window. Calculate+Apply: If the calculation proposal could be created without errors, the value of the "New target price" field of the executed calculation proposal will be applied to the "Sales price" field of the sales line. |
Assuming that consumption-based items (make-to-stock) are procured on a regular basis, the cost price or delivered price (latest) provides a good basis for costing because the prices usually represent realistic values.
The cost price is - except for the stock issue 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 a more detailed definition of the cost price fields on the item card, please use the Microsoft Dynamics 365 Business Central1 Helpsite.
Items that are procured on an order basis (make-to-order production), on the other hand, can either also be costed on the basis of the cost prices, or - and this makes sense especially for articles that are procured infrequently - on the basis of the currently valid purchase prices. If there is no current purchase price for the article, a planned value can also be entered in the preliminary costing.
Note
The cost prices are always "adjusted" prices, i.e. freight costs or precious metal surcharges 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 - even for pure purchase articles, for which the production type is irrelevant by default.
Inforegister numbering#
| Field | Description |
|---|---|
| Calculation Default Numbers | Enter the code of the number series to be used to assign records to the Calculation Default Numbers table. |
| Calculation Condition Numbers | Enter here the code of the number series to be used to assign 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 "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 here a costing item from the costing item plan to which the direct costs incurred when a resource is used in an assembly order are allocated. |
| Description Costing element Direct costs (resource assembly) | Specifies the description of the selection in the "Costing item direct costs (resource assembly)" field. |
| Costing element overhead costs (resource assembly) | Select a costing item from the costing item plan here, to which the overhead costs incurred when a resource is used in an assembly order are assigned. |
| Description of costing element overhead costs (resource assembly) | Specifies the description of the selection in the Costing Item Overhead (Assembly Resource) field. |
Costing components plan#
The costing components plan is the foundation of the costing and is comparable with 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. This applies to both article costing and quotation costing.
In principle, the costing sheet is structured in the same way as the chart of accounts in the Financial Accounting application area.
KUMAVISION factory365 can already provide you with a set up costing element plan via the Smart Start packages. 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 "Connections" call 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: Choose sufficient intervals between the numbers of the individual costing components. This will allow you to insert additional costing items later if required. For example, you could assign only the end digits 00 to all account groups and only the end digits 0 to all accounts. |
| Description | Here you can enter any text to describe the content of the costing element. |
| Cost range | Articles and capacities are later assigned to the costing items table via the costing conditions. The Cost area field indicates the application area of the respective costing item. The following selection options are available: Cost of materials and material overheads: 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 the 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. Outside labor costs and outside labor overhead: The costing items with these options are used in costing items of the type "Capacity" if it is an external labor work center group (or assigned external work center) (Vendor number field is not equal to |
| Cost range | Production Overhead: The costing items with these options are used in costing conditions of 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 used article (production article 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 article, i.e. the difference between the sales price and the cost price of the article. |
| Type | With this field you specify the type of record. You can choose from the following: Costing component: This option is used for the actual calculation components. The later assignment is only done via these data records. Headline: A heading for a group of costing components. Sum: The Sum option is used if you want the application to sum up individual costing items. Please then enter a filter text in the Sum field to specify the costing components to be included. From-total / To-total: The From-total option marks the beginning of a continuous series of costing items to be totalized. The end of this series is a costing item 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 now specify the interval or other filter specification of numbers of the costing elements. The results of the specified costing elements are added to a total balance. For the type "Calculation component", "From-total" or "Heading" this field must remain empty. For the "To total" type, the field is automatically filled when the chart of accounts is indented (function in the ribbon). Only the costing items that lie between a From total and a To total are added together. For the "Sum" type, you must manually specify the costing items to be added together. |
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 Components Plan:
| 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.
Comments#
Date-dependent information can be stored for the respective costing element via the remarks.
Calculation conditions#
The costing conditions establish the link between the master data tables such as article, work center group, etc. and the costing components, thus enabling the results of a costing 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 you to define the costing costs 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.
A distinction is made in the following calculation condition types:
Costing condition (material)#
The calculation condition is used in records of the table Article calculation condition with the calculation type Material. That is, you define here costing conditions that you subsequently assign to some of your articles. The condition is taken into account in the calculation when it comes to 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 item in the "Costing items costs" field. For the costing condition "Material", this is usually the material direct costs. |
| Description costing element costs | Specifies the description of the selected costing item from the Costing Item Cost field. |
| Costing element overhead costs | Select the appropriate costing element in the "Costing element overhead" field. This is usually the material overhead for the costing condition "Material". |
| Description costing element overhead costs | Specifies the description of the selected costing item from the Costing Item Overhead field. |
Inforegister lines#
| Field | Description |
|---|---|
| Description | Here you enter a description of the content of your calculation condition line. |
| Costing item | A costing item 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. |
| Calculation Component Description | This field is automatically filled by the selection of the costing component. |
| Heading no. | The Rubric No. field is used to relate calculation condition rows 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 Amount, then the specification in the field Value is understood as absolute number input. So you have here the possibility to store fixed values, which 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 Amount, then the specification in the Value field is understood as a percentage number entry. If the line has been assigned a rubric no., then the basis of the percentage is the sum of all calculation condition lines of the same calculation condition with the same rubric no. and calculation amount. Note: If the line is not provided with a rubric no., the application uses either the purchase price of the origin line of the corresponding calculation value or (if available) the sum of all calculation condition lines of the same calculation condition with the calculation value as basis for the percentage. The rubric no. of these lines will then be 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 calculation values with the same rubric no. If the row was not assigned a rubric no., the application uses as a basis either the purchase price of the origin row of the corresponding calculation value or (if available) the sum of all calculation condition rows with calculation value and specification of any rubric no. (but only if these calculation condition rows were interpreted as part of a purchase price). |
KUMAVISION factory365 can provide you with predefined costing conditions (material) for use or further individual additions via the Smart Start packages:
Material (single) and material (single2):
| Field | Material (simple) | Material (simple2) |
|---|---|---|
| No. | KK0000 | KK0010 |
| Description | Material (simple) | Material (simple2) |
| Calculation item costs | 10010 | 10011 |
| Description of costing element costs | Direct material costs | Direct material costs 2 |
| Costing item overhead | 10030 | 10030 |
| Description 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) |
| Calculation item costs | 10010 | 10010 |
| Description of costing element costs | Direct material costs | Direct material costs |
| Costing item overhead | 10030 | 10030 |
| Description Costing Item Overhead | Material Overhead | Material Overhead |
| Field | Material (complex) | ||||
|---|---|---|---|---|---|
| Description | Handling | Freight | Overhead costs | Special direct costs | Material surcharges |
| Kalkulationsbestandteil | 10046 | 10046 | 10046 | 10046 | 10046 |
| Costing Item Description | Handling Costs | Freight Costs | Material Overhead | Special Direct Costs Material | 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 |
| Kalkulationsbestandteil | 10046 | 10045 | 10030 |
| Costing 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 records of the table Article calculation condition with the calculation type Production. This means that you define calculation conditions here which you then also assign to some of your articles. The condition is taken into account in the calculation if it is about 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 item in the field "Costing item costs". In the case of the costing condition "Production", these are usually the direct material costs or the special direct costs of production. |
| Calculation Item Cost Description | Indicates the description of the selected costing item from the "Costing Item Cost" field. |
| Costing element overhead costs | Select the appropriate costing item in the "Costing item overhead" field. In the case of the costing condition "Production", this is usually the cost of tools, special direct costs, etc. |
| Description costing element overhead costs | ISpecifies the description of the selected costing item from the Costing Item Overhead field. |
Inforegister lines#
| Field | Description |
|---|---|
| Description | Description of the calculation condition |
| Costing item | A costing item 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. |
| Calculation Component Description | This field is automatically filled by the selection of the costing component. |
| Heading no. | The field "Rubric no. " is used to relate calculation condition rows to each other in order to define a calculation basis 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 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 Amount, then the specification in the field "Value" is understood as a percentage number entry. If the line has been assigned a rubric no., then the basis of the percentage is the sum of all calculation condition lines of the same calculation condition with the same rubric no. and calculation amount. Note: If the row was not provided with a rubric no., the application uses as the basis for the percentage either the EK price of the origin row of the corresponding calculation value or (if available) the sum of all calculation condition rows of the same calculation condition before the current row with the calculation value. The rubric no. of these lines will then be 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 calculation values with the same rubric no. If the line has not been assigned a rubric no., 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 no. (but only if these calculation condition lines have been interpreted as part of an EK price). |
KUMAVISION factory365 can provide you with predefined calculation conditions (production) for use or further individual additions via the Smart Start packages:
| Field | Production (simple) | Production (complex) |
|---|---|---|
| No. | KK1000 | KK1001 |
| Description | Production (simple) | Production (complex) |
| Calculation item costs | 10011 | |
| Description of costing element costs | Direct material costs 2 | |
| Costing item overhead | 10310 | 10320 |
| Description costing component overhead | 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 in data records of the Work center costing condition table. This means that you define costing conditions here which you then assign 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 calculation condition |
| Costing element costs | Select the appropriate costing item in the field "Costing item costs". For the costing condition "Capacity", this is usually the direct production costs. |
| Calculation Item Cost Description | Gives the description of the selected costing item from the "Costing Item Cost" field. |
| Costing element overhead costs | Select the appropriate costing element in the "Costing element overhead" field. This is usually the production overhead for the costing condition "Capacity". |
| Description costing element overhead costs | Indicates the description of the selected costing item from the "Costing Item Overhead" field. |
Inforegister lines#
| Field | Description |
|---|---|
| Description | Here you enter a description of the content of your calculation condition line. |
| Costing item | A costing item 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. |
| Calculation Component Description | This field is automatically filled by the selection of the costing component. |
| Heading no. | The Rubric No. field is used to relate calculation condition rows 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. It can be used to define costing elements that only refer to the setup time in their calculation. |
| Share % | The content of the field is used as a percentage share 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 Amount, then the specification in the field Value is understood as absolute number input. So you have here the possibility to store fixed values, which 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 Value field is understood as a percentage number entry. If the line has been assigned a rubric no., then the basis of the percentage is the sum of all calculation condition lines of the same calculation condition with the same rubric no. and calculation amount. Note: If the row was not provided with a rubric no., the application uses as the basis for the percentage either the EK price of the origin row of the corresponding calculation value or (if available) the sum of all calculation condition rows of the same calculation condition before the current row with the calculation value. The rubric no. of these lines will then be 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 calculation values with the same rubric no. If the line has not been assigned a rubric no., 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 no. (but only if these calculation condition lines have been interpreted as part of an EK price). |
KUMAVISION factory365 can provide you with predefined calculation conditions (capacity) for use or further individual additions via the Smart Start packages:
| Field | Capacity (Energy) | Capacity (Simple) | Capacity (Complex) |
|---|---|---|---|
| No. | 01 | KK2000 | KK2001 |
| Description | Capacity (energy) | Capacity (simple) | Capacity (complex) |
| costing item cost | 10130 | 10130 | |
| Description of costing item cost | Individual costs machine | Individual costs machine | |
| Costing item overhead | 1 | 10170 | 10170 |
| Description of costing element 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 | scrubber | apprentice | GK machine | GK worker |
| Kalkulationsbestandteil | 10130 | 10120 | 10110 | 10120 | 10170 | 10160 |
| Costing component description | Individual costs machine | Individual costs worker | Individual costs elm | Individual costs worker | Individual costs machine | Individual costs worker |
| Rubric No. | M1 | A | A | M1 | A | |
| armament | 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 | Foreign work (simple) | Foreign work (complex) |
| Costing item costs | 10210 | 10210 |
| Description of costing item costs | individual costs external labor | individual costs external labor |
| Costing item overhead | 10250 | 10250 |
| Description of costing element overhead costs | Overhead costs external work | Overhead costs external work |
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 component | 10250 | 10250 |
| Calculation Item Description | Overhead Costs External Labor | Overhead Costs External Labor |
| heading no. | ||
| armament | ||
| Share % | 100 .00 % | 100. 00 % |
| Calculation / Value | 5 .00 % | 15. 00 % |
Calculation condition (markup)#
The calculation condition is used in records of the table Article calculation condition (cannot be activated) with the calculation type markup. This means that you define calculation conditions here which you then assign 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 |
| Takeover guide price | In an article calculation you can transfer the determined target price from a calculation proposal into the master data of the calculated article. You specify here, in which field of the master data the determined target price should be transferred: None: There is no transfer. Target price: The value is transferred to the field target price of the article (table article). Sales price: The value is taken over into the field Sales price (table article). Sales price: The value is taken over into the sales price table of the article. The entry is made taking into account the sales type and sales code. Price + Sales Price: The value is transferred to both the Price field (Article table) and the Sales Price table record. |
| Sales Type | This field is taken into account when entering the target price in the sales price table. The following selection options are available: • Debitor , • Debitor price group, • All debtors • Campaign It can only be edited if the option "Sales price" or "Target price+sales price" has been selected in the Transfer target price field. |
| Sale code | This field is also taken into account when entering the target 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 |
|---|---|
| Heading no. | The field "Rubric no. " is used to relate calculation condition rows to each other in order to define a calculation basis for percentage surcharges. |
| Description | Here you enter a description of the content of your calculation condition line. |
| Calculation | The field is a choice field and controls with its option value the meaning of the field "Formula/Code": 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 Formula, the Formula/Code field contains an arithmetic formula. The parts of the formula refer to the heading no. of other costing condition lines. Costing Item: If you select Costing Item, the Formula/Code field contains a costing item. Thus, this setting allows you to determine a markup line based on the costing values of a specific costing component. This costing item can also be a to-total. Project Planned Line: If you select Project Planned Line, the Formula/Code field contains a project task number. |
| Formula/Code | The meaning of the field depends on the value you have 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 use this constant also, in which you provide the line with a rubric no. and in another calculation condition line with the calculation formula reference to this line. Formula: In 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/1005) § 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/1055). 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 item can also be a to-total. |
| Rounding Method Code | The field specifies whether the costing price of the costing value that will be created when applying the costing condition in a costing proposal is to be rounded.The type and manner of the desired rounding is thereby controlled with the help of a rounding method defined in the master data. This table is a standard table. You have the option to always round up or down amounts or to round them up or down commercially (in this case, amounts are only rounded up if the digit to be rounded is >=5. For further explanations on how to set up the rounding methods, please use the Microsoft Dynamics 365 Business Central1 Helpsite. |
| Costing item | A costing item 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. |
| Guide price | Tick this field only in the line that should determine your guide price. |
| Bold | The Bold field controls the visual highlighting of the row in the E+D Order markup calculation window. |
| Error text | If you specify an incorrect formula, the corresponding error message appears in this field. |
KUMAVISION factory365 can provide you with predefined calculation conditions (markup) for use or further individual additions via the Smart Start packages:
| Field | Impact | Impact Calculation |
|---|---|---|
| No. | AUFSCHLAG | KK3000 |
| Description | Surcharge | Surcharge Calculation |
| Takeover target price | Target price | Target price |
| Sale | Debitor | Debitor |
| sale code |
No further details are defined in the calculation condition lines of the condition "Surcharge".
| Heading no. | Description | Calculation | Formula / Code | Rounding code | Lime. Component | Lime. Component Description | Indicative price |
|---|---|---|---|---|---|---|---|
| HK | Manufacturing costs | Calculation b . | 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. Technik | Calculation b . | 10520 | |||||
| SK | Self cost | Calculation b . | 10600 | ||||
| risk | formula | 02 .00 % SK | 10610 | Risk/profit surcharge | |||
| Profit | Formula | 30 .00 % SK | 10610 | Risk / Profit | |||
| MRP | Minimum Indicative Price | Calculationb . | 10700 | ||||
| commission 1 | formula | 03 ,00 § MRP | 10710 | Provision | |||
| commission 2 | formula | 01 ,00 § MRP | 10710 | Provision | |||
| Saccount | Formula | 03 ,00 § MRP | 10720 | Account | |||
| Discount | Formula | 10 ,00 § MRP | 10730 | Discount | |||
| RP | Guide Price | Calculationb . | 10800 | ||||
| RPG | Directive price rounded | Calculationb . | 10800 | PRICE | |||
| Rounding | Formula | RPG-RP | 10810 | Rounding income / costs | |||
| Guide price (incl. rounding) | Calculationb . | 10900 | Yes |
Calculation scheme#
The "Costing" application area allows you to evaluate the results of item costing and job costing in so-called costing sheets. Costing schemes have the form of a matrix with a freely definable row layout and a freely definable column layout and are comparable to the account schemes (Microsoft Dynamics 365 Business Central1 Standard).
A costing sheet can basically follow the structure of the costing sheet, but it is usually presented in somewhat less detail by grouping certain items together. For example, you can display the 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 calculation schemes can be created. Two calculation schemas are already included in the basic setup of the calculation - namely the standard calculation schema and the overview schema. Of course, these schemes can be further customized according to your requirements.
You can call up the overview using the search term "Kalkulationsschemanamen".
Via "New" in the ribbon you can define a new scheme using the table below.
| Field | Description |
|---|---|
| Name | In this field, assign a name for the calculation schema. |
| Description | In this field, specify a description for the calculation schema. |
| Standard column layout | The field "Standard column layout" is used to 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 |
|---|---|
| Heading no. | Enter a rubric number for a unique description of the row or to be able to use this row later for a calculation. |
| Description | Here you specify a description for the line. |
| Totalization type and totalization | The Totalization type field is a choice field. It determines which records will be included: Ingredient Sum: The sum is formed from the amounts taking into account the costing elements of the costing element type. To do this, specify an expression in the Total field to filter the costing components to be used. Example: The Total 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 items of the type total or to-total. To do this, specify an expression in the Total field to filter the costing items to be used. Example: The Total field contains the expression 10100..10299. Specifying this causes the costing sheet row to display amounts that result 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 this, use the Heading No. field to refer to the other rows in the schema in the formula. Example: The Add Up field contains the expression A+B. The amounts from all other spreadsheet rows in the same schema that have the value A or B in the Heading No. field are added together. |
| Display | This field is relevant for the Costing Sheet 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 without an amount will not be printed at all. |
| New page | If you mark the calculation schema line with a check mark, the report will make a page change at this point. |
| Bold | If you mark the calculation scheme row with a check mark, the row will be displayed in bold in the report. |
| Cursive | If you mark the calculation scheme line with a check mark, the line will be displayed in italics in the report. |
| Underlined | If you mark the calculation scheme row with a check mark, the row will be underlined in the report. |
| Reverse sign on | If the field of the calculation scheme row is checked, all calculated amounts of the row will be displayed in the Calculation scheme matrix window with reversed sign. |
Delete#
You can delete the calculation schema via the "Delete" menu item.
Print#
Via 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 no. of the costing item is then placed in the Totals 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 in the window and then click OK to start the transfer.
Set up column layouts#
Via the menu item "Set up column layouts" you have the possibility to define a column layout for the defined calculation schema.
KUMAVISION factory365 can already provide you with two predefined calculation schemes for use or further individual additions via the Smart Start packages:
Calculation scheme standard:
| Heading no. | Description | Counting type | Counting | Advertisements |
|---|---|---|---|---|
| 10010 | Direct material costs | Inventory total | 10010 | Yes |
| 10011 | Direct material costs 2 | Inventory total | 10011 | Yes |
| 10020 | Special direct costs material | Inventory total | 10020 | Yes |
| 10030 | Material overhead | Inventory total | 10030 | Yes |
| 10040 | Material surcharges | Component 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 |
| Component sum | Yes | |||
| 10110 | Individual costs elm | Component sum | 10110 | Yes |
| 10120 | Single cost worker | Summary | 10120 | Yes |
| 10130 | Individual costs machine | Inventory total | 10130 | Yes |
| 10150 | Overhead costs elm | Component sum | 10150 | Yes |
| 10160 | Overhead labor | Component total | 10160 | Yes |
| 10170 | Overhead machine | Components | 10170 | Yes |
| 10180 | Electricity/Building | Component sum | 10180 | Yes |
| 10210 | Individual costs external labor | Individual costs | 10210 | Yes |
| 10250 | Overhead costs external labor | Inventory total | 10250 | Yes |
| 10299 | Sum capacity costs | Sum total | 10299 | Yes |
| Component sum | Yes | |||
| 10300 | Individual costs assembly res. | Component sum | 10300 | Yes |
| 10305 | Overhead assembly res. | Component sum | 10305 | Yes |
| Component sum | Yes | |||
| 10310 | Tools | Components | 10310 | Yes |
| 10320 | Certifications | Inventory | 10320 | Yes |
| Component sum | Yes | |||
| 10400 | Total cost of goods sold | Sum total | 10400 | Yes |
| Component sum | Yes | |||
| 10410 | Shipping | Inventory | 10410 | Yes |
| 10420 | Quality control | Component sum | 10420 | Yes |
| 10430 | Sales | Inventory | 10430 | Yes |
| 10510 | Administration | Component total | 10510 | Yes |
| 10520 | Special individual costs engineering | Inventory total | 10520 | Yes |
| (Sales overhead) | Inventory total | 10400 ..10499 | Yes | |
| (Administrative overhead) | Component total | 10500 ..10599 | Yes | |
| 10600 | Self cost | Sum total | 10600 | Yes |
| 10610 | Risk/profit surcharge | Component sum | 10610 | Yes |
| 10700 | Minimum reference price | Sum total | 10700 | Yes |
| 10710 | Provision | Component sum | 10710 | Yes |
| 10720 | Discounts | Inventory | 10720 | Yes |
| 10730 | Discounts | Inventory | 10730 | Yes |
| (Commission/Discount/Discount) | Cumulative total | 10710 ..10799;10810 | Yes | |
| 10800 | Guide price | Sum total | 10800 | Yes |
| 10900 | Guide price (rounded) | Sum total | 10900 | Yes |
| Component sum | Yes | |||
| Component sum | Yes | |||
| Summe Aufschläge | Bestandteilsumme | 10401..10499 10501..10599 10601..10699 10701.. 10799 10810 |
Ja |
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 | Total external labor costs | Component total | 10210 ..10298 | Yes |
| PROD | Total production overhead | Inventory total | 10300 ..10399 | Yes |
| Sum of material costs | Sum total | 10049 | Yes | |
| Component sum | Yes | |||
| 10410 | Shipping | Inventory | 10410 | Yes |
| 10420 | Quality control | Component sum | 10420 | Yes |
| 10430 | Sales | Inventory | 10010 | Yes |
| 10510 | Administration | Inventory | 10010 | Yes |
| 10520 | Special individual costs engineering | Inventory total | 10010 | Yes |
| 10600 | Self cost | Sum total | 10600 | Yes |
| 10610 | Risk/profit surcharge | Component sum | 10610 | Yes |
| 10700 | Minimum reference price | Sum total | 10700 | Yes |
| 10720 | Discounts | Inventory | 10720 | Yes |
| 10730 | Discounts | Inventory | 10730 | Yes |
| 10900 | Guide price (rounded) | Sum total | 10900 | Yes |
| Component sum | 10010 | Yes | ||
| Summe Aufschläge | Bestandteilsumme | 10401..10499 10501..10599 10601..10699 10701.. 10799 10810 |
Ja |
Article card#
Article Calculation Conditions#
The article calculation conditions can be called up via the article card. With this mask you can define the calculation conditions specifically for a certain article or a species group for the later calculation.
The "General" area of the article calculation conditions mask initially contains 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 limit your view to lines of a specific costing type or none. The following selections are available: • Material • Production • None |
| Species filter | Using the species filter, you can limit your view to rows of a specific type. The following selections are available: • Article • Article category • Product booking group • Stock booking group • All articles • None |
| Code filter | You can use the code filter to further restrict your view in addition to the species filter on a specific article or similar. |
| Start date filter | Use the start date filter to narrow your view to specific 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: Material: The condition is taken into account in the calculation, if it is the calculation of raw materials (purchase items). Production: The condition is taken into account 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 article or for faster entry of a type group. The following options are available: • Article • Article category • Product booking group • Stock booking group • All articles |
| Code | You can limit each selection in the "Type" field to a specific article number or species group number in this field. |
| Indirect Cost Rate | 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 costs % | Indirect costs of the item as a percentage value. 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 standard field on the item card, but only this one instead. |
| 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 do not work. |
| Cost % (Consumption Activation) | Indicate the consumption-activated costs as a percentage value at this point. |
| Calculation Condition No. | Enter the appropriate calculation condition. |
| 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 calculation conditions (cannot be activated)#
The article calculation conditions (not activatable) can be called up via the article card. This screen allows you to define 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 | Using the sales type filter, you can limit your view to lines of a specific costing type or none.The following selections are available: • Markup • Special Direct Cost • None |
| Type filter | Using the type filter, you can limit your view to rows of a specific type. The following selections are available: • Article • Article category • Product posting group • Stock posting group • All articles • None |
| Code filter | You can use the code filter to further restrict your view in addition to the species filter on a specific article or similar. |
| Start date filter | Use the start date filter to narrow your view to specific validity lines. |
Using the rows 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: Surcharge: The condition is taken into account in the calculation, if it is the calculation of "end products". You define here no longer the cost price of the item, but the markup up to the target price. Special direct costs: The condition is defined 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 article or for faster entry of a type group. The following options are available: • Article • Article category • Product booking group • Stock booking group • All articles |
| Code | You can narrow down each selection in the "Type" field to a specific article number or species group number in this field. |
| Calculation Condition No. | Indicates the corresponding calculation condition. |
| Calculation Condition Description | Gives the description for the calculation condition selected in the "Calculation Condition No." field. |
| Calculation condition no. (E+D) | Indicates the corresponding calculation condition (E+D). |
| Calculation Condition Description (E+D) | Gives the description for the calculation condition selected in the "Calculation Condition No. (E+D)" 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. |
| 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. | SEK Specifies the costing item for the special direct costs. |
| SEK Costing Component Description | Indicates the description for the costing component selected in the "SEK Costing Component 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 are then taken into account in the subsequent costing.
| Field | Description |
|---|---|
| No. | This is assigned automatically on the basis of a stored number series. |
| Item no. | This is automatically assigned with the article number from which you started the call. |
| Description | Corresponds to the item description. |
| Start date | From when should this costing specification apply. |
| End date | To when is this costing specification valid. |
| Lot size | Indicates the lot size number. |
| Standard | This field is queried when calculating the cost price. If this is set and the checkbox "Only standard costing specifications" is also set in the function "Costing price (fixed)/Calculate target price for item", then only lot sizes that have the checkmark set in the costing specifications are used. |
Job costing conditions#
You call up the Costing conditions mask work center via the work center group card. Via this mask 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 "General" area of the Calculation conditions mask workstation, there are initially filters that you can use to control your view. When you open the mask, the filters are always preset to the workstation group from which you called the mask.
| Field | Description |
|---|---|
| Type filter | Using the type filter, you can restrict your view to lines of a specific type or none.The following selections are available: • Department • Workstation group • Workstation • Workstation line • None |
| Code filter | You can use the code filter to further restrict your view in addition to the type filter on a specific workstation group or similar. |
| Start date filter | Use the start date filter to narrow your view to specific validity lines. |
Using the rows you can directly define the calculation conditions with the help of 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 | Specify the appropriate version code. |
| Operation No. | Indicate a corresponding operation. |
| Indirect cost rate | Enter the indirect costs as an absolute amount at this point. |
| Indirect costs % | Enter the indirect costs as a percentage value at this point. |
| Calculation Condition No. | Enter the appropriate calculation condition. |
| Calculation Condition Description | Indicates 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 calculation#
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, historically already preceding costings are displayed (if available).
| Field | Description |
|---|---|
| Warning | Blank: The proposal line does not contain any errors and can be accepted if necessary. Errors: The proposal line contains errors that can be viewed and corrected via the error log. After correction, the proposal must be run through again. |
| Calculation Run Seq. 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. |
| Calculation Run Description | Indicates the description that has been specified for the respective calculation run. |
| Item no. | Indicates the article number for which the suggestion line was calculated. |
| Description | Indicates the description of the item. |
| Procurement method | Indicates the stored procurement method of the item. |
| Status | Indicates the status of the proposal line. A distinction is made here between: • Empty • Preferred • Rejected • Transferred For more information, see 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 when the proposal line was calculated. |
| Cost Price (Fixed) | Indicates the deposited "Cost Price (Fixed)" on the item card. |
| New cost price (fixed) | Specifies the new cost price (fixed) of the proposal line. |
| Cost % (Consumption Activation) | Displays , (if available) the "Cost % (Consumption Activation)" determined from the costing definitions. |
| Overhead rate (consumption capitalization) | Displays, (if available) the "Overhead rate (consumption capitalization) determined from the costing definitions. |
| Guide price | Indicates the previous guide price. |
| New target price | Indicates the recalculated target price. |
Calculate set price (fixed)/direct price for article#
When this function is executed, the cost price for the corresponding item(s) is calculated.
| Field | Description |
|---|---|
| Calculation date | Specifies the calculation date. This is used to take into account the start and end dates of purchase prices, costing conditions or even bills of materials and routings for costing. |
| Calculation Run Description | This input is a mandatory input and defines what kind of calculation it is. |
| Standard costing specifications only | Here it can be defined whether the lot size of the article to be calculated is to be drawn from the article card or the calculation specification. If the switch is not activated, the stored lot size of the costing specification (if available) is treated with priority than that of the article card. If the switch is set, only the stored lot size with the identifier=standard (if available) is treated with priority than that of the article card. Note: This applies only to the first level, that is, the article to be costed. |
| Costing Proposal Name (Plan) | Specification of the costing proposal (plan) if simulations are performed. 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...#
This function allows you to set the status of the costing proposal line according to the selection (Preferred or Rejected) in the "Status" field.
The status is relevant for the function execution "Accept costing proposal (preferred)". Only costing proposal lines with the status "Preferred" are adopted.
When the price is accepted, the "Status" field is set to "Accepted".
Adopt costing proposal (preferred)#
Using this function, the values from the costing proposal lines with the status=Preferred are taken and transferred to the article card.
When executing the function, it is also possible to perform a revaluation at the recalculated price for the 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 to the revaluation ledger sheet. |
| Article Book. sheet template | Indication of the revaluation bookb sheet |
| Article Book. sheet name | Revaluation book sheet name |
| Transfer from | One level: Only the prices from the item from the costing 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 required, changes and/or entries can be made here.
Note
This always only affects the article that is currently being costed. If costing specifications are also defined for assemblies in subset levels, these are not taken into account. Here, the lot size is always taken from the article card.
| Field | Description |
|---|---|
| No | This is assigned automatically on the basis of a stored number series. |
| Article No. | This is automatically assigned with the article number from the data record of the calculation proposal line. |
| Description | Corresponds to the item description. |
| Start date | From when this calculation specification should apply. Reference date is the "Calculation date" when executing the function "Calculate set price (fixed)/Directive price for article". |
| End date | To when is this calculation specification valid. Reference date is the "Calculation date" when executing the function "Calculate set price (fixed)/Directive price for article" |
| Standard | This field is queried when calculating the cost price. If this is set and also at the function "Calculate cost price (fixed)/Directive 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 stored 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.
Costing proposal (planned values)#
With the costing proposal (planned values) you can simulatively calculate proposals with modified planned values and also transfer them via batch processing. Since the basis for the cost of goods manufactured calculation is always the master data, the exchange of the articles is not possible at this point. Only amount values and cost values can be changed (no times and no component quantities).
Via the calculation proposal (plan values) mask you can first select an already created proposal for editing via the "Name" field or define a new one via "New" by entering "Name" and "Description".
You can use the function calls "Propose article costing condition", "Propose capacity unit price (costing)", "Propose article unit price (fixed) (costing)" and "Propose costs according to structured BOM" to redefine the respective stored planned values in batch processing.
The function call opens a mask on which you can define new plan values in the option areas and limit your change project to certain criteria by means of the filter area.
Fixed factor:
These radio buttons allow you to define fixed values for your changes, which will be taken into account over the run and written into the "New value fields" provided for this purpose.
Correction factor:
You can use these option fields to specify factor values that are to be multiplied by the original values. Via the run, these results are also written into the "New value fields" provided for this purpose.
Via the menu item "Accept costing proposal (plan values)" you can finally accept the new plan values.
Note
Please note that only valid condition values are considered for replanning. For example, if an end date of an item calculation condition is in the past, no change value will be written into the "New value field" for this record.
Costing proposal (planned conditions)#
With the costing proposal (planned conditions) you can change the costing conditions defined in the system via batch processing. The logic here corresponds to that of the costing proposal (planned values).
Retrieve error log#
The error log lists all errors that occurred during the calculation. By clicking on the integrated lookups or the call "Display" in the menu ribbon, the errors can be edited directly from the mask.
Note
Please note that you will need to recalculate the costing after you fix the error.
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 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#
Using the structure list, you can view a costing proposal aggregated over all costed levels and their costs.
| Field | Description |
|---|---|
| Calculation proposal 1 Filter | Select a calculation proposal that you want to have displayed. |
| Including overhead costs | 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 only want to view the material costs. |
| Cost selection | You can use the cost selection to 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. Multi-level: Displays the costs multi-level, broken down to the last assembly/component. |
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. |
| Calculation Proposal 2 Filter | Select another calculation proposal that you want to compare with the one already selected from the "Calculation Proposal 1 Filter" |
| Including overhead | Activate the check box if you want to consider the overhead included in the respective costs in the comparisons. |
| Material only | Activate the switch if you only want to compare the material costs. |
| Cost selection | You can use the cost selection to 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: Represents 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.
Quotation costing#
In a quotation, you can transfer the corresponding article lines for customer-specific inquiries into a calculation in order to modify them according to customer-specific requirements and to calculate them separately. The calculated cost price and sales price can then be transferred to the offer.
Calculate manufacturing costs#
With the "Calculate production costing" function, you first initiate the costing for the selected article line. When the function is executed, a "Simulated production order" is automatically created. Depending on the setting in the "Valuation and calculation setup", the production order will then also open automatically or not.
For item rows for which a calculation has already been created, the row in the "Calculation tracking rows available" field has the "Yes" identifier. By clicking on the identifier, the costing lines can be viewed.
Calculation tracking lines#
This call opens the costing trace lines. The links between the production order and the quotation/order are displayed in the calculation tracking lines. Several production order lines can be linked to one quotation line.
| Field | Description |
|---|---|
| Status | Indicates whether the quote line is linked to a calculation. When selected, the calculation tracking lines will be opened. |
| FA No. | Displays the FA number. This can be an FA in "Simulated", "Firmly Scheduled", "Released" or "Finished" status. |
| FA line number | Indicates to which FA line number the offer / order line number is linked. |
| Project no. | Indicates which project it is |
| Project task no. | Indicates which project task no. is involved. |
| Project plan line no. | The project plan line number is shown here. |
| E+D project no. | Indicates which E+D project number was entered in the production order. |
| Production order type | Displays the production order type from the production order. |
| Article No. | Displays the article number from the production order. |
| Variants Code | Displays the variant from the production order. |
| Description | Display the description from the production order. |
| Number of costing proposals (E+D) | Number of costing proposals (E+D) Indicates how many different costings have been carried out for this production order. There is no differentiation between target and actual costing. |
Delete#
By executing the "Delete" function in the ribbon, you can delete a calculation line. If there are no more calculation lines after executing the function, the sales line will be marked with "No" in the "Calculation tracking lines available" field.
Display E+D order#
With this call you can display the corresponding E+D order. At this point, the structure of the E+D order is omitted and only the fields/calls relevant for the calculation are explained in more detail. Further information about the E+D order can be found here.
Additional costs#
Additional costs" allows you to take into account customer-specific quotation requests for the calculation. In addition to general additional costs, you can also include additional resources, articles or similar. Via the call "Costing condition" you establish the connection between the additional cost line and the costing elements and thus enable an account assignment of the results of a costing.
Components#
Via the "Components" you have the possibility to change prices and quantities, exchange items and add overhead costs if necessary.
Work plan#
Through the "Routings" you have the possibility to change prices, swap operations and add overhead costs if necessary.
Add calculation tracking manually#
With this function you can manually add already calculated E+D order lines and take them into account for the current sales line if required.
E+D markup calculation#
If the customer asks for certain discounts, the function "E+D markup calculation" is especially helpful, this allows you to run through possible markup calculations for an offer.
Costing proposals (E+D)#
The costing proposals (E+D) are structured in the same way as the conventional costing proposals. In addition, you can use them to create a simultaneous cost estimate.
To do this, you use the function "Calculate unit price/price for unit order" in the costing proposals (E+D). By specifying the costing base, actual/actual (Posted quantity) and target/actual (Expected quantity) comparisons are available.
You can use the "Change status" and "Adopt costing proposal (Preferred)" functions to adopt the calculated values for the sales line.