| # Estimate Lines (tpest2100m000) use.session.to maintain and display the estimate lines. The columns that are maintained in this session are available based on the settings in the User Profiles (tppdm0101s000) session. Note Even if fields are not displayed in the Estimate Lines (tpest2100m000) session, the hidden fields are filled with defaults or calculation results. Menu options Only the menu options that require an explanation are described here: On the File menu, click Send To. If you downloaded the published templates, you will find Microsoft Word and Microsoft Excel templates in this box. baan offers the following example templates: Estimate-Line.xlt: calculates all field values of estimate lines. Quantity-Calculations.xlt: calculates quantity. Amounts.xlt: considers surcharge, escalation, and contingency amounts. CostPrice-Calculation.xlt: calculates cost price. SalesPrice-Calculation-Mark Up.xlt: calculates sales prices and markup. SalesPrice-Calculation-Target.xlt: calculates sales prices with target pricing. On the Specific menu, click Estimate. The following sessions can be started: Estimate Versions (tpest1100m000) User Profiles (tppdm0101s000) Estimate Structures (tpest1110m000) Structural Elements (tpest1120m000) On the Specific menu, click Compute Prices. Calculates the cost or sales price of a line. On the View menu, click Sort by Project, Version, Estimating type, Sorting Structural Element. If the number of estimate lines requires sorting for a better overview, you can use the Sort by... function. The actual sort structure is defined in the Estimate Versions (tpest1100m000) session and is one of the additional structures. On the Specific menu, click Modify Utilities. This option contains several utilities. You can renumber the lines, change the line status, change dates, update the line number logic, and replace structural elements. On the Specific menu, click View Map. With the map, you can apply a filter on the estimate lines. On the Specific menu, click View Map. On the map, by default, the Use Filter option on the Specific menu is selected. Click the structural element in the map structure, which you want to see in your estimate line filter. On the Specific menu, click View Details or right-click on the mouse and, on the shortcut menu that appears, click View Details. In the Estimate Lines (tpest2100m000) session, you see the structural element of your choice with (filtered) behind it’s the element’s code in the column heading. On the status bar, the message Map Filter Active appears. To switch off the filter, go to the map view and select the Use Filter option. The filter option is cleared. The status bar in the Estimate Lines (tpest2100m000) session reads No Map Filter Active and each estimate line is displayed again. Estimate Line Buttons: The first five buttons are used to calculate a price; click Configure to configure an item. If you click Aggregate Totals, modified amounts are calculated for the lines. The aggregated totals are used to calculate the estimate. You will find the following totals expressed on the estimate lines in the Cost and Sales box. The totals are expressed in the estimate-version currency. The total amounts are calculated in three ways: leading estimate type Sum of all the estimate lines of your primary structure, with the leading estimate type of the used structural element. Top Down Sum of all the estimate lines with the Top-Down estimate type. Bottom Up Sum of all the estimate lines with the Bottom-Up estimate type. Note on bottom up Whether the Detail or Total line is used in the calculation, depends on the structural element's level type. Note Totals are not calculated if no structure is defined for the estimate version. Lines can be excluded of the calculation if the lines are not included in the scope or are excluded from the sales or cost estimate. Each calculated amount can belong to a different column, including Cost Total, Landed Cost, Gross Sales, or Net Sales. Refer to the field Help for more information. To check top-down lines for amount consistency, you can click Verify Top Down Estimate Consistency. Consistency checks are performed for top-down amounts of the primary structure. The sum of the child elements' amounts must be less than or equal to the parent's amount. For a particular primary structural element, the Total amount must be greater than or equal to the sum of the amounts of other level types: Cost Type, Other Structure, or Detail. The total amount check does not apply to flat structures. Messages To avoid messages interrupting your work, messages are directed to a separate window, where you can view or clear the messages. . Related topics To create an estimate To use a map To use estimate line levels To use estimate structures Project The project code. Description The description or name of the code. Status The project status. Note The Blocked status means that the estimate project is copied to a new project. In the new project, you maintain the estimate. Estimate Version The estimate version code. Description The description or name of the code. Status The estimate version status. If the version status is Free, you can add structures to the version, change the version amount, and so on. For example, you can still swap the primary structure with one of the additionally added structures. If the version status is Final, the version is frozen. You can only change the status back to Free and/or change the sort structure. LET If you select Aggregate Totals option in the Specific menu, the line amounts with the leading estimate type (LET) of the linked structural elements are summed up and displayed in the LET field. How the calculation is performed depends on your user settings and the leading estimate type of the structural element. If the LET of the structural element A is top-down and you have two lines for A, one top-down and the other bottom up. The top-down line is used in the LET total calculation of that structural element. For bottom-up elements the Level field value for cost and sales level types in the Structural Elements (tpest1120m000) session, determines what line is aggregated. LET The cost amount is either the total project or the structural element sales amount, depending on your current view. LET The total project or structural element's estimated cost based on the surcharges, depending on your current view. LET The total net sales amount of the project or of the structural element. This depends on your current view. Top Down The total top down amount depends on the structure view. If you enter estimate lines with the view on structural element A, amount A is displayed. The level type entered on the estimate lines determines which specific line amount of A is the total amount. Infor ERP LN 6.1 looks for the amount in the following order of level type: Total Cost type Other structures Detail Top Down Landed cost amount of the estimate line with the Level field set to Total and the Estimate Type field set to Bottom-Up. Top Down Gross sales amount of the top down estimate line with the Level field set to Total. Top Down Net sales amount of the top down estimate line with the Level field set to Total. Bottom Up The aggregated total of all structural element lines with the leading estimate type Bottom Up. Bottom Up Sum of landed cost amount of estimate line with the Level field set to Detailed and the Estimate Type field set to Bottom-Up. Bottom Up Sum of gross sales amount of estimate line with the Level field set to Detailed and the Estimate Type field set to Bottom-Up. Bottom Up Sum of net sales amount of estimate line with the Level field set to Detailed and the Estimate Type field set to Bottom-Up. Total Claimable Tax Amount The sum of claimable tax amount of all the estimate lines. Note This is a display field. Total Non-Claimable Tax Amount The sum of expensed tax amount of all the estimate lines. The amount includes the octroi amount also. Note This is a display field. Total Other Charge Amount The total other charges amount of all the estimate lines. Note This is a display field. Sales Tax Amount The total sales tax amount of all the estimate lines. Note This is a display field. Line Number Each estimate line is identified with a number. By default, the numbering increases the previous number by 10. However, you are free to change the number step. The Renumbering of Estimate Lines command is available on the Specific menu, as one of the Modify Utilities. Note Along with the line number, each estimate line has a unique line number that is not visible. This unique line number is determined by the estimation series and the estimation number group in the General Parameters (tppdm0100s000) session. Estimating Type The estimate type. Following are the two estimating types: Top Down Bottom Up Level The level of detail for the estimate. The level depends on the value of the Estimate Type field. If the Estimate Type is set to Bottom Up, the following values are possible: Total Detail If the Estimate Type is set to Top Down, the following values are possible: Total Detail Cost Type Other Structure Primary Structural Element A primary structural element. The primary structure is entered in the Estimate Versions (tpest1100m000) session. Cost Type The cost type. Item You can insert the following item types: Manufactured Purchased Generic You can also use a project item or a customized item. Note For a PCS item, make sure that the PCS series in the General Parameters (tppdm0100s000) session is filled in. Cost Object cost object or control code Note You cannot enter a material cost object. Estimating uses the Item field as a separate field for the material cost object. Description The description or name of the code. Quantity The gross quantity is used for both sales and cost to calculate the amount with the price multiplied by the gross quantity. Gross quantity = quantity x (1 + scrap factor/100) x adjustment factor x (Norm/Production rate) Unit The quantity unit. Scrap [%] This field is only applicable for estimate lines with the Material cost type. The gross quantity is recalculated if the scrap factor is changed: Gross Quantity = Quantity * (1 +scrap factor /100) * adjustment factor Adj. Factor The adjustment factor is used to modify the standard norms and/or rates of the estimate. The adjustment factor is used to calculate the gross quantity. Gross Quantity = Quantity * (1 + scrap factor /100) * adjustment factor Norm [Price Unit/Unit] The norm is only applicable for cost types Labor, Equipment, and Subcontracting. If the norm is changed, the amount is recalculated: cost/sales amount = quantity * norm * cost price * (1 + scrap factor/100) * adjustment factor If this line is launched to a project budget, the budgeting method of the linked activity or project is Norm. Production Rate [Unit/Price Unit] The production rate is only applicable for cost types Labor, Equipment, and Subcontracting. If the production rate is changed, the amount is recalculated: cost/sales amount = quantity unit * cost price/production rate * (1 + scrap factor/100) * adjustment factor. If this line is launched to a project budget, the budgeting method of the linked activity or project is Production Rate. Product Variant If this check box is selected, a generic item is configured and receives a product variant code. This product variant code contains the configuration of your choice. If the check box is selected, you can click To Configure to change the product variant. Product Variant The product variant. Date of Incurring Cost The expected date that the estimate line costs will occur. This date is used to determine the effective cost/purchase price, the effective rate factor, and the project cash flow at the time costs are released. If the primary structure is Activity or Element, the activity/element start date is the default date. In case of another estimate-version structure type, the project start date is the default date. If the activity schedule is changed, you can update the date of incurring cost. Labor Rate Code The labor rate code determines both the cost and sales price and is maintained in the Labor Rate Codes (tcppl0190m000) session. If the sales pricing method is Mark Up, the sales price of the labor rate can be overruled. Currency The estimate-version currency is the default Currency. Cost Price The cost price can originate from various sources. PriceUnit The cost price unit. The quantity unit can differ from the cost price unit. For example, if the cost price is defined in hours and the quantity of the required material is in pieces. Example: The cost price is EUR 100 per hour and the quantity is 1,000 pieces, the norm determines the calculation. If the norm is: one hour makes two pieces, the amount becomes EUR 5,000. Origin of Cost Price Multiple sources exist for the cost price of an estimate line; knowing the origin is important. Final Cost Price If this check box is selected, you have made the cost price final for this estimate line. You can also perform this process automatically with the Final Cost Price menu option. With this option, the final cost price is retrieved from a corresponding estimate line. However, this method only works if an estimate line exists that contains a final cost price for the same cost object. Cost Amount The calculation is cost price * gross quantity or an amount you enter manually. Rate The cost rate between the estimate-version currency and the home currency of the project. Rate Factor The rate factor of the estimate-version currency rate. Other Charge The other charge code applicable to the estimate line. Use the browse arrow to select an other charge from the Additional Charges (tccom9140m00l) session. When the budget is generated using the estimate, the other charge code is defaulted to the corresponding budget lines. Note The following conditions apply to the other charge code: The Nature of the other charge code must be set to Variable. The Calculation Method of the other charge code must be set to Not Applicable or Value. The field is enabled only when the Cost Type field is set to one of the following: Materials Equipment Subcontracting Other Charge Price The other charge price of each inventory unit. The value is defaulted from the Additional Charges (tccom9140m00l) session when you select an other charge code. Note The price is updated when the Unit or the Currency is changed. Octroi Code The octroi code applicable to the estimate line. Use the browse arrow to select an other charge from the Additional Charges (tccom9140m00l) session. Octroi Price The octroi price for each inventory unit. The value is defaulted from the Additional Charges (tccom9140m00l) session when you select an octroi code. Note The price is updated when the Unit or the Currency is changed. The price is calculated on the Cost Amount, when the Calculation Method of the octroi code is Value. Taxable ASV for Excise The assessable value of the item which is used to calculate excise duty. When excise is applicable on other charges, the other charge price is also included in the value. The value is updated whenever the Unit or the Currency is changed.
    Taxable ASV for Excise =
    				Assessable Value for Excise + Sum of Other Charges where Excise is applicable
Taxable ASV for VAT The assessable value of the item which is used to calculate VAT. When VAT is applicable on other charges, the other charge price is also included in the value. The value is updated whenever the Unit or the Currency is changed.
    Taxable ASV for VAT =
    				Assessable Value for VAT + Sum of Other Charges where VAT is applicable
Taxable ASV for Service The assessable value of the item which is used to calculate service tax. When service tax is applicable on other charges, the other charge price is also included in the value. The value is updated whenever the Unit or the Currency is changed.
    Taxable ASV for Service =
    				Assessable Value for Service Tax + Sum of Other Charges where Service Tax is applicable
Cost Amount The cost amount is expressed in the home currency. Assessable Value for Excise The assessable value of the item used to calculate excise duty. When an item or a cost object is added or changed manually, Infor ERP LN defaults the value in the following order of preference: If Maximum Retail Price (MRP) is applicable for the item/cost object, the MRP Price/Inv. Unit defined for the Item and Duty/Tax Type Excise, is defaulted from the MRP of Item (tcibd9139m00l) session. Otherwise, the Cost Price is defaulted. If MRP is not applicable, the Assessable Value defined for the Item and Duty/Tax Type Excise is defaulted from the Assessable Value (tcibd9138m00l) session. Otherwise, the Cost Price is defaulted. Note The following conditions apply: The field is enabled only when the Estimating Type field is set to Bottom Up and Level field is set to Detail. The field is disabled in the following scenarios: When the status of the estimate version is Final. When the Final Cost Price check box is selected. When the value is changed, the Cost Amount field is updated. Assessable Value for VAT The assessable value of the item used to calculate VAT. When an item or a cost object is added or changed manually, Infor ERP LN defaults the value in the following order of preference: If Maximum Retail Price (MRP) is applicable for the item/cost object, the MRP Price/Inv. Unit defined for the Item and Duty/Tax Type Sales Tax, is defaulted from the MRP of Item (tcibd9139m00l) session. Otherwise, the Cost Price is defaulted. If MRP is not applicable, the Assessable Value defined for the Item and Duty/Tax Type Sales Tax is defaulted from the Assessable Value (tcibd9138m00l) session. Otherwise, the Cost Price is defaulted. Note The following conditions apply: The field is enabled only when the Estimating Type field is set to Bottom Up and Level field is set to Detail. The field is disabled in the following scenarios: When the status of the estimate version is Final. When the Final Cost Price check box is selected. When the value is changed, the Cost Amount field is updated. Assessable Value for Service Tax The assessable value of the item used to calculate Service tax. When an item or a cost object is added or changed manually, Infor ERP LN defaults the value in the following order of preference: If Maximum Retail Price (MRP) is applicable for the item/cost object, the MRP Price/Inv. Unit defined for the Item and Duty/Tax Type Service Tax is defaulted from the MRP of Item (tcibd9139m00l) session. Otherwise, the Cost Price is defaulted. If MRP is not applicable, the Assessable Value defined for the Item and Duty/Tax Type Service Tax is defaulted from the Assessable Value (tcibd9138m00l) session. Otherwise, the Cost Price is defaulted. Note The following conditions apply: The field is enabled only when the Estimating Type field is set to Bottom Up and Level field is set to Detail. The field is disabled in the following scenarios: When the status of the estimate version is Final. When the Final Cost Price check box is selected. When the value is changed, the Cost Amount field is updated. Tax Code The aggregate tax code. When an item or a cost object is added or changed manually, Infor ERP LN defaults the tax code in the following order of preference: The tax code defined for the State/Province specified in the project address and the Item in the Purchase Tax Codes tab is defaulted from the Tax Handling (tctax0138m000) session. The tax code defined in the Purchase Tax Codes tab for the State/Province is defaulted when the Item is not defined the Tax Handling (tctax0138m000) session. Note You can change the tax code. Use the browse arrow to select the aggregate tax code from the Tax Codes by Country (tcmcs0136s000) session. The field is enabled only when the Estimating Type field is set to Bottom Up; Cost Type field is empty and the Level field is set to Detail. The field is disabled when the status of the estimate version is Final. If the GST Implemented check box is selected in the India Localization Parameters (tccom9136m00l) session, Infor LN defaults the tax code applicable for the address at which the goods are delivered. The tax code must be an aggregate tax code. Related topics Example of aggregate tax code Description The description or name of the code. Claimable Tax The amount of tax that is claimable for the estimate line. Non-Claimable Tax The amount of tax that is not claimable and hence considered as an expense. The amount includes octroi. Surcharge % You can either enter a surcharge on a line or enter a separate estimate line of the Sundry Cost cost type, for example, for travel expenses. SurchargeAmount You can either enter a surcharge on a line or enter a separate estimate line of the Sundry Cost cost type, for example, for travel expenses. Landed CostAmount This amount is the total estimate cost, including the surcharges. The landed cost is effected whenever you modify the cost amount or the surcharges. Landed cost amount = Cost Amount + Surcharges (additional costs) + Non-claimable taxes + Other charges. Note The value is re-calculated when any of the following fields are changed: Assessable Value for Excise Assessable Value for VAT Assessable Value for Service Tax Tax Code EscalationAmount A reservation for a price adjustment that can occur during the project life cycle. For example, an increase in the supplier's raw material price, or a collective pay raise. ContingencyAmount Enter a contingency amount as a reservation for risks that can occur, such as preventive actions or repair risk damage. Pricing Method Two methods to calculate the sales price are available: Markup: Adding a margin to the cost based on cost multipliers. The markup can be a profit margin, tax, management fee, or other factor specific to the company. Gross sales amount = landed cost amount + contingency + escalation + markup. Note A mark-up percentage or amount is displayed for information purposes only. Target Pricing: In many cases, the target price for the estimate is fixed. If so, the sales price is, for example, determined by a price list. Gross sales amount = gross quantity * gross sales price. Note By default, the pricing method is taken from the User Profiles (tppdm0101s000) session. Markup % A percentage added to the costs to reach a sales amount. Formula: Gross sales amount = Landedcost amount + escalation amount + contingency amount + markup. Markup Amount A percentage amount, which is added to the landed cost amount to reach a sales amount. Formula: Gross sales amount = Landed cost amount + escalation amount + contingency amount + markup. Date of Expected Sales The date the estimate line is expected to be sold. This date is required if you want to know what the cash flow of the project at that date is, and to get the effective rate factor and the effective sales price. If the primary structure is Activity or Element, the activity/element finish date is the default date. In case of another estimate-version structure type, the project finish date is the default date. If the activity schedule is changed, you can update the date of expected sales. Currency The estimate version determines the currency. Gross Sales Price The sales price is determined by the pricing method. If the method is Target-Pricing, you can manually insert the price . If the method is markup, the price is calculated with the formula: Gross sales price = Gross sales amount / Gross Quantity, where Gross Quantity = Quantity x (1 + scrap factor /100) x adjustment factor Origin of Sales Price This field is a display field and is filled in by baan. Because multiple sources are available to arrive at the sales price for an estimate line, knowing the origin is important. Final Sales Price If this check box is selected, you have made the sales price Final for this estimate line. You can also perform this process semi-automatically with the Final Sales Price menu option. With this option, the final sales price is retrieved from a corresponding estimate line. However, this method only works if an estimate line exists with a final sales price for the same cost object. Gross SalesAmount The gross sales amount depends on the pricing method. When the pricing method is Markup, then Gross Sales Amount = landed cost amount + escalation amount + contingency amount + markup amount. When the pricing method is Target Pricing, the Gross Sales Amount = quantity x gross sales price. Rate The sales rate between the estimate-version currency and the home currency. Rate Factor The rate factor of the estimate-version currency rate. Gross SalesAmount The sales amount in the home currency. Discount % The discount amount. Discount Amount The discount amount Net Sales Price Net Sales Price = Net Sales Amount / Quantity Assessable Value for Excise The assessable value of the item used to calculate excise duty. Infor ERP LN defaults the value from the Net Sales Price field. Assessable Value for VAT The assessable value of the item used to calculate VAT. Infor ERP LN defaults the value from the Net Sales Price field. Assessable Value for Service Tax The assessable value of the item used to calculate Service Tax. Infor ERP LN defaults the value from the Net Sales Price field. Sales Tax Amount The total tax in a sales transaction. When the Tax Method of the Estimate Versions (tpest1100m000) is set to Composition, the Tax Code defined in the Estimate Versions (tpest1100m000) session is used to calculate the value. When the Tax Method of the Estimate Versions (tpest1100m000) is set to Identification, the Tax Code defined for the element or the activity is used to calculate the value. Note This is a display field. Net Sales Amount If the pricing method is Markup, the net sales amount is the gross sales amount - discount amount. Profit % The profit percentage. It is calculated as follows: {(net sales amount - cost amount)/Cost Amount } * 100 Profit Amount Profit amount is the difference of net sales amount and cost amount. If the pricing method is Target Price, a negative amount or a positive amount indicates that you must accept a loss or a profit. Structure 1 The structure 1 structural element. The primary structure is entered in the Estimate Versions (tpest1100m000) session. In the Swap Structures in Version (tpest1202m000) session, you can swap the first additional structure position with another predefined additional structure that is also linked to this estimate version. Structure 2 The structure 2 structural element. The primary structure is entered in the Estimate Versions (tpest1100m000) session. Structure 3 A structure 3 structural element. The primary structure is entered in the Estimate Versions (tpest1100m000) session. Structure 4 A structure 4 structural element. The primary structure is entered in the Estimate Versions (tpest1100m000) session. Structure 5 The structure 5 structural element. The primary structure is entered in the Estimate Versions (tpest1100m000) session. Structure 6 The structure 6 structural element. The primary structure is entered in the Estimate Versions (tpest1100m000) session. Structure 7 The structure 7 structural element. The primary structure is entered in the Estimate Versions (tpest1100m000) session. Sort Structure Element The additional structure that is defined as sort structure. You can use the Sort Structure code to sort the estimate lines. Line Type A classification of the estimate line, whose default value is taken from the User Profiles (tppdm0101s000) session. For example, you can print a report for direct and indirect costs. Status The status of the estimate line. User-Defined Status Define an appropriate status for the estimate. For example, you define two statuses: Request for Quotation and Final Supply. The status can be Request for Quotation if you are not sure about the costs of a supply for the estimate line. Link, for example, only the related cost fields to this status. The Include in Cost check box must be cleared. These cost lines are not included in the total cost calculation. You can change the status of the cost lines to Final Supply later, when you receive the answer to the quotation and you know the cost price of the supply. Now, select the Include in Cost check box. The statuses Request for Quotation and Final Supply are examples. You can create your own status list. Include inScope The Include in Scope check box is displayed based on the setting in the Estimate Lines Utilities (tpest2201m000) session. If the logon you are using has no estimate options by user, the Include in Scope check box is automatically selected for each new estimate line. Use this check box to define alternative lines for the bid and the input for the totals. If the alternative is out-of-scope, the Include in Scope check box value is higher in hierarchy than the value of the Include in Cost and Include in Sales check boxes. As a result, estimate lines with the Include in Cost and Include in Sales check boxes selected, but with the Include in Scope check box cleared, are not considered in the totals. You can select or clear this check box with a User Defined status. Include inCost If this check box is selected, the total and Landed cost are calculated. If you click Aggregate Totals, the line amount is included in the total and landed cost. The display of the Include in Cost check box is based on the setting in the Estimate Lines Utilities (tpest2201m000) session. If the logon you are using has no estimate options by user, the Include in Cost check box is automatically selected for each new estimate line. This check box can be cleared with a User Defined status. Include inSales If this check box is selected, the Total Gross and Net sales are calculated. If you click Aggregate Totals, the line amount is included in the total and landed cost. The display of the Include in Sales check box is based on the setting in the Estimate Lines Utilities (tpest2201m000) session. If the logon you are using has no estimate options by user, the Include in Sales check box is automatically selected for each new estimate line. This check box can be cleared with a User Defined status. Launched If this check box is selected, the estimate line is launched to the budget in the Launch Estimate to Budget (tpest2200m000) session. You can only launch an estimate line with this check box selected. If you select the Re-launch Estimate Lines check box in the Launch Estimate to Budget (tpest2200m000) session, the relaunch will create duplicate records in the budget. Text If this check box is selected, a text is present. Print Estimate Lines Starts the Print Estimate Lines (tpest2400m000) session which prints the estimate lines data. Sales Price Click the Sales Price button to retrieve the cost object's sales price. baan uses this price in the invoice line. |