Budget-Plan-Express - harmony planning
Strategic-Line
Download demo
First project
For Partners
Personal account

Skip to content


Production plan

Exporting and importing Gantt charts - Exchange with MS Project
Planning a Gantt chart
Planning costs by stages of production. Calculation of the plan
Allocation of costs to stocks, capitalization of costs. The method of allocating costs to processes or products

Production plan. Exporting and importing Gantt charts - Exchange with MS Project


☛ Note that the Gantt chart is created using the program interface, but if desired, it can be imported from MS Project.


Tasks and resources

The Gantt chart is a format for displaying data, in addition to common formats (graphical and tabular). The Gantt chart has become widely used in business planning of projects, most likely for the simplicity and adaptability of the planning process. In the Gantt chart, it is customary to use some specific names: lag, percentage of execution, resource type, constraint type, and so on.

In the Budget-Plan Express, the page with the Gantt chart is called the production plan. However, in order for the plans from the Gantt chart to become part of the business plan calculations, the program "translates" them into a tabular standard - into the "production costs for production stages" plan following the "production plan". See "Example of calculation of the production plan of construction of multi-storey 3-sectional residential complex", and also "Example of capitalization of cost in construction projects (included in non-current assets value)".

The tasks or stages of the project display the main planning stages that are integrated into the plan groups and can have a hierarchical multi-level structure.

In "Budget-Plan Express", unlike MS Project, the structure of stages is limited to 3 levels. The maximum number of tasks (stages) in the "Budget-Plan Express" is "40".

☛ Note that if the Gantt chart was previously created in MS Project, you need to take into account the quantitative restrictions for the import and prepare the adapted project. In any case, the algorithm of the program will try to adapt the imported file independently according to the constraints.

Resources reflect cost items and are created in the "resources and production stages" directory. The same resources can be repeatedly included in different tasks (production stages), and the cost of the task is determined through the "attached" resources.

In "Budget-Plan Express" three types of resources are considered: "material" and "labor" and "other". When exporting to MS Project, "other resources" are counted as "labor".

If you want to describe the cost of stages through resources, then your reference book "resources and production stages" must coincide with the production stages in the Gantt chart.

Thus, the main goal of creating a Gantt chart in "Budget-Plan Express" is to calculate the "cost plan for the implementation of production stages" table. For this, after completing editing the Gantt chart, you need to perform a final calculation: "Data → Calculate → "Gantt chart"". Same thing - F9.


Accounting for calendar days

In "Budget-Plan Express" all actual calendar days (including days off) are taken into account, however MS Project by default shows the duration of stages, taking into account working days. Therefore, the number of days (the duration of phase work) in MS Project and in Budget-Plan Express may differ, even if the start and end dates coincide. It does not affect the calculations in any way.

If you want the number of days in MS Project and in Budget-Plan Express to match, you need to make the following settings:

  1. Open the "Project → Changing the working time ".
  2. In the "For Calendar" list, select "Standard (project calendar)".
  3. Click the "Work Weeks" tab and select "Default."
  4. Click the button "Details ..." ("Detalis ...").
  5. Select the "Saturday" and "Sunday" items simultaneously (click the mouse while holding down the CTRL key).
  6. Specify the option (one of the three on the right side of the dialog box): "Set days to use these working hours" ("Set day (s) to these specific working times").
  7. In the first line enter the opening hours (usually "9:00 - 13:00"), in the second line also enter the opening hours (correspondingly, "14:00 - 18:00").
  8. Click OK. Now MS Project will take into account all days as "workers", i.e. - just take into account the calendar days.

☛ Good to know. To display the entire project in the Gantt chart in MS Project, select the "View" menu tab, select the "Time scales" item ("Months", "Quarters", "Years", etc., corresponding to the scale, then click the button right "Time scales". After that, the entire project will be displayed in the Gantt chart.


List of exported / imported data and parameters:

  1. Task sheet
  2. Hierarchical structure (up to 3 levels of attachments);
  3. Start date;
  4. End date;
  5. Duration;
  6. Cost of the stage (tasks);
  7. Percent of completion;
  8. Reflection of information to the right of the task;
  9. Constraint type;
  10. Resource sheet
  11. Resource Type;
  12. Cost of the resource
  13. Payment period (charging period)
  14. Resource code;


Export of "production plan" (export of Gantt chart) to MS Project

Example of export of the "Production Plan".

    step 1. Create a directory with resources that (to simplify the example) coincide with similar tasks in the Gantt chart:

    1. Harmonization of project documentation
    2. Examination of project documentation;
    3. Obtaining a building permit;
    4. Preparation of working documentation.

    step 2. The next step is to create a plan for "the costs of implementing the production stages" in accordance with the previously created directory.

    step 3. First, create a stage in the Gantt chart: "Expertise of project documentation", and then create the subordinate stages:

    Exporting the production schedule (Gantt charts) in MS Project. Business planning Budget-Plan Express

    We indicate the cost of each stage and "tie" the stages to the corresponding resource (in our example, the names of the stages and resources are the same). In the task "Reconciling the project documentation" we indicate 100% of the implementation, in the task "Examination of the project documentation" we indicate, for example, 10% of the fulfillment. Also, we define the financing (payment periods): for "Harmonization of project documentation" - at the beginning, for "Obtaining a building permit" - Upon termination.

    By default, financing (payment period) for each "resource" is "Proportional".


    step 4. To export data in MS Project, called export, where you specify the export options: Main menu → Gantt chart → Export to MS Project.

    Form of export settings:

    Form of export settings:

      File:

      1. Create a new project
      2. Edit an existing one (the file open dialog is called up).

      What to export:

      1. Tasks
      2. Tasks, resource list - when this option is selected, the cost amount for the stage of each task is transferred not to the cost field, but to the resource cost field. You need additional editing of the project file in MS Project, where you need to relate the tasks to the resources (see the figure for exporting "Tasks and resource sheet").

      Other parameters:

      1. Types of restrictions used in MS Project (in Budget-Plan Express are not used). There are the following types of restrictions:

        1. Fixed start
        2. A fixed ending;
        3. Start no earlier than
        4. Beginning no later than
        5. End no earlier than
        6. End no later than
        7. As early as possible
        8. As late as possible.

      2. To the right of the task - to show what should be displayed to the right of the task (in Budget-Plan Express is not used):

        1. Nothing;
        2. % completion;
        3. Duration;
        4. Costs.

    As a result, the task sheet (if you choose to export "tasks") will look like this:

    Export of tasks. Business planning Budget-Plan Express

    A task sheet when you export "Task and resource sheet" will look like this:

    Export task and resource sheet. Business planning Budget-Plan Express

    Sheet "resources" it will look like this:

    Examination of project documentation. Business planning Budget-Plan Express
Please note, selecting export "Task and resource sheet", you must associate the task with the resource, as shown in the figure (or multiple resources using the separator "semicolon": ";").

When using the resource sheet, you need to specify the proportion of used resource in a specific task: labor resource - in percent, material resource - coefficient, where 100% = 1.00:

    "Approval of project documentation[85%];Expertise of project documentation[0,5]"


Import of the production plan (Gantt) from MS Project

If you constantly use the same imported file, it is recommended to create a Gantt chart in the "Budget-Plan Express" and export it to MS Project (export parameters - "tasks, resource list"), then use it to import the data. In the "code" field (see the figure above), you need to specify the resource line number corresponding to the row index in the "Budget-Plan Express" directory (the first line corresponds to the "3" index).

Mandatory import condition: the project period in MS Project must coincide with the period in Budget-Plan Express.


An example of the import of the production plan.

    step 1. Create in MS Project file using the export (use the already prepared file):

    Example of import of the production plan - create in MS Project file using export. Business planning Budget-Plan Express



    step 2. Clear production plan: "Main menu → Gantt chart → Remove all tasks". Then, the production plan in Budget Plan Express will look approximately as shown below:

    Import new project – an example of the import of the production plan. Business planning Budget-Plan Express



    step 3. Import a new project: "Main menu → Gantt chart → Import from MS Project". Further - we search for a file and we press "OK". In the settings you can check the box: "Use this file by default" - then the program will remember the path to the specified file. At this stage, only tasks are imported, as shown in the figure:

    Gantt chart - import from MS Project. Business planning Budget-Plan Express

    The result of the procedure of import a Gantt chart from a project file:

    If you are importing, including the resources the resources are imported and also the cost. Business planning Budget-Plan Express



    If you import only tasks, at this stage, your actions over. Please note, the cost of the task is not imported, as in Budget-Plan Express the cost to treat the resources that are attached to one or more tasks.

    If you are importing tasks, together with resource sheet, perform the following steps:
    step 4. Import options: "Edit existing file": "Main menu → Gantt chart → Import from MS Project". Locate the file and click OK (if you selected the check box: "Use this default file", just click OK).

    After this, a link to the resource sheet is established, and the "tasks" and "costs" are imported, as shown in the figure:

    Form settings - import of the production plan (Gantt) from MS Project. Business planning Budget-Plan Express


    Import the production schedule (Gantt) from MS Project. Business planning Budget-Plan Express


    In the future, you can reuse the same project file to update of data.




Help about the program "Budget-Plan Express", © Strategiс-Line, LLC | Help contents


© 2007-2019,  «Strategiс-Line», LLC,  support@strategic-line.ru, send a message ✉
   Home | Product | Buy | Reading | Contacts  
Рейтинг@Mail.ru