采购成本核算报表手动录入手动录入手动录入自动计算自动计算手动录入自动计算自动计算手动录入手动录入自动计算自动计算手动录入自动计算自动计算商品名称采购数量实际数量数量差异差异率采购进价采购金额实际进价加工用量损耗率损耗金额成本售价毛利润额毛利润率土豆1009822.00%22002.04 0.53.00%0.06 1.08 20.92 3266.67%白菜20019910.50%36003.02 0.45.00%0.15 1.36 31.64 1990.00%黄瓜50500.00%42004.00 1.22.00%0.08 4.88 2015.12 25000.00%猪肉100901010.00%88008.89 11.00%0.09 8.98 2011.02 22500.00%鱼2009810251.00%6120012.24 0.80.00%0.00 9.80 2010.20 土豆2601996123.46%8.5221011.11 1.140.00 12.66 2-10.66 白菜1705012070.59%9.8166633.32 1.263.00%1.00 42.98 3-39.98 300.12%黄瓜180909050.00%11.1199822.20 1.385.00%1.11 31.75 20-11.75 1801.80%猪肉190989248.42%12.4235624.04 1.52.00%0.48 36.54 20-16.54 4159.59%鱼20019910.00513.7274013.77 1.621.00%0.14 22.44 20-2.44 14525.55%土豆210501600.7619047615315063.00 1.740.00%0.00 109.62 2-107.62 白菜220901300.5909090916.3358639.84 1.863.00%1.20 75.31 3-72.31 250.98%黄瓜230911390.6043478317.6404844.48 1.985.00%2.22 90.30 20-70.30 899.21%