混凝土成本计算

原材料名称库号消耗数量合计单价金额单位成本单位消耗量（KG/方）单耗比例%粉料配合比水泥1578.881430.673009.55315948008.2573.29232.679.54%67.59%粉煤灰388.61384.53773.1410480406.566.2259.772.45%17.36%矿粉318.19291.8161025015250011.7947.161.93%13.70%外加剂28.570.04231.4160.0222800168061.612.994.640.19%1.35%粉料小计4452.7121348976.41104.29344.2414.11%100.00%废石砂5100.915493.4710594.3846487341.4837.68819.0533.57%废卵石1022.211199.142221.353679968.66.18171.737.04%细石（瓜子片）1484.941506.62991.5452155560.0812.03231.279.48%碎石3976.014315.188291.1957472597.8336.54640.9926.27%水3009.593009.59000.00232.679.54%28551.1722544444.4196.712439.95100.00%制造费（修理、租赁费）129357.6983067.60柴油1293517.222248217.20水电费129352.8536864.752.85成本项价格元/吨销售费用129352258702.00水泥315管理费用1293581034808.00粉煤灰104487002.7537.65矿粉2503031447.15234.36外加剂2800折旧444195.3134.34废石砂46摊销36100.942.79废卵石36工资26000020.10细石（瓜子片）52职工保费340002.63碎石57南京银行50000000.00945833.333333.54水0龙河100000000.009900006.96制造费（修理、租赁费）7.611800000柴油17.2水电费2.850.00销售费用2910129.583370.36管理费用83941576.733304.67300129352833660849.05712935-280727.677制表：顾忠林盈亏平衡点（方/月）3月成本核算情况注：此表只需修改有色部分的数据无色部分无需修改自动计算取价表18704费用小计月生产总方量（方）本月生产量（方）固定成本可通过管理节约、控制消耗、减少浪费、采购比价降低成本小计本月盈（+）亏（-）情况财务费用合计变动成本可通过比质比价降低成本材料小计合计本月平均销售单价（元/方）本月开票数量方本月开票金额元开票率%％其中：开本月票元：开前期票元累计货发未开票数量方累计货发未开票金额元销售收入元0.000.000.000.000.00其中:本月发货开票元其中：本月估价收入元其中:本期不开票收入元其中:开前期票其中:冲前期票（-）元元其中:损益调整（+、-）元本月回笼资金元回款率%%应收账款余额元预计坏账损失元开票情况销售情况0.000.000.000.000.000.000.000.000.000.000.50########0.00########500.00