Budget Upload

Introduction

Objective:

Establish a basic understanding and procedure for uploading budget from Estimate Template to Viewpoint.

Agenda

• Process diagram
• Step by Step Tutorial
• Buyout and adjust detail estimate
• Consolidate detail estimate, fine tune code, units, descriptions
• Export CSV file
• Import CSV file to Viewpoint
• Set up Billing

Tutorial

What happens after a win?

From operation standpoint we focus on the Estimate Review

• Cost Code Clean Up
• Consolidate Units
• Review Cost and Bid
• Buyout scopes
• Identify contingency vs cash allowance
• Any special agreement or alignment of trades
• Etc.

Then,

1. The entire estimate data after cleanup get poured into Viewpoint using a .CSV file.
2. The CSV file is structured specifically in a format Viewpoint can read using Import Estimate Module.

Ste-by-Step

Within Estimate Work Book, you will need to do the following

Step 1: Locate the "Tab"

1. Open the Estimate File received from Estimate Turn Over Meeting
2. Locate “Summary” and Division pages, drag and position those sheets to the front of all other sheets.
3. Locate “Est To VP” Tab, there are 6 buttons on this tab, each have their own corresponded functions. We will go through them in later pages.

Step 2: Buy Out, Estimate Adjustment

1. Do your contract buy out.
2. During the buy out, modify the estimate file to match the scope that was bought into the trade’s scope.
3. For the example that was shown here, the access panel and a few other scopes were estimated with own forces. During buy out, the drywaller agreed to take on those scopes for an additional cost. The number has been adjusted and moved to Subcontract Cost accordingly.
4. During buy out, if agreement were made for trades to take on certain additional scope for no or any cost, modify the estimate file to match the agreements.
5. Repeat this for all scopes pertains to the project.
6. In case any offsets from original contract value, we can add those after all the buy out to contingency, or book fee – pending on each project case.

Step 3: Pull All Estimate Data To One Page

1. Locate the button called “Consolidate”. Click on it, will open a dialog allow you to select which page to include on pulling the Estimate Data Over.
2. In most cases, all pages from 1 to 16 will be selected.
3. However, if only a portion of the budget is getting uploaded, such as a change order, select only the page you want to upload.

In the "Consolidation" worksheet, we can fine tune the cost codes, units, descriptions.

An example is shown here. This page allows you to

File:Budget Update - Consolidation.PNG

sample consolidation page

• view which lines share the same cost code
• Group or ungroup the cost lines by cost code
• Adjusting unit of measure, quantities as needed.
• This page does not allow modification to costs per se.