公司销售行业进货成本计算统计表

进货日期进货日期货品编号货品编号进货批次进货批次进货数量进货数量 2017年12月9日A1S13 2017年12月10日A1M110 2017年12月11日A1L13 2017年12月12日A1XL13 2017年12月13日A2S13 2017年12月14日A2M13 2017年12月15日A3M14 2017年12月16日A4M15 2017年12月17日A5M16 2017年12月18日A6M17 2017年12月19日A7M18 2017年12月20日A8M19 2017年12月21日A9M110 2017年12月22日A10M111 2017年12月23日A11M112 2017年12月24日A12M113 2017年12月25日A13M114 2017年12月26日A14M115 2017年12月27日A15M116 进价进价进货成本进货成本 200.00600.00 220.002200.00 230.00690.00 300.00900.00 600.001800.00 620.001860.00 621.002484.00 622.003110.00 623.003738.00 624.004368.00 625.005000.00 626.005634.00 627.006270.00 628.006908.00 629.007548.00 630.008190.00 631.008834.00 632.009480.00 633.0010128.00 销售日期销售日期货品编号货品编号 进货批次进货批次 销售数量销售数量 销售单价销售单价 销量金额 销量金额 进货单价 进货单价 2017/12/10A1M13300900.00 220.00 2017/12/11A1L11260260.00 230.00 2017/12/12A2L12261522.00 - 2017/12/13A3L13262786.00 - 2017/12/14A4L142631,052.00 - 2017/12/15A5L152641,320.00 - 2017/12/16A6L162651,590.00 - 2017/12/17A7L172661,862.00 - 2017/12/18A8L182672,136.00 - 2017/12/19A9L192682,412.00 - 2017/12/20A10L1102692,690.00 - 2017/12/21A11L1112702,970.00 - 2017/12/22A12L1122713,252.00 - 2017/12/23A13L1132723,536.00 - 2017/12/24A14L1142733,822.00 - 2017/12/25A15L1152744,110.00 - 2017/12/26A16L1162754,400.00 - 2017/12/27A17L1172764,692.00 - 2017/12/28A18L1182774,986.00 - 2017/12/29A19L1192785,282.00 - 2017/12/30A20L1202795,580.00 - 2017/12/31A21L1212805,880.00 - 2018/1/1A22L1222816,182.00 - 2018/1/2A23L1232826,486.00 - 2018/1/3A24L1242836,792.00 - 2018/1/4A25L1252847,100.00 - 2018/1/5A26L1262857,410.00 - 2018/1/6A27L1272867,722.00 - 2018/1/7A28L1282878,036.00 - 2018/1/8A29L1292888,352.00 - 2018/1/9A30L1302898,670.00 - 2018/1/10A31L1312908,990.00 - 2018/1/11A32L1322919,312.00 - 2018/1/12A33L1332929,636.00 - 2018/1/13A34L1342939,962.00 - 2018/1/14A35L13529410,290.00 - 2018/1/15A36L13629510,620.00 - 2018/1/16A37L13729610,952.00 - 2018/1/17A38L13829711,286.00 - 2018/1/18A39L13929811,622.00 - 2018/1/19A40L14029911,960.00 - 2018/1/20A41L14130012,300.00 - 2018/1/21A42L14230112,642.00 - 2018/1/22A43L14330212,986.00 - 2018/1/23A44L14430313,332.00 - 2018/1/24A45L14530413,680.00 - 2018/1/25A46L14630514,030.00 - 2018/1/26A47L14730614,382.00 - 2018/1/27A48L14830714,736.00 - 2018/1/28A49L14930815,092.00 - 2018/1/29A50L15030915,450.00 - 2018/1/30A51L15131015,810.00 - 2018/1/31A52L15231116,172.00 - 2018/2/1A53L15331216,536.00 - 2018/2/2A54L15431316,902.00 - 2018/2/3A55L15531417,270.00 - 2018/2/4A56L15631517,640.00 - 2018/2/5A57L15731618,012.00 - 2018/2/6A58L15831718,386.00 - 2018/2/7A59L15931818,762.00 - 2018/2/8A60L16031919,140.00 - 2018/2/9A61L16132019,520.00 - 2018/2/10A62L16232119,902.00 - 2018/2/11A63L16332220,286.00 - 2018/2/12A64L16432320,672.00 - 2018/2/13A65L16532421,060.00 - 2018/2/14A66L16632521,450.00 - 2018/2/15A67L16732621,842.00 - 2018/2/16A68L16832722,236.00 - 2018/2/17A69L16932822,632.00 - 2018/2/18A70L17032923,030.00 - 2018/2/19A71L17133023,430.00 - 2018/2/20A72L17233123,832.00 - 2018/2/21A73L17333224,236.00 - 2018/2/22A74L17433324,642.00 - 2018/2/23A75L17533425,050.00 - 2018/2/24A76L17633525,460.00 - 2018/2/25A77L17733625,872.00 - 2018/2/26A78L17833726,286.00 - 2018/2/27A79L17933826,702.00 - 2018/2/28A80L18033927,120.00 - 2018/3/1A81L18134027,540.00 - 2018/3/2A82L18234127,962.00 - 2018/3/3A83L18334228,386.00 - 2018/3/4A84L18434328,812.00 - 2018/3/5A85L18534429,240.00 - 2018/3/6A86L18634529,670.00 - 2018/3/7A87L18734630,102.00 - 2018/3/8A88L18834730,536.00 - 2018/3/9A89L18934830,972.00 - 2018/3/10A90L19034931,410.00 - 2018/3/11A91L19135031,850.00 - 2018/3/12A92L19235132,292.00 - 2018/3/13A93L19335232,736.00 - 2018/3/14A94L19435333,182.00 - 2018/3/15A95L19535433,630.00 - 2018/3/16A96L19635534,080.00 - 2018/3/17A97L19735634,532.00 - 2018/3/18A98L19835734,986.00 - 成本金额 成本金额 毛利 毛利 库存数量 库存数量 660.00 240.00 7.00 230.00 30.00 2.00 - 522.00 -2.00 - 786.00 -3.00 - 1,052.00 -4.00 - 1,320.00 -5.00 - 1,590.00 -6.00 - 1,862.00 -7.00 - 2,136.00 -8.00 - 2,412.00 -9.00 - 2,690.00 -10.00 - 2,970.00 -11.00 - 3,252.00 -12.00 - 3,536.00 -13.00 - 3,822.00 -14.00 - 4,110.00 -15.00 - 4,400.00 -16.00 - 4,692.00 -17.00 - 4,986.00 -18.00 - 5,282.00 -19.00 - 5,580.00 -20.00 - 5,880.00 -21.00 - 6,182.00 -22.00 - 6,486.00 -23.00 - 6,792.00 -24.00 - 7,100.00 -25.00 - 7,410.00 -26.00 - 7,722.00 -27.00 - 8,036.00 -28.00 - 8,352.00 -29.00 - 8,670.00 -30.00 - 8,990.00 -31.00 - 9,312.00 -32.00 - 9,636.00 -33.00 - 9,962.00 -34.00 - 10,290.00 -35.00 - 10,620.00 -36.00 - 10,952.00 -37.00 - 11,286.00 -38.00 - 11,622.00 -39.00 - 11,960.00 -40.00 - 12,300.00 -41.00 - 12,642.00 -42.00 - 12,986.00 -43.00 - 13,332.00 -44.00 - 13,680.00 -45.00 - 14,030.00 -46.00 - 14,382.00 -47.00 - 14,736.00 -48.00 - 15,092.00 -49.00 - 15,450.00 -50.00 - 15,810.00 -51.00 - 16,172.00 -52.00 - 16,536.00 -53.00 - 16,902.00 -54.00 - 17,270.00 -55.00 - 17,640.00 -56.00 - 18,012.00 -57.00 - 18,386.00 -58.00 - 18,762.00 -59.00 - 19,140.00 -60.00 - 19,520.00 -61.00 - 19,902.00 -62.00 - 20,286.00 -63.00 - 20,672.00 -64.00 - 21,060.00 -65.00 - 21,450.00 -66.00 - 21,842.00 -67.00 - 22,236.00 -68.00 - 22,632.00 -69.00 - 23,030.00 -70.00 - 23,430.00 -71.00 - 23,832.00 -72.00 - 24,236.00 -73.00 - 24,642.00 -74.00 - 25,050.00 -75.00 - 25,460.00 -76.00 - 25,872.00 -77.00 - 26,286.00 -78.00 - 26,702.00 -79.00 - 27,120.00 -80.00 - 27,540.00 -81.00 - 27,962.00 -82.00 - 28,386.00 -83.00 - 28,812.00 -84.00 - 29,240.00 -85.00 - 29,670.00 -86.00 - 30,102.00 -87.00 - 30,536.00 -88.00 - 30,972.00 -89.00 - 31,410.00 -90.00 - 31,850.00 -91.00 - 32,292.00 -92.00 - 32,736.00 -93.00 - 33,182.00 -94