How to Use the Toolbox Project Costing Tools

How to Use the Toolbox Project Costing Tools

The purpose of this article is to provide a guide on how to use Microvellum's Proect Costing Tools. A step-by-step tutorial is included in the attached video for a clearer and easier understanding of how to effectively use these tools.


In the Help Center article Announcing Microvellum Project Costing Tools, it was explained that three significant components are comprising those tools.
  1. Material file material cost amounts and/or labor time values for each material.
  2. Activity stations labor time and labor rate for each station.
  3. The Cost Based Estimating Report.
Registered users may access downloads of the most current Reports and Activity Stations in the Downloads section of the Microvellum Knowledge Base.
We are presenting further details about those three components below and how they interact with each other to produce the Cost Based Estimating Report.
The following Project Properties are used in the Cost Based Estimating Report:
  1. Job number
  2. General Contact
  3. Estimator
  4. Currency Symbol (Global)

Material File

The material file contains multiple types of costing data for each sheet stock material, solid stock, buyout item, edge band, and hardware item in the respective material file libraries. In the material file interface, you set the material cost for that material by the sheet, by a linear unit, or by the material unit (Each).

Please see the relevant material file fields and a short description of each below.

  1. Markup – if the Estimate Price is your shop cost for materials, use markup to bring the total price up to fair market value.
You decide to use the Material Pricing Markup value or to use the Markup feature in the reports. If you decide to use the material file Pricing Markup value, keep in mind that if you add a Markup value in the report, it will compound the total markup on the quote. $100 material with 10% material markup = $110. If 10% markup is also added at the report level, the cost would be $121.)
  1. Waste Factor – enter the waste percentage that you expect for this material.
  2. Labor Value – enter the time, calculated as Minutes Per Unit (MPU), that it would take to finish a square foot or meter of material with sanding, staining, painting, lacquering), or to install a piece of hardware. As noted below, in the context of the project costing tools, the material file Labor Value applies only to Finishing and Hardware. Be very careful that you calculate this as MPU. This is the inverse of the Activity Station calculations.
  3. Estimate Price – enter the cost of the material, before markup, waste percentage, or sales tax percentage. This is the most frequently used value of these four to be used in the project costing reports.
The Estimate Price is generated using Optimization Priority 1 Materials only - If you have multiple sheet sizes, ensure that only ONE of them has a cost value entered or the Estimate Price will not calculate correctly.
The material file contains a text entry box for Labor Value, which represents the estimated cost of any labor associated with the sheet or the unit specified. This is currently used in the Toolbox Project Costing Tools for only sheet finishing and hardware installation labor values.

If you decide to enter and use a material file 'Labor Value' instead of the activity station 'Units Per Minute of Factory Time' for something such as material finishing or material handling, you must remember that the material labor value should be entered as a value representing 'Minutes Per Unit' (MPU) instead of 'Units Per Minute' (UPM). This is the inverse of the format required by the activity station's labor calculations.


Fig. 1 - Material File Interface Showing Entry Boxes for Sheet Stock Material Cost per Sheet


Fig. 2 - Material File Interface Showing Entry Boxes for Hardware Material Cost and Unit Type

As you are adding labor values and costing values to the materials, you may edit multiple materials simultaneously, making it quick and easy to configure this Costing component.

Toolbox populates the data from the materials into the work order database parts, sheets, edgebanding, and hardware tables without alteration or re-calculation.

Activity Stations

As the name implies, we use the activity stations to set the values for the time required for each labor operation or activity. The categories set up in the Activity Stations should reflect the various engineering, manufacturing, assembly, shipping, and installation processes in your shop. Every essential operation or group of operations that consume time in the process of producing a billable project can be assigned as an activity station. Configure each activity station with a time value and a labor rate if you want the report to display data for that operation in the reports.

Fig. 3 - Activity Station Setup Screen Showing a Station Set Up to Track a Routing Operation

Default Activity Station Numbers should not be modified. Additionally, make sure you do not have more than one activity station with the same Activity Station Number.
The reports used for Project Costing discussed elsewhere in this article use these values to determine labor costs for each area of your shop needing access to this data. This includes your design, engineering, and manufacturing processes. Labor cost values for each of these Activity Stations are entered based on Units per Minute (UPM).

As you process parts through various Activity Stations, some stations may require many minutes per part, and an activity interval assignment based on 'Units per Minutes' does not make sense for those stations. Here is another way to think about this that may make it easier to understand. Instead of 'Units per Minute' (UPM), think of the interval assigned as 'Minutes per Unit' (MPU). To determine 'Units per Minute' just divide the value of one by the minutes per unit that you determine each part will require in the activity station process to get the proper value (1/MPU).

In Figure 4, the Unit Type is 'Lineal Feet' (Linear). The value of 15 that is entered in the box Units Per Minute of Factory Time means that every minute the CNC machine associated with this processing station can route a distance equal to 15 feet. If the Unit Type is 'Each Parts' and the Units Per Minute of Factory Time is 0.2, the activities related to Part Assembly proceed at the rate of one part every five minutes.

See the table below for the default library values in the Component Cabinet version 50.5. This table can serve as a model for you as you set up your company data.


Fig. 4 - Table of Activity Station Values Entered in the Microvellum Component Cabinet Library Version 50.5

Although the average user can customize the activity stations outside the values found on this table, if you are working in a sandbox environment, we recommend that you acquire the services of a Microvellum Service Tech to assist you. If your activity station modifications include modifying the activity station numbers, you also must modify the costing reports with your revised numbers.

Toolbox populates the data from the activity stations into the factory database ActivityStations table without alteration or re-calculation.

Relationship of Activity Stations to Processing Stations

Each software configuration contains an exclusive set of Activity Stations. Although the Activity Stations contain a section for default Processing stations, they are not defined by those stations, and it is not necessary to attach an Activity Station to a Processing Station. The Activity Station box located in the Processing Station setup screen is used for legacy purposes. It does not need to contain an Activity Station for the program to function correctly. On the other hand, if the Processing Station does contain an Activity Station in this box, nothing in the program is affected adversely.

In summary, the Processing Stations and the Activity Stations are separate entities and only connected because the button for accessing the Activity Stations is located in the Processing Stations tab of the Microvellum options.

Installation Labor (Hardware and Products)

Products and Hardware that are classified in Database Explorer with names containing Bathroom, Closet, Countertops, or WireShelves are determined to be installed onsite.  For Products, this will include all the included hardware.

Reports

We have set up the reports with the ability to tailor the output to your individual needs as the report contains multiple parameters in the header area of the report. Use these user input variables to display the report in the exact combination of predetermined formats you need. For example, open the Cost Based Estimating Report and notice that the header contains multiple parameters to which you add values or checkboxes ON or OFF to control the appearance of the report. These parameters also control the data to display on the report. The parameters for this report include whether you want to display the greyscale graphics bands, the markup percentage to apply to the report subtotal, the overhead percentage to apply, the finishing markup, and options to hide various costing categories on the rendered report.

The Cost Based Estimating Report contains a section of user input variables (properties) that you will use to adapt the report output to your individual company preferences.

Properties


Fig. 5 - Cost Based Estimating Report Data Customization Properties

Hidden Variables

Imperial_Conversion (default value: OFF)

Used for situations where the shop processes data in Metric but the CustomerQuote needs to be converted to Imperial.  This requires the following:
  1. Activity Stations are to be Imperial
  2. Material Costs are to be Imperial
  3. Material Finishing is to be Minutes/1 sq ft

_Code (9 variables) (default value: 111)

This 3 digit code is a multi-use code used to determine if Markup, Overhead, or Sales Tax applies to the following portions of the quote:
  1. Sheets
  2. Sheets Markup
  3. Materials
  4. Materials Markup
  5. Labor
  6. Installation Labor
  7. Custom Amounts (1-3)
The value of each digit of the code is either a 0 (does not apply) or 1 (applies).  Values for the code can vary (i.e. 000, 001, 010, 010, 100, 111, etc).

We will now discuss the three report tabs we currently use with the Project Costing Tools in the Cost Based Estimating Report (Shop Quote, Shop Labor Quote, Customer Quote).

Cost Based Estimating Report: Shop Quote

This report contains two main sections. The first section is Materials and contains the costs for the materials of all parts included in the work order.  The second section is Labor and contains the cost of the labor necessary to design engineer and manufacture your products. 


Fig. 6 - Rendered Sample Shop Quote

Cost Based Estimating Report: Shop Labor Quote

This report contains the cost of the labor necessary to design engineer and manufacture your products. This report draws its base labor values from the activity stations.


Fig. 7 - Rendered Sample MV Labor Report

Cost Based Estimating Report: Customer Project Quote

This report contains a list of products contained in the work order. It sums the material costs for all the parts of those products and the labor for the relevant activity stations, including tax. This report draws its base material cost values from the activity stations and the material file.

It also contains a legal statement of the Terms and Conditions that serves as a contract between the Customer and the Contractor.

This statement must be modified to match the Terms and Conditions of each company using the report.

Fig. 8 - Rendered Sample  Customer Project Quote

You will notice that all the project products are listed on page 2 of the report, along with a subtotal of the products plus any Overhead and Markup.

XML Data Export

This report contains the ability to export the report data via XML to external software.  This requires the use of a plugin for functionality.  The export page, when enabled, will be the last page of the report.

Summary

The reports are the main engine for calculating costing values in the Project Costing Tools. As noted elsewhere in this documentation, the values from the materials and activity stations are populated directly to the database without alteration. The reports take those values from the database and calculate the costs according to the user input variables set in the reports.

Master Class: Reports Level 3: Part 3 Video - Understanding the Costing Report


    • Related Articles

    • Configure Activity Stations for Project Costing

      In this article, we will show you how to configure your Activity Stations to match the default configuration of the Cost Based Estimating Report.     As pointed out in the article How to Use Project Costing Tools, if you modify your activity stations ...
    • Announcing Microvellum Project Costing Tools

      We are pleased to announce the new Microvellum Project Costing Tools in Toolbox. This article presents an overall view of this new Costing capability. Previous versions of estimating and costing relied on library data configurations and those legacy ...
    • Configure Materials for Project Costing

      In this article, we will show you how to configure a material from the Sheet Stock Library, and one from the Hardware Library for use with the Project Costing Tools. This demonstrates the two different styles of material file costing data, and you ...
    • Print Reports for Project Costing

      In this article, we will show you the steps required to create the necessary data and view the Cost Based Estimating Report. Registered users may access downloads of the most current Reports and Activity Stations in the Downloads section of the ...
    • Tutorial: 2D Machining Tools

      General procedure overview:  Create a new nest sheet.  Add parts to the sheet.  Add machining to the parts.  Modify the nest sheet layout as needed.  Generate G-Code for the nest sheet. Click the button on the MV palette "Nest Editing and 2D ...
    • Recent Articles

    • Toolbox Release Notes | Build 24.1.1105.641

      The following release notes apply to Toolbox build 24.1.1105.641 Nesting Fix Fig. 1: The fatal error that would occur during processing. There was reportedly an issue that occurred when clients attempted to process a work order using the nesting ...
    • Microvellum Foundation Library Release Notes | Build 24.1025

      The following release notes apply to Microvellum Foundation Library build 24.1025. Additions Added new global variable “Remove Stop Dado On Bottom Edge” for wood drawer boxes. Check this option to run the dado through at the bottom of the sub front ...
    • Toolbox Release Notes | Build 24.1.1030.641

      The following release notes apply to Toolbox build 24.1.1030.641 Routing and Profile Fixes Several issues were found with routing and polyline paths: Fig. 1: Horizontal routes off of a part disappearing (left) and appearing correctly (right). When ...
    • Toolbox Release Notes | Build 24.1.1010.641

      The following release notes apply to Toolbox build 24.1.1010.641 Biesse Winstore Fix Several issues with the Biesse Winstore plugin have been resolved: There was an issue that would sometimes occur wherein materials that were intended to stack wound ...
    • Toolbox Release Notes | Build 24.1.1001.641

      The following release notes apply to Toolbox build 24.1.1001.641 HBore Toolfile Fix Fig. 1: The location in the Toolfile UI where the error would occur. There was an issue reported with the functionality of the Horizontal Boring Machine setting in ...