Configure Materials for Project Costing

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 will use a procedure similar to the Hardware Library for the Solid Stock, Buy Out, and Edge Band libraries.

We demonstrate this procedure based on the assumption that you want to save these material file modifications to your Library Specification Groups and not your Project Specification Groups. The changes done in your Library Specification Groups will be available in all future projects taken from that specification group, whereas those done from the Project Specification Groups would require that you copy the material as a project level material and edit it from there. In the latter case, it also limits your modifications to only the current project instead of all future projects taken from that specification group template.

  1. Open Toolbox and click Toolbox Setup > Library Specification Groups.
  2. Click the specification group you intend to modify or copy an existing group to create a new group. In Figure 1, I have created a copy named ‘HPDL_ProjectCosting’ and selected it. Make sure the intended group displays a green checkmark next to the name.
  3. Click the ‘Open Material File’ button at the top of the screen. (It is the button that looks like a block of wood showing the end grain.)

Fig. 1 - Library Specification Group Screen Showing Specification Group to Modify and the Open Material File Button

Sheet Stock Material Costing Data

  1. Click on the Sheet Stock tab and expand the sheet stock material tree to select the material you intend to modify. Alternatively, enter a search string for the name of the intended material in the search bar.
  2. If you are modifying one material at a time, right-click that material and click ‘Edit Selected Material,’ or simply double-click on the material. If you are changing multiple materials simultaneously, skip down to Step 7.
  3. Double-click the desired sheet size in the list in the lower area of the interface and enter the price you pay for a single sheet of material of that size and material.
  4. Enter a value in the boxes for Markup and Waste Factor to represent a percentage to add to the basic price you pay for that item. For example, let’s say you want to add a 5% markup to the price per sheet, enter 0.05 in this box. Likewise, enter 0.1 in the Waster Factor box to add a value representing an average waste of 10% per sheet.
There is no need to enter a Labor Value on this material file screen as labor is taken from the Activity Stations in this version of costing.

Fig. 2 - Edit Material and Enter Sheet Estimate Price

  1. Repeat this process for all materials that you want to generate project costing data.
  2. Click ‘OK’ and close the specification group screen.
  3. It is also possible to edit multiple materials simultaneously, as stated in Step 2. After expanding the tree view for the intended material category, select various materials and right-click on that selection. Click the command ‘Edit Multiple Materials’ and check the box for ‘Material Estimate Cost.’ Enter a value and click the ‘Apply’ button. That value will be added to each material selected without having to modify them individually.
  4. Click ‘OK’ and close the specification group screen.

Hardware Material Costing Data

  1. Click on the Hardware tab and expand the sheet stock material tree to select the material you need to modify. Alternatively, enter a search string for the name of the intended material in the search bar.
  2. If you are modifying one material at a time, right-click that material and click ‘Edit Selected Material,’ or simply double-click on the material. If you are changing multiple materials simultaneously, skip down to Step 8.
  3. Click in the Estimate Price box and enter the price you pay for this hardware item.
  4. Click to drop down the Unit Type box and select one of the unit types from the list that best represents how you purchase that item.
  5. Enter a value in the boxes for Markup and Waste Factor to represent a percentage to add to the basic price you pay for that item. For example, let’s say you want to add a 5% markup to the price per hardware item, enter 0.05 in the Markup box. Typically, Waste Factor is not needed for hardware, but it is generally used in the edgebanding library. If needed, add a value representing the average waste amount in a decimal form representing the percentage of waste in the Waste Factor box.
There is no need to enter a Labor Value on this material file screen as labor is taken from the Activity Stations in this version of costing.

Fig. 3 - Edit Material and Enter Estimate Price and Unit Type

  1. Repeat this process for all materials that you want to generate project costing data.
  2. Click ‘OK’ and close the specification group screen.
  3. It is also possible to edit multiple materials simultaneously, as stated in Step 2. After expanding the tree view for the intended material category, select various materials and right-click on that selection. Click the command ‘Edit Multiple Materials’ and check the box for ‘Material Estimate Cost.’ Enter a value and click the ‘Apply’ button. That value will be added to each material selected without having to modify them individually.
  4. Click ‘OK’ and close the specification group screen.

Once you have completed the steps above for all the materials included in a project, you are ready to configure your Activity Stations. When that is complete, create a project and work order and then view the MV Cost Based Estimating 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 ...
    • 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 ...
    • 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 ...
    • 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 ...
    • Overview & Tutorial: User Defined Project Properties in a Work Order Based Report

      This article explains how to use a single or multiple User Defined Project Property (UDPP) in a report based on a single work order. The issue that makes this a subject for training is the fact that the UDPP (User Defined Project Properties) are ...
    • Recent Articles

    • Toolbox Release Notes | Build 24.1.1206.641

      The following release notes apply to Toolbox build 24.1.1206.641 MV Server Nesting Fix There was a reported issue occurring when users attempted to remotely process work orders using a nesting station on MV Server. When attempting to process the work ...
    • Microvellum Foundation Library Release Notes | Build 24.1127

      The following release notes apply to Microvellum Foundation Library build 24.1127. Additions Added a new Soffit product to the Upper Cabinet Accessories category. Added the Top Filler (Ceiling Scribe) option to Upper and Tall cabinets. (Corner ...
    • Toolbox Release Notes | Build 24.1.1125.641

      The following release notes apply to Toolbox build 24.1.1125.641. IRIB Setmill Location Fix Fig. 1: Setmill being moved to the start of the route (top) rather than at the center of a straight line, as intended (bottom). There was an issue reportedly ...
    • 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 ...