Furniture Data Standards

Introduction

This report is intended to assist THE CLIENT and RSC during the implementation process of the CAFM System by provided recommendations and guidance for populating the CAFM data. THE CLIENT should provide as much direction as possible and deliver existing standards to RSC for incorporation. RSC’s recommendations are based on previous successes and best practices. The recommendations may be altered to best fit the needs of THE CLIENT. A sign-off of these recommendations will be required to provide the best possible standard to adhere to.

Background Information

Background information is required to provide a smooth implementation of a CAFM system. This information is the backbone of good reporting and if researched and implemented correctly can provide years, if not decades, of useful Facilities information. Understanding the desired reports and information necessary to accomplish your facilities goals is the basis for solid decisions surrounding the population of background information.

The following is an outline of some of the recommendations for THE CLIENT. They are broken into three categories; 1) Furniture Standards information.

Furniture Standards

The Furniture Standards table defines your categories of furniture. This is used like an umbrella that identifies multiple, yet similar, pieces of furniture. For example, a furniture Standard of “CHAIR-EXEC” may be used to identify all executive chairs regardless of style. Or, “TABLE CONF” might be the standard for all conference room tables. The table provides several fields for storing data about your furniture; complete the fields that are necessary for the way your company tracks furniture.

Field Name

Description

Cat. No.

Catalog Number of the manufacturer

Description

A detailed description of the furniture standard

Drawing Block

The AutoCAD block used to display the furniture standard on the drawings.

Ergonomically Compliant?

An enumeration list of YES/NO for ergo compliant

Furn. Standard Graphic

Image file of the furniture standard

Furn. Std. Block Graphic

Image file of the AutoCAD furniture standard

Furniture Category

Non-validating field that creates a larger umbrella i.e. Chair, bookcase, etc.

Furniture Standard Code

Primary Key or unique value for each furniture standard desired

Lease Code

Foreign Key to the lease table connecting the furniture standard to a lease

Manufacturer

Manufacture

Option 1

User defined field

Option 2

User defined field

Policy Code

Foreign key to the insurance policy code

Product Line

Manufactures product line

Standard Color

color

Standard Depth

depth

Standard Finish

finish

Standard Height

height

Standard Price

cost

Standard Weight

weight

Standard Width

width

Std. Cost to Move

Cost to move the furniture

Warranty Code

Foreign key to the warranties table

MINIMAL APPROACH:

The minimal approach is the most common approach used simply because it minimizes required resources. This approach takes a very simplistic view of furniture that allows fast data collection and identification. Examples of minimalist furniture standards are:

Furniture Standard

Description

CHAIR-EXEC

Executive chairs

CHAIR-WKST

Workstation chairs

CHAIR-CONF

Conference room chairs

CHAIR-SOFT

Soft seating chairs

DESK-EXEC

Executive Desks

DESK-LOBBY

Lobby Desks

WORKSURFACE

Workstation work surface

TABLE-CONF

Conference room tables

TABLE-LAB

Laboratory tables

PANEL

Cubical panels

FILE-2-DRAW

Filing cabinet 2- draw horizontal

FILE-4-DRAW

Filing cabinet 4- draw horizontal

FILE-LAT-2-DRAW

Filing cabinet 2- draw lateral

Pros

  • Fast data collection and minimal resources to maintain data.

Cons

  • Loss of color, size and unique furniture identification. This is not a desired when trying to find existing furniture for a reconfiguration.
  • Also, with finance gathering information around purchase price and date and depreciation this is not the preferred method.

Alternative

When using MicroView FM (PDA solution) the fields need to track information for furniture reconfigurations and finance have been added to the tagged furniture table so a minimal furniture standard approach may be used.

Field Name

Description

Building Code

Foreign key buildings table

Catalog Number

MicroView Added field

Category

MicroView Added field

Colour

MicroView Added field

Date Received

MicroView Added field

Delivery Date

Date Delivered

Department Code

Foreign key departments table

Depth

MicroView Added field

Division Code

Foreign key division table

Drawing Layer

Layer on the AutoCAD drawing when using blocks and asset text

Drawing Name

AutoCAD drawing name when using blocks and asset text

Employee Name

Foreign key employee table

Entity Handle

AutoCAD drawing entity handle (unique ID) when using blocks and asset text

Finish/Style

MicroView Added field

Floor Code

Foreign key floors table

Furn. Status

List of furniture statuses

Furniture Code

Primary key (bar code tag) for each furniture item

Furniture Condition

List of furniture conditions

Furniture Standard

Foreign key furniture standards table

Furniture Use

Furniture Use

Height

MicroView Added field

Last Survey Update From

MicroView Added field

Last Updated From PDA

MicroView Added field

Lease Code

Foreign key lease table

Manufacturer

MicroView Added field

Notes

MicroView Added field

Out of Service Date

Date placed out of service

P.O. Line Number

Foreign key PO line number table

Policy Code

Foreign key insurance policy table

Property Type

Foreign key properties table

Purch. Order Number

MicroView Added field

Purchase Order Code

Foreign key PO table

Purchase Price

Purchase price

Received By

MicroView Added field

Replacement Value

Cost to replace

Room Code

Foreign key rooms table

Sale Date

Date of sale

Salvage Value

Cost at salvage

Serial Number

Serial number

User Name

MicroView Added field

Warranty Code

Foreign key warranties table

Width

MicroView Added field

This shifts the granulated data from the standards table to the inventory table. Reports and summary reports are used to identify groups and types of furniture. This minimizes resource needed at inventory time, simplifies the standards, and leads to lower asset tracking costs.

GRANULATED APPROACH:

Unlike the minimalist furniture standards approach the granulated approach requires increased resources, dedication to maintain the standards, and policies enforcing these standards. When implemented correctly more ARCHIBUS functionality is achieved. For example the furniture standards counts are broken down and easily understood. Also, Color, height, depth, width, and costs can be used to calculate information for facilities and finance.

The granulated furniture standards usually include information in the standard such as color, size, manufacture, and description. Examples are shown below:

Furniture Standard

Description

BOOKCASE-3-SH-LG-HM

42×18 3 Shelf Book Case – Herman Miller

BOOKCASE-3-SH-SM-HM

36×18 3 Shelf Bookcase – Herman Miller

BOOKCASE-5-SHELF-HM

36×12 5-Shelf Bookcase – Herman Miller

CONF-SIDECHAIR1-HM

Side Chair for Conference (Type 1) – Herman Miller

CONF-SIDECHAIR2-HM

Side Chair for Conference (Type 2) – Herman Miller

CONF-SIDECHAIR3-HM

Side Chair for Conference (TYPE 3) – Herman Miller

FILE-LATERAL2-HM

2-Drawer Lateral File Cabinet – Herman Miller

FILE-LATERAL3-HM

3-Drawer Lateral File Cabinet – Herman Miller

FILE-LATERAL4-HM

4-Drawer Lateral File Cabinet – Herman Miller

FILE-LATERAL5-HM

5-Drawer Lateral File Cabinet – Herman Miller

FILE-VERT2-30-HM

2-Drawer File Cabinet 30″ deep – Herman Miller

FILE-VERT3-30-HM

3-Drawer File Cabinet 30″ deep – Herman Miller

PARTITION-108X2X42-HM

108″ long x 2″ thick x 42″ tall partition – Herman Miller

PARTITION-137X2X42-HM

137″ long x 2″ thick x 42″ tall partition – Herman Miller

PARTITION-21X2X42-HM

21″ long x 2″ thick x 42″ tall partition – Herman Miller

PARTITION-30X1X36-HM

30″ long x 1″ thick x 36″ tall partition – Herman Miller

PARTITION-66X1X36-HM

66″ long x 1″ thick x 36″ tall partition – Herman Miller

PARTITION-82X2X42-HM

82″ long x 2″ thick x 42″ tall partition – Herman Miller

PARTITION-94X2X42-HM

94″ long x 2″ thick x 42″ tall partition – Herman Miller

TABLE-CONF-096-HM

Conference Table – 8 ft. long – Herman Miller

TABLE-CONF-120-HM

Conference Table – 10 ft. long – Herman Miller

TABLE-CONF-144-HM

Conference Table – 12 ft. long – Herman Miller

TABLE-END-HM

End Table, 24×24, glass top – Herman Miller

TABLE-OBLONG-48-HM

48×24 Oblong Table – Herman Miller

TABLE-OBLONG-72-HM

72×36 Oblong Table – Herman Miller

TABLE-OFFICE-LARGE-HM

Executive Office Table – Herman Miller

TABLE-OFFICE-SMALL-HM

Office Table for Secretary – Herman Miller

TABLE-RECEPTION-HM

Table at Reception – Herman Miller

TABLE-ROUND-20-HM

20″ Diameter Round Table – Herman Miller

TABLE-ROUND-24-HM

24″ Diameter Round Table – Herman Miller

TABLE-ROUND-30-HM

30″ Diameter Round Table – Herman Miller

TABLE-ROUND-36-HM

36″ Diameter Round Table – Herman Miller

TABLE-SMALL COFFEE-HM

Small Coffee Table – Herman Miller

WORK SURFACE-24X36-HM

24″ x 36″ x 36″ high work surface – Herman Miller

WORK SURFACE-30X72-HM

30″ x 72″ x 36″ high work surface – Herman Miller

Pros

  • Good Furniture counts using standard ARCHIBUS.
  • Understand standard at a glance. This allows most individuals to understand the furniture using one field.
  • AutoCAD blocks can be assigned to each standard which look appropriate for each standard.
  • Can use out of the box furniture libraries such as CAPSPEC, midnight oil, etc.

Cons

  • Resource requirement is high.
  • Too many standards to wade through during inventory can cause confusion and inaccurate data.
  • Requires diligent monitoring and enforcement of Furniture standards.

MODEL NUMBER APPROACH:

Very similar to the granulated approach only using the manufactures model number. The following is an example:

Furniture Standard

Description

1425-L1

LATERAL-ALLSTEEL-4-DWR-RECESSED–STEEL-P05/WARM BEIGE-W/LOCK–18- /52-3/442- /

1428L1

LATERAL-ALLSTEEL-2-DWR-RECESSED–STEEL-P05/WARM BEIGE-W/LOCK–18- /27-3/442- /

1428L1(G)

LATERAL-ALLSTEEL-2-DWR-RECESSED–STEEL-P04/TAUPE-W/LOCK–18- /27-3/442- /

26-3620-2-NN(G)

LATERAL-MERIDIAN-2-DWR-FULL PULL–STEEL-P-998/GREIGE-W/LOCK-P-998/GREIGE-20- /26-1/436- /

26-3620-2EE(BK)

LATERAL-MERIDIAN-2-DRAWER-FULL PULL–STEEL-BLACK-W/LOCK–20- /29- /36- /

26-3620-2NN(BK)

LATERAL-MERIDIAN-2-DWR-FULL PULL–STEEL-BLACK-W/LOCK–20- /26-1/436- /

26-4218-3-NNN

LATERAL-MERIDIAN-3-DWR-STANDARD–STEEL-BLACK—18- /38- /42- /

26-4218-4-EEEE

LATERAL-MERIDIAN-4-DWR-STANDARD–STEEL-P71/LIGHT TONE—18- /55- /42- /

26-4220

LATERAL-MERIDIAN-2-DRAWER-FULL PULL–STEEL-P-52/NEUTRA-W/LOCK–20- /62- /42- /

26-4220-4-NNNN

LATERAL-MERIDIAN-4-DWR-FULL PULL–STEEL-P-52/NEUTRA-W/LOCK–20- /50- /42- /

26-Q4671BB

LOCKER-MERIDIAN-2-DWR/2-DOOR-FULL PULL–STEEL-P-52/NEUTRA-W/LOCK–20- /67- /30- /

A1125.8524N

TACK.ACOUST.BARRIER-HERMAN MILLER-FABRIC-PURPLE-FABRIC-PURPLE-STEEL-DT/DARK TONE-NON-POWER-2-1/485- /24- /

A1125.8524N(T)

TACK.ACOUST-BARRIER-HERMAN MILLER-FABRIC-TEAL-FABRIC-TEAL-STEEL-DT/DARK TONE-NON-POWERED-2-1/485- /24- /

A1125.8542N

TACK.ACOUST.BARRIER-HERMAN MILLER-FABRIC-PURPLE-FABRIC-PURPLE-STEEL-DT/DARK TONE-NON-POWER-2-1/485- /42- /

A1125.8542N(T)

TACK.ACOUST-BARRIER-HERMAN MILLER-FABRIC-TEAL-FABRIC-TEAL-STEEL-DT/DARK TONE-NON-POWERED-2-1/485- /42- /

A1125.8548E

TACK.ACOUST.BARRIER-HERMAN MILLER-FABRIC-PURPLE-FABRIC-PURPLE-STEEL-DT/DARK TONE-POWER-2-1/485- /48- /

A1125.8548N

TACK.ACOUST.BARRIER-HERMAN MILLER-FABRIC-PURPLE-FABRIC-PURPLE-STEEL-DT/DARK TONE-NON-POWER-2-1/485- /48- /

A1125.8548N(T)

TACK.ACOUST-BARRIER-HERMAN MILLER-FABRIC-TEAL-FABRIC-TEAL-STEEL-DT/DARK TONE-NON-POWERED-2-1/485- /48- /

A1160.6724N

GLAZED/HARD SURFACE-HERMAN MILLER-GLASS-TR/CLEAR-FABRIC-PURPLE-STEEL-BU/BLACK UMBER-NON-POWER-2- /67- /24- /

A1160.8524N

GLAZED-HERMAN MILLER-GLASS-TR/CLEAR—STEEL-BU/BLACK UMBER-NON-POWER-1-7/885- /24- /

A1160.8548N

GLAZED-HERMAN MILLER-GLASS-TR/CLEAR—STEEL-BU/BLACK UMBER-NON-POWER-1-7/885- /48- /

A1220.39H

2-WAY 90D-HERMAN MILLER-PLASTIC-BU/BLACK UMBER-STEEL-BU/BLACK UMBER-PLASTIC-BU/BLACK UMBER–3-1/238- /3-1/2

A1220.67H

2-WAY 90D-HERMAN MILLER-PLASTIC-BU/BLACK UMBER-STEEL-BU/BLACK UMBER-PLASTIC-BU/BLACK UMBER–3-1/267- /3-1/2

A1220.85H

2-WAY 90D-HERMAN MILLER-PLASTIC-BU/BLACK UMBER-STEEL-BU/BLACK UMBER-PLASTIC-BU/BLACK UMBER–3-1/285- /3-1/2

A1230.53H

3-WAY-HERMAN MILLER-PLASTIC-BLACK——3-1/253- /4-1/2

A1230.67H

3-WAY-HERMAN MILLER-PLASTIC-BU/BLACK UMBER-STEEL-BU/BLACK UMBER-PLASTIC-BU/BLACK UMBER–3-1/267- /3-1/2

A1230.85H

3-WAY-HERMAN MILLER-PLASTIC-BU/BLACK UMBER-STEEL-BU/BLACK UMBER-PLASTIC-BU/BLACK UMBER–3-1/285- /3-1/2

A1240.62H

4-WAY-HERMAN MILLER-PLASTIC-BU/BLACK UMBER-STEEL—–4-1/261-1/24-1/2

A1260.67H

CONNECTOR-HERMAN MILLER-ENAMELED-BLACK-METAL-BLACK-METAL-BLACK–0- /67- /3-1/2

T4(G)

BOOKCASE-MERIDIAN—-VENEER-P-998/GREIGE—15- /1-1/436- /

V2LT-HLC

VERTICAL-ALLSTEEL-2-DRAWER-HANDLE PULL–STEEL-P05/WARM BEIGE-W/LOCK–28-1/429- /14-7/8

V2LT-ILC

VERTICAL-ALLSTEEL-2-DRAWER-INTEGRAL PULL–STEEL-P05/WARM BEIGE-W/LOCK–28-1/429- /14-7/8

V4LT-1LC

VERTICAL-ALLSTEEL-4-DRAWER-INTEGRAL PULL–STEEL-P05/WARM BEIGE-W/LOCK–28- /48- /15- /

V4LT-HLC

VERTICAL-ALLSTEEL-4-DRAWER-HANDLE PULL–STEEL-P05/WARM BEIGE-W/LOCK–28- /52- /15- /

W304-000

MANAGEMENT TASK-ALLSTEEL-STANDARD/MOLDED-FABRIC-RED-5-STAR-STANDARD-STEEL-P71/BLACK-24- /35- /22-5/8

Pros

  • Good Furniture counts using standard ARCHIBUS.
  • AutoCAD blocks can be assigned to each standard which look appropriate for each standard.
  • Can use out of the box furniture libraries such as CAPSPEC, midnight oil, etc. Including writing LISP to automate the capture of this data from the AutoCAD drawings.

Cons

  • Resource requirement is high.
  • Too many standards to wade through during inventory can cause confusion and inaccurate data.
  • Requires diligent monitoring and enforcement of Furniture standards.
  • Very Confusing.

CONCLUSION

These approaches were developed to provide a basis for the CAFM Implementation. The suggestions are developed from best practices and RSC experience. Careful study and understanding is required to discover the fit to THE CLIENT and their needs. They should be reviewed and modified as required to meet the needs of THE CLIENT. RSC is prepared to implement the CAFM system upon review and signoff of these recommended standards.

RSC recommends the minimal furniture standard approach with the MicroView PDA data collection process. This will place the details in the inventory table and not the standards table.

Was this helpful?

0 / 0

Leave a Reply 0

Your email address will not be published. Required fields are marked *