Payroll
Zone-level Employee Payroll report (v2)
The Employee Payroll report aggregates payroll details of employees from across centers that follow the selected pay period in the zone. If you are a zonal manager or an owner, you can run the Employee Payroll report for pay periods that start within two months before the current date.
Important
Centers should have already configured the pay periods. (Employee > Settings > Pay Period)
The Employee Payroll report considers only closed invoices.
If the Show commission amount in payroll post invoice-level deduction organization-level setting is selected, the commission amounts in this report will reflect values after Zenoti has made invoice-level deductions.
The Employee Payroll report shows the payroll summary of employees either in their primary center or in the deputed center (center to which the employee is deputed) based on whether the Do not consider other center invoices for payroll organization-level setting is selected.
At the zone level, click the Reports icon and go to Employee > Employee Payroll.
From the Zone list, select the applicable zones.
Select the pay period type.
Note
The Pay period type list shows only the pay period types used by at least one center in the zone. For example, if no center in the zone uses the Monthly pay period type, the list will not show Monthly.
Select the pay period
Select the centers.
Click Calculate Commissions Now.
Note
You can run the Zone Payroll report only for a pay period applicable to at least one center in the zone.
From the Employee Wise Details, Invoice Wise Details,or Work Task Wise Details columns, next to the required payroll report, click the Download icon. Zenoti will export the payroll report in the .xlsx format.
Zenoti allows users to select multiple centers within a zone for payroll calculation.
An organization has multiple zones, Zone 1, Zone 2, and Zone 3. Each zone has multiple centers.
Zone 1 has four centers: Center 1, Center 2, Center 3, and Center 4.
To get the latest calculation of the payroll for a zone, you have to select the relevant centers, and then click Calculate Commissions Now. To retrieve the last calculated data, click Refresh.
The following table describes how calculations are done in Zenoti:
Scenario | Centers Selected | Action | Result | Reason |
---|---|---|---|---|
Payroll for Center 1 and Center 2 is not calculated. Need to calculate payroll for both centers. | Center 1, Center 2 | Click Calculate Commissions Now | Payroll calculated | Calculation displayed for Center 1 and Center 2 |
Payroll for Center 1 is calculated. Payroll for Center 3 is not calculated. Need to retrieve the last calculated payroll for both centers. | Center 1, Center 3 | Click Refresh | Calculation not initiated | Center 3's pending calculation prevents the initiation of the calculation |
Payroll for Center 1 is calculated. Payroll calculation for Center 4 failed. Need to retrieve the last calculated payroll for both centers. | Center 1, Center 4 | Click Refresh | Calculation failed | Center 4's failed calculation caused the calculation of payroll to fail. |
Payroll for Center 1 and Center 4 is not calculated. Need to calculate payroll for both centers. | Center 1, Center 4 | Click Calculate Commissions Now | Calculation failed | Calculation failed for at least one center (Center 4) |
Payroll for Center 1, Center 2, Center 3, and Center 4 is not calculated. Need to calculate payroll for all the four centers. | Center 1, Center 2, Center 3, Center 4 | Click Calculate Commissions Now. | Payroll calculated | Calculation displayed for Center 1, Center 2, Center 3, and Center 4. |
Column descriptions
In the table below, you can see a list of columns a Zone Payroll report shows:
Column Name | Short description | Details and Examples |
---|---|---|
Center Code | Unique identifier assigned to the specific center. | Unique identifier assigned to the specific center. |
Center Name | Name of the center. | Name of the center. |
Start Date | Start date of the pay period. | Start date of the pay period. |
End Date | End date of the pay period. | End date of the pay period. |
Payroll Generated Date | Date on which payroll is generated. | Date on which payroll is generated. |
Employee Code | Unique identification code of the employee. | Unique identification code of the employee. |
Employee Name | Full name of the employee from the employee profile. | Full name of the employee from the employee profile. |
First Name | Employee’s first name from the employee profile. | Employee’s first name from the employee profile. |
Last Name | Employee’s last name from the employee profile. | Employee’s last name from the employee profile. |
Employee-wise Details | Detailed export of all payroll and commission information for an individual employee. | This provides a detailed export of payroll and commission information for each employee. Includes commissions, bonuses, deductions, and other payroll data for the selected pay period in one downloadable file. |
Invoice-wise Details | Detailed breakdown of commission amounts by individual invoices for the selected pay period. | Invoice-level data explaining how commissions were calculated, including services performed, products sold, discounts applied, and the final commission earned per invoice. Users can download this information by clicking the download icon next to the employee’s record. |
Work Task-wise Details | Breakdown of hours or pay by each assigned work task when work-task level pay rates are used. | A breakdown of hours worked and pay earned for each assigned work task. It appears when work-task level pay rates are used, allowing detailed insight into how an employee’s compensation is distributed across different tasks. |
Job | Job associated to the employee's profile. | Job associated to the employee's profile. |
Salary | Salary amount recorded per pay period in the employee profile. | Salary amount recorded per pay period in the employee profile. |
Total Hours | Total hours worked by the employee during the pay period, based on center payroll settings. | Shows the total hours worked by the employee during the pay period, determined by the center’s payroll settings. If the Scheduled and Actual Hours Combination setting is turned on, Zenoti calculates hours by taking the later of the scheduled or actual check-in time and the earlier of the scheduled or actual check-out time, ensuring accurate payroll calculations. |
Total Hourly Pay | The total regular hourly pay and overtime pay (if any) earned by the employee for the selected pay period. | The total regular hourly pay and overtime pay (if any) earned by the employee for the selected pay period. |
Service Hours | Total hours an employee spent performing services during the pay period. | The total time an employee spends actively performing services during the selected pay period. It is calculated by adding up the duration of all services delivered. For example, if a stylist completes 5 haircuts (2.5 hours), 3 hair coloring sessions (4.5 hours), and 2 blowouts (1.5 hours), their total Service Hours for the period would be 8.5 hours. |
Hourly Pay/Service Commission | Higher amount earned between hourly pay (including overtime) and service commission during the pay period | The greater of either an employee’s total hourly pay, including any overtime, or their service commission earned during the pay period. This column appears only if the Based on higher of total hourly pay (including overtime hours) and service commission setting is enabled at the center level. Zenoti evaluates both earnings daily, weekly, or per pay period, depending on the employee’s profile settings, and pays the higher amount. For example, if an employee is due $100 in hourly pay and $125 in service commissions for a day, they will receive $125. Service commissions include Add-On commissions and Request Therapist Bonus. |
Service Commission | Commission earned by an employee for services performed, calculated as a flat amount, percentage, or via revenue slabs. | The payout employees earn based on the revenue they generate from performing services. It can be calculated as a flat amount per service, a percentage of the service’s price, or through revenue slabs that award higher rates for higher sales. Zenoti’s payroll configurations determine whether commissions are applied cumulatively or only at the highest qualifying slab and account for deductions, refunds, or adjustments. For example, if an employee generates $750 in service sales and qualifies for a 4% slab, they would earn $30 in commission. |
Add-On Service Commission | Total commission earned by the employee from service add-ons during the pay period. | The total commission an employee earns from performing or selling service add-ons in the selected pay period. These commissions are calculated based on organizational settings, which may include flat rates, percentage-based payouts, or revenue slabs specific to add-on services. |
Product Commission | Commission earned by an employee based on revenue from products sold during the pay period. | The payout an employee earns for selling products, calculated according to payroll configurations that define rates as flat amounts, percentages of sales, or revenue slabs. Zenoti determines the commission based on product-specific rules, employee or job profiles, and special models like product-to-service sales ratios. For example, an employee selling $750 in products might earn 4% commission, totaling $30, depending on slab settings. Refunds and adjustments are also accounted for to ensure accurate commission payouts. |
Package Commission | Commission earned by an employee for selling prepaid service packages to guests. | The earnings an employee receives for selling prepaid service packages, like bundles of facials or laser treatments, at a single price. The commission can be a flat amount, a percentage of the package price, or based on revenue slabs set at the item, employee, or job level. For example, selling a $1,200 laser hair removal package could earn an employee either a flat $50 or 8% ($96), depending on configured rules. |
Gift Card Commission | Commission earned by an employee for selling gift cards, calculated using revenue slabs. | The total commission an employee earns for selling gift cards during a pay period, determined by revenue slabs that define commission rates based on total sales amounts. Employee-level slabs take precedence over job-level slabs if both are configured. For example, if an employee sells $3,000 worth of gift cards and qualifies for a 5% slab, they earn $150, but if they have an employee-specific slab of 6%, they would earn $180 instead. |
Membership Commission | Commission earned by an employee for selling prepaid memberships to guests. | The compensation employees receive when they sell prepaid memberships, such as spa packages, treatment plans, or bundled services. The commission can be a flat amount, a percentage of the membership sale price, or determined by revenue slabs set at the item, employee, or job level. For example, selling a $1,200 laser hair removal membership might earn an employee either a flat $50 or an 8% commission, depending on the configured settings. |
Free Service Commission | Commission paid to employees for services performed without generating revenue for the center, based on configured calculation methods. | The commission awarded to employees for performing services that generate no actual revenue for the center but are tracked for payroll purposes. Zenoti calculates these commissions using one of several methods: applying commission slabs to the discounted amount, including free service value in paid revenue, or paying the highest commission slab on free service revenue. For example, if an employee performs a $60 service discounted by $10, Zenoti may calculate commission on either the $50 paid amount or the full $60, depending on settings. |
No-show Commission | Commission paid to an employee when a guest misses an appointment and a no-show fee is collected. | Compensates employees when guests fail to show up for scheduled appointments, while the business collects a no-show fee. The commission can be calculated as a flat amount, a percentage of the no-show fee, or based on the original service price, with scaling factors available for individual employees. For example, if a $20 no-show fee is collected and the commission rate is 10%, the employee would earn $2 as a no-show commission. |
Cancellation Commission | Commission paid to an employee when a guest cancels an appointment and a cancellation fee is collected. | Compensates employees when guests cancel appointments, especially on short notice, and the business charges a cancellation fee. The commission can be calculated as a flat amount, a percentage of the cancellation fee, or based on the original service price, with adjustments possible through employee-specific scaling factors. For example, if a $30 cancellation fee is collected and the commission rate is 10%, the employee would earn $3 as a cancellation commission. |
Center Commission | Additional commission paid to employees when the center achieves business milestones or targets. | An extra payout awarded to employees when the business reaches specific milestones, such as hitting revenue targets or opening a new center. Zenoti calculates this commission as a percentage of the employee’s total revenue during the pay period, and it applies automatically if a value is entered in the Incentive field for the center. For example, employees may earn a center-based commission on services, products, memberships, and other sales when the center achieves its goals. |
Tenure Bonus | Extra commission awarded to employees based on their length of service with the organization. | An additional commission granted to employees who reach specific service milestones with the organization, serving as a retention incentive. Zenoti calculates this bonus as a percentage of the employee’s total revenue for the pay period, applying it automatically once the defined tenure threshold is met. For example, if an employee with one year of service generates $3,000 in revenue and the tenure commission rate is 5%, they would receive an additional $150 as a tenure bonus. |
Redo Penalty | Penalty deducted from an employee’s commission when a guest requests a redo of a service. | A deduction applied to the original service provider’s commission when a guest is dissatisfied and requests a redo of the service. The penalty may also reduce revenue and is calculated based on organization-defined percentages for revenue and commission deductions. For example, if a $200 service is redone for $150 and the redo commission penalty is 15%, the original employee’s commission could be reduced by $30, while the employee performing the redo earns commission on the redo service. |
Leave Balance (Days) | Number of regular vacation days an employee has left before factoring in the current month’s leave and accruals. | Represents the number of unused regular vacation days an employee has remaining, calculated as total allocated days minus leave taken before the current payroll period. It excludes weekly offs and special leave. Revised Leave Balance is the updated total after accounting for leave accrued and leave taken during the current period. For example, an employee with 24 allocated days who has used 6 before September and takes 2 days off in September would have a revised balance of 18 days after accruals are added. |
Special Leave Balance (Days) | Number of unused special leave days an employee has remaining. | Indicates the number of special leave days an employee still has available, calculated as total allocated special leave minus leave already used before the current payroll period. Attendance rules can adjust this balance automatically based on factors like working hours, late check-ins, or early checkouts. For example, if Priya was granted 5 special leave days at the start of the year and used 2 before June, her special leave balance in the June payroll would be 3 days. |
Last Refreshed | Date when the payroll data was last refreshed. | Date when the payroll data was last refreshed. |
Tips | Total tips received by the employee from guests during the pay period, across all payment types. | Refers to the total amount of gratuities an employee receives from guests during the selected pay period, including all payment types such as cash or credit card, as long as they are linked to the employee’s service or sale. For example, if Maya receives $50 in cash tips and $120 in credit card tips between June 1–15, her total tips for the period would be $170. |
Support Staff Gratuity | Total support staff gratuity earned by the employee on closed invoices during the pay period. | Represents the total amount of gratuities earned by an employee for support staff contributions on closed invoices in the selected pay period. This column appears in the report only if the Allow collection of SSG setting is enabled at the center level, and it displays the label configured for SSG at the organization level. |
Number of Invoices | Total number of closed invoices where the employee sold at least one service, product, or other item during the pay period. | Represents the total count of closed invoices in which an employee sold at least one item, such as a service, product, membership, package, or gift card, during the selected pay period. For example, if Alex sold services, products, or memberships on five invoices between June 1–15, those five invoices would be reflected in his total count for that period. |
Number of Service Invoices | Number of closed invoices where the employee performed at least one service during the pay period. | Represents the total number of closed invoices in which an employee performed at least one service during the selected pay period. For example, if Priya performed services on invoices #201, #203, #204, and #206 between June 1–15, her count of service invoices for that period would be 4. |
Number of Times Requested | Number of times guests specifically selected the employee for services during the pay period, based on closed invoices. | Represents the number of times guests specifically chose an employee to perform services during the selected pay period, counting only closed invoices. For example, if Anita was requested by guests for two services out of several performed during June 1–15, only those two guest-selected and closed invoices are included in the report as her Requested count. |
Request Therapist Bonus | Bonus earned by an employee when guests specifically request their services during the pay period. | Amount paid to an employee when a guest chooses that employee to perform a service. You can see this column in the report only if the Enable Request Therapist Bonus center-level setting is selected. The bonus is calculated by multiplying the number of guest requests by the per-request bonus amount configured in the employee’s profile. For example, if Anita has a bonus rate of $2 per request and 15 guests requested her services during the pay period, she would earn a $30 Request Therapist Bonus shown in the payroll report. |
Deductions on Total Commission | Amounts subtracted from an employee’s gross commission to reflect costs, penalties, or business rules before final payout. | Various amounts deducted from an employee’s gross commission earnings to ensure payouts reflect true profitability and business policies. These can include standard deductions, service-level costs like guest, shop, and labor costs, invoice-level deductions, redo penalties, and COGS deductions. For example, if an employee earns $400 in gross commission but has deductions totaling $193, the final payout becomes $207. Deductions can be configured at multiple levels and vary by service type, employee role, and organizational rules. |
Service and Invoice deductions | Reductions applied to revenue used for commission calculations, covering costs at service and invoice levels. | Reductions taken from an employee’s commissionable revenue based on operational costs or business rules. Service-level deductions include guest cost, shop cost, and labor cost, while invoice-level deductions involve flat amounts or percentage-based reductions. Configuration settings determine which deductions apply, helping ensure accurate commission payouts. |
Service Revenue | Total revenue from services performed by the employee, after discounts and before tax, with possible deductions applied.Considers closed invoices only. | Total amount earned from all services performed by an employee during the pay period, calculated after discounts but before tax. It may include revenue from regular services, package redemptions, membership redemptions, and gift card redemptions, and can be adjusted for deductions like internal costs, guest costs, shop costs, labor costs, and refunds, depending on organizational settings. For example, if Sarah earns $1,830 from services including packages and memberships, minus $100 in costs, her Service Revenue is used to calculate commissions, bonuses, and other payroll metrics. |
Free Service Revenue | Value of services provided without generating revenue for the center, tracked to credit employees for commissions. Considers closed invoices only. | Value of services performed without generating actual revenue for the center, tracked so employees still earn commissions. It includes services paid through loyalty points, membership discounts, $0 priced gift or prepaid cards, and certain discounts, depending on center settings. For example, if Sophia performs a $100 facial paid with loyalty points, this amount is counted as Free Service Revenue to ensure her commissions are calculated correctly. |
Product Revenue | Total revenue from products sold by the employee during the period, after discounts and before tax. Considers closed invoices only. | Represents the total earnings from all products sold by an employee during the selected period, calculated after applying discounts but before tax. For products sold as part of a package, revenue is proportionally derived from the package price. Certain payments and redemptions, such as manual discounts, $0 priced prepaid or gift cards, membership discounts, loyalty point redemptions, and refunded prepaid cards, are excluded to ensure only actual revenue-generating transactions are counted. |
Declared Tips | Total cash tips declared by employees at checkout for the day. | Represents the total cash tips an employee reports at the end of their shift during checkout. This feature appears only if the organization has enabled settings for employee tip declaration and restricted check-in and check-out to logged-in users. For example, at Glow Beauty Salon, Maya declares $45 in cash tips during checkout on June 10, which is then recorded in the payroll or daily report. |
Total Revenue Deductions | Total amounts subtracted from an employee’s gross revenue before calculating commissions, bonuses, or payroll. | Amounts subtracted from an employee’s gross revenue before calculating commissions, bonuses, or payroll. These can include costs like COGS, refunds, guest costs, shop costs, and penalties. For example, if gross revenue is $1,950 with $540 in deductions, the net revenue used for payroll is $1,410. |
Tips Payout through Zenoti | Total amount of tips paid to the employee through Zenoti. | Total amount of tips paid to the employee through Zenoti. |
Overtime Hours | Extra hours worked beyond the defined daily, weekly, or pay-period threshold. | Represents the additional hours an employee works beyond the standard threshold set for overtime, such as exceeding a certain number of hours per day, per week, or per pay period. These thresholds and overtime rules are configured in the employee’s profile to ensure proper tracking and compensation for extra work performed. |
Overtime Pay | Compensation paid for overtime hours worked beyond regular thresholds, usually at a higher pay rate. | Additional compensation an employee earns for working hours that exceed standard daily, weekly, or pay-period limits, calculated at a higher pay rate such as 1.5 times the regular hourly rate. For example, if an employee with a $20 hourly rate works 10 hours in a day under an overtime rule that applies above 8 hours per day, they receive $160 for 8 regular hours plus $60 for 2 overtime hours, totaling $220 for that day. Similar calculations apply for weekly or pay-period overtime, ensuring employees are fairly compensated for extra time worked. |
Vacation Pay Rate | Hourly rate set for vacation hours in the employee’s profile. | Hourly rate set for vacation hours in the employee’s profile. |
Vacation Hours | Total hours recorded as vacation time in the Add Attendance section for the pay period. | Represents the total number of hours entered in the Vacation Hours field within the Add Attendance section on the Manager Check-In page for a specific pay period. For example, if a manager records 8 vacation hours each day for three days for an employee named Anita, the total Vacation Hours shown in the payroll report would be 24 hours. |
Vacation Pay | Total pay the employee receives for vacation hours taken during the pay period. | Represents the total earnings an employee receives for vacation hours taken within the pay period, calculated using the vacation hourly rate set in their employee profile. For example, if Anita has a vacation rate of $20 per hour and takes 24 hours of vacation, her Vacation Pay for the period would be $480, which is shown in the payroll report. |
Holiday Pay Rate | Hourly rate set for holiday hours in the employee’s profile. | Hourly rate set for holiday hours in the employee’s profile. |
Holiday Hours | Total hours recorded as holiday time in the Add Attendance section for the pay period. | Represents the total number of hours entered in the Holiday Hours field within the Add Attendance section on the Manager Check-In page for a specific pay period. For example, if a manager records 8 holiday hours each day for three days for an employee named Anita, the total Holiday Hours shown in the payroll report would be 24 hours. |
Holiday Pay | Total pay the employee receives for holiday hours taken during the pay period. | Represents the total earnings an employee receives for holiday hours taken during the pay period, calculated using the holiday hourly rate set in their employee profile. For example, if Anita has a holiday rate of $20 per hour and takes 24 hours of holiday, her Holiday Pay for the period would be $480. |
Production Hours | Total time spent by the employee on production tasks during the selected pay period. | Represents the total time an employee spends during the selected pay period on tasks designated as production work. These typically include client-facing or revenue-generating activities, such as performing services, and are relevant for businesses using Payroll Plans. |
Non-production Hours | The total number of non-production hours the employee worked in the selected pay period. | Represents the total time an employee spends on activities that are not categorized as production work during the selected pay period. This can include tasks such as administrative duties, training sessions, meetings, or breaks, and is relevant for businesses using Payroll Plans. |
Regular Hours | Total hours worked within the standard, non-overtime threshold during a defined time period. | Refers to the total number of hours an employee works within the standard, non-overtime limit for a given period, such as a day, week, or pay period. These hours are paid at the employee’s base hourly rate, which is configured in the employee’s profile, and do not include any time that qualifies for overtime pay.” |
Regular Hourly Pay | Compensation earned for regular hours worked, based on the employee’s base hourly rate. | The amount an employee earns for their standard hours worked during a pay period, calculated using their assigned base hourly rate and excluding any overtime or bonuses. For example, if an employee’s hourly rate is $20 and they work 40 regular hours, their Regular Hourly Pay amounts to $800. |
Service Sale Price Before Discount | Total original price of services performed by the employee during the selected pay period, before discounts. | Represents the total value of services performed by the employee in the selected pay period, calculated using the original service prices before any discounts or promotions are applied. For example, if an employee performs 3 facials at $100 each, 2 massages at $150 each, and 1 chemical peel at $200, the total service sale price before discounts is $800, regardless of any reductions offered to customers. |
Product Sale Price Before Discount | Total original price of products sold by the employee during the selected pay period, before discounts. | Represents the total value of products sold by the employee in the selected pay period, calculated using the original product prices before any customer discounts are applied. For example, if an employee sells 2 moisturizers at $50 each, 3 serums at $40 each, and 1 sunscreen at $30, the total sale price before discounts is $250, regardless of any price reductions given to customers. |
Payrate Applied Based on Revenue | The pay rate based on the revenue slab in which the employee fell for the selected pay period. | Refers to the pay percentage assigned based on the revenue range an employee achieves during the selected pay period. For example, if the pay structure offers 10% for $0–$999, 15% for $1,000–$1,999, and 20% for $2,000 and above, an employee generating $1,250 in revenue would receive a 15% pay rate for that period. |
Class Commission | Amount paid to the instructor as base earnings for teaching a class. | The amount an instructor earns as base pay for conducting a class session. For example, Sarah teaches a ‘Morning Yoga Flow’ class and receives $35 as commission for that class. |
Hourly Rate | The hourly rate of an instructor. | Refers to the hourly rates charged by instructors. This is applicable only if classes are configured |
Class Hours | Total teaching time an instructor spends delivering classes during the payroll period. | Represents the total time an instructor spends teaching classes during the payroll period, calculated by adding the duration of each class from its start to end time. For example, if Sarah teaches yoga classes lasting 1.5 hours on Monday, 1 hour on Wednesday, and 1.5 hours on Friday, her Class Hours total 4.0 hours for that payroll period. |
Total Classes | Total number of individual class sessions taught by an instructor during the payroll period. | Refers to the number of individual class sessions an instructor teaches within the payroll period, with each separate class counted as one unit regardless of its duration. For example, if Sarah teaches yoga on Monday, Wednesday, and Friday, her Total Classes count is 3. |
Deducted Fees from Paid Tips | Credit card processing fees deducted from the employee’s total tips | Shows the amount of credit card processing fees subtracted from the total tips earned by the employee. For example, if a $20 tip is paid by card and has a 3% fee ($0.60), the employee keeps $19.40, and the deducted fees amount is $0.60. |
Break Time (Hours) | Total time deducted from an employee’s work hours for meal breaks, rest periods, or manual breaks. | The total time deducted from an employee’s worked hours for meal breaks, manual breaks, or mandatory rest periods. Settings like auto meal break deductions and break types determine whether breaks are automatic, their duration, and if they’re paid. For example, a 9-hour shift with a 30-minute auto meal break results in 8.5 payable hours, while a manually tracked one-hour lunch break similarly reduces net hours. |
Click the Reports icons.
Open the report.
Click the show-hide columns icon
.
Click Add column.
In the New column name box, enter the name of the new column.
From the Existing columns box, click the desired column. You can see the existing column in the New column calculation box.
Note
To delete any entry from the calculation box, click Delete.
Define the formula using the calculator.
To add a footer, select the Display column total at the footer of the column checkbox.
Note
If you do not select this checkbox and this column is used to create other custom columns, the new custom columns cannot have a footer.
Click Add column.
Note
The new column is added as the last column.
Example: Create a custom column for calculating product per guest (PPG)
Click the Show/Hide Columns button.
Click Add Column.
Give the column a name, for example, PPG.
From the Existing columns list, select Product Revenue.
In the New column calculation box, select /.
From the Existing columns list, select Production Hours.
Click Add Column.