Users Guide for WoodCite

A Product Cost Quotation Tool for 

Wood Component Manufacturers

Jeff Palmer

Adrienn Andersch

Jan Wiedenbeck

Urs Buehlmann

United States Department of Agriculture

Forest 

Service

General Technical 

Report NRS-126

Northern 

Research Station January 2014

 

 

 
Visit our homepage at: http://www.nrs.fs.fed.us/

Published by: For additional copies:

U.S. FOREST SERVICE U.S. Forest Service

11 CAMPUS BLVD SUITE 200 Publications Distribution

NEWTOWN SQUARE PA 19073 359 Main Road

 Delaware, OH 43015-8640

 Fax: (740)368-0152

January 2014 Email: nrspubs@fs.fed.us

Manuscript received for publication 6 June 2013

Abstract

WoodCite is a Microsoft® Access-based application that allows wood component manufacturers 

to develop product price quotations for their current and potential customers. The application was 

developed by the U.S. Forest Service and Virginia Polytechnic Institute and State University, in 

cooperation with the Wood Components Manufacturers Association.

The Authors

JEFF PALMER is an information technology specialist with the U.S. Forest Service, Northern 

Research Station, in Princeton, WV. He received a B.S. in business management and computer 

science from Bluefield State College in Bluefield, WV.

JAN WIEDENBECK is a research forest products technologist with the U.S. Forest Service, 

Northern Research Station, in Princeton, WV. She received a B.S. in forestry from the University 

of Michigan in 1980, an M.S. in forest products from the Virginia Polytechnic Institute and State 

University in 1988, and a Ph.D. in forest products from Virginia Polytechnic Institute and State 

University in 1992.

ADRIENN ANDERSCH is a graduate research assistant and a doctoral degree candidate in 

wood science and forest products at the Virginia Polytechnic Institute and State University. She 

graduated from the Faculty of Economics at the University of West Hungary, Sopron in 2007 

and has an M.S. in economics. Her research interests include cost accounting, and product and 

process pricing within the primary and secondary wood industry.

URS BUEHLMANN is an associate professor of wood science and forest products at the Virginia 

Polytechnic Institute and State University. He obtained an industrial engineering degree from 

the Swiss Institute of Wood Technology, an MBA in finance and management, and a Ph.D. in 

wood processing from the Department of Wood Science and Forest Products of the Virginia 

Polytechnic Institute and State University.

The use of trade, firm, or corporation names in this publication is for the information and 

convenience of the reader. Such use does not constitute an official endorsement or approval 

by the U.S. Department of Agriculture or the Forest Service of any product or service to the 

exclusion of others that may be suitable.

This software program is provided “as is” without warranty of any kind. The authors do not 

warrant, guarantee, or make any representations regarding the use or the result of the 

software or documentation in terms of their correctness, reliability, currentness, or otherwise. 

The entire risk as to the results and performance of the software is assumed by you. In no 

case will any party involved with the creation or distribution of the software be liable for any 

damage that may result from the use of this software.
CONTENTS

WHAT IS WOODCITE? ..................................................................... 2

SYSTEM AND SOFTWARE REQUIREMENTS ................................. 2

INSTALLATION PROCEDURES ........................................................ 2

 Pre-Installation Checklist ............................................................... 2

 Downloading, Unzipping, and Running the Installation Routine .... 3

 Dragging and Dropping the Application Folder ............................. 5

USING WOODCITE ........................................................................... 5

 The User Interface ........................................................................ 6

 Entering Company Information ..................................................... 8

 Entering Customer Quotation Data ............................................. 10

 Viewing the Customer Quotation Sheet .......................................11

 Closing WoodCite .........................................................................11

APPLICATION INFORMATION AND SUPPORT ............................. 12
2

WHAT IS WOODCITE?

WoodCite is a Microsoft® Access-based application that allows you to create a product price 

quotation for your customers. It uses your production data such as materials, labor, and 

overhead costs (along with your product margin) to compute the total product cost. Before 

starting, make sure you have the appropriate records and documents handy, such as income 

statements and employment records (number of hired employees, wages, salaries, etc).

WoodCite computes your product cost information based on your entries. In addition to 

creating a product price quotation, you can use WoodCite to run various scenarios to see where 

you can improve productivity or add a new machine to your plant, or simply perform a what-if 

analysis to understand how shifts in materials and resources may impact product costs.

SYSTEM AND SOFTWARE REQUIREMENTS

WoodCite, developed using Microsoft® Access 2007, uses Microsoft® Excel to perform 

statistical computations. Although Microsoft® Offi ce 2007 (including Access and Excel) 

provides the ideal environment for running WoodCite, earlier versions of Microsoft® Offi ce 

(such as, but not less than, Microsoft® Offi ce 2002 on Windows XP) will support the 

application. Th e minimum requirements are as follows:

• IBM-compatible PC with Microsoft® Windows 2000 to Windows 7 (latest service 

packs) installed

• Microsoft® Access 2002 to 2007 (latest service packs)

• Microsoft®

 Excel 2002 to 2007, with the data analysis tools installed

INSTALLATION PROCEDURES

Pre-Installation Checklist

If your computer’s security settings prohibit you from installing programs, then the WoodCite 

installation should be performed by a user or administrator who has full administrative rights and 

privileges to your computer. Installing WoodCite without administrative rights may cause errors.

Before running the installation utility, make sure that you are aware of the version of your 

computer’s Microsoft Windows operating system and the version of the Microsoft Offi ce package 

that is installed onto your computer. If you are running Windows 2000, make sure that your 

system’s default font size is set to “Small fonts.” If you are running Windows XP, make sure the 

default font size is set to “Normal” (Fig. 1). Th ese font settings will ensure that the installation 

instructions are readable and fully contained within the document window from where they are 

displayed. In Windows 2000, use the following steps to adjust your system’s default font size:

• Open the Control Panel and select the Display icon.

• Select the Settings tab and click the Advanced button near the bottom of the dialog box.

• Select the General tab and set the Font Size to “Small fonts.”

• Click the Apply button to accept the changes.
3

To change the system font size for Windows XP, use the following steps:

• Open the Control Panel and select the Display icon.

• Select the Appearance tab and set the Font size to “Normal.”

• Click the Apply button to accept the changes.

For more information on changing your computer’s system settings, refer to your computer’s 

users guide or your Microsoft Windows operating system manual.

Downloading, Unzipping, and Running the Installation 

Routine

To download WoodCite’s installation utility, open your Internet browser and type 

“woodproducts.sbio.vt.edu/woodcite” in your browser’s address bar. Th is will take you to 

the WoodCite Download Center. Follow the instructions provided on the page. If you are 

installing WoodCite from a CD (which is available upon request), browse the CD for the 

“index.htm” fi le, open it, and follow the instructions provided. When you execute the “install.

exe” fi le, the WoodCite installation utility will appear (Fig. 2). During installation, be sure 

to note the location in which WoodCite is being installed because you will have to set the 

application folder (where WoodCite is installed) as a trusted location in Access 2007 and 

greater. If you are using Access 2002-2003, you may have to adjust the macro security settings.

Figure 1. — The Display Properties dialog box for Microsoft Windows 

XP systems. 
4

Defi ning a Trusted Location with Microsoft® Access 2007 and 2010

If you are using Microsoft® Access 2007 or 2010, you will have to defi ne the Version_1_Access

folder as a trusted location. To do so, follow these steps:

1. With Microsoft® Access 2007

a. Click the Offi ce button at the upper left-hand corner of the window

b. Select the Access Options button from near the bottom-right side of the menu. Th e 

Access Options dialog will appear.

2. With Microsoft® Access 2010

a. Select the File tab near the upper left-hand corner of the window.

b. Select the Options icon near the bottom of the navigator (on the left side of the 

window). Th e Access Options dialog will appear.

3. Select the Trust Center option at the left side of the Access Options window.

4. At the right side of the Access Options window, select the Trust Center Settings button.

5. At the left side of the Trust Center window, select the Trusted Locations option and then 

select the Add new location button near the bottom of the window.

6. Browse for the Version_1_Access folder. Be sure to select the checkbox that is labeled 

“Subfolders of this location are also trusted.”

7. Select the OK button for each window.

8. Restart Microsoft® Access.

Figure 2. — The WoodCite installation utility. 
5

Adjusting Macro Security Settings in Earlier Versions of Microsoft® Access

Although WoodCite was developed with Microsoft® Access 2007, it will run with older 

versions of Access, but this may yield unpredictable results. If you are running WoodCite 

with an earlier version of Microsoft® Access such as Access 2003, you may have to adjust 

the macro security settings (keep in mind that this feature may not be available in all earlier 

versions of Access). To do this, open Microsoft® Access 2003, and from the main menu, select 

Tools|Macro|Security and set the security level to “Medium” or “Low.” Be sure, however, to 

adjust these back to their original settings before exiting WoodCite. For more information on 

macro security, refer to the users guide or other documentation that came with your version of 

Access.

Dragging and Dropping the Application Folder

If for some reason the above installation procedures do not work on your computer, you 

can drag and drop the WoodCite application folder to your hard drive. To do this, browse 

through the directory in which you decompressed the installation utility fi les, and look for the 

Version_1_Access folder. Th e WoodCite application (woodcite.mdb) and supporting fi les reside 

in this directory. Before you can run WoodCite, you may have to adjust your macro security 

settings with Access 2002 and 2003 (if the feature is available), or if you are using Access 2007 

or 2010, you must allow Microsoft Access to recognize the Version_1_Access directory as a 

trusted location (see the previous section entitled “Defi ning a Trusted Location with Microsoft® Access 2007 and 2010” for instructions. For technical support, please refer to the contact 

information listed in the last section of this publication).

USING WOODCITE

If the above procedures were successful, then you can start using WoodCite immediately by 

selecting the program icon from the Windows Start menu. If you performed the drag-anddrop routine and followed the procedures to defi ne the Version_1_Access directory as a trusted 

location, then you can open WoodCite by opening the Version_1_Access folder, opening the 

Source subfolder, and double-clicking the WoodCite_1_0.mdb icon, which should be shown as a 

Microsoft®

 Access application, depending on the properties of the Source subfolder. Please keep 

in mind that you cannot enter customer quotation data until you enter information about your 

company, which is explained in the “Entering Company Information” section of this guide.

Note that because data entry is required throughout the application, there may be times where 

you will need to make changes to various fi eld values. To navigate between fi elds, you generally 

use the Tab key. In doing this, the fi elds are automatically highlighted, and changes can be 

made instantly. If you wish to use your mouse to highlight a fi eld value for editing, however, 

you will have to double-click the fi eld value to highlight it, or drag the mouse cursor over the 

value to select all of the contents of the fi eld. Th is is especially important for fi elds where values 

must be in specifi c formats (i.e., decimals, whole numbers).
6

Figure 3. — The WoodCite user interface.

The User Interface

At startup, WoodCite’s welcome page appears and provides you with basic instructions on 

using the application. When you are fi nished with the page, click the Proceed button near the 

bottom left area of the window. You will then see the main application window that contains 

command tabs, a tool bar, and the document area where customer, quotation, and product 

information is entered (Fig. 3).

Command Tabs

WoodCite’s interface contains four command tabs: Tasks, Tools and Applications, References, and 

Commands (Fig. 3). Th ey are located near the top of the application window and allow quick 

access to WoodCite’s functions. Each command tab contains a series of buttons that perform 

specifi c functions, as shown in Table 1.

Th e Tool Bar

At the left side of the WoodCite window is a shaded vertical tool bar that contains a series of 

command buttons (Fig. 3). An illustration of the buttons and the function of each are shown in 

Figure 4.

Command Tab 

Tool Bar 

Document Area 
7

Table 1. — The command tabs and the functions associated with each

Tab Name Associated Function(s)

Tasks Edit company data (edit your company’s basic information)

View all products (view the product list)

Review quotes (view the quotations for the current customer)

View the quote sheet (view the customer’s quotation form)

Tools and Applications Run ROMI 3.0 (execute the ROMI application — requires the latest 

version of Java to be installed onto your computer)

Metric conversions (run the Foresters’ Metric Conversions application)

System calculator (run the system calculator)

References Current version (view your current version of WoodCite)

Database properties (view the database properties)

Commands Import (import a WoodCite database that is saved in a Microsoft Excel 

format)

Backup (save your database to a Microsoft Excel spreadsheet format)

Delete all data (empty the database)

Exit (close WoodCite and Microsoft® Access)

Refresh and save the database 

New customer 

Delete current customer 

New quote 

Delete current quote 

Search (search the database for a customer or product)

View charts 

View documentation 

Figure 4. — WoodCite’s tool bar buttons and a description of each.
8

Th e Document Area

WoodCite’s document area contains the tables and fi elds needed for data entry. Th e top of the 

document area contains fi elds for entering customer information, the center part allows you 

to enter quotation information for the current customer, and the table at the bottom of the 

document area allows you to specify products requested for the current customer quotation 

(Fig. 5).

Entering Company Information

Before entering customer, quotation, and product data into WoodCite, you will have to 

perform a one-time setup for your company by entering your company’s name and address, 

workforce information, manufacturing activities, overhead cost data, shipping standards, 

materials utilized, and products manufactured. Th e data you enter will be used to develop cost 

information for your customer quotation sheets, and you can edit your company information 

at any time, if necessary. On the Tasks tab, click the Edit company data button. Th e Company 

Information dialog will appear (Fig. 6). Table 2 shows a description of the tab pages and an 

explanation of the contents of each.

When you are ready to set up your company, begin with the Company Data tab and enter data 

into the fi elds under each consecutive tab, as required. Click the dialog’s Close button when you 

have fi nished entering your company’s information.

Customer 

Quotation 

Information 

Product 

Information 

Figure 5. — The document area contains fields for entering customer, quote, and product data.
9

Table 2. — The Company Information tabs and a description of the content of each

Tab Name Content

Company Data Company name, address information, email address, Web site, and 

optional company motto.

Workforce Employee name, job title, and hourly wage rate.

Activities Manufacturing activities (activity or machine) and description/comments. 

Business Data Monthly historical manufacturing overhead data: date, overhead cost, 

total labor hours, and total machine hours. When entering overhead 

data, you must enter at least three DISTINCTIVE rows of data (the rows 

cannot be the same). Also, be sure to select the “Update” button once 

you have finished entering data (this will compute your labor-hour and 

machine-hour rates). This is the only area in WoodCite that requires you 

to enter historical data.

Shipping Shipping methods, terms, and payment terms.

Materials Material type, unit measure, species, size, quality, cost per unit, and 

percent yield.

Products This is a list of all products that your company manufactures. Be sure to 

enter a record number, product ID, and description for each product.

Figure 6. — The Company Information dialog allows you to enter or edit information about your business. In this 

illustration, the Business Data tab is selected.
10

Figure 7.— Complete this section only if a quotation has been accepted 

by the customer.

Entering Customer Quotation Data

You are now ready to create a product cost quotation for your customer. Recall that the 

document area consists of three parts: customer information, quote information, and product 

information (please refer back to Figure 3 to see the screen shot of the user interface).

Begin entering your customer’s information near the top of the document window. Be sure 

to enter the customer ID in the designated fi eld. For fi elds that may not apply, simply enter 

the word “none.” Do not leave any fi elds blank. To navigate between customer records, use 

the Previous and Next buttons at the top left part of the customer data entry fi elds. Use the 

New customer or Delete current customer command buttons at the left (Fig. 4) to add or delete a 

customer record as needed.

Next, enter quotation information in the center of the document area. WoodCite asks for a 

quote request ID, quote request description, quote type (retail, wholesale, other), date of quote 

request, responsible person, and the tax rate for this potential order. To navigate between the 

current customer’s quotes, use the Previous and Next buttons just above the Quote Request ID

fi eld. Use the New quote or Delete current quote command buttons at the left (Fig. 4) to add or 

delete a customer’s quotation record as needed. Th e next column contains a fi eld that is labeled 

“Check if this quote was accepted” (Fig. 7). For now, do not place a checkmark in this fi eld 

until this customer quotation has been accepted.

Finally, use the product table near the bottom of the document area to select the products you 

will manufacture for your customer. Only predefi ned products can be selected into the Product 

ID fi eld. If you need to defi ne new products into the database, select the Tasks tab, the Edit 

company data button, and then the Products tab. Enter or edit your product list as needed and 

click Close when you are fi nished.

To insert a product from your product list, click the Insert button in the Product ID fi eld.

Click a product record in the list and click the dialog’s Insert button. A new product record 

should appear in the product table. Because the products are selected directly from your list of 

standard products, you should not attempt to modify the data in the Product ID fi eld. As for 

the remaining fi elds, however, you can enter quantity, material, labor, overhead, and other data 
11

associated with the manufacturing of each product. For the Materials, Labor, Overhead, and 

Other fi elds, use the Edit buttons to compute each of these costs, if needed. If you wish to apply 

a margin or discount, enter each item in the appropriate fi elds.

Viewing the Customer Quotation Sheet

Now that you have entered order and product information for your customer, you can 

now view the quote sheet. Select the Tasks tab and click the View the quote sheet button. 

Your customer’s quotation form should look similar to the screen shown in Figure 8. Th e 

information you see on the form is based on the data you entered into WoodCite. You can save, 

send (via email), or print the quotation form. If you are using a version of Microsoft Access that 

is older than Access 2007, the Save and Send command buttons at the top of the quote window 

may not be available. You can, however, still save the quotation sheet by printing it to a PDF 

fi le (your computer must have a PDF writer installed to achieve this).

Closing WoodCite

When you are fi nished using WoodCite, you can exit by selecting the Commands tab and 

clicking the Exit WoodCite button. WoodCite will ask if you wish to backup your database 

before exiting. If you click the Yes button, then WoodCite will back up the database to a 

Microsoft Excel worksheet to a disk or network location of your choice. If you click the No 

button, WoodCite will terminate, but not discard your information.

Figure 8.— The product quotation sheet.
12

APPLICATION INFORMATION AND SUPPORT

Th e computer program described in this publication is available on request with the 

understanding that the U.S. Forest Service cannot ensure its accuracy, completeness, reliability, 

or suitability for any other purposes than that reported. Th e recipient may not assert any 

proprietary rights thereto nor represent it to anyone as other than a Government-produced 

computer program.

If you have questions, comments, or other issues concerning this computer application, our 

contact information is as follows:

Application Content

Dr. Urs Buehlmann or Adrienn Andersch

Virginia Polytechnic Institute and State University

Department of Wood Science and Forest Products

Brooks Forest Products Center 

1650 Ramble Road

Blacksburg, VA 24061

Phone: (540) 231-7107; Fax: (540) 231-8868

Technical Support

Jeff Palmer

U.S. Forest Service

241 Mercer Springs Road

Princeton, WV 24740

Phone: (304) 431-2732; Fax: (304) 431-2772

Email: jpalmer01@fs.fed.us
Printed on Recycled Paper

Palmer, Jeff; Andersch, Adrienn; Wiedenbeck, Jan; Buehlmann, Urs. 2014. Users 

guide for WoodCite, a product cost quotation tool for wood component 

manufacturers [computer program]. Gen. Tech. Rep. NRS-126. Newtown 

Square, PA: U.S. Department of Agriculture, Forest Service, Northern Research 

Station. 12 p.

WoodCite is a Microsoft® Access-based application that allows wood component 

manufacturers to develop product price quotations for their current and potential 

customers. The application was developed by the U.S. Forest Service and Virginia 

Polytechnic Institute and State University, in cooperation with the Wood Components 

Manufacturers Association.

KEY WORDS: wood, components, quotation, manufacturing costs

The U.S. Department of Agriculture (USDA) prohibits discrimination in all its programs and activities on 

the basis of race, color, national origin, age, disability, and where applicable, sex, marital status, familial 

status, parental status, religion, sexual orientation, genetic information, political beliefs, reprisal, or because 

all or part of an individual’s income is derived from any public assistance program. (Not all prohibited 

bases apply to all programs.) Persons with disabilities who require alternate means for communication 

of program information (Braille, large print, audiotape, etc.) should contact USDA’s TARGET Center at 

(202)720-2600 (voice and TDD). To file a complaint of discrimination, write to USDA, Director, Office of 

Civil Rights, 1400 Independence Avenue, S.W., Washington, DC 20250-9410, or call (800)795-3272 

(voice) or (202)720-6382 (TDD). USDA is an equal opportunity provider and employer. 
Northern Research Station

www.nrs.fs.fed.us