Follow

ID258 - QBR - Lease Details (Worksheet7)

The lease detail is designed to get the all the information needed to work the numbers and see when is the best time to upgrade a lease. It requires that you store the lease information in eAutomate. Consider ID64 to ensure that information is accurate.

Lease Details, Grouped by Lease Company:

Lease Payment Total and Lease End Date:

Equipment level lease payment per eAuto Service or Contract Record Lease Details

Average Service Billing

The sum of all contract revenue allocated to specified equipment for the periods (based on invoice date) reported divided by the number of periods reported.

The portion of revenue attached to that equipment's meter readings, average by month of period filter of report. It is the overage and meter group base, if it exists. 

Last BW / Color Meter:

Last BW / Color Meter BILLED

Base and Overage Clicks BW / Color:

BILLED clicks for period time filter

*The short definition of BaseAndOverage is 'The larger of actual clicks run or clicks covered for the period.' So if a given machine is billed for overage (run more clicks than covered) the actual clicks-billed value is used, but if a machine failed to meet it's covered clicks the total covered (paid for) clicks is used instead. It's essentially 'clicks sold.' Then all this is summed up per contract invoice and then for the reporting period.

 

a.PNG

 

 

 

 

******************************************************************************

Please use the links below to see detailed level explanation for each worksheet within the QBR:

Customer Review (Worksheet1)

Equipment Excessive Calls (Worksheet2)

Current Equipment Details (Worksheet3)

Detail Stats Chart (Worksheet4)

Detail Stats (Worksheet5)

Equip Details (Worksheet6)

Lease Details (Worksheet7)

Service Details (Worksheet8)

Survey Responses (Worksheet9)

Worksheets.png

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk