Budget Spreadsheet

This document consists of four separate tabs.

The first tab is the budget template and is how we collect the values compromising your budget.

The last three tabs are worksheets that assist in generating accurate values for labor and equipment costing.

The Labor Cost tab allows us to define an average hourly wage for a specific type of employee.

The Crew Cost tab is where you define the crew types you wish to use in Manage360 and define a crew average wage cost.

The equipment cost tab breaks the cost of your equipment down into three sections and allows you to come up with your total cost per hour for your equipment.

Budget Template Tab

The budget template is where you define your different divisions for use in Manage360 and enter your budgets. Its design reflects how Manage360 tracks your budget by breaking your costs down into categories for materials, plants, labor, subcontracting, and equipment, recording your total revenue (gross sales) as well as accounting for your overhead expenses. The total sum of these categories is important for this spreadsheet. Because of this, you need not fill out all of the “sub-categories” as they essentially function as a worksheet for allowing you to generate your total labor burden or overhead costs.

This tab has a few cell-dependent equations, so care must be taken when inserting or removing cells.

The first section of this spreadsheet is for entering all of your non-overhead-related costs. The next section is for recording your overhead and contains a list of common overhead expenses. After this, we have an area called overhead recovery percentage. The last part, labeled ratios, lists a few industry-standard values for your different costs as a percentage of total sales.

The following tabs contain values required for entry into Manage360 as they are all important factors in cost-based estimating. Your cost projections are the driving factors behind Overhead Recovery and unit pricing and having accurate average wage costs are important for determining labor costs on your Estimates. Providing detail for your equipment costs and Costbook items helps determine what you charge for these items, in conjunction with your budget setup. Incorrect values in these sections decrease the accuracy of your estimates and thus what you end up charging the client, which has consequences such as failure to recover all of your Overhead costs for the year. From the Budget Template tab your Gross sales, as well as your total costs for Materials, Plants, Subcontractors, Equipment, and Overhead, are all required. Also required are your labor costs, broken down into your cost of Direct Labor and your Labor Burden Total.

Labor Cost Tab

Because labor in Manage360 is estimated in total man-hours and because it may not be immediately ascertainable which employees will eventually work on that job, labor is defined as an average wage cost of similar employees. The purpose of this tab is to assist in realizing the average wage cost.

This tab takes the total working hours per employee type and accounts for any time for which they are being paid but not doing work that is billable to the client (e.g. driving to a site). It takes this value and marks up the average wage (which must be independently determined) to give you a total productive hour cost.

Finally, indirect labor costs (pensions, workman’s comp) are accounted for to deliver the total hourly labor cost for each employee type. This value is highlighted in green and will need to be copied onto the next tab (Crew Cost). The Total Labor Cost per Hour is needed to calculate the average wage cost of one of your crews, so that crew cost value can be implemented into Manage360 to assist with labor pricing on estimates.

Crew Cost Tab

This tab is a worksheet that allows you to define the types of crews you would like to use in your estimates and generate a crew average wage cost for each crew type. Taking the average labor costs by worker type, you design a crew and it outputs the total hourly crew cost based upon the crew’s composition.

For example, a 3-man construction crew consisting of one foreman and two laborers would account for the differing wages of each employee type and average them out. Once you have found your crew cost, Manage360 will assist in generating a Unit Price based upon your Overhead Recovery values, Profit Margins and Labor Burden Percentage.

Not all distinct crews are required here as similar crews typically have an average wage that is similar and we are trying to determine an overall average to use when for estimation. Additional crew types can be added if it a specialized crew with a significantly different cost. For example, there may be entries for a Maintenance type crew and a Construction type crew if different rates are charged for those activities. The Crew Average Wage Cost is the only value required for entry into Manage360 from this tab.

Equipment Cost Tab

In the equipment cost spreadsheet, we are interested in generating the total cost per hour per piece of equipment. We break the total cost of your equipment into acquisition, fuel and maintenance costs. In the first section, you must estimate how long you intend to keep the equipment for, its turn-in value and the amount of hours you will get out of it while you have it to properly generate the hourly cost of acquisition. The next section is for maintenance costs on that equipment which must also be estimated. A few common types are listed (brake/clutch repairs) with a few extra rows for you to enter your own values. This generates your total hourly cost of maintenance. The next section requires you to estimate your fuel costs over the vehicle’s lifetime to give an hourly fuel cost. The spreadsheet then takes the sum of these three cots to give you your total hourly equipment cost for you to use in Manage360. The Total Cost per Hour for each piece of equipment you intend to use in your estimates and job costing is required for entry into Manage360.

QuickBooks Connection

QuickBooks Connection