机加工产品报价计算表

1、Operation Procedure(A) Parameter Sheet(1) Input data into colred cells(2) Input customer name, part name , drawing no. , revision(3) Input material specification (include type of material , size , bar stock length , part off width)(4) Input Machining ParametersProcess nameParametersa) Rough TurningM

2、achining name , spindle speed(RPM) , feedrate ,length for machining , no. of time for machiningb) 2nd Turningc) Machining Centerd) Centerless GrindingCycle time for each action in process and no. oftime of actione) Hand Machiningf) Passivation / Cleaningno. of workpiece for each rackg) Sub-contractp

3、rice from sub-contractor for one part(5) All non-colored cells calculated automatically(6) Some formula hide in some blank cells with remarks(red traingle mark at top-right corner of cell)(B) Cost Estimation Sheet(1) Input datas into colored cells(2) Input reference no. and cost estimation sheet no.

4、(3) Input unit price of material $/kg(4) Input cutting tools cost $/workpiece(5) Input packing cost $/workpiece(6) Input Estimated yield(7) Input qty required per month from marketing(8) Input Tooling/Fixture charges and that return period(how many parts in K unit)(9) Grade selection(gradde 1,2,3) o

5、f Rough Turning and 2nd Turning(C) Update Unit Cost(1) If manufacturing(rough turning , 2nd turning , machining center , centerless grinding , hand machining ,passivation and cleaning) Unit cost or machine utilization is changed. You must un-lock the work sheet withpassword 123 to change Unit cost a

6、nd Machine Utilization by hand typing(6) Some formula hide in some blank cells with remarks(red traingle mark at top-right corner of cell)(1) If manufacturing(rough turning , 2nd turning , machining center , centerless grinding , hand machining ,passivation and cleaning) Unit cost or machine utiliza

7、tion is changed. You must un-lock the work sheet withpassword 123 to change Unit cost and Machine Utilization by hand typingCost Estimation Sheet in Assembly ProductCustomer InformationCustomer : 0Product Name : 0Ref. No. : Drawing No. : 0Cost Stimation Sheet No. : Part ListItem No.Part NameMaterial

8、Yield(1)(2)(3)(4)(5)(6)(7)(8)(9)(10)Total Cost:Assembly ProcessProcessNamePart No. 1Part No. 2Part No. 3Part No. 4Part No. 5Part No. 6Part No. 7Part No. 8Part No. 9Part No. 10OperationtimeYieldOperationCostHK$0.0000HK$0.0000HK$0.0000HK$0.0000Total Assembly Cost : Assembly YieldTotal Cost : Prepared

9、By :Checked By : Approved By : Date :DateDate : : Date : CostHK$0.0000HK$0.0000HK$0.000098%98%HK$0.0000Cost Estimation Sheet in Assembly Product Cost Estimation SheetRef. No. :Rev. :Cost Estimation Sheet No. : Customer :Material : Part Name :Specification : Drawing No. :PART ARequirementUnit Cost Co

10、stFixed Cost1 1Rough Turning0.00s0.00sHK$0.7331/min.HK$0.7331/min.HK$0.0000HK$0.0000HK$0.0000HK$0.00002 22nd Turning0.00s0.00sHK$1.0539/min.HK$1.0539/min.HK$0.0000HK$0.0000HK$0.0000HK$0.00003 3Machining Center0.00s0.00sHK$0.9097/min.HK$0.9097/min.HK$0.0000HK$0.0000HK$0.0000HK$0.00004 4Centerless Gri

11、nding0.00s0.00sHK$0.7809/min.HK$0.7809/min.HK$0.0000HK$0.0000HK$0.0000HK$0.00005 5Surface Treatment0.00s0.00sHK$3.9155/min.HK$3.9155/min.HK$0.0000HK$0.0000HK$0.0000HK$0.00001 1Material0.000g0.000gHK$0.00/KgHK$0.00/Kg2 2Cutting Tools3 3Packing4 4Hand Process0.00s0.00sHK$0.0676/min.HK$0.0676/min.5 5Su

12、b-Contact cost6 6Transport costs0.00g0.00gHK$7.54/KgHK$7.54/KgTotal Cost : H HK K$ $0 0. .0 00 00 00 0H HK K$ $0 0. .0 00 00 00 0Estimated Yield85%85%Estimation Cost : PART BAdditional Informations1 1Difficulty Coefficient(Grade 1,2,3)2 2Machine GradesRough Turning(Grade 1,2,3)2nd TurningMachining C

13、enterCenterless Grinding3 3Remarks: Reference Price:HK$0.0000US$0.0000是是否否考考慮慮改改機機費費？ (Y/N)此此報報價價沒沒計計算算運運輸輸費費Tool Unit CostSUS303SUS304SUS316LSUS630Free Cutting SteelBrass / CopperAluminumPrepared By: Checked By: Approved By:Date : Date : Date :表格編號： ENG-108 版本： AVariable CostHK$0.0000HK$0.0000HK$0.

14、0000HK$0.0000HK$0.0000HK$0.0000HK$0.0000HK$0.0000HK$0.0000HK$0.0000HK$0.0000HK$0.0000HK$0.0000HK$0.0000HK$0.0000HK$0.0000HK$0.0000HK$0.0000HK$0.0000HK$0.0000HK$0.0000HK$0.0000HK$0.0000HK$0.0000HK$0.0000HK$0.0000US$0.0000US$0.0000HK$0.1000/min.HK$0.1000/min.HK$0.2000/min.HK$0.2000/min.HK$0.2000/min.H

15、K$0.2000/min.HK$0.1800/min.HK$0.1800/min.HK$0.0800/min.HK$0.0800/min.HK$0.0500/min.HK$0.0500/min.HK$0.0300/min.HK$0.0300/min.此此報報價價沒沒計計算算運運輸輸費費Tool Unit CostNew Product parameters Calculted SheetCustomer InformationMachining ParametersCustomer : Rough TurningTotal :0 0. .0 00 0s sMachining CenterTot

16、al :Part Name :MachiningNameRPMFeedrateMachining LengthNo. oftimeMachiningNameRPMFeedrateMachining LengthNo. oftimeDrawing No. :TimeRevisionCen. Drilling0.00sCen. DrillingDrilling0.00sDrillingMaterial SpecificationTapping0.00sTappingSteel / IronMilling0.00sMillingBrass / CopperKnurling0.00sAluminumR

17、.Turning0.00sDie CastR.Boring0.00sF.Turning0.00sMaterial SizeF.Boring0.00sRoundGrooving0.00sCycletimeNo. oftimeODOD mmXID mmXLength mm Parting off0.00sID0.00sCenterless GrindingLength2nd TurningTotal :0 0. .0 00 0s sRectangleMachiningNameRPMFeedrateMachining LengthNo. oftimeCycletimeNo. oftimeWidth(

18、L)Width(L) mmXWidth(S) mmXLength mm TimeWidth(S)Cen. Drilling0.00sSurface TreatmentLengthDrilling0.00sHexagonTapping0.00sHand MachiningTotal :Width(Flat to Flat)Width(Flat to Flat) mmXLength mm Milling0.00sProcess NameCycletimeNo. oftimeLengthKnurling0.00sMaterial CalculationR.Turning0.00sDeburringB

19、ar Length0R.Boring0.00sTumblingPart off Width2.20mmF.Turning0.00sDrillingRelative Density0F.Boring0.00sTappingWeight(Round)0.000gGrooving0.00sSlottingWeight(Rectangle)0.000gParting off0.00sMillingWeight(Hexagon)0.000g0.00sParting off00 0. .0 00 0s sTime0.00s0.00s0.00s0.00s0.00s0.00s0.00s0.00sTime0 0

20、. .0 00 0s sTime0 0. .0 00 0s s0 0. .0 00 0s sTime0.00s0.00s0.00s0.00s0.00s0.00s0.00sNew Product parameters Calculted Sheet操操作作流流程程(A)參參數數頁頁(1)把數據輸入填了顏色的格(2)輸入 客戶名稱，產品名稱，圖號，版本等(3)輸入材料規格 (包括材料型號，尺寸， bar stock length , part off width)(4)輸入機床參數工序參數a) 粗車機床型號，名稱，主軸轉速(RPM) ,進給速度, 加工長度 , 加工次數b) 第二道車床c) 加工中

21、心d) 無心磨每一工步的周期時間和次數e) 手動加工f) 鈍化/清洗每個清洗工裝可以裝的工件個數g) 外發加工每個工件的外發加工單價(5) 所有未填滿顏色的儲存格自動計算(6) 部份空白儲存格內有公式。(B) 估估價價頁頁(1)把數據輸入填了顏色的格(2) 輸入表格編號及參考號碼(3)輸入材料單價 $/kg(4) 輸入刀具費用 $/件(5) 輸入包裝費用 $/件(6)輸入預算產量（Estimated yield）(7) 輸入每月訂單數(8) Input Tooling/Fixture charges and that return period(how many parts in K unit

22、)(9) 選擇加工難度（1.2.3級）(C) Update Unit Cost(1) 如果加工的標準單價費用發生變化（包括粗車，精車，加工中心，清洗，手動工序等）用密碼123解除表格鎖定並更改單價(6) 部份空白儲存格內有公式。(1) 如果加工的標準單價費用發生變化（包括粗車，精車，加工中心，清洗，手動工序等）用密碼123解除表格鎖定並更改單價裝裝配配工工件件估估價價表表客客戶戶信信息息客戶名稱 : 0產品名稱 : 0參考號 : 圖號 : 0報價表編號: 產產品品清清單單序號產品名稱材質Yield(1)(2)(3)(4)(5)(6)(7)(8)(9)(10)總價格裝裝配配工工序序工序名稱Par

23、t No. 1Part No. 2Part No. 3Part No. 4Part No. 5Part No. 6Part No. 7Part No. 8Part No. 9Part No. 10操作時間YieldOperationCostHK$0.0000HK$0.0000HK$0.0000HK$0.0000總裝配價格Assembly Yield總價格Prepared By :Checked By : Approved By : Date :DateDate : : Date : 費用HK$0.0000HK$0.0000HK$0.000098%98%HK$0.0000裝裝配配工工件件估估價價

24、表表價價格格預預算算表表Ref. No. :Rev. :Cost Estimation Sheet No. : 客客戶戶名名稱稱 :材材質質產產品品名名稱稱規規格格圖圖號號PART ARequirement單單價價價價格格Fixed Cost1 1精精車車0.00s0.00sHK$0.7331/min.HK$0.7331/min.HK$0.0000HK$0.0000HK$0.0000HK$0.00002 22nd Turning0.00s0.00sHK$1.0539/min.HK$1.0539/min.HK$0.0000HK$0.0000HK$0.0000HK$0.00003 3加加工工中中心

25、心0.00s0.00sHK$0.9097/min.HK$0.9097/min.HK$0.0000HK$0.0000HK$0.0000HK$0.00004 4無無心心磨磨0.00s0.00sHK$0.7809/min.HK$0.7809/min.HK$0.0000HK$0.0000HK$0.0000HK$0.00005 5表表面面處處理理0.00s0.00sHK$3.9155/min.HK$3.9155/min.HK$0.0000HK$0.0000HK$0.0000HK$0.00001 1材材質質0.000g0.000gHK$0.00/KgHK$0.00/Kg2 2刀刀具具3 3包包裝裝4 4手

26、手動動0.00s0.00sHK$0.0676/min.HK$0.0676/min.5 5外外包包單單價價6 6運運費費0.00g0.00gHK$7.54/KgHK$7.54/Kg總總價價H HK K$ $0 0. .0 00 00 00 0H HK K$ $0 0. .0 00 00 00 0Estimated Yield85%85%Estimation Cost : PART B附附加加說說明明1 1加加工工難難度度系系數數(Grade 1,2,3)2 2機機床床等等級級粗粗車車(Grade 1,2,3)2nd Turning加加工工中中心心無無心心磨磨3 3備備注注參參考考價價格格:HK$

27、0.0000US$0.0000是是否否考考慮慮改改機機費費？ (Y/N)此此報報價價沒沒計計算算運運輸輸費費合合計計單單價價SUS303SUS304SUS316LSUS630Free Cutting SteelBrass / CopperAluminumPrepared By: Checked By: Approved By:Date : Date : Date :表格編號： ENG-108 版本： AVariable CostHK$0.0000HK$0.0000HK$0.0000HK$0.0000HK$0.0000HK$0.0000HK$0.0000HK$0.0000HK$0.0000HK$

28、0.0000HK$0.0000HK$0.0000HK$0.0000HK$0.0000HK$0.0000HK$0.0000HK$0.0000HK$0.0000HK$0.0000HK$0.0000HK$0.0000HK$0.0000HK$0.0000HK$0.0000HK$0.0000HK$0.0000US$0.0000US$0.0000HK$0.1000/min.HK$0.1000/min.HK$0.2000/min.HK$0.2000/min.HK$0.2000/min.HK$0.2000/min.HK$0.1800/min.HK$0.1800/min.HK$0.0800/min.HK$0.0

29、800/min.HK$0.0500/min.HK$0.0500/min.HK$0.0300/min.HK$0.0300/min.此此報報價價沒沒計計算算運運輸輸費費合合計計單單價價新新產產品品參參數數計計算算表表Customer InformationMachining ParametersCustomer : Rough TurningTotal :0 0. .0 00 0s sMachining CenterTotal :Part Name :MachiningNameRPMFeedrateMachining LengthNo. oftimeMachiningNameRPMFeedrateMachining LengthNo. oftimeDrawing No. :TimeRevisionCen. Drilling0.00sCen. DrillingDrilling0.00sDrillingMaterial SpecificationTapping0.00sTappingSteel / IronMilling0.00sMillingBrass / CopperKnurling0.00sAluminumR.Turning0.