加权平均法公式-成本表

共计,,,,"52,353","604,422.00","58,653","100,422.00","20,853","132,329.23","90,153",*,"572,514.77"

序号,商品名称,单位,规格,上月结存数,,本月入库数,,本月出库数,,本月结存数,,

,,,,数量,成本额,数量,成本额,数量,成本额,数量,平均单价,成本额

1,,,,800,"9,563.00",900,"1,563.00",300,"1,963.41","1,400",6.544706,"9,162.59"

2,,,,801,"9,564.00",901,"1,564.00",301,"1,968.00","1,401",6.538190,"9,160.00"

3,,,,802,"9,565.00",902,"1,565.00",302,"1,972.57","1,402",6.531690,"9,157.43"

4,,,,803,"9,566.00",903,"1,566.00",303,"1,977.14","1,403",6.525205,"9,154.86"

5,,,,804,"9,567.00",904,"1,567.00",304,"1,981.70","1,404",6.518735,"9,152.30"

6,,,,805,"9,568.00",905,"1,568.00",305,"1,986.25","1,405",6.512281,"9,149.75"

7,,,,806,"9,569.00",906,"1,569.00",306,"1,990.79","1,406",6.505841,"9,147.21"

8,,,,807,"9,570.00",907,"1,570.00",307,"1,995.32","1,407",6.499417,"9,144.68"

9,,,,808,"9,571.00",908,"1,571.00",308,"1,999.85","1,408",6.493007,"9,142.15"

10,,,,809,"9,572.00",909,"1,572.00",309,"2,004.36","1,409",6.486612,"9,139.64"

11,,,,810,"9,573.00",910,"1,573.00",310,"2,008.87","1,410",6.480233,"9,137.13"

12,,,,811,"9,574.00",911,"1,574.00",311,"2,013.37","1,411",6.473868,"9,134.63"

13,,,,812,"9,575.00",912,"1,575.00",312,"2,017.87","1,412",6.467517,"9,132.13"

14,,,,813,"9,576.00",913,"1,576.00",313,"2,022.35","1,413",6.461182,"9,129.65"

15,,,,814,"9,577.00",914,"1,577.00",314,"2,026.83","1,414",6.454861,"9,127.17"

16,,,,815,"9,578.00",915,"1,578.00",315,"2,031.29","1,415",6.448555,"9,124.71"

17,,,,816,"9,579.00",916,"1,579.00",316,"2,035.76","1,416",6.442263,"9,122.24"

18,,,,817,"9,580.00",917,"1,580.00",317,"2,040.21","1,417",6.435986,"9,119.79"

19,,,,818,"9,581.00",918,"1,581.00",318,"2,044.65","1,418",6.429724,"9,117.35"

20,,,,819,"9,582.00",919,"1,582.00",319,"2,049.09","1,419",6.423475,"9,114.91"

21,,,,820,"9,583.00",920,"1,583.00",320,"2,053.52","1,420",6.417241,"9,112.48"

22,,,,821,"9,584.00",921,"1,584.00",321,"2,057.94","1,421",6.411022,"9,110.06"

23,,,,822,"9,585.00",922,"1,585.00",322,"2,062.35","1,422",6.404817,"9,107.65"

24,,,,823,"9,586.00",923,"1,586.00",323,"2,066.76","1,423",6.398625,"9,105.24"

25,,,,824,"9,587.00",924,"1,587.00",324,"2,071.15","1,424",6.392449,"9,102.85"

26,,,,825,"9,588.00",925,"1,588.00",325,"2,075.54","1,425",6.386286,"9,100.46"

27,,,,826,"9,589.00",926,"1,589.00",326,"2,079.92","1,426",6.380137,"9,098.08"

28,,,,827,"9,590.00",927,"1,590.00",327,"2,084.30","1,427",6.374002,"9,095.70"

29,,,,828,"9,591.00",928,"1,591.00",328,"2,088.67","1,428",6.367882,"9,093.33"

30,,,,829,"9,592.00",929,"1,592.00",329,"2,093.02","1,429",6.361775,"9,090.98"

31,,,,830,"9,593.00",930,"1,593.00",330,"2,097.38","1,430",6.355682,"9,088.63"

32,,,,831,"9,594.00",931,"1,594.00",331,"2,101.72","1,431",6.349603,"9,086.28"

33,,,,832,"9,595.00",932,"1,595.00",332,"2,106.05","1,432",6.343537,"9,083.95"

34,,,,833,"9,596.00",933,"1,596.00",333,"2,110.38","1,433",6.337486,"9,081.62"

35,,,,834,"9,597.00",934,"1,597.00",334,"2,114.70","1,434",6.331448,"9,079.30"

36,,,,835,"9,598.00",935,"1,598.00",335,"2,119.02","1,435",6.325424,"9,076.98"

37,,,,836,"9,599.00",936,"1,599.00",336,"2,123.32","1,436",6.319413,"9,074.68"

38,,,,837,"9,600.00",937,"1,600.00",337,"2,127.62","1,437",6.313416,"9,072.38"

39,,,,838,"9,601.00",938,"1,601.00",338,"2,131.91","1,438",6.307432,"9,070.09"

40,,,,839,"9,602.00",939,"1,602.00",339,"2,136.20","1,439",6.301462,"9,067.80"

41,,,,840,"9,603.00",940,"1,603.00",340,"2,140.47","1,440",6.295506,"9,065.53"

42,,,,841,"9,604.00",941,"1,604.00",341,"2,144.74","1,441",6.289562,"9,063.26"

43,,,,842,"9,605.00",942,"1,605.00",342,"2,149.00","1,442",6.283632,"9,061.00"

44,,,,843,"9,606.00",943,"1,606.00",343,"2,153.26","1,443",6.277716,"9,058.74"

45,,,,844,"9,607.00",944,"1,607.00",344,"2,157.50","1,444",6.271812,"9,056.50"

46,,,,845,"9,608.00",945,"1,608.00",345,"2,161.74","1,445",6.265922,"9,054.26"

47,,,,846,"9,609.00",946,"1,609.00",346,"2,165.98","1,446",6.260045,"9,052.02"

,,,,847,"9,610.00",947,"1,610.00",347,"2,170.20","1,447",6.254181,"9,049.80"

,,,,848,"9,611.00",948,"1,611.00",348,"2,174.42","1,448",6.248330,"9,047.58"

,,,,849,"9,612.00",949,"1,612.00",349,"2,178.63","1,449",6.242492,"9,045.37"

,,,,850,"9,613.00",950,"1,613.00",350,"2,182.83","1,450",6.236667,"9,043.17"

,,,,851,"9,614.00",951,"1,614.00",351,"2,187.03","1,451",6.230855,"9,040.97"

,,,,852,"9,615.00",952,"1,615.00",352,"2,191.22","1,452",6.225055,"9,038.78"

,,,,853,"9,616.00",953,"1,616.00",353,"2,195.40","1,453",6.219269,"9,036.60"

,,,,854,"9,617.00",954,"1,617.00",354,"2,199.58","1,454",6.213496,"9,034.42"

,,,,855,"9,618.00",955,"1,618.00",355,"2,203.75","1,455",6.207735,"9,032.25"

,,,,856,"9,619.00",956,"1,6