OperationProcedure(A)ParameterSheet(1)Inputdataintocolredcells(2)Inputcustomername,partname,drawingno.,revision(3)Inputmaterialspecification(includetypeofmaterial,size,barstocklength,partoffwidth)(4)InputMachiningParametersProcessnameParametersa)RoughTurningb)2ndTurningc)MachiningCenterd)CenterlessGrindinge)HandMachiningf)Passivation/Cleaningno.ofworkpieceforeachrackg)Sub-contractpricefromsub-contractorforonepart(5)Allnon-coloredcellscalculatedautomatically(B)CostEstimationSheet(1)Inputdatasintocoloredcells(2)Inputreferenceno.andcostestimationsheetno.(3)Inputunitpriceofmaterial$/kg(4)Inputcuttingtoolscost$/workpiece(5)Inputpackingcost$/workpiece(6)InputEstimatedyield(7)Inputqtyrequiredpermonthfrommarketing(8)InputTooling/Fixturechargesandthatreturnperiod(howmanypartsinKunit)(9)Gradeselection(gradde1,2,3)ofRoughTurningand2ndTurning(C)UpdateUnitCost(1)Ifmanufacturing(roughturning,2ndturning,machiningcenter,centerlessgrinding,handmachining,passivationandcleaning)Unitcostormachineutilizationischanged.Youmustun-locktheworksheetwithpassword123tochangeUnitcostandMachineUtilizationbyhandtypingCycletimeforeachactioninprocessandno.oftimeofactionMachiningname,spindlespeed(RPM),feedrate,lengthformachining,no.oftimeformachining(6)Someformulahideinsomeblankcellswithremarks(redtrainglemarkattop-rightcornerofcell)CustomerInformationCustomer:0ProductName:0Ref.No.:DrawingNo.:0CostStimationSheetNo.:PartListItemNo.YieldCost(1)(2)(3)(4)(5)(6)(7)(8)(9)(10)TotalCost:HK$0.0000AssemblyProcessProcessNamePartNo.1PartNo.2PartNo.3PartNo.4PartNo.5PartNo.6PartNo.7PartNo.8PartNo.9PartNo.10OperationtimeYieldOperationCostHK$0.0000HK$0.0000HK$0.0000HK$0.0000TotalAssemblyCost:HK$0.000098%TotalCost:HK$0.0000PreparedBy:CheckedBy:ApprovedBy:Date:Date:Date:AssemblyYieldCostEstimationSheetinAssemblyProductPartNameMaterialHK$0.0000CostEstimationSheetRef.No.:Rev.:CostEstimationSheetNo.:Customer:Material:PartName:Specification:DrawingNo.:PARTARequirementUnitCostCostFixedCostVariableCost1RoughTurning0.00sHK$0.7331/min.HK$0.0000HK$0.0000HK$0.000022ndTurning0.00sHK$1.0539/min.HK$0.0000HK$0.0000HK$0.00003MachiningCenter0.00sHK$0.9097/min.HK$0.0000HK$0.0000HK$0.00004CenterlessGrinding0.00sHK$0.7809/min.HK$0.0000HK$0.0000HK$0.00005SurfaceTreatment0.00sHK$3.9155/min.HK$0.0000HK$0.0000HK$0.00001Material0.000gHK$0.00/KgHK$0.00002CuttingToolsHK$0.00003PackingHK$0.00004HandProcess0.00sHK$0.0676/min.HK$0.00005Sub-ContactcostHK$0.00006Transportcosts0.00gHK$7.54/KgHK$0.0000TotalCost:HK$0.0000HK$0.0000HK$0.0000EstimatedYield85%EstimationCost:HK$0.0000US$0.0000PARTBAdditionalInformations1DifficultyCoefficient(Grade1,2,3)2MachineGradesRoughTurning(Grade1,2,3)2ndTurningMachiningCenterCenterlessGrinding3Remarks:ReferencePrice:HK$0.0000US$0.0000是否考慮改機費?(Y/N)此報價沒計算運輸費SUS303HK$0.1000/min.SUS304HK$0.2000/min.SUS316LHK$0.2000/min.SUS630HK$0.1800/min.FreeCuttingSteelHK$0.0800/min.Brass/CopperHK$0.0500/min.AluminumHK$0.0300/min.PreparedBy:CheckedBy:ApprovedBy:Date:Date:Date:表格編號:ENG-108版本:AToolUnitCostCustomerInformationMachiningParametersCustomer:RoughTurningTotal:0.00sMachiningCenterTotal:0.00sPartName:DrawingNo.:TimeTimeRevisionCen.Drilling0.00sCen.Drilling0.00sDrilling0.00sDrilling0.00sMaterialSpecificationTapping0.00sTapping0.00sSteel/IronMilling0.00sMilling0.00sBrass/CopperKnurling0.00s0.00sAluminumR.Turning0.00s0.00sDieCastR.Boring0.00s0.00sF.Turning0.00s0.00sMaterialSizeF.Boring0.00sRoundGrooving0.00sODODmmXIDmmXLengthmmPartingoff0.00sTimeID0.00sCenterlessGrinding0.00sLength2ndTurningTotal:0.00sRectangleWidth(L)Width(L)mmXWidth(S)mmXLengthmmTimeTimeWidth(S)Cen.Drilling0.00sSurfaceTreatment0.00sLengthDrilling0.00sHexagonTapping0.00sHandMachiningTotal:0.00sWidth(FlattoFlat)Width(FlattoFlat)mmXLengthmmMilling0.00sLengthKnurling0.00sMaterialCalculationR.Turning0.00sDeburring0.00sBarLength0R.Boring0.00sTumbling0.00sPartoffWidth2.20mmF.Turning0.00sDrilling0.00sRelativeDensity0F.Boring0.00sTapping0.00sWeight(Round)0.000gGrooving0.00sSlotting0.00sWeight(Rectangle)0.000gPartingoff0.00sMilling0.00sWeight(Hexagon)0.000g0.00sPartingoff0.00s0FeedrateMachiningMachiningNameRPMFeedrateMachiningNewProductparametersCalcultedSheetMachiningNameRPMFeedrateMachiningNo.oftimeNo.oftimeNo.oftimeMachiningNameRPMTimeCycletimeNo.oftimeProcessNameCycletimeNo.oftimeCycletimeNo.oftime操作流程(A)參數頁(1)把數據輸入填了顏色的格(2)輸入客戶名稱,產品名稱,圖號,版本等(3)輸入材料規格(包括材料型號,尺寸,barstocklength,partoffwidth)(4)輸入機床參數工序參數a)粗車b)第二道車床c)加工中心d)無心磨e)手動加工f)鈍化/清洗每個清洗工裝可以裝的工件個數g)外發加工每個工件的外發加工單價(5)所有未填滿顏色的儲存格自動計算(B)估價頁(1)把數據輸入填了顏色的格(2)輸入表格編號及參考號碼(3)輸入材料單價$/kg(4)輸入刀具費用$/件(5)輸入包裝費用$/件(6)輸入預算產量(Estimatedyield)(7)輸入每月訂單數(8)InputTooling/Fixturechargesandthatreturnperiod(howmanypartsinKunit)(9)選擇加工難度(1.2.3級)(C)UpdateUnitCost(1)如果加工的標準單價費用發生變化(包括粗車,精車,加工中心,清洗,手動工序等)用密碼123解除表格鎖定並更改單價每一工步的周期時間和次數機床型號,名稱,主軸轉速(RPM),進給速度,加工長度,加工次數(6)部份空白儲存格內有公式。客戶信息客戶名稱:0產品名稱:0參考號:圖號:0報價表編號:產品清單序號Yield費用(1)(2)(3)(4)(5)(6)(7)(8)(9)(10)總價格HK$0.0000裝配工序工序名稱PartNo.1PartNo.2PartNo.3PartNo.4PartNo.5PartNo.6PartNo.7PartNo.8PartNo.9PartNo.10操作時間YieldOperationCostHK$0.0000HK$0.