CMiC - Forecasting
-
Preconstruction Project Status Report
Please use this link to access the Preconstruction Project Status Report How To documents.
-
Month End Forecasting Flowchart
-
Contract Forecasting Column & Highlighting Explanations
Contract Forecasting Column Explanations 1 Notes: A pencil and paper icon will show up in this column, if you have added a note to this line. 2 Attachments: A paper clip icon will show up in this column, if you have added an attachment to this line. 3 Freeze: Check the box in this column if you want to freeze the line and prevent any new transactions from updating it when you “Refresh” during the forecasting process. 4 Job Number 5 Phase Code 6 Phase Code Name 7 Category Code 8 Phase Type 9 Method: ("P" for Labor Productivity and "A" for Non Labor Productivity Items) A Current Cost Budget = Original Cost Budget + Posted Internal and External PCIs 1. The Current Cost Budget should be the estimated final cost at the end of the job, excluding unposted PCI Cost amounts in columns D and E (as adjusted in F) 2. If there are no unposted PCI Costs in columns B or C, the Current Cost Budget should be equal to, or greater than, the Spent/Committed Total 3. At the end of the job, the Current Cost Budget and the Spent/Committed Total should be the same for each line (since unposted PCIs will be 0, this will also equal the Cost Forecast) 4. NCTOs can be posted as frequently as needed to manage the Current Cost Budget and reduce the need for overrides to the Cost Forecast B Spent/Committed (Less Advance SCOs on Internal PCIs): Committed Amounts + Amounts Spent Outside Commitments - Any advanced SCOs issued to Subcontractors (Advanced SCOs occur when a SCO is issued prior to posting a PCI/OCO) **THIS IS NOT A BEST PRACTICE** C Spent/Committed Total: Committed Amounts + Amounts Spent Outside Commitments 10 Current Period Cost: Costs hitting your project only for the current month period D Unposted Internal PCI Cost Budget: Unposted Internal PCIs (NCTO, BC) (This column does not reflect any adjustments that may have been made in PCI Projections.) E Unposted External PCI Cost Budget: Unposted External PCIs (CTO, ALLOW, CONT, TRANSFER) (This column does not reflect any adjustments that may have been made in PCI Projections.) F Unposted Int & Ext PCI Cost Budget Adjusted: Equals columns D + E, unless adjustments have been made in PCI Projections. If so, those adjustments are reflected in this column. G Cost to Complete: 1. If Current Cost Budget (A) is higher than Spent/Committed Total (C) the calculation is: A - B = Cost to Complete 2. If Current Cost Budget (A) is lower than Spent/Committed Total (C) the calculation is: Cost to Complete = 0 (The system is going to assume you are done since you spent more money than you budgeted) 11 Cost Detail Pop Up: The magnifying glass is in this column that will allow you to open the Cost to Complete Detail Pop Up 12 Override Visual: A checkmark will appear in this box, if the Cost to Complete column N has been overridden. H Cost to Complete Unposted PCIs: This should equal the Unposted Int & Ext PCI Cost Budget (Adjusted) column F, unless there has been an Advanced SCO given. (NEVER best practice) I Cost Forecast: Calculation: Spent/Committed Total + Cost to Complete + Cost to Complete Unposted PCIs = Cost Forecast. (C+G+H) This should be looked at on a line by line basis and always reflect where you expect to be by the end of the project. 13 Override Visual: A checkmark will appear in this box, if the Cost Forecast in column R has been overridden J Current Revenue Budget = Original Revenue Budget + Posted External PCIs (CTO, ALLOW, CONT, TRANSFER) K Unposted PCI Revenue Budget: Unposted External PCIs (CTO,ALLOW,CONT, TRANSFER) L Unposted PCI revenue Budget Adjusted: Equals column K, unless adjustments have been made in PCI Projections. If so, those adjustments are reflected in this column. M Revenue Forecast: Columns J +L (Can be overridden) 14 Override Visual: A checkmark appears in this box, if the Revenue Forecast in column Q has been overridden. N Projected Gain/Loss: Columns M - I Contract Forecasting Highlighting Explanations Field Color Hover Text Cost to Complete (CTC) Yellow Cost to complete has detail lines Field Color Hover Text Cost to Complete (CTC) Red Cost to Complete Detail lines are not in sync with the Projected Cost Cost Forecast Orange Projected Cost exceeds the override from the previous forecast Cost Forecast Red The override from the previous stored forecast has been cleared Cost Forecast Yellow When the Spent/Committed Total amount is greater than the Current budget (Cost) amount and there isn't an override by the user Field Color Hover Text Cost Forecast Green When there is a previous period override for the line
-
Entering a Contract Forecast
Entering a Contract Forecast Note: Best Practice would be to complete your PCI Projection review first. CLICK HERE for the How To, although adjustments can be made in the Forecasting screen directly Note: CLICK HERE for Forecasting Tips/Tricks Note: CLICK HERE to navigate to the Forecasting Column & Highlighting Explanations How To STEP 1: Expand Budget & Cost Management STEP 2: Click Contract Forecasting STEP 3: Confirm the Contract (Should be the job # you are forecasting STEP 4: Confirm the right period (Only one (1) period will be open at a time in the system. if you are late with your forecast and the period has been closed, contact your Financial Manager for resolution.) STEP 5: Click Go STEP 6: Click Clear Overrides (You always want to start with a fresh slate so that the calculations are current, Best Practice is to clear overrides at the beginning if each period) STEP 7: Click All STEP 8: Click Yes STEP 9: Click Refresh (This will bring in all new data) STEP 10: Click All STEP 11: Click Yes STEP 12: Review and complete the updates needed to reflect what is going on on the project Note: Always forecast as if you were not going to be on the project tomorrow. Leave the next person a full history via the PCIs Note: Remember you have two budgets to forecast, What is it going to cost you? & What can you get paid for by the owner? If it is going to COST you something but you can't get that money from the owner, that is an NCTO with a full explanation. That will drive your Cost budget up and tell the full truth of the project. Note: Best practice is to never have spent costs higher than your Cost budget, without a PCI explaining the history Once you have completed your Review and Updates STEP 13: Click Forecast Comments Note: As of 7/3/2023 the Schedule Substantial Complete is a required field. Note: As of 10/3/024 the Planned % Completed has been added, make sure to get this % from your scheduler and enter each month STEP 14: Run your PSR report and review STEP 15: Once you are happy with your PSR, go back to Contract Forecasting and click Store Forecast Note: Your last period data on your PSR pulls from the Stored Forecast for the next month so make sure you are clicking this button or your Last Period Data will not be correct. STEP 16: Click Ok
-
Using PCI Projections
Using PCI Projections in CMiC STEP 1: Click the Budget & Cost Management folder. STEP 2: Click the PCI Projection link. Understanding what everything does... PCI Projection Column Explanations: A Selection Column This columns works with the Edit Risk action button to allow you to make the same change to multiple rows B Freeze Check the box in this column if you want to freeze the line and prevent any new transactions from updating it when you “Refresh” during the forecasting process. C Change Order Type PCI Type (NCTO, CTO, BC etc) D Status PCI Status (Pending – Proceeding, Submitted – Proceeding, Approved, Denied etc) E PCI # PCI Number F PCI Description Short description of the PCI NOTE: If you know that you are going to need to make an adjustment on a PCI, put some kind of delineator at the beginning of the desc. (Ex. *) so that when you go to do your PCI Projections you now exactly which ones need to be updated. G Phase Line Item Description Description from this line in the PCI Detail H Company If a Vendor/Subcontract is assigned in the PCI Detail, the company will be listed here I Phase Code Phase code J Category Code Category code K Unposted PCI Cost Budget Cost Budget amount from the PCI Detail for only unposted PCIs L Cost Budget % at Risk Can be overridden. 0% is default and we expect to spend all of the cost Budget Amount. 50% would mean we expect to spend half the cost Budget amount. 100% would mean we expect not to spend anything on this PCI. M Adjusted Unposted PCI Cost Budget Can be overridden. The amount we expect to spend on this PCI. A checkmark will appear when overridden. N Spent/Committed If you have issued an Advanced SCO, it will show here. O % Complete Actual Cost / Projected Cost Forecast Incl. Pending PCI x 100 P Cost to Complete Should equal the Adjusted Unposted PCI Cost Budget column UNLESS you have issued an Advanced SCO and then it will calculate the different (L-M =N) Q Projected Final Cost Projected Final Cost = Spent/Committed + Cost to Complete Overriding Projected Final Cost will back calculate: Cost To Complete = Projected Final Cost – Spent/Committed % Complete = (Spent/Committed / Projected Final Cost) x 100 This column can be updated, as required. R Unposted PCI Revenue Budget Revenue Budget Amount from the PCI Detail for only unposted PCIs S Revenue Budget % at Risk Can be overridden. 0% is default and we expect to get full recovery from the Owner for the Revenue Budget Amount. 50% would mean we expect the Owner to give us half the Revenue Budget amount. 100% would mean we expect no recovery from the Owner on this PCI. T Adjusted Unposted PCI Revenue Budget Can be overridden. The amount we expect to be paid from the Owner on this PCI. A checkmark will appear when overridden. U Gain/Loss Equals Column R (Adjusted Unposted PCI Revenue Budget) – Column M (Adjusted Unposted PCI Cost Budget) Clear Overrides Button: If you want to clear ANY of the overrides made, click the Clear Overrides button. If you only want specific overrides cleared, check the boxes for those items, then click Clear Overrides, and select "Current" If you want all the overrides cleared, click the All button Freezing Lines: To freeze lines, click in the box under the freeze column for the line you would like to freeze. Use Freeze under the following conditions: Freeze will keep your cost and revenue forecast numbers in place even if the PCIs are updated/changed. Frozen lies should be verified EVERY MONTH. Sorting and Filtering: Sort by clicking on the column title in the header of the PCI Projection screen. Filter by clicking on the filter icon at the bottom of the screen. Select the column to filter by, set the filter and click add and then click OK Showing more rows Show more rows in the screen by clicking the down arrow to the left of Per Page and choose how many rows you want to see Now that you understand what everything does, lets Forecast the Risk STEP 3: Confirm the Contract Number is displaying the correct job Number. If incorrect, confirm you are working in the correct project in the tree view on the left. STEP 4:: Confirm you are in the correct Period. Only One (1) period will be open at a time in the system. if you are late with your forecast and the period has been closed, contact your Financial Manager for resolution. STEP 5:: Adjust your screen to allow all columns to display. STEP 6: Click the Refresh button to bring in the latest transactions and ensure all the most current costs are being shown. STEP 7: In any field in Blue font, it can be clicked on to drill down to see more detail. In the example above, the PCI # column will drill down to the PCI record. Modifications can be made to the PCIs from here. STEP 8: Adjust the PCI values for risk follow the below steps: a. Override with the amount you think it will really cost you b. Override with the amount you think you will be able to get from the owner. NOTE: If just a Pricing Exercise from the owner, then both would be 0.00 until the owner decided what to do. If the owner decides not to move forward you can cancel the PCI, but still have all the information in case they change their minds. STEP 9: Click Save STEP 10: Go to your Contract Forecasting Screen and Refresh
-
"Overrides Only" & "Current Activity Only" New Functionality
Contract Forecasting Additional Filtering for "Overrides Only" & "Current Activity Only" "Overrides Only" Note: If you click Overrides Only + Go, it will allow you to filter to only the rows that have been overridden (the check mark is visible) "Current Activity Only" Note: When checked, will show only bill codes where some activity is performed in that period (e.g. where some cost, commitment and changes transactions are posted).
-
Navigating the Job Forecast Statement (JFS)
Navigating the Job Forecast Statement Note: The Job Forecast Statement is intended to be used for the Month End Process and Forecasting only. Use the Cost Status Query for details on Job Cost and Commitments. STEP 1: Always make sure you have gone into Contract Forecasting and clicked Go > Refresh All before you try to print your PSR STEP 2: Expand Reports STEP 3: Expand Budget & Cost Reports STEP 4: Expand Job Costing STEP 5: Click Job Forecast Stmt - by Cat, Phase, Type STEP 6: Enter the information for the project you want to run the report for Note: If you are using a Controlling Project/SubJob scenario make sure to include your SubJobs in your report STEP 7: Click Run Report Job Forecast Statement Columns: A Company Number and Company Name B Report Name and Forecast Period/Month End C Job Number and Job Name D No. of pages of the report E Date the report was Printed F Time the report was Printed G Cost Section H Revenue Section I Phase Code J Phase Name K Current Cost Budget Original Cost Budget + any Posted PCIs L Spent This Period Costs to Job during the period of the report M Spent To Date Total Cost to the Job since inception N Spent/Committed Committed + Spent out of commitment O Cost to Cmplt Inc. PCIs Cost to Complete as calculated or overridden manually in field or adjusted via the Pop up + Unposted PCIs P Cost Forecast Cost Forecast as calculated or overridden in Contract Forecasting. This should be the projected final cost to complete the project including all anticipated change order work. Q Current Revenue Budget Current Revenue Budget (Original Revenue Budget + Change Orders to date), i.e. Current Contract Amount R Anticipated Cos Anticipated Change Orders from the Owner to make the Revenue Forecast (Revenue Forecast – Current Revenue Budget) S Revenue Forecast Revenue Forecast as calculated or overridden in Contract Forecasting. This should be the projected final contract value with the Owner at the end of the project including all anticipated change orders. T Projected Gain/Loss Revenue Forecast – Cost Forecast U One Month Variance Difference between last month and this month V Category Totals Bottom of Report W Fee Category Total X Projected Final Fee on the Job This will calculate all the way down the Projected Gain/Loss (including the fee line) to give you your current fee on the project.
-
Navigating the Project Status Report (PSR)
Navigating the Project Status Report (PSR) Note: This report includes a series of smaller reports with project data from various areas of CMiC to create a comprehensive overview of the project. This report is used on a monthly basis to communicate to Division Management, Corporate Management and Swinerton business partners the status of each project. STEP 1: Always make sure you have gone into Contract Forecasting and clicked Go > Refresh All before you try to print your PSR STEP 2: Expand Reports STEP 3: Expand Budget & Cost Reports STEP 4: Expand Job Costing STEP 5: Click Project Status Report - PM STEP 6: Enter the information for the project you want to run the PSR for Note: No need to change the Current Period/Prior Period unless you are specifically running a report for a prior period STEP 7: Click Run Report BOX 1 - JOB FORECAST STATEMENT SUMMARY Column Details (from left to right): A Name: Phases/Categories are summarized into Types: Labor, Rentals, Materials, Subcontracts, Admin and Other, Insurance Taxes and Bonds, Allowance, Contingency, Buyout, Non‐Reimbursables, Joint Venture, Claim Costs, Claim Recovery, Contract Fee, Adjustments. B Spent This period: Costs posted to the job during the month the report is for C Spent To Date: Costs posted to the job since inception D Spent/Committed Total: The higher of Spent or Committed plus Spent outside of Commitment E Cost to Cmplt Inc. PCIs Cost to Complete as calculated or overridden manually in field or adjusted via the Pop up + Unposted PCIs F Cost Forecast: Cost Forecast as calculated or overridden in Contract Forecasting. This should be the projected final cost to complete the project including all anticipated change order work. G Current Revenue Budget: Current Contract value with the Owner. H Anticipated COs: Revenue Forecast – Current Revenue Budget = Anticipated COs. This is a calculation that reflects any revenue forecast reductions that were made in PCI Projections, or any revenue forecast overrides that were made in Contract Forecasting. If such adjustments have been made, this number will be different than the Total External PCIs recorded in Box 2, which is the amount the Owner sees on the PCI log. I Revenue Forecast: Revenue Forecast as calculated or overridden in Contract Forecasting. This should be the projected final contract value with the Owner at the end of the project including all anticipated change orders. J Projected Gain/Loss: Revenue Forecast – Cost Forecast = Projected Gain/Loss. The difference between what it is going to Cost to do the work and what the Owner is going to pay us. The FINAL Fee when the job is closed. K One Month Variance: Prior Month Projected Gain/Loss – This Month Projected Gain/Loss = One Month Variance L % Cost Complete: Spent To Date/Cost Forecast Row Details (from Top to Bottom): M Contract Fee: Should exist on all jobs (Revenue Budget only) and is Phase/Category 999999‐79999. N Adjustments: Combines PM Cost and Revenue Adjustments and Financial Manager accruals. Refer to “Forecasting Philosophy” handout for details on when and how to use Adjustments. O Total: Job Totals for each Column. Total under Projected Gain/Loss is your PM Projected Fee. P General Conditions: Total of Phases and Categories on the job assigned to Phase Type “GC”, (value is already included in above.) Q Self-Performed Work Total of Phases and Categories on the job assigned to the following Phase Types (CARP, CONC,DRYW,SOLA,SPGC or SPW(value is already included in above.) BOX 2 - CHANGE ORDER STATUS - EXTERNAL PCIs Note: Data for this report is from the External (CTO, ALLOWANCE & CONTINGENCY types) & TRANSFER Potential Change Items and Owner Change Orders. Statement Summary, if any PCI forecasts have been adjusted in PCI Projections, or any Revenue Forecast amounts have been overridden in Contract Forecasting. Use comment 2 if amounts are not close. Column Details (from left to right): A Current: Data as of the period entered in “Current Year and Current Period” parameters when running report B Last period: Data as of the period entered in “Prior Year and Prior Period” parameters when running report C No.: Number of PCIs in each Status D Current Amount: Dollar value from the “Revenue Amount” column of the PCIs in each Status E Days: Number of days from the “Estimated Days Impact” field in the PCI header for all the PCIs in each Status Row Details: F Original Contract: Original Contract value with the Owner as shown in the Owner Change Order module. G Posted OCOs: All OCOs that have been posted. H Current Contract: Original Contract + Posted OCOs I Approved (Unposted) All PCIs with a Status of "Approved" but have not been Posted J Submitted All External PCIs with a Status of “Submitted” – Proceeding or Not Proceeding. K Pending / Resubmit: All External PCIs with a Status of "Pending" - Proceeding or Not Proceeding All External PCIs with a Status of “Revise and Resubmit” – Proceeding or Not Proceeding. L Denied: All External PCIs with a Status of “Denied” ‐ Proceeding or Not Proceeding. Denied status should never be used for Cancelled PCIs. Use Comment 2 if Denied PCIs exist. M Total External PCI’s: Total of Submitted, Revise & Resubmit, Pending and Denied External PCIs. Use Comment 2 if this amount is less than the Total Anticipated CO’s in report 1 Job Forecast Statement Summary. N Projected Final: Current Contract + Total External PCIs. This amount should equal the total the Owner sees on the PCI Log. It may not match the total of the Revenue Forecast Column of Report 1 Job Forecast O Self Perform Unposted: Total of all Self Perform projects Unposted External PCI's BOX 3 - EXTERNAL PCIs PROCEEDING WITHOUT OCO Note: Data for this report is from the External (CHANGE TO OWNER, ALLOWANCE & CONTINGENCY types) & TRANSFER Potential Change Items and Subcontract Change Orders. Column Details (from left to right): A Proceeding: External PCIs with the status “Proceeding” not included in a posted OCO. B No.: Number of External PCIs with the status “Proceeding” not included in a posted OCO. C Current Amount: Dollar value of External PCIs with the status “Proceeding” not included in a posted OCO. Amount Proceeding should not exceed amount Owner Directed to Proceed. Use Comment 3 if condition exists. D Owner Direction: Includes data from the “Owner Direction” field in the header of External PCIs. E Proceed: Dollar value of External PCIs not included in a posted OCO with the Owner Direction of Proceed. F Under Protest: Dollar value of External PCIs not included in a posted OCO with the Owner Direction of Proceed Under Protest. Use Comment 3 if amounts exist in Under Protest. G Advanced SCO Issued: Subcontract Change Orders issued against External PCIs not in a posted OCO. H No.: Number of Subcontract Change Orders issued against External PCIs not in a posted OCO. I Amount : Dollar Value of Subcontract Change Orders issued against External PCIs not in a posted OCO. Use Comment 3 if Advanced SCOs exist. Row Details: J Submitted: External PCIs with the status “Submitted” for each column. K Revise & Resubmit: External PCIs with the status “Revise & Resubmit” for each column. L Pending: External PCIs with the status “Pending” for each column. M Denied: External PCIs with the status “Denied” for each column. N Total External PCI’s: Total External PCIs for each column. BOX 4 - UNPOSTED INTERNAL PCIs Note: Data for this report is from the Internal (NO CHANGE TO OWNER, BACKCHARGE types) Potential Change Items. Column Details (from left to right): A Current: Data as of the period entered in “Current Year and Current Period” parameters when running report B Last period: Data as of the period entered in “Prior Year and Prior Period” parameters when running report C No.: Number of Internal PCIs not Posted. D Current Amount: Dollar value of Internal PCIs not Posted. Row Details: E NCTO’s: Unposted Internal PCIs with Type No Change To Owner. F BC’s: Unposted Internal PCIs with Type Backcharge. Use Comment 4 if large number of BCs exist. G Total Internal PCI’s: NCTO’s + BC’s. Total Unposted Internal PCIs. BOX 5 - BILLINGS Column Details (from left to right): A Current: Data as of the period entered in “Current Year and Current Period” parameters when running report B Last period: Data as of the period entered in “Prior Year and Prior Period” parameters when running report Row Details: C Gross Billing: Total amount billed to the Owner on the job. D Gross Cost: Total Cost on the job. Should match the Total of the Spent to Date Column in Report 1 Job Forecast Statement Summary. E Earned Fee: (Gross Cost/Total Cost Forecast in Report 1) * Total Gain/Loss in Report 1. If projecting a loss, this will equal the Total Gain/Loss in Report 1. Since the Cost Forecast includes unposted PCIs, the Total Gain/Loss should include the potential Fee on those unposted PCIs, or our Earned Fee will be understated. (This is a big difference from our previous fee projection philosophy.) F Over (Under) Billing: Gross Billing – (Gross Cost + Earned Fee). Use Comment 5 if under billed or significantly over billed. G % Est Fnl Cont Billed: Gross Billing/Total Revenue Forecast in Report 1 Job Forecast Statement Summary. % Billed of the estimated final contract value with the Owner. H Retention Held: Total retention held by the Owner. BOX 6 - RECEIVABLES Note: Data for this report is from the A/R Aged Report (See below for screenshot of where this report can be found on your treeview) Column Details (from left to right): A Current: Data as of the period entered in “Current Year and Current Period” parameters when running report B Last period: Data as of the period entered in “Prior Year and Prior Period” parameters when running report Row Details: C Total Receivables: Total Billed to the Owner not paid. D Current: Total Billed to the Owner and outstanding for 30 days or less. E Over 30: Total Billed to the Owner and outstanding for over 30 days, and up to 60 days. Use Comment 6. F Over 60: Total Billed to the Owner and outstanding for over 60 days, and up to 90 days. Use Comment 6. G Over 90: Total Billed to the Owner and outstanding for over 90 days. Use Comment 6. BOX 7 - FEE SUMMARY Column Details (from left to right): A Current: Data as of the period entered in “Current Year and Current Period” parameters when running report B Last period: Data as of the period entered in “Prior Year and Prior Period” parameters when running report NOTE: The "History" for the Last Period is taken after the Company WIP has been completed by all Financial Mangers. C % C: Percent Cost Complete - Calculation = Spent to Date / Cost Forecast D %RF Percent Return of Fee - Calculation = PM Forecasted Fee / Current Contract Value Row Details: E Main Project Forecasted Fee: Total from the Projected Gain/Loss Column of Box 1 Fee as reported by the Project Manager in Contract Forecasting. F All Self Perform Project Forecasted Fee: As each Self Perform project has its Contract Forecast updated, it will start to pull into the Main Job PSR with the same column calculations as the Main Job. NOTE: If the Current amount next to a Self Perform project is blank, please reach out to that PM to complete the forecast. NOTE: If the Self Perform project is closed, it will pull the final calculation of Revenue - Cost NOTE: For Self Perform projects with other companies (SAK, MD Builders, Timberlab) see below for what will/will not show on your PSR due to Union rules G Total Swinerton Forecasted Fee: Total of Main Project + all Self Perform project Forecasted Fee H Total Current Contract Fee Total of Main Project + all Self Perform Contract Fee I Total Variance: Total of Main Project + all Self Perform - Calculation = Forecasted Fee - Contract Fee. Use Comment 7 if any variance J Total Original Contract Fee: Total of Main Project + all Self Perform - Original Fee based on Original Contract K Shared Savings From Job Setup / Project Maint. OM User-Defined Fields L Savings Split (%) From Job Setup / Project Maint. OM User-Defined Fields BOX 8 - PROJECT MANAGEMENT Note: Data for this report is from the Project Management modules: Submittals, RFIs and Daily Journals (There should only ever be 7 DJs open/pending at a time). Note: Use Comment 8 in Forecast Comments if an explanation is warranted regarding risks related to any values reported. Column Details (from left to right): A Current: Data as of the period entered in “Current Year and Current Period” parameters when running report B Last period: Data as of the period entered in “Prior Year and Prior Period” parameters when running report Row Details: C Not Yet Submitted (Submittals): Number of Submittals with the status of: Anticipated. D Open (Submittals): Number of Submittals with the status of: Open, Pending Design Change, Received, Revise and Resubmit, Submitted. E Rejected (Submittals): Number of Submittals with the status of: Rejected, Submit Specified Item. F Closed (Submittals): Number of Submittals with the status of: Approved, Approved as Noted, Closed, Make Corrections Noted, For Information Purposes, No Exceptions Taken, Reviewed, Voided. G Total Open (RFIs) Number of RFIs not closed or voided. H Total Overdue (RFIs): Number of RFIs where the date due is less than the period end date. I Total (Daily Journals): Total number of Daily Journals on the project. J Open (Daily Journals): Number of Daily Journals not yet Submitted.There should only ever be 7 of these.If there are more, please ask that they get submitted BOX 9 - SCHEDULE (Updated 10/30/2024) to include Planned % Complete Note: Data for this report is mostly pulling from the Forecast Comments button/pop‐up entered in Contract Forecasting to be completed monthly by the Project Manager. The Contract LDs and LSs Cost/Day is coming from the OM UDF Tab in Project Maintenance (same area as General & Default) Column Details (from left to right): A Completion Date (Current): Date as entered in Forecast Comments for the current period. B Duration in Mos (Current): Number of months from Contract Start Date entered in Project Maintenance General Tab. C % Complete (Current): % Complete based on the period end date and the Current Contract Completion date. D Completion Date (Last Period): Date as entered in Forecast Comments for the prior period. Row Details: E Schedule ID: Schedule ID for the monthly schedule update as entered in Forecast Comments. F Data Date: The data date represents the line in the sand between what is actual and what remains G Original Contract: Original Contract Completion date entered in Project Maintenance General Tab. H Current Contract: Current Contract Completion date as reflected in the Owner Change Order module. I Substantial Completion: Substantial Completion date for the monthly schedule update as entered in Forecast Commen s. J Final Completion: Final Completion date for the monthly schedule update as entered in Forecast Comments. K Date Sent to Owner: Date the monthly schedule update was provided to the Owner. L GCs Projected Through: Date General Conditions are projected through as entered in Forecast Comments. Use Comment 9 if earlier than Final Completion date. M Schedule Delay, PCIs: If Monthly schedule update reflects a delay to the project schedule, PCI numbers where the delay is being tracked as entered in Forecast Comments. N Contract LDs: Does your project have Liquidated Damages written into the Prime Contract (Yes/No) O LDs Cost/Day: What is the cost implication by day for those Liquidated Damages $ P Planned % Complete: What is the Planned % Complete as per your current schedule BOX 10 - SAFETY Note: Data for this report is from the Forecast Comments button/pop‐up entered in Contract Forecasting to be completed monthly by the Project Manager. Column Details (from left to right): A Current: Data as of the period entered in “Current Year and Current Period” parameters when running report B Last period: Data as of the period entered in “Prior Year and Prior Period” parameters when running report Row Details: C JHA’s Prepared: Total number of Job Hazard Analyses prepared (current month). D Safety Meetings Held: Total number of Safety Meetings held (current month). E Safety Orientations Held: Total number of Safety Orientations held (current month). F Pre‐Task Plans Prepared: Total number of Pre‐Task Plans prepared (current month). G Safety Audits Performed: Total number of Safety Audits performed (current month). H Safety Near Misses: Total number of Safety Near Misses (current month). I First Aid Cases: Total number of First Aid Cases (current month). J Recordable Incidents: Total number of Recordable Incidents (current month). K Lost Time Incidents: Total number of Lost Time Incidents (current month). BOX 11 - QUALITY Note: Data for this report is from the Forecast Comments button/pop‐up entered in Contract Forecasting to be completed monthly by the Project Manager. Column Details (from left to right): A Current: Data as of the period entered in “Current Year and Current Period” parameters when running report B Last period: Data as of the period entered in “Prior Year and Prior Period” parameters when running report Row Details: C Pre‐installation Meetings Held: Total Number of Pre‐Installation Meetings held for the entire project, not just the single month. D 1st Work inspections Held: Total Number of First Work Inspections held for the entire project, not just the single month. E Total Deficiencies: Total Number of Quality Deficiencies identified for the entire project, not just the single month. F Deficiencies Still Open: Number of unresolved Quality Deficiencies for the entire project, not just the single month. G Building Envelope Review By: Party who performed the Building Envelope review. BOX 12 - CASH FLOW Note: The data in this box is exactly the same as the separate report called "Job Cash Flow Report" which can be run by a Project Manager at any time of the month and found on the CMiC treeview under Reports/Job Costing/Job Cash Flow Report. Starting 1/16/2023, the calculations in this box will add the Main job and all the Self Perform jobs numbers together. The new Job Cash Flow Report will have all jobs on it so you are not needing to run multiple reports to validate. Column Details (from left to right): A Last Bill Date: Last date we billed the Owner B Last Receipt Date: Last date we received payment from the Owner C JTD Billing: Job to date amount billed to the Owner D JTD Cost: Job to date cost that has been charged to the job E Current Receivables: Billing amount outstanding with the Owner F Current Payables: Payables on the job (amount we currently owe to Subs, Vendors, etc) G Retention Receivables: Retention held by the Owner H Retention Payables: Retention held on our Subcontractors I Cash In: Amount we have been paid to date by the Owner (less current receivables and retention held) J Cash Out: Amount we have paid out to Subs, Vendors, etc (less current payables and retention held) K Net Cash In/Out: Cash In less Cash Out. Net cash flow on the job. COMMENTS BOX Note: Data for this report is from the Forecast Comments button/pop‐up entered in Contract Forecasting. Note: Comments are required to explain any abnormalities or address any potential risks reflected in the information reported in the respective sections. Comments can be up to 100 characters per field. 1. Job Forecast Statement Summary 2. Change Order Status – External PCIs 3. External PCIs Proceeding without OCO 4. Unposted Internal PCIs 5. Billings 6. Receivables 7. Fee Summary 8. Project Management 9. Schedule 10. Safety 11. Quality 12. Cash Flow
-
Contract Forecasting Screen Navigation - Tips & Tricks
Contract Forecasting Screen Navigation - Tips & Tricks Adjusting your screen/columns STEP 1: Click ellipsis in browser STEP 2: Adjust Zoom until you can see all columns STEP 3: You can adjust the size of your columns STEP 4: You can expand the screen over the treeview Any number in blue font, you can click on and drill down to the items that make up that number Note: If you drill down on one of the Unposted PCI columns, it will take you to the PCI Projection screen where you can make adjustments to Risk. It will also allow you to drill down further into the PCI itself Using the Freeze Functionality Note: Freeze will keep your Cost and Revenue Forecast numbers in place even if additional costs, commitments or PCIs are created/posted that would increase or decrease the Forecast using the system default calculation. Freeze is risky as additional cost could hit a frozen line and not be included in the forecast. Freeze should be used sparingly. Frozen lines should be verified EVERY MONTH. Note: CMiC default calculation for the Cost Forecast is the higher of the Current Cost Budget or Spent/Committed Total plus Adjusted PCIs. • If your override is more than what the system would calculate, your override will remain month to month without having to freeze. • If your override is less than what the system would calculate, your override will not remain month to month. The system default calculation will replace your override next month unless the line is frozen. Adding a Note STEP 1: Click on the desired line item STEP 2: Click the Notes button STEP 3: Click Add Notes STEP 4: Enter Subject STEP 5: Enter Note STEP 6: Click Submit Note: You can then decide later to close the note, edit the note or delete the note Adding an Attachment STEP 1: Click on the desired line item STEP 2: Click the Attachments button STEP 3: Click Upload Multiple Note: Upload New works if the document is already in Document Management, it does not take you out to your computer STEP 4: Choose your file STEP 5: Click Upload STEP 6: Click Proceed STEP 5: Click Save Filtering Note: Filtering allows you to review your forecast in smaller sections, the screenshot below gives you a couple of examples STEP 1: Click Filter icon at bottom of screen STEP 2: Choose what you want to filter by STEP 3: Click Add STEP 4: Choose the specifics STEP 5: Click Ok
-
Cost To Complete Pop up Window
Cost To Complete Pop up Window OVERVIEW On the Contract Forecasting screen, to the right of Column G "Cost To Complete" there is a magnifying glass. When clicked, this magnifying glass opens a pop-up window called Cost Detail which allows you to enter the logic for the override such as remaining quantity or time with rates. Use this function if you are not yet ready to reallocate funding to or from the line item. [insert photo of column g and the adjacent magnifying glass] BENEFITS In lieu of a basic override of the Cost to Complete column, this pop-up window contains logic that can be updated month to month and WILL NOT be cleared when the Clear Overrides button is clicked (best practice at the beginning of each reporting period). EXAMPLE 1: Productivity Budget Line Item (Budget Method P - 71111) (See excel spreadsheet attached to see how the formulas work) EXAMPLE 2: Non-Productivity Budget Line Item (Budget Method A)