 |  |
Back to Reports |
Print Friendly |
Contracts, Summary P&L (#201) |
Why:
You need a profit and loss statement on a revenue contract basis
Focus:
Focus of Report is to provide a summary profit and loss statement on a revenue contract basis. Because a revenue contract may cover multiple Blocks, a the P&L for a revenue contract may represent the consolidated P&L for a group of blocks.
Selection Window:
The selection window allows you to filter the report by:
- Date Range: You can either select a pay period, or you can simply enter the start and end date directly into the selection criteria window. The Period selection is merely a short-cut for entering a date range, so you can always edit the start and end dates to be any date you choose. For example, you can pick a period defined as 8/1/2004 to 8/12/2004, and then extend the end date by three days to 8/15/2004. If you leave the end time blank, the program will assume you want the entire day for the end date. In the example below, the start date/time is 8/1/2004 00:00:00 (a blank is assumed to be time 00:00:00) and the end date/time is 8/15/2004 00:00:00. Because the end date time is blank (or 00:00:00), the program assumes you want the whole day of the 15th and makes the end date/time 8/16/2004 00:00:00. In the selection query, the program returns records whose start date/time is greater than OR equal to the start/date time and strictly less than the end date/time.
- Contract: You can select any or all of your revenue contracts.
- The "Fully Loaded Employee Cost" option allows you to run the report using your loaded payroll cost instead of your direct payroll cost (the default).
Detailed Description:
The report will show a P&L for each block and then a summary that consolidates the selected blocks into one P&L.
Key Notes:
- Employee, Vendor and Invoice pay calculators must be run for the report
- All Costs included: (1) hourly payroll -- hourly, tree count & tree volume -- costs (employees and contractors), (2) pay based on production (both employees and contractors), (3) pay based on load slips (employees and contractors), and (4) miscellaneous expenses
- Revenue for Loads is based on the Loadslip_Revenue table (not the Invoice Details Table). Depending on the software configuration, load revenue may be (1) entered manually as settlements are received or (2) calculated when invoices are processed. If option (1) is in effect, revenue must be entered for each load for it to appear in the report, otherwise it will be reported as zero. If option (2) is in effect, the invoice calculator must be run in order for load revenue to appear in this report. Revenue for loads is based on the date/time out for each load.
- Revenue for other contracts (those based on hours, production or fixed fee), is based on Invoice Details Table. Revenue in this table is recorded on the day after the ending period for the invoice. That is, if you have a pay period that ends on July 17th, Revenue for these contracts is recognized as of July 18th.
- The actual delivered volume is calculated by load slips delivered over the date range selected for the block
- Equipment cost is based on the equipment standard cost entered for each unit (Maintenance time is NOT charged out at standard cost).
- Tree counts are not necessary
- When the "Fully Loaded Employee Cost" option is selected, employee pay load rates are applied; for employees paid on a load-by-load basis, the overall basic setup factor is applied to arrive at a "loaded" employee cost.
Report:
Example One:
Example Report 1
The top part of the report shows your revenue from the block based on the revenue rates set up for each revenue contract. The revenue is calculated for the loads when the “Invoice Calculator” is run for the period that encompasses the loads you have delivered. In the example, we see revenue from the "RV-W FRASER" contract. Beneath the revenue portion, any mill advances that are outstanding (not collected) are listed -- in this example, there is an advance on the RV-W FRASER contract for $3,200.
The second part of the report shows the hourly payroll for your employees, by activity. The cost in the report is $9,788.28 (line 21). This cost is based on your time slips and the hourly rates assigned to your employees. This cost is your direct payroll cost; if the option "Fully Loaded Employee Cost" option had been selected, the payroll costs would be at your fully loaded payroll cost.
The third part shows the cost of using your own equipment, by activity. The cost in the report is $24,337.00 (line 32). This cost is based on the hours reported on your time slips for each piece of equipment multiplied by the standard cost rates assigned to your equipment units.
The fourth part of the report shows payroll for your employees, by activity, where pay is based on production activities (not hours), such as by day or kilometer. The cost in the report is $200.00 (line 36). This cost is based on your production activity slips and the piece rates assigned to your employees. This cost is your direct payroll cost; if the option "Fully Loaded Employee Cost" option had been selected, the payroll costs would be at your fully loaded payroll cost.
The fifth part of the report shows payroll for your employees where pay is based on load slips, such as by tons, tonnes, MBF, M3. The cost in the report is $273.08 (line 40). This cost is based on your load slips and the contract rates assigned to your employees. This cost is your direct payroll cost; if the option "Fully Loaded Employee Cost" option had been selected, the payroll costs would be at your fully loaded payroll cost.
The sixth part shows the internal cost of using your own trucks. The cost in the report is $4,038.64 (line 44). This cost is based on the weight reported on your time slips for each piece of truck multiplied by the standard cost rates assigned to your trucks.
The next section refers to your subcontractor costs:
The first part of the subcontractor section shows payments to contractors where pay is based on load slips, such as by tons, tonnes, MBF, M3. The cost in the report is $7,624.32 (line 49).
The second part of the subcontractor section shows payments to contractors where pay is based on hours. The cost in the report is $11,042.25 (line 56). This cost is based on your contractor time slips and the hourly rates assigned to your contractors. This part will also include pay to contractors based on tree counts or tree volumes and pay for rental equipment.
The third part of the subcontractor section shows payments to contractors where pay is based on production activity, such as by day or miles or kilometers. In the example report, there are no costs of this type and so this detail has been suppressed. Costs reported here are based on your contractor production activity slips and the piece rates assigned to your contractors.
The next section refers to your miscellaneous expenses. The amounts included here include expenses paid to third-party vendors and those reimbursed to your own employees. In the example report, there are no costs of this type and so this detail has been suppressed.
Total Cost ($57,303.57) is the sum of all the expenses (lines 21, 32, 36, 40, 44, 49, and 56).
Total Profit is Total Revenue less Total Cost $56,216.89 - $57,303.57 = -$1,086.68
Panel 2
Example Two:
Example Report 2
Example report 2 is the same as Report 1, except that the "Loaded Payroll Cost" option has been selected. In this case all the employee payroll cost numbers will reflect the loaded payroll cost rates -- not the direct payroll cost rates.
See lines 21, 36, and 40.
Example Report 1
Panel 2
