XLS《测量计算》

"粮食库存检查工作底稿",,

,,

, ,,

,,

, "附表2-1粮食实物检查工作底稿(测量计算法)",,

,,

, ,,

,,

, "被检查企业(盖章):",,

"检查时点:","实际查库日:年月日",,

"货位号",,

"品种",,

"性质", "收获年度",,

"储存形式",,

"保管账数量(kg)", "质量等级",,

"入仓方式","人工入仓机械入仓",,

"是否重度不宜存",,

,"是否受委托储粮",,

"粮食入库质量","容重(g/l)(出糙率、纯粮率%)",,

"实测粮食质量","容重(g/l)(出糙率、纯粮率%)", ,"水分(%)",,

,"水分(%)", ,"杂质(%)",,

,"杂质(%)", "1.

计算粮堆体积",,

,"粮堆形状及基本尺寸",,

"粮堆测量体积(m3)",,

,"(图)",,

"需要扣除体积(m3)",,

,,

, "粮堆实际体积(m3)",,

,,

, "2.计算粮堆平均密度",,

,,

, "标准容重器法","粮食容重","(g/l)",,

, ,"校正后修正系数",,

,,

,"粮堆平均密度","(kg/m3)",,

, "特制大容器法","单位体积粮食重量","(kg/m3)",,

, ,"校正后修正系数",,

,,

,"粮堆平均密度","(kg/m3)",,

, "3.计算粮食数量",,

,"4.认定粮食实际数量",,

"测量计算数(kg)",,

,"检查计算数与保管账数量比较","差数(kg)", "应记粮食损耗(kg)","水分减量",,

,"差率(%)", ,"保管自然损耗",,

"账实是否相符",,

"是否" ,"合计",,

"粮食实际数量(kg)",,

"检查计算数(kg)",,

,"账实不符原因",,

"备注",,

,,

, "检查人(签字): 保管责任人(签字): 被检查企业负责人(签字):",,

,,

, "填表说明:",,

,,

, "1.根据检查情况在表内相关项目后的""内打" "2.粮堆实际体积=粮堆测量体积-需要扣除体积.",,

,,

, "3.粮堆平均密度=粮食容重(单位体积粮食重量)*校正后修正系数.",,

,,

, "4.测量计算数=粮堆实际体积*粮堆平均密度.",,

,,

, "5.水分减量=保管账数量*(入库水分%-实测水分%)/(1-实测水分% "6.保管自然损耗=保管账数量*0.2%*粮食储存年数.",,

,,

, "7.应记粮食损耗=水分减量+保管自然损耗.",,

,,

, "8.检查计算数=测量计算数+应记粮食损耗.",,

,,

, "9.差数=保管账数量-检查计算数;

差率=差数/保管账数量*100%.",,

,,

, "10.差率在±3%以内的,认定账实相符,保管账数量即为粮食实际数量.",,

,,

, "11.账实不符原因可另附说明.",,

,,

, " 12.属于受托储粮的,在备注栏中标明委托方企业名称.",,

,,

, "13.表中以kg、g/l为单位的栏目保留整数,以m、kg/m

3、%为单位的保留1位小数,修正系数保留2位小数.",,

,,

, ,,

,,

, " 粮食库存检查工作底稿" "附表2-2粮食实物检查工作底稿(抽包检斤法) "被检查企业(盖章):",,

,,

"检查时点:",,

"实际查库日: 年月日",,

,,

,,

"货位号",,

,,

"品种",,

,,

"性质",,

,,

"保管账包数(包)",,

,,

"保管账数量(kg)",,

,,

"包装定量(kg)",,

,,

"收获年度",,

,,

"储存形式",,

,,

"质量等级",,

, "是否重度不宜存",,

,,

,,

"是否受委托储粮",,

,,

, "粮食入库质量",,

"容重(g/l)(出糙率、纯粮率%)",,

,,

"实测粮食质量",,

"容重(g/l)(出糙率、纯粮率%)",,

, ,,

"水分(水分(%)",,

, ,,

"杂质(杂质(%)",,

, "

一、抽包检斤" "1.抽包数量(包)2.抽包粮食毛重(kg)",,

,,

, "3.包装物平均单重(kg)4.单包粮食称量平均净重(kg)",,

,,

, "5.单包平均差数(kg)6.差率( "7.是否定量包装粮",,

,,

,,

"是否",,

,,

, "

二、点包计算" "实际包数(包)粮食实际数量(kg)",,

,,

, "

三、验证账实差数是否合理" "1.水分减量(kg)2.保管自然损耗(kg)",,

,,

, "3.应记粮食损耗(kg)4.账实差数(kg)",,

,,

, "5.判定值(kg)6.是否存在超耗",,

,,

"是否", "超耗的原因" "备注" "常见定量包装粮标准(kg/包)",,

"小麦",,

"大米",,

"大豆",,

"稻谷",,

"玉米",,

,,

"90",,

"90",,

"90",,

"70",,

"80或85",,

,,

"说明:(1)辽、吉、黑、内蒙四省区玉米标包为80公斤.(2)标准麻袋的皮重应为927克,目前实际常用麻袋皮重为840~860克.(3)对省间贸易双方有定量包装协议的,可参照协议确定的每包重量进行抽包检斤. "检查人(签字): 保管责任人(签字): 被检查企业负责人(签字) "填表说明: "1.根据检查情况在表内相关项目后的""内打" "2.单包粮食称量平均净重=(抽包粮食毛重-包装物平均单重*抽包数量)/抽包数量. "3.单包平均差数=包装定量-单包粮食称量平均净重. "4.差率=单包平均差数/包装定量*100%,差率在±0.5%以内的,认定为定量包装粮. "5.实际粮食数量=实际包数*单包粮食称量平均净重. "6.水分减量=保管账数量*(入库水分%-实测水分%)/(1-实测水分% "7.保管自然损耗=保管账数量*0.2%*粮食储存年数. "8.应记粮食损耗=保管自然损耗+水分减量. "9.账实差数=保管账数量-粮食实际数量. "10.判定值=账实差数-应记粮食损耗. "11.如判定值>0,判定值即为超耗数量,超耗数量过大的要延伸核查具体原因. "12.属于受托储粮的,在备注栏中标明委托方企业名称. "13.表中水分、杂质栏保留1位小数,"抽包检斤"的3-6项保留2位小数,其他栏目保留整数. " 粮食库存检查工作底稿" "附表2-3粮食实物检查工作底稿(直接称重法) "被检查企业(盖章):",,

,,

"检查时点:",,

"实际查库日: 年月日",,

,,

,,

"货位号",,

,,

"品种",,

,,

"性质",,

,,

"堆装方式",,

"非定量包装粮散装粮",,

,,

,,

"保管账数量(kg)",,

,,

"收获年度",,

,,

"储存形式",,

,,

"保管账包数(包)",,

, "是否重度不宜存",,

,,

,,

"是否受委托储粮",,

,,

, "粮食入库质量",,

"容重(g/l)(出糙率、纯粮率%)",,

,,

"实测粮食质量",,

"容重(g/l)(出糙率、纯粮率%)",,

, ,,

"水分(水分(%)",,

, ,,

"杂质(杂质(%)",,

, "

一、过秤检查货位中粮食实际数量" "1.全部粮食(含皮重)检斤重量(kg) "2.全部包装物重量或皮重(kg) "3.检斤粮食净重(粮食实际数量)(kg) "

二、验证账实差数是否合理" "1.水分减量(kg)2.保管自然损耗(kg)",,

,,

,,

"3.应记粮食损耗(kg)4.账实差数(kg)",,

,,

,,

"5.判定值(kg)6.是否存在超耗",,

,"是否",,

, "超耗的原因" "备注" "检查人(签字): 保管责任人(签字): 被检查企业负责人(签字) "填表说明: "1.根据检查情况在表内相关项目后的""内打" "2.检斤粮食净重=全部粮食(含皮重)检斤重量-全部包装物重量或皮重,检斤粮食净重即为检查认定的货位中粮食实际数量. "3.水分减量=保管账数量*(入库水分%-实测水分%)/(1-实测水分% "4.保管自然损耗=保管账数量*0.2%*粮食储存年数. "5.应记粮食损耗=保管自然损耗+水分减量. "6.账实差数=保管账数量-粮食实际数量. "7.判定值=账实差数-应记粮食损耗. "8.如判定值>0,判定值即为超耗数量,超耗数量过大的要延伸核查具体原因. "9.属于受托储粮的,在备注栏中标明委托方企业名称. "10.表中以%为单位的保留1位小数,其余保留整数. " 粮食库存检查工作底稿" "附表2-4粮食实物检查结果登记底稿" "被检查企业(盖章)实际查库日: 年月日" "货位号","品种","性质","收获年度","清查方法","保管账数量(kg)","粮食实际数量(kg)","粮食实际数量与保管账数量比较",,

"备注" ,,

,,

,,

,"差数(kg)","差数原因", "检查人(签字)被检查企业负责人(签字):" "填表说明: "1.本表按同品种、同性质粮食分别汇总;

"2.被检查企业受其它企业委托代储的粮食需单独列表填写,并在备注栏中说明情况. "3.表中数据保留整数. ,,

,,

"3",,

,,

,,

,,

,,

,,

,,

,,

,,

,,

,,

,,

,,

,,

,,

,,

,,

,,

,,

,,

,,

,,

,,

,,

,,

,,

,,

,,

,,

,,

,,

,,