实用Excel考试实例表

1、产产品品销销售售成成本本表表鲜鲜冻冻类类别别大大类类类类别别明明细细类类别别项项目目代代码码标标准准名名称称加加权权成成本本（含含税税）（元元）鲜品分割原料类烫剥白条20287带皮白条14.60鲜品分割原料类毛剥白条20288去皮白条14.62鲜品大副产类带耳猪头20807带耳猪头(劈半)10.21鲜品大副产类无耳猪头20806无耳猪头(劈半)10.03鲜品大副产类无耳猪头20902无耳猪头B9.64鲜品大副产类混级毛皮20795一级毛猪皮13.54鲜品大副产类混级毛皮20796二级毛猪皮6.99鲜品大副产类大肠20037大肠14.15鲜品大副产类大肠20843大肠(头)14.04鲜品大副产类

2、大肠头20040猪大肠头19.30鲜品大副产类猪小肠20831小肠(头)14.47鲜品大副产类板油20026板油11.87鲜品大副产类板油20854碎板油10.92鲜品大副产类猪网油20094猪网油10.02鲜品大副产类冠油20408精冠油2.51鲜品大副产类猪尾20056猪尾29.97鲜品大副产类猪尾20285精短尾24.01鲜品大副产类猪血20268猪血(头)1.45鲜品大副产类猪肝20027猪肝8.77鲜品大副产类猪肚20013猪肚25.82鲜品大副产类猪心20020猪心14.02鲜品大副产类猪肺20046猪肺4.66鲜品大副产类猪肺20916猪肺(原料)4.11鲜品大副产类猪舌2002

3、9猪舌17.94鲜品大副产类猪腰20014猪腰19.96鲜品大副产类猪耳20034猪耳28.98鲜品大副产类猪耳20934猪耳B19.91鲜品大副产类去筋猪蹄20015猪蹄13.79鲜品大副产类去筋猪蹄20238猪蹄S12.15鲜品大副产类带筋猪蹄20022带筋猪蹄16.05鲜品小副产类脾脏20062脾脏2.93鲜品小副产类连肝肉20073连肝肉12.96鲜品小副产类肺心管20275肺心管48.56鲜品小副产类尿管20261尿管3.38鲜品小副产类苦胆20260苦胆1.94鲜品小副产类猪鞭20276猪鞭30.56鲜品小副产类小肚 20091猪小肚19.94鲜品小副产类小肠头20844小肠头(头

4、)23.91鲜品小副产类猪脑20826鲜猪脑(个)14.64鲜品小副产类蹄筋20845蹄筋(头)40.88鲜品小副产类腿筋20520腿筋8.70鲜品小副产类生肠20047生肠12.33鲜品小副产类天梯20846天梯(头)18.31鲜品小副产类猪毛20267猪毛0.26鲜品下料类食用油原料20168食用猪油下料1.24鲜品下料类食用油白条20170食用油白条1.40鲜品下料类工业油白条20294工业油白条0.23鲜品其它类待煮去皮白条20289待煮去皮白条1.24鲜品其它类待煮带皮白条20290待煮带皮白条1.24鲜品其它类待煮猪舌20299待煮猪舌1.48鲜品其它类待煮猪心20300待煮猪心1

5、.48鲜品分割肉类颈背肌肉20000颈背肌肉17.40鲜品分割肉类颈背肌肉20048梅肉18.17鲜品分割肉类颈背肌肉20887带脂颈背肌肉16.39鲜品分割肉类前腿肌肉20001前腿肌肉18.39鲜品分割肉类前腿肌肉20406带脂前腿肌肉15.40鲜品分割肉类大排肌肉20002大排肌肉21.44鲜品分割肉类大排肌肉20541大排肌肉B21.03鲜品分割肉类大排肌肉20804带脂大排肌肉19.41鲜品分割肉类后腿肌肉20003后腿肌肉18.93鲜品分割肉类后腿肌肉20523掏骨后腿肌肉18.82鲜品分割肉类后腿肌肉20075元宝肉(和尚头)20.36鲜品分割肉类后腿肌肉20246内腿肉20.7

6、9鲜品分割肉类后腿肌肉20136带脂后腿肌肉17.06鲜品分割肉类小里脊20004小里脊21.40鲜品分割肉类精碎肉20044精碎肉16.95鲜品骨类大排20006大排18.04鲜品骨类后腿骨20033后腿骨7.96鲜品骨类后腿骨20159带肉后腿骨9.18鲜品骨类后腿骨20605带展后腿骨12.27鲜品骨类后腿骨20315带肉带腿圈后腿骨10.93鲜品骨类后腿骨20316带腿圈后腿骨8.82鲜品骨类后腿骨20227棒骨13.83鲜品骨类后腿骨20229带肉短后腿骨7.09鲜品骨类前腿骨20042前腿骨6.94鲜品骨类前腿骨20158带肉前腿骨8.11鲜品骨类前腿骨20691带展前腿骨11.1

7、4鲜品骨类肋排20007肋排24.31鲜品骨类肋排20050加厚肋排24.43鲜品骨类肋排20221通肋排23.16鲜品骨类脊骨20016脊骨13.14鲜品骨类脊骨20160带肉脊骨14.24鲜品骨类颈骨20241颈骨头11.11鲜品骨类无颈前排20452加厚无颈前排16.53鲜品骨类前排20065有颈前排15.85鲜品骨类前排20223加厚有颈前排15.98鲜品骨类前排20218无颈前排16.89鲜品骨类通排20655有颈通排18.43鲜品骨类通排20681无颈通排18.76鲜品骨类通排20555带尾叉骨通排18.64鲜品骨类扇骨20077扇骨9.14鲜品骨类西施骨20463西施骨14.49

8、鲜品骨类尾叉骨20803带肉尾叉骨9.98鲜品骨类尾叉骨20161带肉叉骨8.17鲜品骨类尾骨20028尾骨11.91鲜品骨类尾骨20508尾骨B10.73鲜品骨类肋骨20179杂骨8.09鲜品骨类杂骨20081肋骨12.34鲜品分割下料类带皮五花肉20005带皮五花肉16.77鲜品分割下料类去皮五花肉20012去皮五花肉15.62鲜品分割下料类去皮五花肉20651去皮小五花14.25鲜品分割下料类去皮五花肉20657去皮大五花14.84鲜品分割下料类带皮五花肉20349带皮大五花16.32鲜品分割下料类去皮五花肉20700千层五花肉10.85鲜品分割下料类去皮五花肉20936肥五花肉13.9

9、7鲜品分割下料类碎肉201392：8碎肉14.42鲜品分割下料类碎肉204043:7碎肥10.94鲜品分割下料类碎肉202023:7碎肉14.48鲜品分割下料类脆骨边20021脆骨边36.40鲜品分割下料类寸骨20011寸骨23.51鲜品分割下料类肋软骨20030肋软骨21.36鲜品分割下料类小骨节20023小骨节20.84鲜品分割下料类带皮白条前段20620带皮白条前段14.45鲜品分割下料类带皮白条中段20621带皮白条中段17.22鲜品分割下料类带皮白条后段20622带皮白条后段16.36鲜品分割下料类带皮软白条前段20823带皮软白条前段15.74鲜品分割下料类带皮软白条后段20825

10、带皮软白条后段17.00鲜品分割下料类去皮白条前段20626去皮白条前段15.04鲜品分割下料类去皮白条中段20627去皮白条中段17.36鲜品分割下料类去皮白条后段20628去皮白条后段15.96鲜品分割下料类去皮软白条前段20819去皮软白条前段14.70鲜品分割下料类去皮软白条后段20821去皮软白条后段15.92鲜品分割下料类带脂后腿肌肉20440去皮去骨后尖16.81鲜品分割下料类带皮带骨后腿20064带皮带骨后腿16.99鲜品分割下料类带皮去骨后肘20053带皮去骨后肘18.43鲜品分割下料类带皮带骨前肘20010带皮带骨前肘17.77鲜品分割下料类带皮去骨前肘20035带皮去骨前

11、肘19.71鲜品分割下料类去皮带骨中方肉20243去皮带骨中方肉18.14鲜品分割下料类带皮带骨中方肉20106带皮带骨中方肉19.73鲜品分割下料类带皮去骨中方肉20242带皮去骨中方肉19.11鲜品分割下料类后腿肌肉20842去皮后上肉12.66鲜品分割下料类前腿肌肉20841去皮前上肉12.49鲜品分割下料类膈肌肉20122膈肌肉13.05鲜品分割下料类肘花原料皮20976肘花原料皮17.77鲜品分割下料类精修猪皮20087精修猪皮12.65鲜品分割下料类去皮小蹄膀20233去皮小蹄膀7.36鲜品分割下料类带皮小蹄膀20232带皮小蹄膀8.09鲜品膘类精膘20025精膘8.35鲜品膘类肥

12、膘20172肥膘8.10鲜品膘类脊膘20090脊膘8.71鲜品膘类脊膘20601带皮脊膘11.79鲜品膘类碎膘20080碎膘9.31鲜品膘类槽头膘20230槽头膘8.38鲜品红白条类带皮白条20787 带槽头板油奶脯带皮白条(四级)14.87鲜品红白条类带皮白条20759带奶脯带皮白条（一级）17.38鲜品红白条类带皮白条20760带奶脯带皮白条（二级）15.40鲜品红白条类带皮白条20761带奶脯带皮白条（三级）14.07鲜品红白条类带皮白条20898带奶脯带皮白条(四级)14.95鲜品红白条类带皮白条20762带皮白条（一级）15.63鲜品红白条类带皮白条20763带皮白条（二级）15.3

13、2鲜品红白条类带皮白条20764带皮白条（三级）15.20鲜品红白条类去皮白条20769去皮白条（二级）15.00鲜品红白条类去皮白条20770去皮白条（三级）15.46鲜品红白条类去皮白条20799去皮白条（四级）13.83鲜品红白条类带皮白条29039良种带皮白条15.36鲜品红白条类去皮白条29064良种去皮白条15.50鲜品红白条类带皮白条20899欧尚白条14.97鲜品红白条类红条20215红条16.43鲜品红白条类去皮软白条20692去皮软白条16.89鲜品红白条类带皮白条29038去前段带皮白条(二级)15.63鲜品红白条类带皮白条29040去前段带皮白条(三级)15.55鲜品其

14、它类食用毛猪油原料20929食用毛猪油下料2.06鲜品其它类工业油原料20293工业用猪油下料0.47鲜品分割下料类去皮白条中段20568去皮去肋排中段16.96鲜品分割下料类带皮白条中段20569带皮去肋排中段16.61鲜品分割肉类前腿肌肉20521前腿肌肉(标)18.23鲜品分割肉类后腿肌肉20537后腿肌肉(标)18.81鲜品骨类板叉骨20345板叉骨3.63鲜品红白条类带皮白条21105去后段带皮白条(二级)16.30鲜品小副产类肺心管20847肺心管（头）48.60鲜品大副产类猪肚20587猪肚（头）26.27鲜品小副产类食管20588食管（头）14.50冻品大副产类带筋猪蹄2502

15、10冻带筋猪蹄M(10Kg)17.26冻品大副产类去筋猪蹄250056冻猪蹄MS(10Kg)11.40冻品大副产类去筋猪蹄250054冻猪蹄M(10Kg)13.96冻品大副产类去筋猪蹄250055冻猪蹄L(10Kg)14.17冻品大副产类带筋猪蹄250209冻带筋猪蹄L(10Kg)16.32冻品大副产类去筋猪蹄250057冻猪蹄LS(10Kg)11.61冻品大副产类猪肚250045冻猪肚(10Kg)27.67冻品大副产类猪肺250064冻猪肺(20Kg)3.60冻品大副产类猪心250043冻猪心(10Kg)12.82冻品大副产类猪网油250037冻猪网油(25Kg)10.31冻品大副产类板油2

16、50150冻猪吊挂板油(25Kg)13.57冻品大副产类板油250152冻猪碎板油(20Kg)8.13冻品大副产类冠油250615冻猪精冠油(原料)(25kg)8.52冻品大副产类猪舌250044冻猪舌(10Kg)17.76冻品大副产类猪肝250164冻猪肝(10Kg)8.73冻品小副产类带耳猪头250040冻带耳猪头10.19冻品小副产类无耳猪头250042冻无耳猪头9.83冻品小副产类蝴蝶肉250640冻猪蝴蝶肉(25kg)9.72冻品小副产类猪尾250047冻猪尾B(10Kg)21.33冻品小副产类猪尾250599冻猪尾(10kg)29.37冻品小副产类连肝肉250138冻猪连肝肉(10

17、Kg)14.34冻品小副产类尿管250193冻猪尿管4.49冻品小副产类苦胆250140冻猪苦胆(25Kg)2.58冻品小副产类胰脏250335冻猪胰腺(20Kg)2.40冻品小副产类三腺250795冻猪三腺(25kg)0.95冻品分割肉类颈背肌肉250592冻猪梅肉(白梅)(25kg)18.13冻品分割肉类颈背肌肉250597冻猪颈背肌肉(俄白)(25kg)17.11冻品分割肉类后腿肌肉250007冻猪后腿肌肉(25Kg)19.50冻品分割肉类大排肌肉250006冻猪大排肌肉(25Kg)21.32冻品分割肉类大排肌肉250586冻猪大排肌肉(10kg)21.59冻品分割肉类腿弧250601冻

18、猪腿弧肉(25kg)17.27冻品分割肉类精碎肉250008冻猪精碎肉(25Kg)15.88冻品分割肉类肉青250464冻猪肉青A(25Kg)27.15冻品分割肉类肉青250069冻猪肉青(优质)(25Kg)25.22冻品骨类脊骨250165冻猪脊骨(10Kg)13.26冻品骨类后腿骨250182冻猪后腿骨(10Kg)7.79冻品骨类前腿骨250051冻猪前腿骨(10Kg)7.35冻品骨类肋排250022冻猪肋排(10Kg)26.95冻品骨类加厚肋排250021冻猪加厚肋排(10Kg)23.73冻品骨类尾骨250232冻猪尾骨B(10Kg)10.51冻品骨类尾骨250170冻猪尾骨(10Kg)

19、11.61冻品骨类颈骨头250106冻猪颈骨头(10Kg)10.97冻品骨类颈骨250587冻猪颈骨（10kg）9.40冻品骨类加厚无颈前排250100冻猪加厚无颈前排(15Kg)16.04冻品骨类无颈前排250585冻猪无颈前排(10kg)15.47冻品骨类有颈前排250456冻猪有颈前排(15Kg)16.59冻品骨类肉前排250028冻猪肉前排(20Kg)15.95冻品骨类带肉尾叉骨250561冻猪带肉叉骨(10Kg)7.94冻品骨类板叉骨250255冻猪板叉骨3.54冻品骨类扇骨250079冻猪扇骨(10Kg)8.72冻品骨类寸骨250465冻猪寸骨A(10Kg)23.48冻品骨类寸骨2

20、50027冻猪寸骨(10Kg)23.50冻品骨类杂骨250101冻猪杂骨4.45冻品分割下料类膈肌肉250117冻猪膈肌肉(25Kg)12.82冻品分割下料类肋软骨250110冻猪肋软骨(10kg)12.80冻品分割下料类胸软骨250041冻猪胸软骨(25Kg)11.23冻品分割下料类带皮小蹄膀250192冻猪带皮小蹄膀(25Kg)7.87冻品分割下料类去皮小蹄膀250197冻猪去皮小蹄膀(25Kg)6.08冻品分割下料类带皮带骨后肘250030冻猪带皮带骨后肘(25Kg)16.51冻品分割下料类带皮带骨前肘250032冻猪带皮带骨前肘(25Kg)16.72冻品分割下料类带皮去骨前肘25000

21、2冻猪带皮去骨前肘(25Kg)18.60冻品分割下料类碎肉250001冻猪碎肉2:8(25Kg)15.08冻品分割下料类碎肥250068冻猪碎肥(3:7)(25Kg)12.35冻品分割下料类脆骨边250114冻猪脆骨边(10Kg)36.70冻品分割下料类去皮槽头250186冻猪去皮槽头(25Kg/袋)10.05冻品分割下料类带皮带骨中方肉250012冻猪带皮带骨中方肉(25Kg)14.50冻品分割下料类去皮带骨中方肉250508冻猪去皮带骨中方肉(25Kg)18.71冻品分割下料类小骨节250748冻猪小骨节(10Kg)18.31冻品分割下料类猪皮250256冻猪皮(原料)(25Kg)12.0

22、7冻品分割下料类肘花原料皮250774冻肘花原料皮17.95冻品分割下料类去皮五花肉250563冻猪去皮大五花(10Kg)16.92冻品分割下料类带皮五花肉250015冻猪带皮五花肉(10Kg)16.24冻品分割下料类去皮五花肉250203冻猪去皮五花肉(10Kg)16.59冻品分割下料类去皮五花肉250598冻猪去皮五花肉(25kg)14.16冻品膘类碎膘250071冻猪碎膘(25Kg)8.39冻品膘类精膘250017冻猪精膘(25Kg)8.85冻品膘类脊膘250016冻猪脊膘(25Kg)12.17冻品膘类槽头膘250608冻猪槽头膘(原料)(25Kg)8.55冻品膘类肥膘250609冻猪肥

23、膘(原料)(25Kg)6.36冻品小副产类天梯250514冻猪天梯(10Kg)19.14冻品分割肉类前腿肌肉250813前腿肌肉(标)19.22冻品分割肉类后腿肌肉250814后腿肌肉(标)20.64冻品膘类肥膘259012冻猪肥膘(标)(25kg)9.87冻品分割下料类去皮五花肉250556冻猪千层五花肉（25kg)12.41冻品分割肉类后腿肌肉250564冻带脂后腿肌肉18.70冻品小副产类喉头250420冻猪喉头8.44冻品小副产类鼻骨250421冻猪鼻骨9.96冻品小副产类肺气管250216冻猪肺气管7.69销销售售收收入入明明细细表表鲜鲜冻冻类类别别大大类类类类别别明明细细类类别别项

24、项目目代代码码标标准准名名称称重重量量（kgkg）鲜大副产类带耳猪头020807 带耳猪头(劈半)9,999.00鲜大副产类混级毛皮020795 一级毛猪皮35,843.50鲜大副产类混级毛皮020796 二级毛猪皮453.00鲜大副产类大肠020843 大肠(头)5,330.00鲜大副产类猪小肠020831 小肠(头)5,450.00鲜大副产类板油020026 板油3,273.90鲜大副产类猪网油020094 猪网油913.70鲜大副产类冠油020408 精冠油2,254.00鲜大副产类猪尾020056 猪尾115.00鲜大副产类猪尾020285 精短尾115.00鲜大副产类猪血020268

25、 猪血(头)13,505.00鲜大副产类猪肝020027 猪肝5,904.50鲜大副产类猪肚020013 猪肚492.50鲜大副产类猪心020020 猪心1,387.50鲜大副产类猪肺020046 猪肺550.00鲜大副产类猪舌020029 猪舌1,045.00鲜大副产类猪腰020014 猪腰1,309.00鲜大副产类猪耳020034 猪耳60.10鲜大副产类去筋猪蹄020015 猪蹄1,683.60鲜大副产类带筋猪蹄020022 带筋猪蹄120.10鲜小副产类脾脏020062 脾脏614.50鲜小副产类连肝肉020073 连肝肉724.50鲜小副产类尿管020261 尿管101.00鲜小副产

26、类苦胆020260 苦胆220.00鲜小副产类猪鞭020276 猪鞭23.50鲜小副产类小肚 020091 猪小肚189.00鲜小副产类小肠头020844 小肠头(头)275.50鲜小副产类猪脑020826 鲜猪脑(个)432.50鲜小副产类蹄筋020845 蹄筋(头)308.00鲜小副产类腿筋020520 腿筋92.00鲜小副产类生肠020047 生肠309.50鲜小副产类天梯020846 天梯(头)124.00鲜小副产类猪毛020267 猪毛2,224.00鲜下料类食用油原料020168 食用猪油下料2,113.00鲜下料类食用油白条020170 食用油白条503.00鲜其它类待煮去皮白条

27、020289 待煮去皮白条1,813.50鲜其它类待煮带皮白条020290 待煮带皮白条485.50鲜其它类待煮猪舌020299 待煮猪舌48.00鲜其它类待煮猪心020300 待煮猪心47.00鲜分割肉类颈背肌肉020000 颈背肌肉525.00鲜分割肉类颈背肌肉020887 带脂颈背肌肉105.00鲜分割肉类前腿肌肉020001 前腿肌肉1,740.00鲜分割肉类前腿肌肉020406 带脂前腿肌肉15.00鲜分割肉类大排肌肉020002 大排肌肉2,817.04鲜分割肉类大排肌肉020541 大排肌肉B40.00鲜分割肉类后腿肌肉020003 后腿肌肉11,442.90鲜分割肉类后腿肌肉0

28、20246 内腿肉800.00鲜分割肉类后腿肌肉020136 带脂后腿肌肉1,437.70鲜分割肉类小里脊020004 小里脊1,253.11鲜分割肉类精碎肉020044 精碎肉990.00鲜骨类大排020006 大排555.00鲜骨类后腿骨020033 后腿骨4,417.90鲜骨类后腿骨020159 带肉后腿骨26.00鲜骨类后腿骨020315 带肉带腿圈后腿骨26.00鲜骨类后腿骨020316 带腿圈后腿骨39.00鲜骨类后腿骨020229 带肉短后腿骨45.00鲜骨类前腿骨020042 前腿骨5,149.88鲜骨类前腿骨020158 带肉前腿骨15.00鲜骨类肋排020007 肋排5,7

29、33.20鲜骨类肋排020221 通肋排30.00鲜骨类脊骨020016 脊骨2,100.00鲜骨类颈骨020241 颈骨头1,090.00鲜骨类无颈前排020452 加厚无颈前排3,470.00鲜骨类前排020065 有颈前排100.00鲜骨类前排020223 加厚有颈前排10.00鲜骨类前排020218 无颈前排2,430.00鲜骨类通排020655 有颈通排18.40鲜骨类通排020681 无颈通排153.86鲜骨类扇骨020077 扇骨1,469.00鲜骨类西施骨020463 西施骨15.00鲜骨类尾叉骨020161 带肉叉骨2,782.00鲜骨类尾骨020028 尾骨1,807.50

30、鲜骨类尾骨020508 尾骨B562.30鲜骨类杂骨020179 杂骨120.00鲜分割下料类带皮五花肉020005 带皮五花肉90.00鲜分割下料类去皮五花肉020651 去皮小五花1,440.00鲜分割下料类去皮五花肉020657 去皮大五花30.00鲜分割下料类带皮五花肉020349 带皮大五花36.00鲜分割下料类去皮五花肉020936 肥五花肉6,986.00鲜分割下料类碎肉020139 2：8碎肉570.00鲜分割下料类碎肉020404 3:7碎肥1,010.60鲜分割下料类碎肉020202 3:7碎肉75.00鲜分割下料类小骨节020023 小骨节108.00鲜分割下料类带皮白条

31、前段020620 带皮白条前段2,239.50鲜分割下料类带皮白条中段020621 带皮白条中段1,630.22鲜分割下料类带皮白条后段020622 带皮白条后段56.00鲜分割下料类去皮白条前段020626 去皮白条前段20.70鲜分割下料类去皮白条中段020627 去皮白条中段65.16鲜分割下料类去皮白条后段020628 去皮白条后段69.84鲜分割下料类去皮软白条前段020819 去皮软白条前段180.00鲜分割下料类去皮软白条后段020821 去皮软白条后段5,090.00鲜分割下料类带皮带骨中方肉020106带皮带骨中方肉20,041.30鲜分割下料类后腿肌肉020842 去皮后上

32、肉200.00鲜分割下料类膈肌肉020122 膈肌肉160.00鲜分割下料类去皮小蹄膀020233 去皮小蹄膀9.00鲜分割下料类带皮小蹄膀020232 带皮小蹄膀169.20鲜膘类精膘020025 精膘420.00鲜膘类肥膘020172 肥膘13,011.00鲜膘类脊膘020090 脊膘1,454.00鲜膘类碎膘020080 碎膘1,630.00鲜红白条类带皮白条020787 带槽头板油奶脯带皮白条(四级) 354.86鲜红白条类带皮白条020761 带奶脯带皮白条（三级）1,218.64鲜红白条类带皮白条020898 带奶脯带皮白条(四级)30,732.00鲜红白条类带皮白条020764

33、带皮白条（三级）5,871.61鲜红白条类去皮白条020769 去皮白条（二级）3,439.87鲜红白条类去皮白条020770 去皮白条（三级）73.99鲜红白条类去皮白条020799 去皮白条（四级）257.50鲜红白条类带皮白条029039 良种带皮白条34,036.27鲜红白条类去皮白条029064 良种去皮白条7,811.20鲜红白条类红条020215 红条37.00鲜红白条类带皮白条029038 去前段带皮白条(二级)1,848.04鲜其它类食用毛猪油原料020929 食用毛猪油下料1,573.00鲜其它类工业油原料020293 工业用猪油下料1,350.00鲜分割下料类带皮白条中段

34、020569 带皮去肋排中段500.00鲜分割肉类前腿肌肉020521 前腿肌肉(标)3,346.00鲜分割肉类后腿肌肉020537 后腿肌肉(标)11,000.00鲜小副产类肺心管20847肺心管（头）108.50鲜大副产类猪肚20587猪肚（头）1,594.00鲜小副产类食管20588食管（头）294.00鲜鲜品品合合计计316,021.19冻大副产类猪肺250064 冻猪肺(20Kg)2,500.00冻大副产类板油250150 冻猪吊挂板油(25Kg)5,000.00冻小副产类带耳猪头250040 冻带耳猪头8,000.00冻小副产类无耳猪头250042 冻无耳猪头10,000.00冻分

35、割肉类大排肌肉250586 冻猪大排肌肉(10kg)2,000.00冻骨类后腿骨250182冻猪后腿骨(10Kg)70.00冻骨类前腿骨250051 冻猪前腿骨(10Kg)2,150.00冻骨类肋排250022 冻猪肋排(10Kg)20.00冻骨类加厚肋排250021 冻猪加厚肋排(10Kg)100.00冻骨类尾骨250232冻猪尾骨B(10Kg)10.00冻骨类颈骨头250106 冻猪颈骨头(10Kg)600.00冻骨类无颈前排250585 冻猪无颈前排(10kg)100.00冻骨类肉前排250028 冻猪肉前排(20Kg)11,000.00冻分割下料类去皮小蹄膀250197 冻猪去皮小蹄膀

36、(25Kg)75.00冻分割下料类去皮带骨中方肉250508 冻猪去皮带骨中方肉(25Kg)2,000.00冻分割下料类去皮五花肉250563 冻猪去皮大五花(10Kg)5,000.00冻分割下料类带皮五花肉250015 冻猪带皮五花肉(10Kg)6,000.00冻分割下料类去皮五花肉250203 冻猪去皮五花肉(10Kg)1,000.00冻膘类精膘250017 冻猪精膘(25Kg)500.00冻膘类槽头膘250608 冻猪槽头膘(原料)(25Kg)9,000.00冻冻品品合合计计65,125.00鲜鲜冻冻合合计计381,146.19销销价价（含含税税）（元元）金金额额（含含税税）（元元）13

37、.00129,987.0017.87640,475.708.813,988.6717.5493,492.0019.21104,696.0012.5641,127.3612.8211,717.402.605,860.4038.304,404.5031.003,565.001.7924,125.6010.9964,913.5833.0216,260.6817.0723,680.006.003,300.0023.0124,050.0023.6630,974.4937.212,236.4516.5627,877.6820.472,457.863.612,217.3016.5712,003.254.00

38、404.002.40528.0039.15920.0325.504,819.5018.175,007.2020.008,648.8051.8015,953.7012.011,105.0015.504,797.2522.032,731.200.29635.501.603,380.802.001,006.001.602,901.601.60776.801.9091.201.9089.3022.7211,929.5019.732,071.5022.6139,337.5019.50292.5027.5077,460.4527.401,096.0023.12264,540.8626.3721,093.6

39、021.5731,015.8726.4833,188.0621.5021,282.0022.8512,683.809.5842,329.3410.80280.8013.70356.20销销售售收收入入明明细细表表10.00390.008.50382.508.1141,762.5012.80192.0030.90177,165.9229.30879.0016.4334,496.1114.0915,353.0020.2170,121.4119.501,950.0020.00200.0021.4852,191.8123.20426.8823.903,677.9810.5015,424.5018.30

40、274.5010.2928,622.1015.4727,965.9413.427,547.8710.151,218.0021.301,917.0017.6925,476.5020.20606.0020.90752.4016.96118,465.0017.7810,137.0013.3513,496.1418.301,372.5025.982,806.0218.0040,311.0021.4835,014.0720.701,159.2019.50403.6522.001,433.5220.201,410.7718.503,330.0019.94101,479.6925.00501,038.681

41、6.003,200.0016.502,640.009.2082.8010.171,720.9210.504,410.009.61124,978.2211.1416,201.2010.0516,377.0018.306,493.9417.6021,448.1318.45567,027.8418.70109,799.0318.8064,669.5619.531,444.7817.004,377.5018.90643,413.3918.90147,658.4020.70765.9019.5136,064.192.604,089.800.60810.0021.0010,500.0022.9076,63

42、3.7223.85262,332.2260.836,600.4034.0154,219.0018.585,462.4017.155,420,436.275.7014,250.009.5047,500.0012.80102,400.0010.90109,000.0027.3054,600.009.00630.007.0315,125.0029.00580.0028.002,800.0012.00120.0013.508,100.0019.501,950.0020.00220,000.007.50562.5022.0044,000.0016.5082,500.0019.30115,800.0016

43、.0016,000.009.004,500.007.4066,600.0013.93907,017.5016.606,327,453.77计数项:姓名性别姓名男女总计柴汇11董军强11郭建平11郭卫华112韩俊平11黄霞11姜桂琴11李海军22李辉11李娟22李军33李玲11李小娟11李英君11李振强33刘春华11刘丽华11卢红英11马山峰33裴新华11尚秋华22宋刚11万明军11王国11王申银11王天11王玉兰314王自立33徐丽红11许翠华11许海峰11许勤11薛庆庆11杨晶11杨静11尹小聚11于俊华11翟正强22张桂荣11张国方11张海军11张磊11张全升33张铁岭11张岩33张艳22

44、赵海振11赵胜峰11周春国11总计462470计数项:姓名计数项:姓名姓名汇总姓名汇总柴汇1柴汇1董军强1董军强1郭建平1郭建平1郭卫华2韩俊平1韩俊平1黄霞1黄霞1姜桂琴1姜桂琴1李辉1李海军2李玲1李辉1李小娟1李娟2李英君1李军3刘春华1李玲1刘丽华1李小娟1卢红英1李英君1裴新华1李振强3宋刚1刘春华1万明军1刘丽华1王国1卢红英1王申银1马山峰3王天1裴新华1徐丽红1尚秋华2许翠华1宋刚1许海峰1万明军1许勤1王国1薛庆庆1王申银1杨晶1王天1杨静1王玉兰4尹小聚1王自立3于俊华1徐丽红1张桂荣1许翠华1张国方1许海峰1张海军1许勤1张磊1薛庆庆1张铁岭1杨晶1赵海振1杨静1赵胜峰1

45、尹小聚1周春国1于俊华1郭卫华2翟正强2李海军2张桂荣1李娟2张国方1尚秋华2张海军1翟正强2张磊1张艳2张全升3李军3张铁岭1李振强3张岩3马山峰3张艳2王自立3赵海振1张全升3赵胜峰1张岩3周春国1王玉兰4总计70总计70职工信息第1页，共几页职职工工身身份份信信息息统统计计表表身身份份证证号号姓姓名名参参加加工工作作时时间间性性别别工工龄龄( (月月) 晶1998-5-22女134411102195509161535李小娟1986/3/1男280411123196404164525许翠华1997/4/29女147411102195710251532

46、赵海振1992/10/1男201411102196602261519万明军1993/8/1男191411102630417155李英君1998/4/1男135411122197808098067徐丽红1998/5/1女13441110219750411152x杨静1994/1/14女186411102197006301523姜桂琴1991/2/1女221411102197601103011张海军1999/3/1男124411121197301035490赵胜峰2005-4-1男51411102197412285629张艳2004-8-1女59411102197209305647李娟2000-3

47、-20女112411102196206121557尹小聚1994/9/1男178411102660915153郭卫华1984/4/24男303411102680309151张国方1991/10/1男213411102620603004刘丽华1981/1/1女342411102195312245030薛庆庆1986/7/1男276411102196302262026刘春华2000/2/1女113411102500620153王申银1970/9/1男466411102500928101董军强1965/9/1男526412828195711100034宋刚2002/3/1男8841110219620

48、1101020李娟1991/6/1女217411123198612156027张艳2004/6/5女61411102196404121523黄霞1980/12/1女343411102197008151522郭卫华1987-6-1女265411123198209241539张磊2007/4/1男27411102196509271528李玲1998/10/1女129411102196702151560尚秋华2002/9/1女82411102196208150714翟正强1992/8/3男203411102197105271526李海军2000/7/22女10841110219661013101x马

49、山峰1984/4/1男303411102197310184018张全升1992/10/1男20141110219751015151X王玉兰1992/6/1男205411102830214301李军2000/3/1男112411102197708232518张岩2000/8/1男107411102197309291510李振强1992/11/1男200411102196501211512王自立1993/12/1男187411102196308261016王天1981/9/1男33441100219700321201X郭建平1993/11/1男188411102196203091516裴新华197

50、9/12/1男355411102195804201034韩俊平1979/1/1男366411102198601070154张铁岭2003/11/1男68411102195701071011王国1976/3/1男400411102196003250017周春国1989/5/1男242411123195504154530许勤1987/2/1男269411123195507204513许海峰1987/2/1男269411102196705151523卢红英1985/5/1女290411123196805174580柴汇2008/7/1女12411102661019152于俊华1984/6/1女301

51、职工信息第1页，共几页职职工工身身份份信信息息统统计计表表身身份份证证号号姓姓名名参参加加工工作作时时间间性性别别工工龄龄( (月月) 玉兰1993/7/1女192411122197712180285李辉1999/12/1女115411102196603151020张桂荣1996/4/1女15941110219661013101x马山峰1984/4/1男303411102197310184018张全升1992/10/1男20141110219751015151X王玉兰1992/6/1男205411102830214301李军2000/3/1男112411

52、102197708232518张岩2000/8/1男107411102197309291510李振强1992/11/1男200411102196501211512王自立1993/12/1男187411102196702151560尚秋华2002/9/1女82411102196208150714翟正强1992/8/3男203411102197105271526李海军2000/7/22女10841110219661013101x马山峰1984/4/1男303411102197310184018张全升1992/10/1男20141110219751015151X王玉兰1992/6/1男2054111

53、02830214301李军2000/3/1男112411102197708232518张岩2000/8/1男107411102197309291510李振强1992/11/1男200411102196501211512王自立1993/12/1男187EXCELEXCEL应应用用考考试试题题姓姓名名：得得分分：100.00注注意意事事项项1 1、打打开开工工作作表表后后，先先在在B3B3填填写写自自己己的的名名字字；2 2、试试题题共共试试题题一一（4040分分）与与试试题题二二（6060分分）两两部部分分；3 3、试试题题一一以以工工作作表表 成成绩绩单单 为为依依据据按按要要求求完完成成试试

54、题题；4 4、试试题题二二以以“销销售售成成本本表表”、“销销售售收收入入表表”及及“职职工工身身份份信信息息表表”为为依依据据按按要要求求完完成成试试题题；3 3、考考试试时时间间为为一一个个小小时时，交交卷卷按按试试题题要要求求进进行行交交卷卷，不不按按要要求求或或不不按按时时交交卷卷者者，按按0 0分分处处理理；4 4、不不能能复复制制他他人人的的答答案案做做为为自自己己的的答答案案，如如果果复复制制他他人人答答案案做做为为自自己己的的答答案案，试试题题会会自自动动记记录录复复制制人人与与被被复复制制人人的的名名字字，复复制制他他人人答答案案者者，复复制制人人与与被被复复制制人人均均以以

55、作作弊弊论论处处，0 0分分。性别数据男女求和项:总分汇总姓名求和项:总分计数项:总分2求和项:总分计数项:总分2郭建平6291629郭卫华6321632韩俊平6291629李 军5381538李 玲6351635李振强5831583刘春华520.51520.5刘丽华5611561卢红英5721572裴新华5721572尚秋华1177.521177.5王 国5671567王 天5201520王申银755.51755.5王自立729.51729.5许 勤5301530许海峰6101610薛庆庆6241624尹小聚6021602张 磊6291629张 岩615.51615.5张国方616.5161

56、6.5张铁岭589.51589.5周春国708.51708.5总计9949165197915146621.8125577.4444444计数项:总分2汇总11111111112111111111111125605.84性别数据男女求和项:总分汇总姓名求和项:总分计数项:总分2求和项:总分计数项:总分2郭建平6291629郭卫华6321632韩俊平6291629李 军5381538李 玲6351635李振强5831583刘春华520.51520.5刘丽华5611561卢红英5721572裴新华5721572尚秋华1177.521177.5王 国5671567王 天5201520王申银755.51

57、755.5王自立729.51729.5许 勤5301530许海峰6101610薛庆庆6241624尹小聚6021602张 磊6291629张 岩615.51615.5张国方616.51616.5张铁岭589.51589.5周春国708.51708.5总计9949165197915146621.8125577.4444444计数项:总分2汇总11111111112111111111111125605.84一一、用用公公式式计计算算下下表表中中每每位位考考生生的的总总分分与与平平均均分分，并并按按总总分分高高低低排排名名；（5 5分分）漯漯河河中中学学初初三三（1 1）班班期期终终考考试试成成绩绩

58、单单准考证号姓名性别数学语文英语政治物理化学LHGZ31025王申银男99.095.093.098.097.591.0LHGZ31005王自立男95.088.097.083.585.595.0LHGZ31012周春国男67.095.088.097.083.585.5LHGZ31017李 玲女85.595.097.588.078.076.0LHGZ31020郭卫华男69.076.066.090.066.089.0LHGZ31007郭建平男67.073.069.089.078.089.0LHGZ31009韩俊平女66.089.079.097.067.073.0LHGZ31016张 磊男67.073

59、.069.089.078.089.0LHGZ31001尚秋华女85.073.066.578.089.079.0LHGZ31023薛庆庆男66.090.055.066.067.095.0LHGZ31021张国方男67.073.069.089.083.578.0LHGZ31003张 岩男66.578.089.079.085.073.0LHGZ31014许海峰男66.067.073.069.089.078.0LHGZ31019尹小聚男78.089.079.085.079.049.0LHGZ31010张铁岭男83.578.078.079.079.049.0LHGZ31004李振强男67.069.076

60、.066.090.055.0LHGZ31008裴新华女79.049.067.076.069.076.0LHGZ31015卢红英女66.090.079.049.067.076.0LHGZ31011王 国男78.067.069.076.066.090.0LHGZ31022刘丽华女79.049.067.076.078.067.0LHGZ31018尚秋华女66.049.067.069.067.073.0LHGZ31002李 军男55.066.049.067.069.076.0LHGZ31013许 勤女79.078.076.066.049.066.0LHGZ31024刘春华女55.045.558.063