Software for furniture construction DESIGN SINTEZThe module uses 2 basic kinds of units for price offer calculating: units with entered fixed prices and units with generated element nomenclature.
To calculate the price offer, you must have entered
materials to connect with the elements of units in the job (Nomenclature materials).
Calculated summary expense of the elements in the current job ,
connects with materials to got the final cost of the job. If you use
the PRO version , toward the materials can be added operations and can
be set overmeasures. Price offer formation
The price offer can include 2 kinds of units:
Existing in the drawing unitsThese are generated units with created element nomenclatures to them and non-standard units (desks, tables and etc.), inserted in the drawing by module Insert units. They are specified with "from a job" in the list. Colunm number with price from Units register- This value defines what price from Units register to be taken in price for the selected unit. If the list contains several identical units, they receive a common number of column, ie there can be not several units with the same name and different prices. Added to the price offer - AdditionalThey don't exist in the drawing. They are added for the price offer generating only and participate in it and in material calculating. They are specified as "additional" in the list. The way of their addition is: Press the button Add. Opens a dialog describing the content of Units register. Select a unit from the list and press Select. The unit is including in register with units in the job that are subject of price-formation. To delete such a unit from the list, select it and press Delete. Regardless the unit mode - Existing or Additional - if it participate in Units register and you mark it in the register with units ,it is loading its preview and a register with prices for choice. To choose number of column with the price, with which it will participate in the price offer formation, press left mouse button on the field with respective price or enter column number from Units register into the field (from 1 to 4). The button Offer opens specification to the already created price offer in Excel or OpenOffice (if certainly you have connected the generated element nomenclature with materials and have defined the prices of units with fixed prices). The option On units adds a detailed list for the expense on elements for each unit to the printed specification. It is active by default. The elements of units with unit of measure "package" which participate in the price offer, must be connected with materials. Press the button Elements list. Loads a form for connecting - Register of participating in the drawing elements. Design Sintez PRO: The section Elements includes the specification of the calculated expense for each of the participating elements in used in the drawing units. All units in the job created by modules Cabinet and Doors with fixed price and same name are kept as one common element from the list and unit of measure pieces. The list of materials can be filtered according to the measure and with the buttons in the upper end of the dialog - sq.m,l.m and piece. Select an element from the list (with double clicking the left mouse button). In the right list are loaded the materials with the unit of measure responding to the measure of the selected element for connecting. Choose a material and press the button between them (Choice of material). You can choose a material from group or from the complete list with materials. In the long lists with materials it is possible to sort the list on a Material name; Length or Width of the materials or to use Search for material... field. When there is a found concurrence the cursor will be set on a respective line.Specify and connect consistently elements appropriate to the selected material or other material in the list. If there is an element associated with the material that must be assigned to another element (or elements), select the associated row and right-click on it. In the upper left corner of the window is displayed the name of the copied material. To connect it with other items, select them with left mouse button and then right click on the marked rows. The prices of units from Units register are loaded automatically from the specified column in the Units register. You, certainly, can connect them with a material, if the structure of unit allows this. Button PRO - Additional expenses calculated at the price offer - Enable in Design Sintez Professional only Report (Expense) “ Materials – Overmeasures” - Overmeasures are entered for materials with measure "l.m." in Nomenclature materials. Overmeasure is added to each element nomenclature , connected with this material from the inventory. I.e. If the material is connected with 10 elements and the value of the overmeasure is 10 cm , the quantity of this material in the report "Materials-> Overmeasures" will be 10 elements x 10 cm = 1 l.m. This length is multiplied by the price of material per unit of material and gives the final cost of the material. If in the job are several materials with overmeasure, the amount of the report is calculated as the sum of the amounts of all materials. Expense "Elements ---> Operations“ - The formation of this cost is based on generating units in certain parts thereof (left or right end panel , bottom, top , etc.) with operations. Based on the cost of operation “for whole operation " and number of related elements , when there is generate a price offer for the job ( Module Price offer formation, Elements’ list, button PRO) it is calculating the expense "Elements-> Operations" , such as the sum of the number of elements by price operation , with which they are connected. If there are several elements, related to different operations, quantity accumulate. For example: Default is 1 element , connected with a price Operation 1 with price 2 BGN / operation and 3 elements , related to Operation 2 with price for operation 5 BGN. Clicking the button PRO in module Price offer formation, we get: Elements -> Operations: Operation1 1pc х 2 BGN= 2 BGN Operation2 3pc х 5 BGN = 15 BGN Total Elements ->Operations 17 BGN Thus, the calculated quantity participated in the formation of the final price offer and the report Calculation on units / Total, if there is specified in the of module general settingsCutting , page Reports' parameters. Expense "Operations ---> Charged work" - Calculates when the material, connected to elements from the list, has attached operations in nomenclature "Materials - Operations". It comes out as the quantity of the material is multiplied by the unit price of the material of the operation or operations (depending on how many operations have attached to it). Expense "Operations - Materials" - Based on the connection of a material to an operation. Besides, the operation must to have set a Material consumption rate for the material. Accordingly, for its part, the operation must be attached to material , connected with elements from " Register of participating in the drawing elements “. It is calculated as follows: The quantity of material related to elements from the register is multiplied by the expense rate of the secondary material (attached to the operation, which is set for the original material). The result is multiplied by the price of secondary material per unit of material. For example: The material , connected to an element in “Register of participating in the drawing elements “ is EDGEBAND and its quantity is 20 meters. To edgeband is attached operation EDGEBANDING with price “per unit of material" from 2.5 BGN . For its part to EDGEBANDING operation is attached material glue with Material consumption rate 0.1 pc. per unit material and unit price 10 BGN / package. Activating the button PRO we receive: expense “Operations - Materials "=20 BGN (0.1 package glue x 20 l.m. -expense rate x 10 BGN (cost of 1 package glue). An expense “Operations -> Charged work” - is equal to the product of the quantity of material , connected to elements in the list (20 l.m.) multiplied by the price of the operation of processing unit of the material (2,5 BGN), ie 20 x 2.5 = 50 BGN Thus the estimated additional costs are also included in the calculation of the final price offer. Variants of price formation - creation and work with them The variants are saved combinations of connected elements with materials for price formation and cutting (nesting) purposes.This structure allows to save three variants with connecting of elements with materials and their setting as current in the working process. Variants - creation and saving:
Click Load variant to load an already saved one. Deleting of variant - If you want to delete a variant, press the button with X above the list. The operation does not requireconfirmation before execution. There is a small window with the description of the materials, connected with elements in the job ( in the right bottom window corner). It is intended for group selection of elements, connected with a concrete material and their reconnecting with other material. Select a material from the list. In the left field are specified all elements connected to it . Choose other material from the nomenclature and connect the elements to it.
ATTENTION! For units in the drawing, which have only one element and unit of measure, different from "package" and have got entered prices in the Units register on columns, the price from the Units register is accepted with priority (according to chosen columns: 1-4 ), regardless of the fact that you connect an element to a material. To connect an element with a material, the prices on a column in the Units register must be 0. For example: if for the identifier of the generated worktop "TK" has an entered price in the column 1 ("Price 1") at operation Price offer formation (even if connect the element with a material from the nomenclature), in a consequence the program will cancel the connecting and will restore the price from the Units Register.
Press the button Offer to print out the specification. The specification creates in a file "C:\Proekti.xls" or "C:\Proekti.ods" , in format Microsoft Excel or OpenOffice Calc. This file is created on your disk at installation of Design Sintez (The choice of program makes in the form System parameters). The specification can be detailed (separately for each unit) or generalized. The option On units prints а detailed specification. Irrespective of the chosen kind of the specification always under the list with the participating units you can see the total calculation by elements and materials, connected to them. After the end of processing Excel (or OpenOffice) it will ask you whether you want to save the made changes. Press Cancel and you can edit the made specification. If you choose No, the table closes without saving. If you choose Yes, it closes and saves as page in a file Proekti. Subsequently you can open this file again and to make changes in the chosen page. Closing it, Design Sintez automatically returns you in the current working drawing. The generated and saved price offers remain as pages in Proekti.xls (or Proekti.ods). Excel and OpenOffice support up to 256 pages in one file. Therefore it is necessary to look through and to delete the unnecessary pages periodically. The address and the name of a file Proekti.xls (or Proekti.ods) must be not changed, as well as name of page Prices. |