產(chǎn)品成本自動(dòng)核算工具

營(yíng)銷實(shí)戰(zhàn)工具,,,,,,,,,,,,,

產(chǎn)品成本自動(dòng)核算工具（含預(yù)算與實(shí)際控制，全自動(dòng)計(jì)算）,,,,,,,,,,,,,

說(shuō)明：此表格主要用于產(chǎn)品成本核算，主要包括直接材料費(fèi)用、直接人工費(fèi)用、燃料及動(dòng)力費(fèi)用、制造費(fèi)用四大部分，包括預(yù)算與實(shí)際費(fèi)用的統(tǒng)計(jì)分析。產(chǎn)品成本核算，一方面有利于控制成本費(fèi)用，另一方面可以作為產(chǎn)品定價(jià)的重要依據(jù)。注：1.直接人工成本是按照工藝流程來(lái)計(jì)算的，也可以直接按照部門維度來(lái)進(jìn)行統(tǒng)計(jì)計(jì)算，但計(jì)量單位一般都統(tǒng)一為工時(shí)。2.所列費(fèi)用項(xiàng)目、計(jì)量單位、名稱設(shè)置等僅供參考，應(yīng)根據(jù)實(shí)際進(jìn)行調(diào)整；所列數(shù)據(jù)為模擬數(shù)值，請(qǐng)勿對(duì)號(hào)入座。3.顏色標(biāo)注部分已經(jīng)設(shè)置自動(dòng)公式，請(qǐng)勿錄入數(shù)據(jù)。,,,,,,,,,,,,,

產(chǎn)品成本自動(dòng)核算分析預(yù)算與實(shí)際控制,,,,,,統(tǒng)計(jì)項(xiàng)目,,預(yù)算成本,實(shí)際成本,增減比例,信息項(xiàng)目,產(chǎn)品基本信息,

,,,,,,直接材料費(fèi)用小計(jì),,21040.00,25930.00,23.24%,產(chǎn)品名稱,,

,,,,,,直接人工費(fèi)用小計(jì),,29420.00,35025.00,19.05%,產(chǎn)品規(guī)格,,

,,,,,,燃料及動(dòng)力費(fèi)用小計(jì),,24456.00,27100.00,10.81%,計(jì)量單位,,

,,,,,,制造費(fèi)用小計(jì),,36502.00,43905.00,20.28%,計(jì)劃生產(chǎn)數(shù)量,5000,

,,,,,,生產(chǎn)成本費(fèi)用總計(jì),,111418.00,131960.00,18.44%,實(shí)際生產(chǎn)數(shù)量,5600,

,,,,,,單位產(chǎn)品成本費(fèi)用,,￥22.28,￥23.56,5.75%,單價(jià),￥55.00,

成本費(fèi)用項(xiàng)目大類,費(fèi)用項(xiàng)目細(xì)分類,材料編碼,材料名稱,材料規(guī)格,計(jì)量單位,標(biāo)準(zhǔn)材料成本/預(yù)算直接材料成本,,,實(shí)際耗用直接材料成本,,,實(shí)際比預(yù)算增減幅度,

,,,,,,預(yù)計(jì)耗用數(shù)量,標(biāo)準(zhǔn)單價(jià),預(yù)算成本額,實(shí)際耗用數(shù)量,實(shí)際采購(gòu)單價(jià),實(shí)際成本金額,數(shù)量增減比例,成本金額增減比例

直接材料費(fèi)用,1.原材料1,,,,,5.00,500.00,2500.00,6.00,560.00,3360.00,20.00%,34.40%

,1.原材料2,,,,,6.00,740.00,4440.00,7.00,750.00,5250.00,16.67%,18.24%

,1.原材料3,,,,,18.00,320.00,5760.00,18.00,350.00,6300.00,0.00%,9.38%

,1.原材料4,,,,,15.00,556.00,8340.00,19.00,580.00,11020.00,26.67%,32.13%

,1.原材料5,,,,,,,0.00,,,0.00,,

,2.外購(gòu)半成品,,,,,,,0.00,,,0.00,,

,3.包裝材料,,,,,,,0.00,,,0.00,,

,,,,,,,,0.00,,,0.00,,

,,,,,,,,0.00,,,0.00,,

,,,,,,,,0.00,,,0.00,,

,直接材料費(fèi)用小計(jì)（含預(yù)算實(shí)際增減比例）,,,,,21040.00,,,25930.00,,,23.24%,

直接人工費(fèi)用,費(fèi)用項(xiàng)目細(xì)分類,生產(chǎn)/工藝流程編號(hào),工藝流程名稱,工藝流程標(biāo)準(zhǔn),計(jì)量單位（工時(shí)）,標(biāo)準(zhǔn)分?jǐn)側(cè)斯こ杀?預(yù)計(jì)分?jǐn)側(cè)斯こ杀?,,實(shí)際分?jǐn)側(cè)斯こ杀?,,實(shí)際比預(yù)算增減幅度,

,,,,,,預(yù)計(jì)分?jǐn)偤臅r(shí),標(biāo)準(zhǔn)單位工時(shí)成本,預(yù)算成本額,實(shí)際分?jǐn)偤挠霉r(shí),實(shí)際單位工時(shí)成本,實(shí)際成本金額,耗時(shí)增減比例,成本金額增減比例

,,,,,,120.00,50.00,6000.00,150.00,55.00,8250.00,25.00%,37.50%

,,,,,,260.00,45.00,11700.00,280.00,45.00,12600.00,7.69%,7.69%

,,,,,,140.00,38.00,5320.00,145.00,45.00,6525.00,3.57%,22.65%

,,,,,,80.00,80.00,6400.00,90.00,85.00,7650.00,12.50%,19.53%

,,,,,,,,0.00,,,0.00,,

,,,,,,,,0.00,,,0.00,,

,,,,,,,,0.00,,,0.00,,

,直接人工費(fèi)用小計(jì)（含預(yù)算實(shí)際增減比例）,,,,,29420.00,,,35025.00,,,19.05%,

燃料及動(dòng)力費(fèi)用,費(fèi)用項(xiàng)目細(xì)分類,燃料編碼/動(dòng)力編號(hào),燃料/動(dòng)力名稱,規(guī)格/標(biāo)準(zhǔn),計(jì)量單位,預(yù)計(jì)分?jǐn)側(cè)剂霞皠?dòng)力成本,,,實(shí)際分?jǐn)側(cè)剂霞皠?dòng)力成本,,,實(shí)際比預(yù)算增減幅度,

,,,,,,預(yù)計(jì)分?jǐn)倲?shù)量,標(biāo)準(zhǔn)單價(jià),預(yù)算成本額,實(shí)際分?jǐn)倲?shù)量,實(shí)際單價(jià),實(shí)際成本金額,數(shù)量增減比例,成本金額增減比例

,煤,,,,,10.00,680.00,6800.00,12.00,700.00,8400.00,20.00%,23.53%

,水,,,,,120.00,36.80,4416.00,150.00,35.00,5250.00,25.00%,18.89%

,電,,,,,360.00,29.00,10440.00,380.00,27.00,10260.00,5.56%,-1.72%

,柴油,,,,,56.00,50.00,2800.00,58.00,55.00,3190.00,3.57%,13.93%

,,,,,,,,0.00,,,0.00,,

,,,,,,,,0.00,,,0.00,,

,燃料及動(dòng)力費(fèi)用小計(jì)（含預(yù)算實(shí)際增減比例）,,,,,24456.00,,,27100.00,,,10.81%,

制造費(fèi)用,費(fèi)用項(xiàng)目細(xì)分類,編碼/編號(hào),名稱,規(guī)格/標(biāo)準(zhǔn),計(jì)量單位,計(jì)劃分?jǐn)傊圃熨M(fèi)用成本,,,實(shí)際分?jǐn)傊圃熨M(fèi)用成本,,,實(shí)際比預(yù)算增減幅度,

,,,,,,預(yù)計(jì)分?jǐn)倲?shù)量,標(biāo)準(zhǔn)單價(jià),預(yù)算成本額,實(shí)際耗用數(shù)量,實(shí)際單價(jià),實(shí)際成本金額,數(shù)量增減比例,成本金額增減比例

,間接材料1,,,,,56.00,12.00,672.00,55.00,13.00,715.00,-1.79%,6.40%

,間接材料2,,,,,6.00,99.00,594.00,9.00,120.00,1080.00,50.00%,81.82%

,間接材料3,,,,,82.00,43.00,3526.00,85.00,38.00,3230.00,3.66%,-8.39%

,間接人工——管理人員工資,,,,工時(shí),56.00,80.00,4480.00,60.00,89.00,5340.00,7.14%,19.20%

,間接人工——職工福利,,,,工時(shí),59.00,50.00,2950.00,62.00,50.00,3100.00,5.08%,5.08%

,勞動(dòng)保護(hù)費(fèi),,,,,6.00,500.00,3000.00,7.00,520.00,3640.00,16.67%,21.33%

,維修費(fèi),,,,,29.00,120.00,3480.00,36.00,150.00,5400.00,24.14%,55.17%

,房屋租賃費(fèi),,,,月,2.00,5000.00,10000.00,1.90,4800.00,9120.00,-5.00%,-8.80%

,固定資產(chǎn)折舊費(fèi),,,,,9.00,200.00,1800.00,12.00,190.00,2280.00,33.33%,26.67%

,設(shè)計(jì)制作費(fèi),,,,工時(shí),2.00,3000.00,6000.00,2.00,5000.00,10000.00,0.00%,66.67%

,研發(fā)分?jǐn)傎M(fèi),,,,工時(shí),,,0.00,,,0.00,,

,停工損失,,,,工時(shí),,,0.00,,,0.00,,

,低值易耗品,,,,,,,0.00,,,0.00,,

,物流運(yùn)輸費(fèi),,,,,,,0.00,,,0.00,,

,辦公費(fèi),,,,工時(shí),,,0.00,,,0.00,,

,差旅費(fèi),,,,工時(shí),,,0.00,,,0.00,,

,教育培訓(xùn)費(fèi),,,,工時(shí),,,0