Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The Ginsu Report excels at

Excerpt

providing both high-level and detailed insight into staffing, revenue, profitability, resource borrowing and loaning for a specific time period. 


Projector's Ginsu report is our workhorse report that oftentimes is a great place to turn to if you don't know where to start.

...

To run this report type you must have the cost center permission Run Ginsu and Schedule Variance Report.

In addition, Engagement Engagement managers, project managers, and Can Act as PM users can all run the Ginsu report and see time/cost on their own projects. You must search using engagements in cost center to return any results in this case.


Permission or Setting

Description

Calculate RDC Basis as

A system setting that controls how the Utilization Basis Hours (UBH) are calculated.

Calculate Utilization For

A system setting that controls whether Yield or Capacity is the default utilization measurement. This setting can be overridden on a per report basis from the parameters tab.

Resource Direct Cost (RDC) Data

Global permission required to view the following report data fields - Resource Direct Cost, Resource Direct Rate, Resource Margin, Resource Profit and Resource ROI. Must be used in conjunction with the Financial Data in Utilization Reports permission.

Financial Data in Utilization Reports

View Project Margin

Global Permission required to view the following report data fields -

Resource Direct Cost, Resource Direct Rate, Resource Margin, Resource Profit and Resource ROI. Must be used in conjunction with the* Resource Direct Cost (RDC) Data* permission.

Include Engagements of this type in Busy Hours on Utilization Reports

An engagement type setting that governs whether an engagement affects utilization /wiki/spaces/docworkspace/pages/10331057.

Prebuilt Reports

The following prebuilt reports may be available in your installation.

Report

Description

Expense Analysis

This report can be used to examine the effect of project expenses not charged back to clients. It shows the effective rate change caused by this activity, as well as the percentage relative to revenue.

Project Profitability Analysis

This report delivers detailed project profitability and percentage completion information for a selected engagement.

Borrow & Loan

This report can be used to learn the inter-office resource sharing patterns of your organization. It delivers person hours, revenue, and cost information about those assignments on which a resource from one organizational unit work on another unit's project.

Resource Profitability Analysis

This report delivers a comparison of the revenue generated by each resource to the full cost of employing that resource over a configurable period of time. Note that doe to the particular sensitivity of the information generated by this report, that access to it is specifically configurable within Projector's user access/permissions subsystem.

Rate Realization Analysis

This report allows the user to compare actual realized rates against the organization's standard rates and contracted rates for each project. The results allow the user to differentiate between revenue foregone due to discounting in the sales process versus revenue foregone due to overages and/or other delivery issues.

Resource Schedule

View current and projected hours worked on a project

Rate Realization by Department Chart

A column chart of the Rate Realization Analysis report

System Revenue by Cost Center Trend Chart

A line chart with a line for each cost center representing system revenue over time.

System Revenue by Department Chart

A pie chart showing system revenue broken down by department

Profit Analysis Trend Chart

A stacked trend chart showing resource direct cost, other direct cost expenses and project profit. This chart breaks down how project profitability was affected by your labor costs and project expenses.

Profit Analysis by Cost Center Chart

A stacked column chart showing RDC, ODC Expenses and proejct profit.

Accounting Periods in Ginsu

...

  1. To group data by accounting period in the Ginsu, edit a Ginsu report, go to the Column Fields tab, choose Accounting Period from the dropdown box.
  2. Because there is no such thing as "future" transactions that get sent into your accounting package, there are no projected hours displayed when grouping by accounting period
  3. In order to financial data to appear in the report, it must be included in an existing batch. The status of the batch (pending, confirmed, failed, etc) is irrelevant.
  4. You will want to use the data field System Revenue
  5. When operating period and financial periods do not align, revenue may get pushed into a later period. When this happens, you'll have revenue that is not associated with a time card. Rather at the row level, it will be associated with a date.

FAQ

...