Standard Reports:
Payroll Detail and Payroll Summary
(downloads: stdPayrollDetail.rpt, stdPayrollSummary.rpt)

These reports detail the elements of pay involved in final pay calculations.

Note: If your reports don't have the same set of columns discussed on this page, you may be using older versions of the reports. You can download newer ones from the links above and save them in your Standard Reports folder.

• Hours - the hours associated with each event.
  • Regular
  • Overtime
  • Doubletime
  • Other
  • Total
• Event Earnings - Actual Event Earnings
• Elements of Pay - components of Total Pay
  • Time Work
  • Distributed Earnings
  • Distributed Makeup
  • Adjustments
  • Overtime Premiums
  • Shift Premiums
• Total Pay - the sum of all Elements of Pay.
• More about Makeup Sets

Event Earnings (Event Erns.)

The value in this column is total production earnings (from tickets, lot operations, and non-pay adjustments) multiplied by the Earned Rate Split Factor set on the Pay Condition's Associated Rates tab.

Elements of Pay

The values in these columns can be added together to form the amount in the Total Pay column.

• Time Work
• Distributed Earnings
• Distributed Makeup
• Adjustments
• Overtime Premiums
• Shift Premiums

---

Time Work (Tim.W.)

Total time-based earnings:

(Event's Regular Hours) X (Hourly Rate) X (Hourly Rate Split Factor)

The Hourly Rate is set on the Pay Condition's Associated Rates tab.
The Hourly Rate Split Factor is set on the Pay Condition's Associated Rates tab.

---

Distributed Earnings (Dist. Ern.)

The values in the Dist. Ern. column are weighted distributions of the total Event Earnings amount calculated across a Makeup Set's entire timeframe.

Many users mistakenly assume that the values in the Dist. Ern. column can be derived solely from the other values on the same event row, and when they find that the numbers don't work that way, they mistakenly conclude that the report is broken.

Essentially, Event Earnings are summed across all events in the entire timeframe of the applicable Makeup Set, and then this sum is distributed across all related events, with each event receiving a Distributed Earnings amount proportional to its share of the total number of worked hours in the makeup set's timeframe. In the end, the sum of all Distributed Earnings in a week matches Event Earnings.

---

Distributed Makeup (Dist.Mkup.)

As with Distributed Earnings, the values in the Distributed Makeup column are weighted distributions of a Total Makeup Amount calculated across a Makeup Set's entire timeframe.

An easy way to understand it is to consider the total Incentive Minimum Earnings dictated by the Makeup Set and to compare that against the total Event Earnings for that same time period. To calculate the Incentive Minimum Earnings, just multiply the worked hours associated with the Makeup Set's timeframe against the Makeup Set's Incentive Minimum Rate. If the total Event Earnings fall short of the Incentive Minimum Earnings, then the difference is the Total Makup Amount for that timeframe. That Total Makeup Amount is then distributed across the related events in amounts proportional to each event's share of the hours worked in that timeframe.

---

Adjustments (Adjust.)

Total Pay Adjustments for the Event. (Earned Time Adjustments are reflected in Event Earnings.)

More about Makeup Sets

Every Makeup Set specifies an Incentive Minimum Rate, and a timeframe for comparison: either per Event, per day, or per week. Since every Pay Condition is assigned a Makeup Set, every Event is related to a Makeup Set. However, Makeup Sets affect only those Pay Conditions involving on-standard (Earned) pay.

If the Makeup Set's timeframe is 'per Event', then the Makeup-related calculations will involve only that event, and in the Payroll Detail report, all the values in the Event's row will be based entirely on that Event. However, if the Makeup Set's timeframe is larger than one Event, then the values in an Event row's Makeup and Total Pay columns may be affected by other Events.

Bundle-Track adds up the Event Earnings across all Events associated with a given Makeup Set and then divides that total by the total number of hours worked across those Events to determine the Employee's Actual Earned Incentive Rate within that timeframe. (That Actual Earned Incentive Rate is the one used to calculate Disributed Earnings for each event.) If the Employee's Actual Earned Incentive Rate is less than the Makeup Set's Incentive Minimum Rate, Bundle-Track adds Makeup Pay to those Events to raise the Effective Incentive Pay Rate to the level guaranteed by the Makeup Set. It does this by calculating an hourly Makeup Rate (as the difference of the Employee's Actual Earned Incentive Rate and the Makeup Set's Incentive Minimum Rate) and then applying Makeup Pay amounts to each Event. The Distributed Makeup amount applied to each Event, as you will see on the report, is simply the calculated Makeup Rate times the Event's Worked hours.

We welcome your comments at support@bundle-track.com.

If you would like our live assistance, you may hire us at our professional services rate.