Resource Scorecard

Modified on Tue, 28 Jul 2009 09:38 by kyimin — Categorized as: Time and Material

Table of Contents [Hide/Show]

Default Menu Location
General Description
Standard Report Fields (Header)
Standard Report Fields Group Header1 (resid1)
Standard Report Fields Group Footer (resid1)
Standard Report Fields (Footer)
Additional Report Fields for Customization

Default Menu Location¶

Reports >> Time & Materials >> Resource Scorecard

Click here for a screenshot

General Description¶

The Resource Scorecard report generates a report showing hours, revenue, cost, profit and margin.

Standard Report Fields (Header)¶

Resource:

lc_resource

Start and End Dates selected for the report:

lc_sdate + " - " + lc_edate

Standard Report Fields Group Header1 (resid1)¶

Item:

text1

Actual Hours:

actqty

Invoiced Hours:

billqty

Invoiced Revenue:

itotal

Average Rev/Unit:

avgprice

Direct Cost:

tcost

Weighted Cost:

wcost

Gross Profit:

Margin:

margin

Sales Order Number:

sono

Standard Report Fields Group Footer (resid1)¶

Actual Hours Total by resid1:

actqty

Invoiced Hours Total by resid1:

billqty

Invoiced Revenue Total by resid1:

itotal

Direct Cost Total by resid1:

tcost

Weighted Cost Total by resid1:

wcost

Gross Profit Total by resid1:

Load at Given Percentage:

lc_load

Average Cost Unit:

No Load: iif(totalact<>0,totalcost/totalact,0)

Load at Given Percentage: iif(totalact<>0,totalcost/totalact*ln_burden,0)

Average Rev Unit:

No Load: iif(totalact<>0,totalinv/totalact,0)

Load at Given Percentage: iif(totalact<>0,totalinv/totalact,0)

P/L Per Unit:

No Load: iif(totalact<>0,(totalinv-totalcost)/totalact,0)

Load at Given Percentage: iif(totalact<>0,(totalinv-(totalcost*ln_burden))/totalact,0)

Margin %:

No Load: iif(totalinv<>0,((totalinv-totalcost)/totalinv)*100,0)

Load at Given Percentage: iif(totalinv<>0,((totalinv-(totalcost*ln_burden))/totalinv)*100,0)

Weighted Cost/Invoiced Hour:

No Load: iif(totalbill<>0,totalcost/totalbill,0)

Load at Given Percentage: iif(totalbill<>0,totalcost/totalbill*ln_burden,0)

Weighted Rev/Invoiced Hour:

No Load: iif(totalbill<>0,totalinv/totalbill,0)

Load at Given Percentage: iif(totalbill<>0,totalinv/totalbill,0)

P/L Per Invoiced Hour:

No Load: iif(totalbill<>0,(totalinv-totalcost)/totalbill,0)

Load at Given Percentage: iif(totalbill<>0,(totalinv-(totalcost*ln_burden))/totalbill,0)

Margin %:

No Load: iif(totalinv<>0,((totalinv-totalcost)/totalinv)*100,0)

Load at Given Percentage: iif(totalinv<>0,((totalinv-(totalcost*ln_burden))/totalinv)*100,0)

% Hours Invoiced:

No Load: iif(totalact<>0,totalbill/totalact*100,0)

Load at Given Percentage: iif(totalact<>0,totalbill/totalact*100,0)

Standard Report Fields (Footer)¶

Date:

date()

Page:

_PAGENO

Additional Report Fields for Customization¶