2014_baja sae india costreporttemplate

Upload: monique-deleon

Post on 03-Jun-2018

217 views

Category:

Documents


0 download

TRANSCRIPT

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    1/71

    Objective-The objective of the cost report is to report the cost value (suggested retail price) of the items selected

    to build the car. The objective is notto report the cheapest price that an item can be purchased. For

    example, if two schools are using the same Gear Box they both should be reporting the same price,

    even though they might have purchased them for different prices, since both schools get the same

    value from the Gear Box.

    -The cost report should serve as two functions, (1) a bill of materials for the car, and (2) it should help

    equalize teams that choose to use items of high value with teams that use items of low value.

    -In industry it is very important to look at design and performance, as well as cost. Cost is the key

    driving force to many design decisions. If shocks are selected that cost Rs 1,00,000 the team should

    understand it will loose points in cost, but it might improve the score in the dynamic events. During

    design presentations these cost decisions should be discussed.

    Common Mistakes- Teams did not use the correct template; the only template that is allowed is the template which posted

    for that year. If you submit an older template you will receive a score of 0.

    - Teams found prices at discount companies that were not suggested retail prices. Remember to use

    the current retail price of all parts.

    - Teams did not get signatures on the summary cost page. It is required that you print out the summary

    cost with captain and advisor approval signatures. This must be scanned and placed in the PDF aspage #1.

    - Reports were not labeled correctly.

    - Make sure everything is filled out. Don't leave anything blank (quantities, descriptions, sub-assembly

    times, etc.).

    - Bring a printed copy of the cost report with you to competition.

    It also would be helpful to bring drawings of any components that are hidden or enclosed. For

    example, a exploded view of a transmission or the component drawings. This would help speed

    u an verification rocess.

    Submission of reportsAll reports MUST be done using that year's template. Only one electronic copy will need to be

    submitted by each team and this will be for all competitions in which the team is competing. The

    template must be submitted as an Excel file (.xls or .xlsx). Do not add pictures, drawings or other

    things that make this file larger.

    All supporting documents (i.e.: scanned copy of the summary cost sheet with signature, cost overview,

    cost sheets, pictures, ,receipts, drawings) should be included in the .PDF file. Only .PDF file will be

    scored.

    These files must be titled as specified in the rules. File size of PDF and EXCEL put together should not

    exceed 6 MB

    If the cost of your vehicle changes after you have submitted your cost report, then at registration you

    mustsubmit a "Cost Adjustment Form". When submitting this form you must have receipts or form

    "B" attached for each changed item. See the rules for more details on the Cost Adjustment form.

    DO NOT SUBMIT REPORTS EMBEDDED WITH

    MACROS IN THE FILE OR REPORTS WITH A .XLSMEXTENSION. REPORTS SUBMITTED IN THIS

    FORMAT WILL NOT BE GRADED.

    Foreign Teams

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    2/71

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    3/71

    Receipts, catalog pages, or other documentation of cost must be included in the .PDF. To help make

    the documentation clear and readable, each receipt must have the appropriate final cost circled. Each

    receipt should also have the section title, Form A line number, and Form B (if needed) line number

    clearly marked. All of these receipts must be included in the .PDF file. Documentation should be in

    the same order as presented in the report. For example, all the engine documentation first, followed by

    the transmission documentation, etc.

    Editing the worksheetsThe worksheets have been designed to be used by most teams with little modification. The majority ofthe teams will find that one or more of the worksheets is too short to cover all the components used in

    one functional area (Form A), fabricated items must be linked from Form B to Form A, or there are

    more fabrication items than shown (Form B). Therefore, it is expected that the spreadsheets will need

    to be modified. Use the following guidelines:

    -You MAY NOT change the column headings, the categories, or the summation methods.

    -You MAY add additional lines to accommodate your particular design. You may also need to add

    additional sections to a Form B (and the resulting line in the corresponding Form A) as required. Minor

    changes to the formatting of cells (i.e. visible decimal places) is permitted when necessary to

    communicate within Forms A and B. If you add lines, it is your responsibility to ensure that formulas

    pick up all additional lines and carry through the forms properly.

    Form A Issues and EditingYou may insert additional lines as required. As long as you insert the lines above the summation

    Formulas, the spreadsheet will pick up the costs in the new lines. You may need to renumber the lines;

    this has no effect on the cost rollup. Be careful that the line numbers match the appropriate Form B

    items. It is good practice to put all the Form B items at the top of the sheet, purchased items below.

    Be careful not to 'CUT' items or drag and drop. Use 'COPY' functions. Failure to do so may lead to

    dropped links to the final worksheet.

    Form B Issues and EditingTo add an additional section for a fabricated item, highlight lines 2 through 25, 'COPY', highlight the

    upper left corner below the last used section, and 'PASTE'. Be sure to add a page break above it and

    change the item number appropriately. Next, you will need to add the three links to the appropriateForm B. Go to the appropriate line on the appropriate Form B, highlight the 'Part Name' cell, enter an

    '=' to start a Formula, then (without completing the Formula) switch to Form B, find and highlight the

    new Part Name cell, and hit 'enter'. This will transfer the location and send you back to Form A. Repeat

    with materials and labor cost cells.

    There are two ways to calculate part costs on Form B: you can enter Density, Amount, Weight, and

    Rs/Unit, and the final cost will be calculated for you. Alternatively, you can leave the Density column

    blank and the cost will be calculated on the basis of Amount, and Rs/Unit.

    There may be some cases where the cost calculation does not fit your situation. Use your preferred

    calculation method, highlight the calculation in light yellow, and provide an explanation at the bottom of

    that page (Insert blank lines as required).

    The Amount should be the gross amount of material you started with, not the finished amount of

    material in the finished part. i.e. If you machine a full transmission case, use the weight of the starting

    billet, not the final case.

    Be careful not to 'CUT' items or drag and drop. Use 'COPY' functions. Failure to do so may lead to

    dropped links to the matching Form A.

    Check Page size, orientation and page break to ensure proper print/pdf

    SampleThere is a sample pair of Form A and Form B at the start of the worksheets. They are identical to the

    others with the exception that they do not roll up to the final worksheet.

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    4/71

    *Preferably, use SI standard for dimensions.

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    5/71

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    6/71

    Cost GuideThe cost should reflect the prototype vehicle brought to competition. Included in this amount is the cost for the

    Brigss and Straton engine, (use fixed price Rs. 25000, for the engine- to rationalise the price for all teams) but

    excluded are the costs of the required life preserver, helmet, and face shield. Anything that is in the vehicle at the

    time of technical inspection must be represented in the cost report. The prototype cost of the vehicle will be1. All purchased parts at full retail cost (INR), even if it was actually acquired with a discount or in a foreign country

    where the exchange rate would make it cheaper.2. Receipts for all components over Rs. 200 (Indian Rupees) must be included.

    (A) The receipts must be numbered and labeled, and included in the .PDF file. (B) The full retail cost of parts must be used in the Cost Report. Discounted or wholesale prices are not to be

    used. If a part is used,

    donated or discounted, the full retail cost for the part must still be used (or a part of similar specification).

    (C) The supplier/retailers phone number must be included with each receipt.

    (D) If the actual receipt for a part is not available, a photocopy of a page from a catalog of the part in question will

    be acceptable.

    (E) Receipts that are dated less than three (3) years prior to the Competition, i.e. no older than 3 years, are valid.

    Part prices must be current for that year (year of competition). (Provide current year quotations for the previous

    years purchased parts used in the car. And, support it with previous years original receipt. Use current years

    3. All modified purchased parts should use full retail cost, plus the cost of the modifications taken from the

    Operations Cost Table specified in the rule book appendix.

    4. Fabricated/Manufactured parts use the cost for the basic material from the Materials Cost Table (refer rule book,

    appendix); bearing in mind the weight must include any scrapfrom cutting or machining. If the material is notlisted in the table then a receipt for the material must be provided. The cost for making the part will then be added

    using the rates from the Operations Cost Table (refer rule book, appendix).

    5. Fabricated/Manufactured parts do not include design or setup time for your manufacturing, actual run time

    6. Assembly labor is to be cost at Rs. 50 per hour.

    (A) Assembly of a component is to be included in the cost of that component.

    (B) Assembly of components into a sub-assembly is to be listed as Sub-System Assembly Time(D13 on Form

    A) in the section

    that sub-assembly appears.

    (C) Assembly of a sub-assembly or assembly onto the vehicle is Vehicle Assembly Laborand should be

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    7/71

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    8/71

    0

    Material Labor Material1 Engine 0.00 25,000.00

    2 Transmission 0.00 0.00

    3 Drive Train 0.00 0.00

    4 Steering 0.00 0.00

    5 Suspension 0.00 0.00

    6 Frame 0.00 0.00

    7 Body 0.00 0.00

    8 Brakes 0.00 0.00

    9 Safety Equipment 0.00 0.00

    10 Electrical Equipment 0.00 0.00

    11 Fasteners 0.00 0.00

    12 Miscellaneous 0.00 0.00

    Rs0.00 Rs0.00 Rs0.00 Rs25,000.00

    2014 Baja SAE Cost Adjustment Form

    Car Number

    Total Cost (Rs)

    Sect#

    Item Description of change

    Subassembly Costs Sum of

    Adj.Sub

    1234

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    9/71

    Labor0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    Rs0.00

    otal

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    10/71

    Car Number

    Team Name

    Total Cost (Rs)

    1 Engine

    2 Transmission

    3 Drive Train

    4 Steering

    5 Suspension

    6 Frame

    7 Body8 Brakes

    9 Safety Equipment

    10 Electrical Equipment

    11 Fasteners

    12 Miscellaneous

    ;

    Team Captain:

    Financial Head:

    Level 1 Summary

    Sr.No.

    Item

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    11/71

    1234

    XYZ

    25000.00

    Engine, Engine Mountings, Engine Subframe, Fuel Tank, Exhaust System, Catalytic Convertor, Engine Oil,

    Gearbox, Clutches, Accelerator Pedal, CVT, Shift Mechanisms, Transmission Oil etc.

    Drive Shafts, Bearings, Axles, Tyres, Rims, Hub, etc.

    Steering Wheel, Intermediate Shafts, Gear Box, Tie Rods, etc.

    A Arms, Spindles, Shock Absorbers, Springs, etc.

    Structural Members, Roll Cage, Mounts, Firewall, Seat, etc.

    Outer Covering, Fenders, Skid Plates, etc.Mech/Hyd. Components, Pedals, Lines, Fittings, Fluid, etc.

    Kill Switch, Fire Extinguisher, Safety Harness, etc.

    Battery, Starter, Cables, Wiring, Safety Device, etc.

    Nuts, Bolts, Spring Washer, etc. (don't include fasteners in each subassembly, put the QTY of each variou

    Paint, Trim, etc. and other items.

    Date:

    2014 Baja SAE Off icial Cos ting

    Description

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    12/71

    Material Labor Time(min) Cost Material Labor

    25,000.00 0.00 0.00 0.00 25,000.00 0.00

    0.00 0.00 0.00 0.00 0.00 0.00

    0.00 0.00 0.00 0.00 0.00 0.00

    0.00 0.00 0.00 0.00 0.00 0.00

    0.00 0.00 0.00 0.00 0.00 0.00

    0.00 0.00 0.00 0.00 0.00 0.00

    0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00

    0.00 0.00 0.00 0.00 0.00 0.00

    0.00 0.00 0.00 0.00 0.00 0.00

    0.00 0.00 0.00 0.00 0.00 0.00

    0.00 0.00 0.00 0.00 0.00 0.00

    25,000.00 0.00 0.00 0.00 25,000.00 0.00

    Approval Date:

    Revision: A

    heet

    SubtotalSubassembly Costs

    Vehicle Assembly Labor

    Cost

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    13/71

    Sample Subsystem Form A

    Item Part Name Purc

    hased

    Fabr

    icated

    Vendor QtyMaterial

    Cost

    1 Roll Cage and rear frame X 1 134.53

    2 Seat Mounting X 1 2.75

    3 Bushings X MISC 1 100.00

    4

    5

    6

    7

    8

    9

    Subsystem Assembly Time (minutes) 5 Subsystem Assy CostTotals

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    14/71

    Labor Cost Exte

    nded

    Mate

    rialCost

    Labo

    rCost

    Exte

    ndedTotal

    5,625.00 134.53 5,625.00 5,759.53

    512.00 2.75 512.00 514.75

    0.00 100.00 0.00 100.00

    0.00 0.00 0.00

    0.00 0.00 0.00

    0.00 0.00 0.00

    0.00 0.00 0.00

    0.00 0.00 0.00

    0.00 0.00 0.00

    4.17 4.17237.28 6,141.17 6,374.28

    Total: 6,378.45

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    15/71

    Line 1 on Sample Subsystem Form A

    Description: Roll Cage and rear frame

    Material:

    Part Name Material Density Unit Amount Weight Rs/Unit

    1 Pipes Astm A106 Gr B 0.01 cm^3 209.36 1.65 79.75

    2 Pipes Astm A106 Gr B 0.01 cm^3 17.66 0.14 23.62

    Subtotal:

    Labor:

    Rs/Unit

    1 5.00

    2 40.00

    3 10.00

    4

    5

    6

    Subtotal:

    Material Total

    Labor Total

    To Form A Line 1 Subassembly Total

    Line 2 on Sample Subsystem Form A

    Description: Seat Mounting

    Material:

    Part Name Material Density Unit Amount Weight Rs/Unit

    1 Pipes ASTM A106 Gr B 0.01 cm^3 3.60 0.03 24.00

    2 Plates Mild Steel 0.01 cm^3 10.53 0.08 25.00

    Subtotal:

    Labor:

    Rs/Unit

    1 5.00

    2 5.00

    3 10.00

    4 3.00

    5 5.00

    6

    Subtotal:

    Material Total

    Labor TotalTo Form A Line 2 Subassembly Total

    Line 3 on Sample Subsystem Form A

    Description: Bushings

    Material:

    Engine Subsystem Form B

    Item

    Manufacturing Process Amount Unit

    Cut Pipes 957.00 cm

    Bending 6.00 bend

    Radiusing at ends 60.00 end

    Item

    Manufacturing Process Amount Unit

    Cut pipes 32.00 cm

    Cut plates 16.00 cm

    Radiusing at ends 2.00 end

    Drill Holes 4.00 hole (light)

    Weld plates 48.00 cm

    m

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    16/71

    Part Name Material Density Unit Amount Weight Rs/Unit

    1 Bushings piece 2.00 0.00 50.00

    2 0.00

    Subtotal:

    Labor:

    Rs/Unit

    1

    2

    3

    4

    5

    6

    Subtotal:

    Material Total

    Labor Total

    To Form A Line 3 Subassembly Total

    Ite

    Manufacturing Process Amount Unit

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    17/71

    Cost (Rs)

    131.25

    3.28

    134.53

    Cost (Rs)

    4785.00

    240.00

    600.00

    0.00

    0.00

    0.00

    5625.00

    134.53

    5625.00

    5759.53

    Cost (Rs)

    0.68

    2.07

    2.75

    Cost (Rs)

    160.00

    80.00

    20.00

    12.00

    240.00

    0.00

    512.00

    2.75

    512.00514.75

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    18/71

    Cost (Rs)

    100.00

    0.00

    100.00

    Cost (Rs)

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    100.00

    0.00

    100.00

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    19/71

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    20/71

    Engine Subsystem Form A

    Item Part Name Purchased

    Fabricated

    Vendor Qty

    Material

    Cost Labor CostExtended

    MaterialCost

    LaborCost

    ExtendedTotal

    1 Engine X 1 25,000.00 25,000.00 0.00 25,000.0

    2 Engine Mountings X 0.00 0.00 0.0

    3 Drive Shaft X 0.00 0.00 0.0

    4 0.00 0.00 0.0

    5 0.00 0.00 0.0

    6 0.00 0.00 0.0

    7 0.00 0.00 0.0

    8 0.00 0.00 0.0

    9 0.00 0.00 0.0

    Subsystem Assembly Time (minutes) 0 Subsystem Assy Cost 0.00 0.0

    Totals 25,000.00 0.00 25,000.0

    Total: 25,000.0

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    21/71

    Line 1 on Engine Subsystem Form A

    Description: (From Sheet "A")

    Material:

    Part Name Material Density Unit Amount Weight Rs/Unit

    1 0.00

    2 0.00

    Subtotal:

    Labor:

    Rs/Unit

    1

    2

    3

    4

    5

    6

    Subtotal:

    Material TotalLabor Total

    To Form A Line 1 Subassembly Total

    Line 2 on Engine Subsystem Form A

    Description: (From Sheet "A")

    Material:

    Part Name Material Density Unit Amount Weight Rs/Unit

    1 0.00

    2 0.00

    Subtotal:

    Labor:

    Rs/Unit

    1

    2

    3

    4

    5

    6

    Subtotal:

    Material Total

    Labor Total

    To Form A Line 2 Subassembly Total

    Line 3 on Engine Subsystem Form A

    Description: (From Sheet "A")

    Material:

    Part Name Material Density Unit Amount Weight Rs/Unit

    1 0.00

    Item

    Item

    Manufacturing Process Amount Unit

    Engine Subsystem Form B

    Item

    Manufacturing Process Amount Unit

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    22/71

    2 0.00

    Subtotal:

    Labor:

    Rs/Unit

    1

    2

    3

    45

    6

    Subtotal:

    Material Total

    Labor Total

    To Form A Line 3 Subassembly Total

    Manufacturing Process Amount Unit

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    23/71

    Cost (Rs)

    0.00

    0.00

    0.00

    Cost (Rs)

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    0.000.00

    0.00

    Cost (Rs)

    0.00

    0.00

    0.00

    Cost (Rs)

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    Cost (Rs)

    0.00

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    24/71

    0.00

    0.00

    Cost (Rs)

    0.00

    0.00

    0.00

    0.000.00

    0.00

    0.00

    0.00

    0.00

    0.00

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    25/71

    Transmission Subsystem Form A

    Item Part Name Purchased

    Fabricated

    Vendor Qty

    Material

    Cost Labor Cost Extended

    MaterialCost

    LaborCost

    ExtendedTotal

    1 0.00 0.00 0.00

    2 0.00 0.00 0.00

    3 0.00 0.00 0.00

    4 0.00 0.00 0.00

    5 0.00 0.00 0.00

    6 0.00 0.00 0.00

    7 0.00 0.00 0.00

    8 0.00 0.00 0.00

    9 0.00 0.00 0.00

    Subsystem Assembly Time (minutes) 0 Subsystem Assy Cost 0.00 0.00

    Totals 0.00 0.00 0.00

    Total: 0.00

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    26/71

    Line 1 on Transmission Subsystem Form A

    Description: (From Sheet "A")

    Material:

    Part Name Material Density Unit Amount Weight

    1 0.00

    2 0.00

    Labor:

    1

    2

    3

    4

    5

    6

    To Form A Line 1

    Line 2 on Transmission Subsystem Form A

    Description: (From Sheet "A")

    Material:

    Part Name Material Density Unit Amount Weight

    1 0.00

    2 0.00

    Labor:

    1

    2

    3

    4

    5

    6

    To Form A Line 2

    Item

    Manufacturing Process Amount Unit

    Item

    Transmission Subsystem Form B

    Manufacturing Process Amount Unit

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    27/71

    Line 3 on Transmission Subsystem Form A

    Description: (From Sheet "A")

    Material:

    Part Name Material Density Unit Amount Weight

    1 0.002 0.00

    Labor:

    1

    2

    3

    4

    5

    6

    To Form A Line 3

    Item

    Manufacturing Process Amount Unit

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    28/71

    Rs/Unit Cost (Rs)

    0.00

    0.00

    Subtotal: 0.00

    Rs/Unit Cost (Rs)

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    Subtotal: 0.00

    Material Total 0.00

    Labor Total 0.00

    Subassembly Total 0.00

    Rs/Unit Cost (Rs)

    0.00

    0.00

    Subtotal: 0.00

    Rs/Unit Cost (Rs)

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    Subtotal: 0.00

    Material Total 0.00

    Labor Total 0.00

    Subassembly Total 0.00

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    29/71

    Rs/Unit Cost (Rs)

    0.000.00

    Subtotal: 0.00

    Rs/Unit Cost (Rs)

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    Subtotal: 0.00

    Material Total 0.00

    Labor Total 0.00

    Subassembly Total 0.00

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    30/71

    Drive Subsystem Form A

    Item Part Name Purchased

    Fabricated

    Vendor Qty

    Material

    Cost Labor Cost Extended

    MaterialCost

    LaborCost

    ExtendedTotal

    1 0.00 0.00 0.0

    2 0.00 0.00 0.0

    3 0.00 0.00 0.0

    4 0.00 0.00 0.0

    5 0.00 0.00 0.0

    6 0.00 0.00 0.0

    7 0.00 0.00 0.0

    8 0.00 0.00 0.0

    9 0.00 0.00 0.0

    Subsystem Assembly Time (minutes) 0 Subsystem Assy Cost 0.00 0.0

    Totals 0.00 0.00 0.0

    Total: 0.0

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    31/71

    Line 1 on Drive Subsystem Form A

    Description: (From Sheet "A")

    Material:

    Part Name Material Density Unit Amount Weight

    1 0.00

    2 0.00

    Labor:

    1

    2

    3

    4

    5

    6

    To Form A Line 1

    Line 2 on Drive Subsystem Form A

    Description: (From Sheet "A")

    Material:

    Part Name Material Density Unit Amount Weight

    1 0.00

    2 0.00

    Labor:

    1

    2

    3

    4

    5

    6

    To Form A Line 2

    Item

    Manufacturing Process Amount Unit

    Drive Subsystem Form B

    Item

    Manufacturing Process Amount Unit

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    32/71

    Line 3 on Drive Subsystem Form A

    Description: (From Sheet "A")

    Material:

    Part Name Material Density Unit Amount Weight

    1 0.002 0.00

    Labor:

    1

    2

    3

    4

    5

    6

    To Form A Line 3

    Item

    Manufacturing Process Amount Unit

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    33/71

    Rs/Unit Cost (Rs)

    0.00

    0.00

    Subtotal: 0.00

    Rs/Unit Cost (Rs)

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    Subtotal: 0.00

    Material Total 0.00

    Labor Total 0.00

    Subassembly Total 0.00

    Rs/Unit Cost (Rs)

    0.00

    0.00

    Subtotal: 0.00

    Rs/Unit Cost (Rs)

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    Subtotal: 0.00

    Material Total 0.00

    Labor Total 0.00

    Subassembly Total 0.00

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    34/71

    Rs/Unit Cost (Rs)

    0.000.00

    Subtotal: 0.00

    Rs/Unit Cost (Rs)

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    Subtotal: 0.00

    Material Total 0.00

    Labor Total 0.00

    Subassembly Total 0.00

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    35/71

    Steering Subsystem Form A

    Item Part Name Purchased

    Fabricated

    Vendor Qty

    Material

    Cost Labor Cost Extended

    MaterialCost

    LaborCost

    ExtendedTotal

    1 0.00 0.00 0.002 0.00 0.00 0.00

    3 0.00 0.00 0.00

    4 0.00 0.00 0.00

    5 0.00 0.00 0.00

    6 0.00 0.00 0.00

    7 0.00 0.00 0.00

    8 0.00 0.00 0.00

    9 0.00 0.00 0.00

    Subsystem Assembly Time (minutes) 0 Subsystem Assy Cost 0.00 0.00

    Totals 0.00 0.00 0.00

    Total: 0.00

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    36/71

    Line 1 on Steering Subsystem Form A

    Description: (From Sheet "A")

    Material:

    Part Name Material Density Unit Amount Weight Rs/Unit

    1 0.00

    2 0.00

    Subtotal:

    Labor:

    Rs/Unit

    1

    2

    3

    4

    5

    6

    Subtotal:

    Material Total

    Labor Total

    To Form A Line 1 Subassembly

    Line 2 on Steering Subsystem Form A

    Description: (From Sheet "A")

    Material:

    Part Name Material Density Unit Amount Weight Rs/Unit

    1 0.00

    2 0.00

    Subtotal:

    Labor:

    Rs/Unit

    1

    2

    3

    4

    5

    6

    Subtotal:

    Material Total

    Labor Total

    To Form A Line 2 Subassembly

    Item

    Manufacturing Process Amount Unit

    Item

    Steering Subsystem Form B

    Manufacturing Process Amount Unit

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    37/71

    Line 3 on Steering Subsystem Form A

    Description: (From Sheet "A")

    Material:

    Part Name Material Density Unit Amount Weight Rs/Unit

    1 0.002 0.00

    Subtotal:

    Labor:

    Rs/Unit

    1

    2

    3

    4

    5

    6

    Subtotal:

    Material Total

    Labor Total

    To Form A Line 3 Subassembly

    Item

    Manufacturing Process Amount Unit

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    38/71

    Cost (Rs)

    0.00

    0.00

    0.00

    Cost (Rs)

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    Cost (Rs)

    0.00

    0.00

    0.00

    Cost (Rs)

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    39/71

    Cost (Rs)

    0.000.00

    0.00

    Cost (Rs)

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    40/71

    Suspension Subsystem Form A

    Item Part Name Purchased

    Fabricated

    Vendor Qty

    Material

    Cost Labor Cost Extended

    MaterialCost

    LaborCost

    ExtendedTotal

    1 0.00 0.00 0.002 0.00 0.00 0.00

    3 0.00 0.00 0.00

    4 0.00 0.00 0.00

    5 0.00 0.00 0.00

    6 0.00 0.00 0.00

    7 0.00 0.00 0.00

    8 0.00 0.00 0.00

    9 0.00 0.00 0.00

    Subsystem Assembly Time (minutes) 0 Subsystem Assy Cost 0.00 0.00

    Totals 0.00 0.00 0.00

    Total: 0.00

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    41/71

    Line 1 onSuspension Subsystem Form A

    Description: (From Sheet "A")

    Material:

    Part Name Material Density Unit Amount Weight

    1 0.002 0.00

    Labor:

    1

    2

    3

    4

    5

    6

    To Form A Line 1

    Line 2 on Suspension Subsystem Form A

    Description: (From Sheet "A")

    Material:

    Part Name Material Density Unit Amount Weight

    1 0.00

    2 0.00

    Labor:

    1

    2

    3

    4

    5

    6

    To Form A Line 2

    Line 3 on Suspension Subsystem Form A

    Description: (From Sheet "A")

    Amount UnitManufacturing Process

    Item

    Suspension Subsystem Form B

    Item

    Manufacturing Process Amount Unit

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    42/71

    Material:

    Part Name Material Density Unit Amount Weight

    1 0.00

    2 0.00

    Labor:

    1

    2

    3

    4

    5

    6

    To Form A Line 3

    Item

    Manufacturing Process Amount Unit

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    43/71

    Rs/Unit Cost (Rs)

    0.000.00

    Subtotal: 0.00

    Rs/Unit Cost (Rs)

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    Subtotal: 0.00

    Material Total 0.00

    Labor Total 0.00

    Subassembly Total 0.00

    Rs/Unit Cost (Rs)

    0.00

    0.00

    Subtotal: 0.00

    Rs/Unit Cost (Rs)

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    Subtotal: 0.00

    Material Total 0.00

    Labor Total 0.00

    Subassembly Total 0.00

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    44/71

    Rs/Unit Cost (Rs)

    0.00

    0.00

    Subtotal: 0.00

    Rs/Unit Cost (Rs)

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    Subtotal: 0.00

    Material Total 0.00

    Labor Total 0.00

    Subassembly Total 0.00

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    45/71

    Frame Subsystem Form A

    Item Part Name Purchased

    Fabricated

    Vendor Qty

    Material

    Cost Labor Cost Extended

    MaterialCost

    LaborCost

    ExtendedTotal

    1 0.00 0.00 0.002 0.00 0.00 0.00

    3 0.00 0.00 0.00

    4 0.00 0.00 0.00

    5 0.00 0.00 0.00

    6 0.00 0.00 0.00

    7 0.00 0.00 0.00

    8 0.00 0.00 0.00

    9 0.00 0.00 0.00

    Subsystem Assembly Time (minutes) 0 Subsystem Assy Cost 0.00 0.00

    Totals 0.00 0.00 0.00

    Total: 0.00

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    46/71

    Line 1 on Frame Subsystem Form A

    Description: (From Sheet "A")

    Material:

    Part Name Material Density Unit Amount

    1

    2

    Labor:

    1

    2

    3

    4

    5

    6

    To Form A Line

    Line 2 on Frame Subsystem Form A

    Description: (From Sheet "A")

    Material:

    Part Name Material Density Unit Amount

    1

    2

    Labor:

    1

    2

    3

    4

    5

    6

    To Form A Line

    Item

    Manufacturing Process Amount U

    Frame Subsystem Form B

    Item

    Manufacturing Process Amount U

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    47/71

    Line 3 on Frame Subsystem Form A

    Description: (From Sheet "A")

    Material:

    Part Name Material Density Unit Amount

    12

    Labor:

    1

    2

    3

    4

    5

    6

    To Form A Line

    Item

    Manufacturing Process Amount U

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    48/71

    Weight Rs/Unit Cost (Rs)

    0.00 0.00

    0.00 0.00

    Subtotal: 0.00

    Rs/Unit Cost (Rs)

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    Subtotal: 0.00

    Material Total 0.00

    Labor Total 0.00

    1 Subassembly Total 0.00

    Weight Rs/Unit Cost (Rs)

    0.00 0.00

    0.00 0.00

    Subtotal: 0.00

    Rs/Unit Cost (Rs)

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    Subtotal: 0.00

    Material Total 0.00

    Labor Total 0.00

    2 Subassembly Total 0.00

    it

    it

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    49/71

    Weight Rs/Unit Cost (Rs)

    0.00 0.000.00 0.00

    Subtotal: 0.00

    Rs/Unit Cost (Rs)

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    Subtotal: 0.00

    Material Total 0.00

    Labor Total 0.00

    3 Subassembly Total 0.00

    it

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    50/71

    Body Subsystem Form A

    Item Part Name Purchased

    Fabricated

    Vendor Qty

    Material

    Cost Labor Cost Extended

    MaterialCost

    LaborCost

    ExtendedTotal

    1 0.00 0.00 0.0

    2 0.00 0.00 0.0

    3 0.00 0.00 0.0

    4 0.00 0.00 0.0

    5 0.00 0.00 0.0

    6 0.00 0.00 0.0

    7 0.00 0.00 0.0

    8 0.00 0.00 0.0

    9 0.00 0.00 0.0

    Subsystem Assembly Time (minutes) 0 Subsystem Assy Cost 0.00 0.0

    Totals 0.00 0.00 0.0

    Total: 0.0

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    51/71

    Body Subsystem Form B

    Line 1 on Body Subsystem Form A

    Description: (From Sheet "A")

    Material:

    Part Name Material Density Unit Amount Weight Rs/Unit

    1 0.00

    2 0.00Subtotal:

    Labor:

    Rs/Unit

    1

    2

    3

    4

    5

    6

    Subtotal:

    Material Total

    Labor Total

    To Form A Line 1 Subassembly Total

    Line 2 on Body Subsystem Form A

    Description: (From Sheet "A")

    Material:

    Part Name Material Density Unit Amount Weight Rs/Unit

    1 0.00

    2 0.00Subtotal:

    Labor:

    Rs/Unit

    1

    2

    3

    4

    5

    6

    Subtotal:

    Material Total

    Labor Total

    To Form A Line 2 Subassembly Total

    Line 3 on Body Subsystem Form A

    Description: (From Sheet "A")

    Item

    Manufacturing Process Amount Unit

    Item

    Manufacturing Process Amount Unit

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    52/71

    Material:

    Part Name Material Density Unit Amount Weight Rs/Unit

    1 0.00

    2 0.00

    Subtotal:

    Labor:

    Rs/Unit1

    2

    3

    4

    5

    6

    Subtotal:

    Material Total

    Labor Total

    To Form A Line 3 Subassembly Total

    Item

    Manufacturing Process Amount Unit

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    53/71

    Cost (Rs)

    0.00

    0.000.00

    Cost (Rs)

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    Cost (Rs)

    0.00

    0.000.00

    Cost (Rs)

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    54/71

    Cost (Rs)

    0.00

    0.00

    0.00

    Cost (Rs)0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    55/71

    Brakes Subsystem Form A

    Item Part Name Purchased

    Fabricated

    Vendor Qty

    Material

    Cost Labor Cost Extended

    MaterialCost

    LaborCost

    ExtendedTotal

    1 0.00 0.00 0.002 0.00 0.00 0.00

    3 0.00 0.00 0.00

    4 0.00 0.00 0.00

    5 0.00 0.00 0.00

    6 0.00 0.00 0.00

    7 0.00 0.00 0.00

    8 0.00 0.00 0.00

    9 0.00 0.00 0.00

    Subsystem Assembly Time (minutes) 0 Subsystem Assy Cost 0.00 0.00

    Totals 0.00 0.00 0.00

    Total: 0.00

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    56/71

    Brakes Subsystem Form B

    Line 1 on Brakes Subsystem Form A

    Description: (From Sheet "A")

    Material:

    Part Name Material Density Unit Amount Weight

    1 0.002 0.00

    Labor:

    1

    2

    3

    4

    5

    6

    To Form A Line 1

    Line 2 on Brakes Subsystem Form A

    Description: (From Sheet "A")

    Material:

    Part Name Material Density Unit Amount Weight

    1 0.00

    2 0.00

    Labor:

    1

    2

    3

    4

    5

    6

    To Form A Line 2

    Item

    Manufacturing Process Amount Unit

    Item

    Manufacturing Process Amount Unit

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    57/71

    Line 3 on Brakes Subsystem Form A

    Description: (From Sheet "A")

    Material:

    Part Name Material Density Unit Amount Weight

    1 0.00

    2 0.00

    Labor:

    1

    2

    3

    4

    5

    6

    To Form A Line 3

    Item

    Manufacturing Process Amount Unit

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    58/71

    Rs/Unit Cost (Rs)

    0.000.00

    Subtotal: 0.00

    Rs/Unit Cost (Rs)

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    Subtotal: 0.00

    Material Total 0.00

    Labor Total 0.00

    Subassembly Total 0.00

    Rs/Unit Cost (Rs)

    0.00

    0.00

    Subtotal: 0.00

    Rs/Unit Cost (Rs)

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    Subtotal: 0.00

    Material Total 0.00

    Labor Total 0.00

    Subassembly Total 0.00

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    59/71

    Rs/Unit Cost (Rs)

    0.00

    0.00Subtotal: 0.00

    Rs/Unit Cost (Rs)

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    Subtotal: 0.00

    Material Total 0.00

    Labor Total 0.00

    Subassembly Total 0.00

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    60/71

    Safety Equipment Subsystem Form A

    Item Part Name Purchased

    Fabricated

    Vendor Qty

    Material

    Cost Labor Cost Extended

    MaterialCost

    LaborCost

    ExtendedTotal

    1 0.00 0.00 0.002 0.00 0.00 0.00

    3 0.00 0.00 0.00

    4 0.00 0.00 0.00

    5 0.00 0.00 0.00

    6 0.00 0.00 0.00

    7 0.00 0.00 0.00

    8 0.00 0.00 0.00

    9 0.00 0.00 0.00

    Subsystem Assembly Time (minutes) 0 Subsystem Assy Cost 0.00 0.00

    Totals 0.00 0.00 0.00

    Total: 0.00

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    61/71

    Safety Equipment Subsystem Form B

    Line 1 on Safety Equipment Subsystem Form A

    Description: (From Sheet "A")

    Material:

    Part Name Material Density Unit Amount Weight

    1 0.002 0.00

    Labor:

    1

    2

    3

    4

    5

    6

    To Form A Line 1

    Line 2 on Safety Equipment Subsystem Form A

    Description: (From Sheet "A")

    Material:

    Part Name Material Density Unit Amount Weight

    1 0.00

    2 0.00

    Labor:

    1

    2

    3

    4

    5

    6

    To Form A Line 2

    Item

    Manufacturing Process Amount Unit

    Item

    Manufacturing Process Amount Unit

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    62/71

    Line 3 on Safety Equipment Subsystem Form A

    Description: (From Sheet "A")

    Material:

    Part Name Material Density Unit Amount Weight

    1 0.00

    2 0.00

    Labor:

    1

    2

    3

    4

    5

    6

    To Form A Line 3

    Item

    Manufacturing Process Amount Unit

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    63/71

    Rs/Unit Cost (Rs)

    0.000.00

    Subtotal: 0.00

    Rs/Unit Cost (Rs)

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    Subtotal: 0.00

    Material Total 0.00

    Labor Total 0.00

    Subassembly Total 0.00

    Rs/Unit Cost (Rs)

    0.00

    0.00

    Subtotal: 0.00

    Rs/Unit Cost (Rs)

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    Subtotal: 0.00

    Material Total 0.00

    Labor Total 0.00

    Subassembly Total 0.00

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    64/71

    Rs/Unit Cost (Rs)

    0.00

    0.00Subtotal: 0.00

    Rs/Unit Cost (Rs)

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    Subtotal: 0.00

    Material Total 0.00

    Labor Total 0.00

    Subassembly Total 0.00

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    65/71

    Electrical Subsystem Form A

    Item Part Name Purchased

    Fabricated

    Vendor Qty

    Material

    Cost Labor Cost Extended

    MaterialCost

    LaborCost

    ExtendedTotal

    1 0.00 0.00 0.00

    2 0.00 0.00 0.00

    3 0.00 0.00 0.00

    4 0.00 0.00 0.00

    5 0.00 0.00 0.00

    6 0.00 0.00 0.00

    7 0.00 0.00 0.00

    8 0.00 0.00 0.00

    9 0.00 0.00 0.00

    Subsystem Assembly Time (minutes) 0 Subsystem Assy Cost 0.00 0.00

    Totals 0.00 0.00 0.00

    Total: 0.00

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    66/71

    Fasteners Subsystem Form A

    Item Part Name Purchased

    Fabricated

    Vendor Qty

    Material

    Cost Labor Cost Extended

    MaterialCost

    LaborCost

    ExtendedTotal

    1 0.00 0.002 0.00 0.00

    3 0.00 0.00

    4 0.00 0.00

    5 0.00 0.00

    6 0.00 0.00

    7 0.00 0.00

    8 0.00 0.00

    9 0.00 0.00

    Subsystem Assembly Time (minutes) 0 Subsystem Assy Cost 0.00 0.00

    Totals 0.00 0.00 0.00

    Total: 0.00

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    67/71

    Miscellaneous Items Form A

    Item Part Name Purchased

    Fabricated

    Vendor Qty

    Material

    Cost Labor Cost Extended

    MaterialCost

    LaborCost

    ExtendedTotal

    1 0.00 0.00 0.00

    2 0.00 0.00 0.00

    3 0.00 0.00 0.00

    4 0.00 0.00 0.00

    5 0.00 0.00 0.00

    6 0.00 0.00 0.00

    7 0.00 0.00 0.00

    8 0.00 0.00 0.00

    9 0.00 0.00 0.00

    Subsystem Assembly Time (minutes) 0 Subsystem Assy Cost 0.00 0.00

    Totals 0.00 0.00 0.00

    Total: 0.00

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    68/71

    Miscellaneous Items Form B

    Line 1 on Miscellaneous Items Form A

    Description: (From Sheet "A")

    Material:

    Part Name Material Density Unit Amount Weight

    1 0.002 0.00

    Labor:

    1

    2

    3

    4

    5

    6

    To Form A Line 1

    Line 2 on Miscellaneous Items Form A

    Description: (From Sheet "A")

    Material:

    Part Name Material Density Unit Amount Weight

    1 0.00

    2 0.00

    Labor:

    1

    2

    3

    4

    5

    6

    To Form A Line 2

    Item

    Manufacturing Process Amount Unit

    Item

    Manufacturing Process Amount Unit

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    69/71

    Line 3 on Miscellaneous Items Form A

    Description: (From Sheet "A")

    Material:

    Part Name Material Density Unit Amount Weight

    1

    2

    Labor:

    1

    2

    3

    4

    5

    6

    To Form A Line 3

    Item

    Manufacturing Process Amount Unit

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    70/71

    Rs/Unit Cost (Rs)

    0.000.00

    Subtotal: 0.00

    Rs/Unit Cost (Rs)

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    Subtotal: 0.00

    Material Total 0.00

    Labor Total 0.00

    Subassembly Total 0.00

    Rs/Unit Cost (Rs)

    0.00

    0.00

    Subtotal: 0.00

    Rs/Unit Cost (Rs)

    0.00

    0.00

    0.00

    0.00

    0.00

    0.00

    Subtotal: 0.00

    Material Total 0.00

    Labor Total 0.00

    Subassembly Total 0.00

  • 8/12/2019 2014_Baja SAE India CostReportTemplate

    71/71

    Rs/Unit Cost

    Rs0.00

    Rs0.00Subtotal: Rs0.00

    Rs/Unit Cost

    Rs0.00

    Rs0.00

    Rs0.00

    Rs0.00

    Rs0.00

    Rs0.00

    Subtotal: Rs0.00

    Material Total Rs0.00

    Labor Total Rs0.00

    Subassembly Total Rs0.00