汽车零部件采购-报价明细表

linmiaolove
0 ℃
2020-08-11

整理文档很辛苦，赏杯茶钱您下走！

还剩 ... 页未读，继续阅读 >>

免费阅读已结束，点击下载阅读编辑剩下 ... 页

阅读已结束，您可以下载文档离线阅读编辑

资源描述

CURRENCYҰJudiChina,Shanghai2014/2/181.SubcontractingQuantityScrapHandlingCostUnitPriceReference/Description(%)(%)1Packaging0.00010%0.07%0.00020.000Total(1)0.0002.RawMaterialGrossWeightorLengthNetWeightMaterialPriceScrapQuantityHandlingCostScrapresellingUnitPriceDescription(kgorm)(kg)(/kgor/m)(%)#(%)(/kg)14390.328810.19913.63.0%10.1%34.21320.000-0.019Total(2)4.1943.AddedValueCostCycleTimeEfficiencyScrapSetupToolUnitPriceOp.Operation/machinesecondOEE(%)(%)CostM&A1Washing7100%3.0%0.00000.0382Forming7100%3.0%0.00500.1003Triming7100%3.0%0.00500.1004Cutting7100%3.0%0.00500.1005Blanking2100%3.0%0.00000.0596Bending7100%3.0%0.00500.1007Packing2.4100%0.0%0.00000.0138Ctrl570%2.0%0.00000.00190.000Total(3)0.5134.Overhead&ProfitUnitPrice0.4590.0000.3030.000Total(4)0.7615.LogisticUnitPricePackaging0.000Transport0.000Valorisation&Consignement0.000OtherCost0.000Total(5)0.0006.ToolingUnitPriceToolingInvestment0.000Total(6)0.000INCOTERMPAIEMENTTERMLeadTimeinweeksSUPPLIERSIGNATUREProductionOverhead0.30255OtherCostAmortisedonpartpriceYes01NumberofCavitiesSUPPLIERBaffleJudiJudiREQUESTFORQUOTATIONCOMMENTValue160000DATEPRODUCTIONLOCATION0.45876PleasespecifyhereUnitPriceGeneralOverheadProfitSUPPLIERNAMEAnyREFERENCEDESCRIPTIONValueofInvestmentPiecePrice5.469(1)+(2)+(3)+(4)+(5)+(6)QUANTITYMachine19ProcessScrapResellIfYes,nbofpartfordepreciation19.960.3947.6847.6847.68103.2247.68CURRENCYҰChina,Shanghai2014/2/181.SubcontractingQuantityScrapHandlingCostUnitPriceReference/Description(%)(%)1Packaging0.00010%0.07%0.00020.000Total(1)0.0002.RawMaterialGrossWeightorLengthNetWeightMaterialPriceScrapQuantityHandlingCostScrapresellingUnitPriceDescription(kgorm)(kg)(/kgor/m)(%)#(%)(/kg)14390.328810.19913.63.0%10.1%34.21320.000-0.019Total(2)4.1943.AddedValueCostCycleTimeEfficiencyScrapSetupToolUnitPriceOp.Operation/machinesecondOEE(%)(%)CostM&A1Washing7100%3.0%0.00000.0382Forming7100%3.0%0.00500.1003Triming7100%3.0%0.00500.1004Cutting7100%3.0%0.00500.1005Blanking2100%3.0%0.00000.0596Bending7100%3.0%0.00500.1007Packing2.4100%0.0%0.00000.0138Ctrl570%2.0%0.00000.00190.000Total(3)0.5134.Overhead&ProfitUnitPrice0.4590.0000.3030.000Total(4)0.7615.LogisticUnitPricePackaging0.000Transport0.000Valorisation&Consignement0.000OtherCost0.000Total(5)0.0006.ToolingUnitPriceToolingInvestment0.000Total(6)0.000INCOTERMPAIEMENTTERMREQUESTFORQUOTATIONSUPPLIERREFERENCEBaffle47.68SUPPLIERNAMEUnitPricePRODUCTIONLOCATIONDESCRIPTIONDATEQUANTITY1600000.39Any47.6847.6847.68103.22ProcessScrapResellMachine1919.96Profit0.30255OtherCostPleasespecifyhereValueGeneralOverhead0.45876ProductionOverhead0YesAmortisedonpartpriceIfYes,nbofpartfordepreciationCOMMENTValueofInvestmentNumberofCavities1LeadTimeinweeksPiecePriceSUPPLIERSIGNATURE(1)+(2)+(3)+(4)+(5)+(6)5.469SUPPLIERJudiPRODUCTIONLOCATIONChina,ShanghaiDATE2014/2/18Ұ%Subcontracting0.000%RawMaterial4.1977%AddedValue0.519%Overhead&Other0.468%Profit0.306%Logistics0.000%TOTAL5.47COSTVIEWERANALYSIS:REALCOSTSTRUCTURECOSTVIEWERANALYSIS0%77%9%8%6%0%COSTVIEWERREALCOSTSTRUCTURESubcontractingRawMaterialAddedValueOverhead&OtherProfitLogisticsREFERENCEBaffleJudiDESCRIPTIONJudiQUANTITY160000COSTVIEWERANALYSISCUSTOMERRFQDELTAҰ%Subcontracting0.000.000.000.000.0%RawMaterial4.194.190.004.1976.7%AddedValue0.510.510.000.519.4%Overhead&Other0.460.460.000.468.4%Profit0.300.300.000.305.5%Logistics0.000.000.000.000.0%TOTAL5.475.470.005.47REALSTRUCTURECUSTOMERRFQANALYSIS:PROFITANALYSIS0%77%9%8%6%0%CUSTOMEROFFERCOSTSTRUTURESubcontractingRawMaterialAddedValueOverhead&OtherProfitLogisticsINVESTMENTҰ5.50%FINANCIALINTEREST0ҰDEPRECIATIONYearsPERPART0.000ҰSTARTYEAR1YEAR2YEAR3YEAR4YEAR5YEAR6YEAR7YEAR81600001600001600001600001600001600001600001600001600005.4695.4695.4695.4695.4695.4695.4695.4695.469048,40896,816145,224193,632242,040290,448338,856387,2640%0%0%0%0%0%0%0%0.0000.0000.0000.0000.0000.0000.0000.0000.000INVESTMENTDEPRECIATIONPERPARTCOMMERCIALPRICEREDUCTIONREQUESTFORQUOTATIONANALYSISFORMONLYMODIFY(ifrequired)WHITECELLS1.EnterInvestment(dedicated),DepreciationMUSTBEthesameasinCostViewerAnalysis2.Integratecommercialpricereductions3.Change(ifrequired)investmentdepreciationperpartQUANTITYPRICECASHFLOW(Depretiation+Profit)0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%5.5%5.5%5.5%5.5%5.5%5.5%5.5%5.5%5.5%13.9%13.9%13.9%13.9%13.9%13.9%13.9%13.9%13.9%0.0%2.0%4.0%6.0%8.0%10.0%12.0%14.0%16.0%STARTYEAR1YEAR2YEAR3YEAR4YEAR5YEAR6YEAR7YEAR8PRICEEVOLUTION(Depreciation+Commercial)PROFIT%CONTRIBUTION%050000100000150000200000250000300000350000400000450000500000STARTENDYEAR1ENDYEAR2ENDYEAR3ENDYEAR4ENDYEAR5ENDYEAR6ENDYEAR7ENDYEAR8CASHFLOW(DEPRECIATION)CASHFLOW(DEPRETIATION+PROFIT)CASHFLOW(DEPRETIATION+CONTRIBUTION)