CMiC - Budget
-
Updating Self-Perform Budget Units/Hours
Updating Self-Perform Budget Units/Hours Updating your Self-Perform Budget's Units/Hours after completing the Update Budget process and/or when it has been locked down by Finance. Here is an example of some Phase Codes that need Units/Hours/Rates added... 1. Create a No Change To Owner (NCTO) PCI 2. You should only need to fill out the required fields in the PCI Header section 3. If desired, you can change the PCI number 4. Add your Description 5. Uncheck Auto Calculate Markups (not required) 6. In the PCI Detail section, click Show Rates 7. Add the Phase Code, Category Code 8. Add the Quantities and Rate(s) a) Labor Productivity project, the Phase Quantity (Output) is for only. It is the total amount to be completed by the end of the project. (Ex.: 2400 CY of concrete) b) Labor Productivity project, then the Quantity (Input) would be the hours it was going to take to complete and the Rate would be the budgeted amount per hour 9. Type in 0 or 0.00 in the Cost Budget Amount field 10. Click Save NOTE: PLEASE DO NOT POST YOUR PCI UNTIL YOU MAKE SURE THE INFORMATION YOU ENTERED IS CALCULATING CORRECTLY IN YOUR FORECAST, REPORTS ETC... - a posted PCI, cannot be unposted
-
Formatting the Drywall Project Budget Import Spreadsheet for CMiC Bid Items
Note: Project budgets are imported from an Excel template into CMiC via the bid items module. There are several formatted spreadsheets available to use. The spreadsheets are available on SwinNet on the Technology > CMiC Templates, scroll to the bottom of the page to Important Documents Note: Managing your Labor Productivity starts with setting up your Budget Import Spreadsheet correctly. Way before it even gets into CMiC STEP 1: Select the Company Code STEP 2: Change the Job Number to the project you are working on STEP 3: Enter the Retainage Percentage (%). This value (normally 10%) applies to all line items except Fee STEP 4: Click the Save My Spreadsheet button. (This will save the document to your desktop. DO NOT DO FILE/SAVE AS, it will break the macro and your budget will NOT import) STEP 5: Double check that the file name changed to include your job # and today's date. (If the file name looks like this: Budget Import Spreadsheet - - 1-1-2018, STOP 🛑 > go back to SwinNet and open a new template, the macro has been broken.) STEP 6: Search up a Phase Codes needed for this project and type "Y" in column A to select that phase code. Each row will turn Yellow when selected 6A – Start with the Work Detail filter to limit the number of rows showing (e.g. Exterior, Interior or Misc). Because many Drywall jobs have different breakdown for Exterior (by Elevation) and Interior (by Levels), you may want to select the Exterior and Interior codes separately. 6B – Use the Scope filter to reduce the number of lines to only the scope you need. 6C – Use the Level filter to limit the number of rows showing to just the levels of your building. • For smaller jobs that don’t require break down codes by level, select only the “All” option to hide all other Levels. 6D – Use the Area/Elevation filter if you are separating your budget by Area or Elevation in lieu of Level. • If you intend to break the codes by Areas (e.g. Area A and Area B), then choose the Areas you need. • If you intend to break the codes by Elevations (e.g. North, South, East, West), then choose the Elevations you need. • If you don’t intend to break the codes by Area or Elevation, choose only the “All” option to hide all Areas and Elevations. Note: Once all the phases are selected, filter the spreadsheet to only show "Y"s using the down arrow in cell A1 Note: You can navigate to the Data-Tab and click on the “clear” button to reset all the filters. STEP 7: Enter a Category Code for each selected Phase Code Note: If a Phase Code has multiple category codes associated, each must be entered as a separate line. Using Column U, enter the number of times you want this Phase code duplicated then click the Add Duplicate Rows Button. (Remember to remove this number in Column U before you click the Add Duplicate Rows button again.) STEP 8: Choose your Phase Type. (We have defaulted where appropriate, but you can choose another from the list if needed.) STEP 9: Choose your Forecast Method (A = Amounts / P = Productivity) Note: THIS ONE IS SO IMPORTANT FOR LABOR PRODUCTIVITY!!! Think about your Forecast Method now. * If this cell is left blank, it will default to A (Amounts) * A "P" (productivity) method is what makes the phase code show up on your Labor Productivity Report (Use this if the work was estimated with a production rate and if the project needs to track this production rate (i.e., Framing, Drywall, Tape/Finish, backing, etc.) * A "P" (productivity) method changes how the Cost Detail pop up works in Contract Forecasting. Cost Detail for Labor Productivity tries to think for you by calculating what is left to install and how many hours it will take to complete it. Have you ever gotten behind in entering quantities and noticed your Cost to Complete has doubled/tripled. That is because the system is trying to think for you because it is a P Forecast Method. * If the phase code is for Burn-rate work (Forklift operator, Safety tasks, general cleanup) then put an A (Amounts) in the Forecast Method cell so it will not show up on your LP reports and the Cost Detail in Contract Forecasting will forecast as an A method. * If the production scope of work is so small it is not worth tracking (This should be discussed with your manager first) you can put an A (Amounts) in the Forecast Method cell so it will not show up on your LP reports and the Cost Detail in Contract Forecasting will forecast as an A method. STEP 10: Confirm the Weight Measure (WM) This column is for Manhours/Hours (Input) Note: Use this for both category 71111 & 71151 and track the hours on the Quantity/Hours Tracking log. Even though you are not tracking LP on a 71151 employee, you can track hours. * If you are 50% complete with your project, but your PE has spent 75% of the hours, there might be a question to ask or a PCI to complete STEP 11: Number of hours to complete the scope STEP 12: Average combined rate for crew STEP 13: Enter the Cost Budget Estimated Amount (Total). This is the total COST budget amount for this particular Phase & Category line item. Remember that the Fee Phase & Category line should have zero COST budget STEP 14: Revenue Budget, what you are going to get paid by the owner (REMEMBER, this can be different than your Cost Budget) * You estimated for 2 apprentices and 1 Journeymen, but were given 1 apprentice and 2 Journeymen, that is going to cost you more. If you can't get that difference from the owner, then your Cost Budget is going to be higher. Tell the truth!! If you know that now you can set your budget up this way, or immediately create an NCTO PCI * You estimated for 2 apprentices and 1 Journeymen, but were given 3 apprentices, that is going to cost you less. If you can still bill the owner for the full Revenue Budget, then your Cost Budget is going to be lower. Tell the truth!! If you know that now you can set your budget up this way, or immediately create an NCTO PCI STEP 15: Weight Measure for Output (How many CY, SF, LF etc. will it take to complete the scope) NOT LS, NOT HR Note: For Standard Production rates, this has already been filled out. These are company standards, DO NOT CHANGE THEM. STEP 16: Total output quantity for the scope of work in the phase code. STEP 17: Review Retention (the formula on the spreadsheet will pull from the field in the upper left hand corner, but if you have a phase code that will have a different retention you can change it here. STEP 18: If a Phase Code has multiple category codes associated, each must be entered as a separate line. Using Column U, enter the number of times you want this Phase code duplicated then click the Add Duplicate Rows Button. (Remember to remove this number in Column U before you click the Add Duplicate Rows button again.) STEP 19: Be careful, this will remove ALL duplicate rows, not just the one you added last. No need to put a number in any cell on this column. STEP 20: Clear what you have done STEP 21: Click Save My Spreadsheet to save your work STEP 22: Click Finish & Create Bid Items to create the .csv format that will allow it to be imported into CMiC. The Macro will add IMPORT THIS FILE to make it easy to know which one to import.
-
Formatting the Concrete Project Budget Import Spreadsheet for CMiC Bid Items
Note: Project budgets are imported from an Excel template into CMiC via the bid items module. There are several formatted spreadsheets available to use. The spreadsheets are available on SwinNet on the Technology > Products & Services page, scroll to the bottom of the page to Important Documents Note: Managing your Labor Productivity starts with setting up your Budget Import Spreadsheet correctly. Way before it even gets into CMiC STEP 1: Select the Company Code STEP 2: Change the Job Number to the project you are working on STEP 3: Enter the Retainage Percentage (%). This value (normally 10%) applies to all line items except Fee STEP 4: Click the Save My Spreadsheet Button. (This will save the document to your desktop. DO NOT DO FILE/SAVE AS, it will break the macro and your budget will NOT import) STEP 5: Double check that the file name changed to include your job # and today's date. (If the file name looks like this: Budget Import Spreadsheet - - 1-1-2018, STOP 🛑 > go back to SwinNet and open a new template, the macro has been broken.) STEP 6 Search up a Phase Codes needed for this project and type "Y" in column A to select that phase code. Each row will turn Yellow when selected 6A – Use the Work Type Filter to narrow the selection by type (I.E. Form & Strip, reshore, place, etc.). 6B – Use the Work Detail Filter to filter the selection detail. (I.E. Walls, Columns, Beams, etc.) Note: Once all the phases are selected, filter the spreadsheet to only show "Y"s using the down arrow in cell A1 Note: You can navigate to the Data-Tab and click on the “clear” button to reset all the filters. STEP 7: Enter a Category Code for each selected Phase Code Note: If a Phase Code has multiple category codes associated, each must be entered as a separate line. Using Column U, enter the number of times you want this Phase code duplicated then click the Add Duplicate Rows Button. (Remember to remove this number in Column U before you click the Add Duplicate Rows button again.) STEP 8: Choose your Phase Type. (We have defaulted where appropriate, but you can choose another from the list if needed.) STEP 9: Choose your Forecast Method (A = Amounts / P = Productivity) Note: THIS ONE IS SO IMPORTANT FOR LABOR PRODUCTIVITY!!! Think about your Forecast Method now. * If this cell is left blank, it will default to A (Amounts) * A "P" (productivity) method is what makes the phase code show up on your Labor Productivity Report (Use this if the work was estimated with a production rate and if the project needs to track this production rate (i.e., Framing, Drywall, Tape/Finish, backing, etc.) * A "P" (productivity) method changes how the Cost Detail pop up works in Contract Forecasting. Cost Detail for Labor Productivity tries to think for you by calculating what is left to install and how many hours it will take to complete it. Have you ever gotten behind in entering quantities and noticed your Cost to Complete has doubled/tripled. That is because the system is trying to think for you because it is a P Forecast Method. * If the phase code is for Burn-rate work (Forklift operator, Safety tasks, general cleanup) then put an A (Amounts) in the Forecast Method cell so it will not show up on your LP reports and the Cost Detail in Contract Forecasting will forecast as an A method. * If the production scope of work is so small it is not worth tracking (This should be discussed with your manager first) you can put an A (Amounts) in the Forecast Method cell so it will not show up on your LP reports and the Cost Detail in Contract Forecasting will forecast as an A method. STEP 10: Confirm the Weight Measure (WM) This column is for Manhours/Hours (Input) Note: Use this for both category 71111 & 71151 and track the hours on the Quantity/Hours Tracking log. Even though you are not tracking LP on a 71151 employee, you can track hours. *: If you are 50% complete with your project, but your PE has spent 75% of the hours, there might be a question to ask or a PCI to complete STEP 11: Number of hours to complete the scope STEP 12: Average combined rate for crew STEP 13: Enter the Cost Budget Estimated Amount (Total). This is the total COST budget amount for this particular Phase & Category line item. Remember that the Fee Phase & Category line should have zero COST budget STEP 14: Revenue Budget, what you are going to get paid by the owner (REMEMBER, this can be different than your Cost Budget) * You estimated for 2 apprentices and 1 Journeymen, but were given 1 apprentice and 2 Journeymen, that is going to cost you more. If you can't get that difference from the owner, then your Cost Budget is going to be higher. Tell the truth!! If you know that now you can set your budget up this way, or immediately create an NCTO PCI * You estimated for 2 apprentices and 1 Journeymen, but were given 3 apprentices, that is going to cost you less. If you can still bill the owner for the full Revenue Budget, then your Cost Budget is going to be lower. Tell the truth!! If you know that now you can set your budget up this way, or immediately create an NCTO PCI STEP 15: Weight Measure for Output (How many CY, SF, LF etc. will it take to complete the scope) NOT LS, NOT HR Note: For Standard Production rates, this has already been filled out. These are company standards, DO NOT CHANGE THEM. STEP 16: Total output quantity for the scope of work in the phase code. STEP 17: Review Retention (the formula on the spreadsheet will pull from the field in the upper left hand corner, but if you have a phase code that will have a different retention you can change it here. STEP 18: If a Phase Code has multiple category codes associated, each must be entered as a separate line. Using Column U, enter the number of times you want this Phase code duplicated then click the Add Duplicate Rows Button. (Remember to remove this number in Column U before you click the Add Duplicate Rows button again.) STEP 19: Be careful, this will remove ALL duplicate rows, not just the one you added last. No need to put a number in any cell on this column. STEP 20: Clear what you have done STEP 21: Validate your production rate (as appropriate) STEP 22: Validate your yield (as appropriate) STEP 23: Reference the description of work to ensure that you are using the correct code for the work. STEP 24: Click Save My Spreadsheet to save your work STEP 25: Click Finish & Create Bid Items to create the .csv format that will allow it to be imported into CMiC. The Macro will add IMPORT THIS FILE to make it easy to know which one to import.