1. Home
  2. Milestones
  3. Estimates and Budgets

Prorating a Budget from an Existing Estimate

A pro-rata budget allows you to see the proportional comparison between the current estimated cost and a target budget

Create a pro-rata Budget in Join following the steps below:
  1. Click the Milestones tab in the top navigation bar
  2. Click the name of the Milestone
  3. Click the Estimate tab
  4. Select any cell in the Direct Cost Estimate table and use Ctrl+A to select all followed by Ctrl+C to copy the table data
  5. Click the Budget tab
  6. Click the New Estimate button to generate a blank Budget
  7. Align the columns to match the same structure from the Estimate. Columns can be added or moved as needed using the drop-down in a column header
  8. Select the first cell in the table and use Ctrl+V to paste the data to the table
  9. Switch the cost breakdown to Enter Totals only using the toggle shown below. Doing this will delete the Unit Pricing or Cost Type data
  10. Switch back to the Enter Quantity, Unit, Unit Price cost breakdown using the same toggle. This will reset the Quantity column to 1.
  11. Each line in the Budget can now be increased or decreased by utilizing Quantity as a factor. See the example below. You can use the filter tool to target specific areas for the project to create a more realistic pro-rata Budget.
  12. Review your Markups and determine if they need to be scaled. Use the same copy-paste approach from steps 1-4 to transfer over your Estimate Milestone Markup structure. The percentage Markups will adjust automatically but Lump Sums will not and may need to be adjusted.
  13. Finally, click the Publish button to publish the prorated Budget.

If you are creating a Budget for a new Milestone and want to use a previous Milestone Budget or Estimate use the Copy from button found on the Estimate tab in the Milestone. From there start at Step 9 and continue through the process of adjusting the Budget. For questions on how to use the Copy from function read the Copying an Existing Milestone Estimate or Budget article.

Note: For more information on the benefits of creating a Budget, read The Importance of a Milestone Budget article.