新建 Microsoft Excel 97-2003 工作表

  • 格式:xls
  • 大小:70.00 KB
  • 文档页数:6

门出品率物料汇总表条记录 查询期间: 20160601 到 20160617物料类别物料名称单位期初数量期初金额收到数量收到金额标准消耗数量冬瓜斤750.5801.44133.7137.38113.78海带结斤203.1812.433.8135.20杭椒斤27270胡萝卜斤4.3411.172.35.750黄豆芽斤6154100黄瓜斤7.18.523.84.560鸡腿菇斤157.051,104.9523.6167.50金针菇斤5125120韭菜斤90.8213.8421.251.4419.26空心菜斤6.813.66.813.60苦瓜斤3.19.33.19.30快菜斤7.418.57.418.50茄子斤16329.5190青椒斤6126120生姜斤9.218.4002.46莴笋斤1.73.41.73.40咸菜斤11.811.80苋菜斤1,242.904,297.35173.5613.51192香葱斤152.8475.828.7890蟹味菇斤170.991,865.6626.552950杏鲍菇斤4.8174.8170油麦菜斤8552,030.75123.1308.20长豆角斤2.88.42.88.4011,790.281,939.54

里脊肉斤19.4329.83.559.50五花肉斤5755750仔排斤78.41,788.802557513.8猪肺斤4912613.4360猪尾斤65.81,430.8014.53190猪血斤59147.516400猪腰个265.982,659.805252006,557.701,624.50

鹌鹑只26492475262.50公鸡斤10.7160.52.334.501,084.50297

茶叶斤0.517.50.517.50花生米斤319.5319.50干货类蔬菜类

小计猪肉类

小计禽类

小计辣椒面斤1181180.375555

白砂糖斤1854390白芝麻斤0.560.560脆炸粉盒61841211.5豆豉稻花香袋262620206.37番茄酱筒217006.9番茄沙司俊峰园瓶6.516.25256.9桂花糖瓶310.5310.510.6胡椒粉斤0.527.50.527.50黄贡椒瓶1401400火腿肠根14026650950鸡汁家乐壶211621160吉士粉筒2152154.6美极鲜瓶2762761.26牛肉酱阿香婆瓶325.5325.51.83香辣酱李锦记瓶5555551.19玉米粒双象绿欣瓶224466.68721500浙醋大醋瓶25250孜然粉斤51002402.44孜然粒斤1181180.611,358.43725.5

豆泡斤9355814840内酯豆腐盒9091,090.80119142.801,648.80226.8

年糕斤292.81,171.205220842.41,171.20208

咸蛋黄袋20192.55650192.565

圣女果斤35.3284.74973.36.9284.7473.3

鱿鱼包3614,332.001001,200.00614,332.001,200.0028,475.156,414.64外采

小计合计食用油类

小计冻货类

小计水果类

小计小计调料类

小计豆腐类

小计标准消耗金额实际消耗数量实际消耗金额差异数量差异金额出品率标准结存数量标准结存金额125.1600-113.78-125.16--770.42813.6600000--236.9947.600000--41400000--6.6416.9200000--102500000--10.913.0800000--180.651,272.4500000--102444.300-19.26-44.3--92.74220.9800000--13.627.200000--6.218.600000--14.83700000--25.55100000--12244.9200-2.46-4.92--6.7413.4800000--3.46.800000--23.657600-192-576--1,224.404,334.8600000--181.5564.800000--197.542,160.6600000--9.63400000--978.12,338.9500000--5.616.8750.380-750.3812,979.44

00000--22.9389.300000--10150317.400-13.8-317.4--89.62,046.4000000--62.416200000--80.31,749.8000000--75187.500000--317.983,179.80317.40-317.47,864.80

00000--3391,186.5000000--131950001,381.50

00000--13500000--639000-0.370--1.6336000110

00000--216300000--11234.500-11.5-34.5---1.5-4.56.3700-6.37-6.37--39.6339.6358.6500-6.9-58.65---4.9-41.6517.2500-6.9-17.25--1.6437.100-10.6-37.1---4.6-16.100000--15500000--28000000--19036100000--423234.500-4.6-34.5---0.6-4.547.7900-1.26-47.79--2.74104.2115.5600-1.83-15.56--4.1735.4413.0800-1.19-13.08--8.8196.9200000--296616.6800000--41048.800-2.44-48.8--4.5691.210.9800-0.61-10.98--1.3925.02324.570-324.571,759.35

00000--10764200000--1,028.001,233.600001,875.60

169.600-42.4-169.6--302.41,209.60169.60-169.61,209.60

00000--25257.5000257.5

53.8200-6.9-53.82--37.4304.2253.820-53.82304.22

73200-61-732--4004,800.007320-7324,800.002,347.770-2,347.7732,542.01实际结存数量实际结存金额884.2938.82236.9947.64146.6416.92102510.913.08180.651,272.451024112265.2813.627.26.218.614.83725.55112249.218.43.46.823.61,416.404,910.86181.5564.8197.542,160.669.634978.12,338.955.616.813,729.82

22.9389.310150103.42,363.8062.416280.31,749.8075187.5317.983,179.808,182.20

3391,186.50131951,381.50

135639236110

2163112103046462178.521.256211552801903614232430415265110110296616.6841071402362,083.93

1076421,028.001,233.601,875.60

344.81,379.201,379.20

25257.5257.5

44.3358.04358.04

4615,532.005,532.0034,889.79