Excel Bill of Materials Template - Excel

Document Sample
Excel Bill of Materials Template - Excel Powered By Docstoc
					Bill of Materials                      Project Name

                            Finished size                                 Rough size       board
  # Name            thick       width    length     qty   material    thick width length    feet     totals
  1                                                          1          0     0      0      0.00
  2                                                          1          0     0      0      0.00
  3                                                          1          0     0      0      0.00
  4                                                          1          0     0      0      0.00
  5                                                          1          0     0      0      0.00
  6                                                          1          0     0      0      0.00
  7                                                          1          0     0      0      0.00
  8                                                          1          0     0      0      0.00
  9                                                          1          0     0      0      0.00
 10                                                          1          0     0      0      0.00

    * notes:                             Total      0

                                                                     Totals    3   bf    price     cost
                                                                  material 1   1    0.00     $0.00     $0.00
                                                                  material 2   2    0.00     $0.00     $0.00
                                    sq. per sheet   32        sheet material   3    0.00     $0.00     $0.00

                                                                                                       $0.00
Bill of Materials                               Coffee / Game Table                       Jeff Bratt

                                           Finished size                                       Rough size           board
 #    Name                         thick       width    length       qty   material        thick width length        feet     totals
 1    Leg                            2           2        17          4       2              2     2      17         1.89

 2  Front apron                           3/4    5         54        2        1              1         5      54     3.75     13.60
 3  Side apron                            3/4    5         20        2        1       *      1         5      20     1.39
 4  Front lower rail                      3/4    2         54        2        1              1         2      54     1.50
 5  Side lower rail                       3/4    2         20        2        1              1         2      20     0.56
 6  Center lower rail                     3/4    2         22        1        1              1         2      22     0.31
 7  Top support - side                    3/4    5         22 1/2    2        1              1         5      23     1.60
 8  Top support - center                  3/4    5         13        1        1              1         5      13     0.45
    Front facing
  9  left/right                           3/4    5         20        4        1       *      1         5      20     2.78
 10 center (drawer)                       3/4    5         14        2        1       *      1         5      14     0.97
 11 Drawer runner                         3/4    1         10 1/8    4        1              1         1      11     0.31

      Top                                                                                                                     7.15
 12   long side                       1          4         60        2        2              1         4      60     3.33
 13   short side                      1          5         26        2        2              1         5      26     1.81
 14   middle                          1         14         19        1        2       *      1         5      58     2.01
 15   insert support                      3/4    2         18        4        1              1         2      18     1.00

      Drawer                                                                                                                  2.67
 16   Front                               1/2    4         12 1/2    2        6              1          4     13     0.72
 17   Rear                                1/2    3 3/4     12 1/2    2        6              1          4     13     0.72
 18   Side                                1/2    4         10 3/4    4        6              1          4     11     1.22
 19   Bottom                              1/8   10 1/4     11 1/2    2        5              1         11     12     1.83
      Face - see #10                                                                         0          0      0     0.00

 20 Shelf                                 1/4   22         27 7/8    2        3              1         22     28     8.56

    Top inserts
 21 base - MDF                            1/2   17         17        3        4              1         17     17     6.02
 22 frame                                 1/2    1         18        8        6              1          1     18     1.00

      * notes:                                            Total      58
      match grain #3, 9, 10
      #9, 10 sawn out of a single board                                                 Totals         #    bf     price     cost
      #14 - glue up to width                                                     4/4 white oak         1     14.60     $4.50   $65.72
                                                                                 8/4 white oak         2      9.04     $5.25   $47.47
                                                                                 2/4 white oak         6      3.67 resawn from 8/4
                                                     sq. per sheet   32    1/4 in oak plywood          3      8.56    $15.00   $15.00
                                                     sq. per sheet   32            1/2 in MDF          4      6.02    $18.00   $18.00
                                                     sq. per sheet   32    1/8 in oak plywood          5      1.83    $15.00   $15.00
      How to use the template:
      Enter information for Name, Finished size, and quantity                                                                $161.19
        rough size and board feet are calculated automatically
      Put in additional items using the 'Add New Item' button…
      Enter the different materials needed, using the 'Add New…' buttons as required
      Enter a material number for each part in column 'G'
      For solid materials, enter price per board foot
      For sheet materials, enter price per sheet and square feet per sheet
        NOTE - thickness for sheet materials should be 1" or less (or the formulas will be wrong)
      The totals will reflect the quantities for each material and total cost
      Subtotals for assemblies can be added in the totals column using the Excel SUM function
      Insert blank lines using the Excel Insert Rows command, delete parts or materials using Delete Rows

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:363
posted:7/29/2010
language:English
pages:2
Description: Excel Bill of Materials Template document sample