16.6. Resource Reports

Because the information is displayed within a window, you can apply a variety of predefined or advanced filters (Search ). The result can be exported and displayed using custom print formats (Report ).

The following fields are available:

• Quantity - the quantity entered in the roadmap line;

• Qty 1,2,3 (hours) - the ours entered (effective, parking, moving);

• List, Standard and Limit Price - the prices corresponding to the evaluation of the entered hours (see the previous chapters);

  • the current version of the price list marked with the Default checkbox will be taken into account;

• Revenue 1,2,3 = Qty (1) * price (list) + Qty (2) * price (standard) + Qty (3) * price (limit);

• Total Qty Revenue = (Sum of Revenue 1,2,3) * Quantity;

• Start index, Stop index - the indexes entered on the file;

• Covered Km = Stop index - Star index;

• Qty 1,2,3 (mileage) - the kilometres entered on the file;

• Price - the evaluation price of the km, the same for Qty 1,2,3 (mileage) - set when defining the mean of conveyance (this information is only available for cars);

• Revenue Km = sum Qty 1,2,3 (mileage) * price km;

• Total Revenue = Total Qty Revenue + Revenue Km.

Internal Resource Matrix

The Internal Resource Matrix report is used for the internal discount of the resources used for a certain time period, allocated on projects.

The reporting can be done using two grouping methods:

• by Activity - in this case, the values to be discounted are analysed on Activities which are determined from the definition of the project or project phase;

• by Trx Organization - in this case, the values to be discounted are analysed on Trx Organizations which are determined from the definition of the project or project phase;

The calculation formulas are the same as those used in the Detailed Resource Report window:

• Total Qty Revenue = Quantity * (sum (Qty 1,2,3 (hours) * List, Standard, Limit Price));

• Revenue Km = sum Qty 1,2,3 (mileage) * price km - this is only applicable for clocked means of conveyance that are also clocked in km;

• Total Revenue = Total Qty Revenue + Revenue Km.

Activity Resources Report

The Activity Resources Report report is used to analyse the resource consumption, especially cars - equipments. The calculation formulas are the same as those from the Detailed Resource Report. The report contains the following columns:

• Price List: Price List for the product linked to the resource from the DEFAULT price list

• Price Standard: Price Standard for the product linked to the resource from the DEFAULT price list

• Price Limit: Price Limit for the product linked to the resource from the DEFAULT price list

• Effective Hours: Qty 1 from resource report line, converted to hours

• Stationary Hours: Qty 2 from resource report line, converted to hours

• Movement Hours: Qty 3 from resource report line, converted to hours

• Total Hours = Effective Hours + Stationary Hours

• Effective Hours Income = Effective Hours * Price List

• Stationary Hours Income = Stationary Hours * Price Standard

• Movement Hours Income = Movement Hours * Price Limit

• Total Qty Revenue = (Effective Hours Income) + (Stationary Hours Income) + (Movement Hours Income)

• Efficiency Use=Effective Hours/Monthly Norm (168 hours)

• Covered Km = Stop Index - Start Index

• Km Cost = the price from the mean of conveyance

• Income Covered Km = Covered Km * Km Cost

• Total Income Resource = (Effective Hours Income) + (Stationary Hours Income) + (Movement Hours Income) + (Income Covered Km)

P&L / Resource Report

The P&L / Resource Report report is used to determine the profitability per resources. The report needs to be structured as described below:

• Report Lines: Resources (resource-type products)

• Report Columns:

  1. Revenue from:

     • Resource time sheets (Credit account 9520/ Resource (product)) – GL Journal on the product linked to the resource (from issue to project);

     • Externally renting equipment (Credit account 70608) –> Customer Invoice- fill in asset. (The link is: Resource => Product, asset, select the resource-type product).

  2. Expenses from: this are those from cost - resource allocation (the value must be taken from the allocated amount - the Resource field in the Assignment tab, the accounting is found on the source documents: Internal Use Inventory, Vendor Invoice, Cash Journal, Payment/Receipt document, bank statement);

DAR Centralizer Report

DAR = Fleet Daily Activity Report

The DAR Centralizer Report report brings information from the time sheet (resource statement) and from cost-resource allocations. Enter all the data in the time sheet as according to the daily activity report.

The report centralizes the information and presents them in a chronological order in a grid as displayed below:

Organization Data:

DAR Centralizer, Period: 01.01.13-31.01.13

Report Columns:

• Vehicle - the mean of conveyance registration number;

• Day - from 1 to 31;

• Paper - document number of resource statement;

• Driver - employee on the resource statement;

• Hours Exploitation - sum of effective, stationary and moving hours from the details;

• Effective Km = (stop index - start index);

• Km full - Km 1 from the details;

• Km empty - Km 2 from the details;

• Medium Consumption - from the definition of the mean of conveyance, standard medium consumption;

• In tank Initial = the end of the previous day (measured if different from 0, otherwise it is equal to the tank capacity from the definition of the mean of conveyance);

• Home Fuelling = the quantity on the allocated Internal Use Inventory with cost-resource category = "Fuel" (this must be the exact name of the category) at the Internal Use Inventory date;

• Transit Fuelling = the quantity on the allocated Vendor Invoice with cost-resource category = "Fuel" (this must be the exact name of the category) at the allocation date;

• Effective Consumption = Home Fuelling + Transit Fuelling;

• Normed Consumption = Effective Km * Medium Consumption / 100;

• Difference = Effective Consumption - Normed Consumption;

• In tank final (calculated) = In tank Initial + Home Fuelling + Transit Fuelling - Normed Consumption;

• In tank final (measured) = the fuel in the resource statement line, if the value is different from 0.

The totals are calculated on:

• effective hours;

• effective, full, empty km;

• home, transit fuelling;

• effective, normed, difference consumption.