Cost Breakdown PART - Download as Excel by ekf16301

VIEWS: 41 PAGES: 5

									                             Deutsch        TEILEBEZEICHUNG (a):                                           TEILE-NUMMER (e):                                    TEILE-INDEX (i):

                                            PROJEK (b):                                                    ANFRAGE-NUMMER (f):                                  MAßEINHEIT (k):
   COST BREAKDOWN                           LIEFERANTENNAME (c):                                           ANGEFRAGTE MENGE / JAHR (g):                         MAX. FERTIGUNGSKAPAZITÄT / TAG (l):
            TEIL                            PRODUKTIONSSTANDORT (d):                                       LIEFERADRESSE (h):                                   WÄHRUNG (m):


ROHMATERIAL / KAUFTEILE
MATERIALBEZEICHNUNG (1)       EINHEIT (2)   MATERIAL PREIS   MATERIAL         MATERIAL        SUMME (6)    MATERIALBEZEICHNUNG (1)                EINHEIT (2)    MATERIAL PREIS (3)     MATERIAL MENGE   MATERIAL          SUMME (6)
                                                 (3)       MENGE BRUTTO     MENGE NETTO                                                                                                   BRUTTO (4)      MENGE
                                                                (4)              (5)                                                                                                                     NETTO (5)

                                                                                                   0.000                                                                                                                    0.000
                                                                                                   0.000                                                                                                                    0.000
                                                                                                   0.000                                                                                                                    0.000
                                                                                                   0.000                                                                                                                    0.000
                                                                                                                                                                                      Gesamt (7):                           0.000

PROZESS
                                              ANZAHL DER                                                        ZYKLUS                    LOHNKOSTEN                     MASCHINENSTUNDENSATZ                        GESAMT
          FERTIGUNGSPROZESS (8)               WERKER (9)               MASCHINENTYP / GRÖßE (10)             ZEIT [MIN] (11)    PRO STUNDE (12)  GESAMT (13)       PRO STUNDE (14)     GESAMT (15)        PROZESSKOSTEN GESAMT (16)

                                                                                                                                                    0.00                                  0.00                       0.000
                                                                                                                                                    0.00                                  0.00                       0.000
                                                                                                                                                    0.00                                  0.00                       0.000
                                                                                                                                                    0.00                                  0.00                       0.000
                                                                                                                                                    0.00                                  0.00                       0.000
                                                                                                                                                                                      Gesamt (17):                   0.000
                                                                                          FERTIGUNGSKOSTEN GESAMT (18)                                                                                               0.000

SONSTIGES                                                                                 GEMEINKOSTEN
VERPACKUNG (29)                                                                           BESCHREIBUNG                                                                                          %

                                                                                          MATERIALGEMEINKOSTEN (19)
                                                                                          ALLE OVERHEAD-KOSTEN MATERIAL (20)
                                                                                          ALLE OVERHEAD-KOSTEN PROZESS (21)
ANZAHL TEILE / VERPACKUNG (30)                                                            GEWINN (22)
                                                                                          AMORTISATIONSKOSTEN R&D (23)                                             (wo zutreffend)
LIEFERANT / NAME / DATUM / UNTERSCHRIFT (31)                                              AMORTISATIONSKOSTEN WERKZEUGE (24)                                       (wo zutreffend)
                                                                                          VERPACKUNG (25)
                                                                                          TRANSPORT (26)
                                                                                          RABATTE (27)
                                                                                          VERKAUFSPREIS (28)                                                                                                         0.000




              eb8fa193-89a8-4676-ab4e-1a49dfef18dc.xls
              Cost Breakdown PART                                                                                                                                                                               9/5/2010
Instructions for completion of supplier piece cost breakdown worksheet

 #    Field description       Content / instructions                                                                                   Inhalt / Anleitung
 a    Description             Name of the part                                                                                         Teilebezeichnung
 b    Project                 Customer and Project code                                                                                Projektbezeichnung
 c    Supplier                Name of the issuing company                                                                              Lieferantenname
 d    Plant location          City and country of the production location of this part                                                 Produktionsstandort
 e    Part number             Webasto's part number                                                                                    Ident. Nummer
 f    RFQ number              Webasto's Request For Quotation number, if available                                                     Anfragenummer
 g    Volume quoted           Volumes on which the calculations are based                                                              Angefragte Menge/ Jahr
 h    FOB point               Location where the parts will be delivered at supplier's cost                                            Lieferadresse
 i    Issue level             Issue level of the drawing / specification                                                               Teile-Index (A, B, C etc)
 k    Unit of measure         Measurement unit for this part (pcs., meters, inches...)                                                 Maßeinheit des Produkts (St/ Satz/ L)
 l    Max. capacity /shifts   List max. capacity per working day and add no. of shifts (eg 1.000 / 3)                                  Max. Fertigungskapazität/ Tag
 m    Currency / rate         Fill in currency and add exchange rate, if applicable                                                    Währung (EUR etc.)
 1    Description             Identify the material and/or identify the name of the purchased component. Outside services (eg          Materialbezeichnung
                              heat treatment etc.). Include expendable packaging in this section
 2    Unit                    Show the unit of measurement, eg metres, pcs…                                                            Maßeinheit des Rohmaterials (kg, St. Etc.)
 3    Price per unit          Fill in your purchasing price per unit (eg 1,50 €/pc.). Subsuppliers quotations must be available        Rohmaterialpreis
                              upon request. If you are able to sell obsolete material for scrap prices, please list also and fill in
                              negative price (eg -2,50 €/kg
 4    Gross qty.              Gross quantity: How much material input is needed to produce one part                                    Wieviel Material ist brutto für die Teilefertigung notwendig
 5    Net qty.                Net quantity: How much material will be in the finished part                                             Wieviel Material ist netto für die Teilefertigung notwendig/ im Teil enthalten
 6    Subtotal                Self calculating: 3 x 5                                                                                  Selbstberechnend
 7    Total                   Self calculating: Sums up all subtotals (7)                                                              Selbstberechnend
 8    Operation               Identify each process step to produce the part                                                           Fertigungsprozess-Schritte bei Teilefertigung
 9    N° of workers           Fill in N° of workers involved for every single process step. If 1 worker covers several process      Anzahl der Arbeiter die für jeden einzelnen Fertigungsschritt notwendig sind (falls
                              steps, fill in the adequate share per step (i.e. 0,5 , if 1 worker covers 2 process steps at the same 2 oder mehr Arbeitsschritte von einen Arbeiter ausgeübt werden, bitte die
                              time with the same share of working time)                                                             Kapazität splitten, z.B. 0,5 Arbeiter für Prozess1, 0,5 Arbeiter für Prozess2)
 10   Machine type / size     List and describe the machine type and size for every process step (eg Battenfeld 450 tons)              Beschreibung Maschinentyp und Größe (z.B. Battenfeld 450 Tonnen)
 11   Cycle time              Fill in exact time for one production cycle for each process step (Minutes)                              Produktionszykluszeit für jeden einzelnen Prozess (pro Teil)
 12   Labour per hour         The hourly rate per worker, including all related costs (i.e. social overheads etc.)                     Stundensatz pro Arbeiter (inklusive aller Nebenkosten)
 13   Labour total            Self calculating: 9 x 11 x 12                                                                            Selbstberechnend: 9 x 11 x 12
 14   Machine per hour        The hourly rate for the machine including fixed (depreciation...) and variable (energy...) costs         Maschinenstundensatz (inklusive aller Nebenkosten)
 15   Machine total           Self calculating: 11 x 14                                                                                Selbstberechnend: 11 x 14
 16   Total process costs     Self calculating: 13 + 15                                                                                Selbstberechnend: 13 + 15
 17   Total                   Self calculating: sums up all 16                                                                         Selbstberechnend: sums up all 16
 18   Total manuf. costs      Self calculating: 7 + 17                                                                                 Selbstberechnend: 7 + 17
 19   On material             % and value of overheads for material handling, warehouse, logistics etc. added to material costs Materialgemeinkosten
                              (7)
 20   SG & A on material      All overheads (% of 7 and value) added to material costs                                          alle Overhead-Kosten bzgl. Material (7)
 21   costs A on process
      SG &                    All overheads (% of 17 and value) added to process costs                                                 alle Overhead-Kosten bzgl. Prozess (17)
 22   costs
      Profit                  Calculated profit (% of 28 and value)                                                                    kalkulierte Gewinnspanne (% von 28)
 23   R&D amortization        Amount of amortization for project specific R&D costs (general R&D costs to be included in 20            Amortizationskosten durch projektspezifische Forschung und Entwicklung
                              and 21), if applicable                                                                                   (allgemeine F&E - Kosten sind in Pos. 20 und 21 inbegriffen)
 24   Tooling amortization    Amount of amortization for project specific tooling costs (general costs for machines etc. to be         Amortizationskosten von projektspezifischen Werkzeugen (allgemeine
                              included in 14), if applicable                                                                           Maschinen-/ Anlagenkosten sind in Pos.14 inbegriffen)
 25   Packaging costs         Calculated amount for packaging as specified in 29 and 30)                                               Verpackungskosten
 26   Transport               Costs for transport until FOB point (see h)                                                              Transportkosten
 27   Discount                Any kind of discount if applicable                                                                       Rabatte
 28   Total selling price     Self calculating: 18 + 19 + 20 + 21 + 22 + 23 + 24 + 25 + 26 + 27                                        Selbstberechnend: 18 + 19 + 20 + 21 + 22 + 23 + 24 + 25 + 26 + 27
 29   Packaging type          Describe the type of packaging precisely                                                                 Genaue Verpackungsbezeichnung
 30   No of parts / package   How many parts are calculated to fit into one packaging unit                                             Anzahl Teile pro Ladungsträger
 31   Supplier ....           Name of issuing person, date and signature                                                               Aussteller des Cost-Break-downs mit Datum und Unterschrift
                                                        DESCRIPTION (a):           Lever                       PART NUMBER (e):                   123456         ISSUE LEVEL (i):                    B
                                                        PROJECT (b):               Example                     RFQ NO. (f):                         ABC          UNIT OF MEASURE (k):               pcs
        COST BREAKDOWN                                  SUPPLIER (c):              XXX                         VOLUME QUOTED (g):                 100,000        MAX. CAPACITY / SHIFTS (l):      10,000
                  PART                                  PLANT LOCATION (d):        Munich Germany              FOB POINT (h):                   Ex Works         CURRENCY / RATE (m):


RAW MATERIALS / PROCURED PARTS
DESCRIPTION (1)                          UNIT (2)       PRICE/UNIT (3) GROSS QTY. NET QTY. (5)   SUBTOTAL (6) DESCRIPTION (1)                      UNIT (2)      PRICE/UNIT (3)      GROSS QTY.   NET QTY.   SUBTOTAL
                                                                          (4)                                                                                                           (4)         (5)         (6)


H 360 LA EN 10 268 ( 1 x 150 x 170 )       kg               0.500          0.400      0.290           0.20                                                                                                       0.00
scrap                                      kg              -0.150                     0.110          -0.02                                                                                                       0.00
                                                                                                      0.00                                                                                                       0.00
                                                                                                      0.00                                                                                                       0.00
                                                                                                                                                                                     Total (7):                  0.18

PROCESS
                                                            N° OF                                                  CYCLE                  LABOUR                            MACHINE                       TOTAL
                     OPERATION (8)                       WORKERS(9)            MACHINE TYPE / SIZE (10)        TIME [MIN] (11) PER HOUR (12)     TOTAL (13)      PER HOUR (14)       TOTAL (15)   PROCESS COSTS (16)

set up (30 min)                                               1         Weingarten 630to.                           0.01          18.00             0.00             95.00             0.01               0.011
stamping 2 parts / stroke; 45 stroke / min                   0.5        Weingarten 630to.                           0.02          18.00             0.00             95.00             0.04               0.039
washing                                                      0.1        pass washing maschine                       0.01          15.00             0.00              7.00             0.00               0.001
vibratory grinding                                           0.1        Trowal                                      0.01          15.00             0.00              6.00             0.00               0.001
                                                                                                                                                    0.00                               0.00               0.000
                                                                                                                                                                                    Total (17):            0.05
                                                                                                 TOTAL MANUFACTURING COSTS (18):                                                                          0.24

OTHERS                                                                                           OVERHEADS
PACKAGING TYPE (Returnable / Expendable) (29)                                                    DESCRIPTION                                                                             %

                                                                                                 ON MATERIAL (WAREHOUSE, LOGISTICS...) (19)                                            2.5%               0.005
Returnable box                                                                                   SELLING, GENERAL AND ADMIN. ON MATERIAL COSTS(20)                                     4.0%               0.007
                                                                                                 SELLING, GENERAL AND ADMIN. ON PROCESS COSTS (21)                                     6.0%               0.003
NO. OF PARTS / PACKAGE (30)                                                                      PROFIT (22)                                                                           4.0%               0.002
400 Parts                                                                                        R&D AMORTIZATION (23)                         (If applicable)
SUPPLIER / NAME / DATE / SIGNATURE (31)                                                          TOOLING AMORTIZATION (24)                     (If applicable)
                                                                                                 PACKAGING (25)
X X X / X X X / 01.01.05                                                                         TRANSPORT (26)
                                                                                                 DISCOUNT (27)
                                                                                                 TOTAL SELLING PRICE (28)                                                                                 0.25




             eb8fa193-89a8-4676-ab4e-1a49dfef18dc.xls
             example stamping Part
                                                        DESCRIPTION (a):           Lever                       PART NUMBER (e):                   123456         ISSUE LEVEL (i):                    B
                                                        PROJECT (b):               Example                     RFQ NO. (f):                         ABC          UNIT OF MEASURE (k):               pcs
      COST BREAKDOWN                                    SUPPLIER (c):              XXX                         VOLUME QUOTED (g):                 100,000        MAX. CAPACITY / SHIFTS (l):       5,000
                                                        PLANT LOCATION (d):        Munich Germany              FOB POINT (h):                   Ex Works         CURRENCY / RATE (m):


RAW MATERIALS / PROCURED PARTS
DESCRIPTION (1)                          UNIT (2)       PRICE/UNIT (3) GROSS QTY. NET QTY. (5)   SUBTOTAL (6) DESCRIPTION (1)                      UNIT (2)      PRICE/UNIT (3)      GROSS QTY.   NET QTY.   SUBTOTAL
                                                                          (4)                                                                                                           (4)         (5)         (6)


EN AC - 4340                               kg              1.700           0.313      0.290         0.493                                                                                                      0.000
                                                                                                    0.000                                                                                                      0.000
                                                                                                    0.000                                                                                                      0.000
                                                                                                    0.000                                                                                                      0.000
                                                                                                                                                                                     Total (7):                0.49

PROCESS
                                                            N° OF                                                  CYCLE                  LABOUR                            MACHINE                        TOTAL
                    OPERATION (8)                        WORKERS(9)            MACHINE TYPE / SIZE (10)        TIME [MIN] (11) PER HOUR (12)     TOTAL (13)      PER HOUR (14)       TOTAL (15)   PROCESS COSTS (16)

set up (30 min)                                               1         Italpress 320to.                            0.01          18.00             0.00             95.00             0.01               0.014
die casting 4 Parts / cycle                                  0.5        Italpress 320to.                            0.17          18.00             0.03             95.00             0.26               0.289
to trim                                                      0.1        Exzenter Weingarten 120to.                  0.10          15.00             0.00              8.00             0.01               0.016
vibratory grinding                                           0.1        Trowal                                      0.03          15.00             0.00              6.00             0.00               0.003
                                                                                                                                                    0.00                               0.00               0.000
                                                                                                                                                                                    Total (17):            0.32
                                                                                                 TOTAL MANUFACTURING COSTS (18):                                                                           0.81

OTHERS                                                                                           OVERHEADS
PACKAGING TYPE (Returnable / Expendable) (29)                                                    DESCRIPTION                                                                             %

                                                                                                 ON MATERIAL (WAREHOUSE, LOGISTICS...) (19)                                            2.5%               0.012
Returnable box                                                                                   SELLING, GENERAL AND ADMIN. ON MATERIAL COSTS(20)                                     4.0%               0.020
                                                                                                 SELLING, GENERAL AND ADMIN. ON PROCESS COSTS (21)                                     6.0%               0.019
NO. OF PARTS / PACKAGE (30)                                                                      PROFIT (22)                                                                           4.0%               0.013
250 Parts                                                                                        R&D AMORTIZATION (23)                         (If applicable)
SUPPLIER / NAME / DATE / SIGNATURE (31)                                                          TOOLING AMORTIZATION (24)                     (If applicable)
                                                                                                 PACKAGING (25)
X X X / X X X / 01.01.05                                                                         TRANSPORT (26)
                                                                                                 DISCOUNT (27)
                                                                                                 TOTAL SELLING PRICE (28)                                                                                  0.88



             eb8fa193-89a8-4676-ab4e-1a49dfef18dc.xls
             example die casting
                                                        DESCRIPTION (a):           Lever                       PART NUMBER (e):                   123456         ISSUE LEVEL (i):                    B
                                                        PROJECT (b):               Example                     RFQ NO. (f):                         ABC          UNIT OF MEASURE (k):               pcs
      COST BREAKDOWN                                    SUPPLIER (c):              XXX                         VOLUME QUOTED (g):                 100,000        MAX. CAPACITY / SHIFTS (l):       5,000
                  PART                                  PLANT LOCATION (d):        Munich Germany              FOB POINT (h):                   Ex Works         CURRENCY / RATE (m):


RAW MATERIALS / PROCURED PARTS
DESCRIPTION (1)                          UNIT (2)       PRICE/UNIT (3) GROSS QTY. NET QTY. (5)   SUBTOTAL (6) DESCRIPTION (1)                      UNIT (2)      PRICE/UNIT (3)      GROSS QTY.   NET QTY.   SUBTOTAL
                                                                          (4)                                                                                                           (4)         (5)         (6)


POM Hastaform C9021 XAP                    kg              2.300           0.026      0.025          0.06                                                                                                         0.00
                                                                                                     0.00                                                                                                         0.00
                                                                                                     0.00                                                                                                         0.00
                                                                                                     0.00                                                                                                         0.00
                                                                                                                                                                                     Total (7):                   0.06

PROCESS
                                                            N° OF                                                  CYCLE                  LABOUR                            MACHINE                        TOTAL
                     OPERATION (8)                       WORKERS(9)            MACHINE TYPE / SIZE (10)        TIME [MIN] (11) PER HOUR (12)     TOTAL (13)      PER HOUR (14)       TOTAL (15)   PROCESS COSTS (16)

set up (30 min)                                               1         Engler 260to.                               0.00          18.00             0.00             95.00             0.01               0.007
injection molding 2 parts / cycle                            0.2        Engler 260to.                               0.25          18.00             0.02             95.00             0.40               0.411
                                                                                                                                                    0.00                               0.00               0.000
                                                                                                                                                    0.00                               0.00               0.000
                                                                                                                                                    0.00                               0.00               0.000
                                                                                                                                                                                    Total (17):            0.42
                                                                                                 TOTAL MANUFACTURING COSTS (18):                                                                           0.48

OTHERS                                                                                           OVERHEADS
PACKAGING TYPE (Returnable / Expendable) (29)                                                    DESCRIPTION                                                                             %

                                                                                                 ON MATERIAL (WAREHOUSE, LOGISTICS...) (19)                                            2.5%               0.001
Returnable box                                                                                   SELLING, GENERAL AND ADMIN. ON MATERIAL COSTS(20)                                     4.0%               0.002
                                                                                                 SELLING, GENERAL AND ADMIN. ON PROCESS COSTS (21)                                     6.0%               0.025
NO. OF PARTS / PACKAGE (30)                                                                      PROFIT (22)                                                                           4.0%               0.017
250 Parts                                                                                        R&D AMORTIZATION (23)                         (If applicable)
SUPPLIER / NAME / DATE / SIGNATURE (31)                                                          TOOLING AMORTIZATION (24)                     (If applicable)
                                                                                                 PACKAGING (25)
X X X / X X X / 01.01.05                                                                         TRANSPORT (26)
                                                                                                 DISCOUNT (27)
                                                                                                 TOTAL SELLING PRICE (28)                                                                                  0.52




             eb8fa193-89a8-4676-ab4e-1a49dfef18dc.xls
             example injection molding

								
To top