銷售收入、成本、費用、稅金分析表excel表格.xls

1、銷售收入、成本、費用、稅金分析表共14頁第1頁被審計單位名稱：查驗人員：日期：索引號：所屬時期或截至?xí)r間：復(fù)核人員：日期：金額單位：人民幣元月份銷售收入銷售成本銷售費用銷售稅金銷售成本率銷售費用率銷售稅金率112166.857749.18980.9610.2263.69%8.06%0.08%28501.996968.95970.69460.1781.97%11.42%5.41%310960.798361.14324.20451.0276.28%2.96%4.11%411735.975989.04180.5463.4651.03%1.54%0.54%510878.716835.02322.483

2、91.5362.83%2.96%3.60%67561.869158.29325.84290.55121.11%4.31%3.84%712878.068423.81262.82101.9365.41%2.04%0.79%810409.818256.45354.60138.0479.31%3.41%1.33%911880.567951.87755.11298.4266.93%6.36%2.51%1010835.108217.84162.70349.2375.84%1.50%3.22%1110458.337998.3152.43435.6976.48%0.50%4.17%127632.396394.

3、0680.93483.7583.78%1.06%6.34%合計125900.4292303.964773.293474.0173.32%3.79%2.76%一、銷售收入、成本相關(guān)情況二、銷售成本率變化情況回歸函數(shù)為：0.0314643167361.882505平均值：75.39%Y=0.0315X+7361.8825(Y:銷售成本 X:銷售收入)標準差：16.53%相關(guān)系數(shù)為：r=0.0581異常銷售收入、成本對比表1234567891011120.00 2000.00 4000.00 6000.00 8000.00 10000.00 12000.00 14000.00 銷售收入銷售成本銷售成

4、本率變化情況1234567891011 120.00%20.00%40.00%60.00%80.00%100.00%120.00%140.00%銷售成本率銷售收入、成本、費用、稅金分析表共14頁第2頁被審計單位名稱：查驗人員：日期：索引號：所屬時期或截至?xí)r間：復(fù)核人員：日期：金額單位：人民幣元三、銷售收入、費用相關(guān)情況四、銷售費用率變化情況回歸函數(shù)為：0.02194368167.5479543平均值：3.84%Y=0.0219X+167.5480(Y:銷售費用 X:銷售收入)標準差：3.11%相關(guān)系數(shù)為：r=0.1177異常五、銷售收入、稅金相關(guān)情況六、銷售稅金率變化情況回歸函數(shù)為：-0.05

5、8420737902.4335847平均值：3.00%Y=-0.0584X+902.4336(Y:銷售稅金 X:銷售收入)標準差：1.90%相關(guān)系數(shù)為：r=-0.5991異常銷售收入、費用對比表12345678910 11 120.00 2000.00 4000.00 6000.00 8000.00 10000.00 12000.00 14000.00 銷售收入銷售費用銷售費用率變化情況1234567891011120.00%2.00%4.00%6.00%8.00%10.00%12.00%銷售費用率銷售收入、費用對比表12345678910 11 120.00 2000.00 4000.00

6、6000.00 8000.00 10000.00 12000.00 14000.00 銷售收入銷售稅金銷售稅金率變化情況1234567891011120.00%1.00%2.00%3.00%4.00%5.00%6.00%7.00%銷售稅金率銷售收入、成本、費用、稅金分析表共14頁第3頁銷售收入、成本、費用、稅金分析表共14頁第4頁銷售收入、成本、費用、稅金年度對比表共14頁第5頁被審計單位名稱：查驗人員：日期：索引號：所屬時期或截至?xí)r間：復(fù)核人員：日期：金額單位：人民幣元月份上年度本年度增減金額增減比率銷售收入89241.85125900.4236658.5741.1%銷售成本75072.57

7、92303.9617231.3923.0%銷售費用3026.514773.291746.7857.7%銷售稅金966.333474.012507.67259.5%銷售成本率84.12%73.32%-10.81%-12.8%銷售費用率3.39%3.79%0.40%11.8%銷售稅金率1.08%2.76%1.68%154.8%一、銷售收入、成本、費用、稅金對比圖二、銷售成本率、銷售費用率、銷售稅金率對比圖銷售收入銷售成本銷售費用銷售稅金0.00 20000.00 40000.00 60000.00 80000.00 100000.00 120000.00 140000.00 上年度本年度銷售成本率

8、銷售費用率銷售稅金率0.00%10.00%20.00%30.00%40.00%50.00%60.00%70.00%80.00%90.00%上年度本年度銷售收入、成本匯總表共14頁第6頁被審計單位名稱：查驗人員：日期：索引號：所屬時期或截至?xí)r間：復(fù)核人員：日期：金額單位：人民幣元產(chǎn)品名稱上年銷售情況本年銷售情況銷售收入銷售成本銷售數(shù)量銷售單價單位成本銷售成本率銷售收入銷售成本銷售數(shù)量銷售單價單位成本銷售成本率A8511.994416.5869.03123.3163.9851.89%5473.513784.2499.8054.8437.9269.14%B1168.212484.1393.9512.

9、4326.44212.64%6636.615712.79106.6062.2653.5986.08%C5150.876344.1997.6752.7464.95123.17%6463.084069.7497.3066.4241.8362.97%D8843.233953.9262.65141.1563.1144.71%5964.004148.97105.6656.4539.2769.57%E1441.311091.4836.6739.3129.7775.73%5381.794407.64122.0444.1036.1281.90%F7188.751147.6017.47411.5765.7015

10、.96%6244.704679.5786.8071.9453.9174.94%G2806.02278.1360.4546.424.609.91%5929.164636.7282.8471.5755.9778.20%H32.385158.1041.390.78124.63 15929.00%5854.244360.37119.5648.9736.4774.48%I135.013384.0282.491.6441.02 2506.44%6559.194535.21144.2145.4831.4569.14%J8074.174131.2933.33242.26123.9651.17%7006.633

11、840.92101.5069.0337.8454.82%K8584.777109.6538.32224.04185.5582.82%5965.874196.08143.8941.4629.1670.33%L3157.641546.8537.7283.7141.0148.99%7418.923364.21124.1259.7727.1045.35%M3289.251317.4370.3046.7918.7440.05%7301.924483.62114.5763.7339.1361.40%N5872.684145.5799.5958.9741.6370.59%7766.934876.38137.

12、2156.6035.5462.78%O7687.633375.9520.04383.67168.4943.91%4893.274319.22138.5835.3131.1788.27%P2348.684932.822.97789.971659.13210.02%6117.824027.4477.9578.4851.6665.83%Q8519.316879.9520.25420.62339.6880.76%6283.025735.0377.6880.8973.8391.28%R250.891680.8939.696.3242.35669.97%6829.645814.59110.8861.605

13、2.4485.14%S6109.155736.7177.8378.5073.7193.90%7015.775280.31104.1367.3850.7175.26%T69.895957.3147.951.46124.23 8523.72%4794.366030.91151.8131.5839.73 125.79%合計89241.8575072.5784.12%125900.4292303.9673.32%一、上年銷售收入結(jié)構(gòu)圖二、本年銷售收入結(jié)構(gòu)圖10%1%6%10%2%8%3%0%0%9%10%4%4%7%9%3%10%0%7%0%ABCDEFGHIJKLMNOPQRST4%5%5%5%4%

14、5%5%5%5%6%5%6%6%6%4%5%5%5%6%4%ABCDEFGHIJKLMNOPQRST銷售收入、成本匯總表共14頁第7頁被審計單位名稱：查驗人員：日期：索引號：所屬時期或截至?xí)r間：復(fù)核人員：日期：金額單位：人民幣元10%1%6%10%2%8%3%0%0%9%10%4%4%7%9%3%10%0%7%0%ABCDEFGHIJKLMNOPQRST4%5%5%5%4%5%5%5%5%6%5%6%6%6%4%5%5%5%6%4%ABCDEFGHIJKLMNOPQRST6%3%8%5%1%2%0%7%5%6%9%2%2%6%4%7%9%2%8%8%ABCDEFGHIJKLMNOPQRST4%

15、6%4%4%5%5%5%5%5%4%5%4%5%5%5%4%6%6%6%7%ABCDEFGHIJKLMNOPQRSTA BCDEFGHIJKLM N OPQRST0.00 2000.00 4000.00 6000.00 8000.00 10000.00 上年銷售收入本年銷售收入A BCDEFGHIJKLM N OPQRST0.00 1000.00 2000.00 3000.00 4000.00 5000.00 6000.00 7000.00 8000.00 上年銷售成本本年銷售成本A BCDEFGHIJKL M N OPQRST0.00%5000.00%10000.00%15000.00%20

16、000.00%上年銷售成本率本年銷售成本率三、上年銷售成本結(jié)構(gòu)圖四、本年銷售成本結(jié)構(gòu)圖五、銷售收入對比圖六、銷售成本對比圖七、銷售成本率對比圖6%3%8%5%1%2%0%7%5%6%9%2%2%6%4%7%9%2%8%8%ABCDEFGHIJKLMNOPQRST4%6%4%4%5%5%5%5%5%4%5%4%5%5%5%4%6%6%6%7%ABCDEFGHIJKLMNOPQRSTA BCDEFGHIJKLM N OPQRST0.00 2000.00 4000.00 6000.00 8000.00 10000.00 上年銷售收入本年銷售收入A BCDEFGHIJKLM N OPQRST0.00

17、1000.00 2000.00 3000.00 4000.00 5000.00 6000.00 7000.00 8000.00 上年銷售成本本年銷售成本A BCDEFGHIJKL M N OPQRST0.00%5000.00%10000.00%15000.00%20000.00%上年銷售成本率本年銷售成本率銷售收入、成本匯總表共14頁第8頁被審計單位名稱：查驗人員：日期：索引號：所屬時期或截至?xí)r間：復(fù)核人員：日期：金額單位：人民幣元10%1%6%10%2%8%3%0%0%9%10%4%4%7%9%3%10%0%7%0%ABCDEFGHIJKLMNOPQRST4%5%5%5%4%5%5%5%5%

18、6%5%6%6%6%4%5%5%5%6%4%ABCDEFGHIJKLMNOPQRST6%3%8%5%1%2%0%7%5%6%9%2%2%6%4%7%9%2%8%8%ABCDEFGHIJKLMNOPQRST4%6%4%4%5%5%5%5%5%4%5%4%5%5%5%4%6%6%6%7%ABCDEFGHIJKLMNOPQRSTA BCDEFGHIJKLM N OPQRST0.00 2000.00 4000.00 6000.00 8000.00 10000.00 上年銷售收入本年銷售收入A BCDEFGHIJKLM N OPQRST0.00 1000.00 2000.00 3000.00 4000.

19、00 5000.00 6000.00 7000.00 8000.00 上年銷售成本本年銷售成本ABCDEFGHIJKLM NOPQRST0.00 20.00 40.00 60.00 80.00 100.00 120.00 140.00 160.00 上年銷售數(shù)量本年銷售數(shù)量ABCDEFGHIJKLMNOPQRST0.00 100.00 200.00 300.00 400.00 500.00 600.00 700.00 800.00 900.00 上年銷售單價本年銷售單價ABCDEFGHIJKLM NOPQ RST0.00 200.00 400.00 600.00 800.00 1000.00

20、1200.00 1400.00 1600.00 1800.00 上年單位成本本年單位成本A BCDEFGHIJKL M N OPQRST0.00%5000.00%10000.00%15000.00%20000.00%上年銷售成本率本年銷售成本率八、銷售數(shù)量對比圖九、銷售單價對比圖十、單位成本對比圖ABCDEFGHIJKLM NOPQRST0.00 20.00 40.00 60.00 80.00 100.00 120.00 140.00 160.00 上年銷售數(shù)量本年銷售數(shù)量ABCDEFGHIJKLMNOPQRST0.00 100.00 200.00 300.00 400.00 500.00 6

21、00.00 700.00 800.00 900.00 上年銷售單價本年銷售單價ABCDEFGHIJKLM NOPQ RST0.00 200.00 400.00 600.00 800.00 1000.00 1200.00 1400.00 1600.00 1800.00 上年單位成本本年單位成本分產(chǎn)品銷售收入、成本分析表共14頁第9頁被審計單位名稱：查驗人員：日期：索引號：所屬時期或截至?xí)r間：復(fù)核人員：日期：金額單位：人民幣元產(chǎn)品名稱項目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合計A銷售收入610.91530.75692.29213.80899.43547.1

22、0239.33680.70350.39436.00176.8595.965473.51銷售成本369.76184.20428.06182.63182.23298.31261.79796.91212.340.95687.34179.703784.24銷售數(shù)量4.558.563.5818.619.978.123.494.139.7018.633.536.9499.80銷售單價134.3962.04193.4011.4990.1967.3868.65164.8836.1323.4050.0513.8254.84單位成本81.3421.53119.599.8118.2736.7475.09193.03

23、21.900.05194.5225.8837.92銷售成本率60.5%34.7%61.8%85.4%20.3%54.5%109.4%117.1%60.6%0.2%388.7%187.3%69.1%收入、成本、數(shù)量對比圖單價、成本對比圖銷售成本率趨勢圖產(chǎn)品名稱項目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合計B銷售收入963.98211.26307.10875.2897.21274.91806.03623.11963.49946.31148.94418.996636.61銷售成本777.13506.41479.25344.84524.28635.25613.7

24、5397.40493.90545.1562.76332.665712.79銷售數(shù)量14.441.453.3315.0012.662.868.5713.937.3117.898.170.99106.60銷售單價66.74145.8092.1358.367.6896.1994.1144.73131.8152.9018.23421.4462.26單位成本53.81349.50143.7722.9941.42222.2771.6628.5267.5730.477.68334.6153.59銷售成本率80.6%239.7%156.1%39.4%539.3%231.1%76.1%63.8%51.3%57.

25、6%42.1%79.4%86.1%收入、成本、數(shù)量對比圖單價、成本對比圖銷售成本率趨勢圖1234567891011120.00 200.00 400.00 600.00 800.00 1000.00 銷售收入銷售成本銷售數(shù)量1234567891011120.00 50.00 100.00 150.00 200.00 250.00 銷售單價單位成本12345678910 11120.0%100.0%200.0%300.0%400.0%500.0%銷售成本率1234567891011120.00 200.00 400.00 600.00 800.00 1000.00 1200.00 銷售收入銷售成

26、本銷售數(shù)量1234567891011120.00 50.00 100.00 150.00 200.00 250.00 300.00 350.00 400.00 450.00 銷售單價單位成本1234567891011 120.0%100.0%200.0%300.0%400.0%500.0%600.0%銷售成本率分產(chǎn)品銷售收入、成本分析表共14頁第10頁被審計單位名稱：查驗人員：日期：索引號：所屬時期或截至?xí)r間：復(fù)核人員：日期：金額單位：人民幣元1234567891011120.00 200.00 400.00 600.00 800.00 1000.00 銷售收入銷售成本銷售數(shù)量12345678

27、91011120.00 50.00 100.00 150.00 200.00 250.00 銷售單價單位成本12345678910 11120.0%100.0%200.0%300.0%400.0%500.0%銷售成本率1234567891011120.00 200.00 400.00 600.00 800.00 1000.00 1200.00 銷售收入銷售成本銷售數(shù)量1234567891011120.00 50.00 100.00 150.00 200.00 250.00 300.00 350.00 400.00 450.00 銷售單價單位成本1234567891011 120.0%100.0

28、%200.0%300.0%400.0%500.0%600.0%銷售成本率1234567891011120.00 200.00 400.00 600.00 800.00 1000.00 銷售收入銷售成本銷售數(shù)量1234567891011120.00 2000.00 4000.00 6000.00 8000.00 10000.00 12000.00 14000.00 16000.00 銷售單價單位成本12345678910 11120.0%100.0%200.0%300.0%400.0%500.0%600.0%銷售成本率1234567891011120.00 200.00 400.00 600.0

29、0 800.00 1000.00 銷售收入銷售成本銷售數(shù)量1234567891011120.00 100.00 200.00 300.00 400.00 500.00 600.00 700.00 800.00 銷售單價單位成本1234567891011 120.0%500.0%1000.0%1500.0%2000.0%2500.0%銷售成本率產(chǎn)品名稱項目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合計C銷售收入951.72206.27897.57730.95406.53129.95914.87620.78506.00748.73268.3681.366463.

30、08銷售成本51.72383.00228.10148.59241.85380.5891.34408.02722.64628.26394.06391.594069.74銷售數(shù)量1.050.035.8716.5410.0115.195.9313.5419.112.464.692.8797.30銷售單價903.467317.72152.9444.1840.608.55154.1945.8326.48304.9357.2528.3366.42單位成本49.0913587.8538.878.9824.1525.0515.3930.1237.81255.8684.06136.3741.83銷售成本率5.4

31、%185.7%25.4%20.3%59.5%292.9%10.0%65.7%142.8%83.9%146.8%481.3%63.0%收入、成本、數(shù)量對比圖單價、成本對比圖銷售成本率趨勢圖產(chǎn)品名稱項目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合計D銷售收入795.23710.17593.07559.15636.43409.88302.2330.76546.46280.76932.70167.165964.00銷售成本467.89432.49281.06284.14104.36665.8357.40612.15156.77392.38689.325.184148

32、.97銷售數(shù)量1.298.4110.747.6312.861.338.759.8116.9710.241.3316.30105.66銷售單價618.0784.4455.2473.2949.48308.4934.543.1432.2127.42698.9210.2556.45單位成本363.6651.4226.1837.248.11501.146.5662.419.2438.32516.540.3239.27銷售成本率58.8%60.9%47.4%50.8%16.4%162.4%19.0%1990.1%28.7%139.8%73.9%3.1%69.6%收入、成本、數(shù)量對比圖單價、成本對比圖銷售成

33、本率趨勢圖1234567891011120.00 200.00 400.00 600.00 800.00 1000.00 銷售收入銷售成本銷售數(shù)量1234567891011120.00 2000.00 4000.00 6000.00 8000.00 10000.00 12000.00 14000.00 16000.00 銷售單價單位成本12345678910 11120.0%100.0%200.0%300.0%400.0%500.0%600.0%銷售成本率1234567891011120.00 200.00 400.00 600.00 800.00 1000.00 銷售收入銷售成本銷售數(shù)量12

34、34567891011120.00 100.00 200.00 300.00 400.00 500.00 600.00 700.00 800.00 銷售單價單位成本1234567891011 120.0%500.0%1000.0%1500.0%2000.0%2500.0%銷售成本率分產(chǎn)品銷售收入、成本分析表共14頁第11頁被審計單位名稱：查驗人員：日期：索引號：所屬時期或截至?xí)r間：復(fù)核人員：日期：金額單位：人民幣元1234567891011120.00 200.00 400.00 600.00 800.00 1000.00 銷售收入銷售成本銷售數(shù)量1234567891011120.00 50.

35、00 100.00 150.00 200.00 250.00 銷售單價單位成本12345678910 11120.0%100.0%200.0%300.0%400.0%500.0%銷售成本率1234567891011120.00 200.00 400.00 600.00 800.00 1000.00 1200.00 銷售收入銷售成本銷售數(shù)量1234567891011120.00 50.00 100.00 150.00 200.00 250.00 300.00 350.00 400.00 450.00 銷售單價單位成本1234567891011 120.0%100.0%200.0%300.0%40

36、0.0%500.0%600.0%銷售成本率1234567891011120.00 200.00 400.00 600.00 800.00 1000.00 銷售收入銷售成本銷售數(shù)量1234567891011120.00 2000.00 4000.00 6000.00 8000.00 10000.00 12000.00 14000.00 16000.00 銷售單價單位成本12345678910 11120.0%100.0%200.0%300.0%400.0%500.0%600.0%銷售成本率1234567891011120.00 200.00 400.00 600.00 800.00 1000.0

37、0 銷售收入銷售成本銷售數(shù)量1234567891011120.00 100.00 200.00 300.00 400.00 500.00 600.00 700.00 800.00 銷售單價單位成本1234567891011 120.0%500.0%1000.0%1500.0%2000.0%2500.0%銷售成本率1234567891011120.00 200.00 400.00 600.00 800.00 1000.00 銷售收入銷售成本銷售數(shù)量1234567891011120.00 100.00 200.00 300.00 400.00 500.00 600.00 700.00 800.00

38、 900.00 銷售單價單位成本12345678910 11120.0%100.0%200.0%300.0%400.0%500.0%600.0%700.0%800.0%銷售成本率1234567891011120.00 200.00 400.00 600.00 800.00 1000.00 銷售收入銷售成本銷售數(shù)量1234567891011120.00 100.00 200.00 300.00 400.00 500.00 600.00 700.00 銷售單價單位成本1234567891011 120.0%100.0%200.0%300.0%400.0%500.0%銷售成本率產(chǎn)品名稱項目1月份2月

39、份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合計E銷售收入161.55753.99540.63874.0872.16440.78319.64425.32567.99416.80723.7885.075381.79銷售成本285.2657.52496.7213.88416.40274.86105.66550.89426.88788.38351.07640.124407.64銷售數(shù)量9.6418.5317.185.803.790.5514.1016.142.0718.1614.651.43122.04銷售單價16.7740.6931.47150.6719.04801.712

40、2.6726.35274.6322.9549.4059.3844.10單位成本29.603.1028.912.39109.87499.947.4934.12206.4043.4123.96446.7936.12銷售成本率176.6%7.6%91.9%1.6%577.1%62.4%33.1%129.5%75.2%189.2%48.5%752.4%81.9%收入、成本、數(shù)量對比圖單價、成本對比圖銷售成本率趨勢圖產(chǎn)品名稱項目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合計F銷售收入557.87686.52514.25592.54320.98176.16876.083

41、73.04322.79629.99626.35568.116244.70銷售成本683.63560.40788.07278.16304.26733.79525.87166.8664.6882.02249.82242.024679.57銷售數(shù)量1.5012.6018.4418.246.695.702.478.095.531.031.974.5286.80銷售單價371.1554.4827.8832.4847.9630.90355.2246.0858.38608.89317.46125.6771.94單位成本454.8144.4742.7315.2545.46128.73213.2220.6111

42、.7079.27126.6253.5453.91銷售成本率122.5%81.6%153.2%46.9%94.8%416.5%60.0%44.7%20.0%13.0%39.9%42.6%74.9%收入、成本、數(shù)量對比圖單價、成本對比圖銷售成本率趨勢圖1234567891011120.00 200.00 400.00 600.00 800.00 1000.00 銷售收入銷售成本銷售數(shù)量1234567891011120.00 100.00 200.00 300.00 400.00 500.00 600.00 700.00 800.00 900.00 銷售單價單位成本12345678910 11120

43、.0%100.0%200.0%300.0%400.0%500.0%600.0%700.0%800.0%銷售成本率1234567891011120.00 200.00 400.00 600.00 800.00 1000.00 銷售收入銷售成本銷售數(shù)量1234567891011120.00 100.00 200.00 300.00 400.00 500.00 600.00 700.00 銷售單價單位成本1234567891011 120.0%100.0%200.0%300.0%400.0%500.0%銷售成本率分產(chǎn)品銷售收入、成本分析表共14頁第12頁被審計單位名稱：查驗人員：日期：索引號：所屬時

44、期或截至?xí)r間：復(fù)核人員：日期：金額單位：人民幣元1234567891011120.00 200.00 400.00 600.00 800.00 1000.00 銷售收入銷售成本銷售數(shù)量1234567891011120.00 50.00 100.00 150.00 200.00 250.00 銷售單價單位成本12345678910 11120.0%100.0%200.0%300.0%400.0%500.0%銷售成本率1234567891011120.00 200.00 400.00 600.00 800.00 1000.00 1200.00 銷售收入銷售成本銷售數(shù)量123456789101112

45、0.00 50.00 100.00 150.00 200.00 250.00 300.00 350.00 400.00 450.00 銷售單價單位成本1234567891011 120.0%100.0%200.0%300.0%400.0%500.0%600.0%銷售成本率1234567891011120.00 200.00 400.00 600.00 800.00 1000.00 銷售收入銷售成本銷售數(shù)量1234567891011120.00 2000.00 4000.00 6000.00 8000.00 10000.00 12000.00 14000.00 16000.00 銷售單價單位成本

46、12345678910 11120.0%100.0%200.0%300.0%400.0%500.0%600.0%銷售成本率1234567891011120.00 200.00 400.00 600.00 800.00 1000.00 銷售收入銷售成本銷售數(shù)量1234567891011120.00 100.00 200.00 300.00 400.00 500.00 600.00 700.00 800.00 銷售單價單位成本1234567891011 120.0%500.0%1000.0%1500.0%2000.0%2500.0%銷售成本率1234567891011120.00 200.00 4

47、00.00 600.00 800.00 1000.00 銷售收入銷售成本銷售數(shù)量1234567891011120.00 100.00 200.00 300.00 400.00 500.00 600.00 700.00 800.00 900.00 銷售單價單位成本12345678910 11120.0%100.0%200.0%300.0%400.0%500.0%600.0%700.0%800.0%銷售成本率1234567891011120.00 200.00 400.00 600.00 800.00 1000.00 銷售收入銷售成本銷售數(shù)量1234567891011120.00 100.00 2

48、00.00 300.00 400.00 500.00 600.00 700.00 銷售單價單位成本1234567891011 120.0%100.0%200.0%300.0%400.0%500.0%銷售成本率1234567891011120.00 200.00 400.00 600.00 800.00 1000.00 1200.00 銷售收入銷售成本銷售數(shù)量1234567891011120.00 500.00 1000.00 1500.00 2000.00 2500.00 3000.00 銷售單價單位成本12345678910 11 120.0%500.0%1000.0%1500.0%2000

49、.0%2500.0%3000.0%3500.0%銷售成本率1234567891011120.00 100.00 200.00 300.00 400.00 500.00 600.00 700.00 800.00 銷售收入銷售成本銷售數(shù)量1234567891011120.00 200.00 400.00 600.00 800.00 1000.00 銷售單價單位成本1234567891011 120.0%50.0%100.0%150.0%200.0%250.0%銷售成本率產(chǎn)品名稱項目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合計G銷售收入792.89659.463

50、47.16505.05411.5014.17835.13988.96308.40236.65500.56329.225929.16銷售成本294.81491.94638.09642.34295.82468.15764.6868.57313.03270.13345.3143.844636.72銷售數(shù)量16.188.162.7410.360.162.4415.5711.851.225.243.125.8082.84銷售單價48.9980.84126.7348.732648.055.8153.6483.48251.8245.20160.2356.7771.57單位成本18.2260.31232.93

51、61.981903.68191.7649.125.79255.6051.60110.537.5655.97銷售成本率37.2%74.6%183.8%127.2%71.9%3303.0%91.6%6.9%101.5%114.1%69.0%13.3%78.2%收入、成本、數(shù)量對比圖單價、成本對比圖銷售成本率趨勢圖產(chǎn)品名稱項目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合計H銷售收入354.25605.66697.32410.9076.49729.14563.23696.81735.31390.85477.57116.725854.24銷售成本738.33351.7

52、1741.869.10127.87621.20245.15685.40385.02366.0981.487.164360.37銷售數(shù)量0.8412.2013.780.6617.3117.335.9916.928.2517.585.732.97119.56銷售單價423.4549.6450.61623.774.4242.0894.0841.1789.1022.2483.3239.3148.97單位成本882.5728.8253.8513.817.3935.8540.9540.5046.6520.8314.212.4136.47銷售成本率208.4%58.1%106.4%2.2%167.2%85.

53、2%43.5%98.4%52.4%93.7%17.1%6.1%74.5%收入、成本、數(shù)量對比圖單價、成本對比圖銷售成本率趨勢圖1234567891011120.00 200.00 400.00 600.00 800.00 1000.00 1200.00 銷售收入銷售成本銷售數(shù)量1234567891011120.00 500.00 1000.00 1500.00 2000.00 2500.00 3000.00 銷售單價單位成本12345678910 11 120.0%500.0%1000.0%1500.0%2000.0%2500.0%3000.0%3500.0%銷售成本率123456789101

54、1120.00 100.00 200.00 300.00 400.00 500.00 600.00 700.00 800.00 銷售收入銷售成本銷售數(shù)量1234567891011120.00 200.00 400.00 600.00 800.00 1000.00 銷售單價單位成本1234567891011 120.0%50.0%100.0%150.0%200.0%250.0%銷售成本率分產(chǎn)品銷售收入、成本分析表共14頁第13頁被審計單位名稱：查驗人員：日期：索引號：所屬時期或截至?xí)r間：復(fù)核人員：日期：金額單位：人民幣元1234567891011120.00 200.00 400.00 600.

55、00 800.00 1000.00 銷售收入銷售成本銷售數(shù)量1234567891011120.00 50.00 100.00 150.00 200.00 250.00 銷售單價單位成本12345678910 11120.0%100.0%200.0%300.0%400.0%500.0%銷售成本率1234567891011120.00 200.00 400.00 600.00 800.00 1000.00 1200.00 銷售收入銷售成本銷售數(shù)量1234567891011120.00 50.00 100.00 150.00 200.00 250.00 300.00 350.00 400.00 45

56、0.00 銷售單價單位成本1234567891011 120.0%100.0%200.0%300.0%400.0%500.0%600.0%銷售成本率1234567891011120.00 200.00 400.00 600.00 800.00 1000.00 銷售收入銷售成本銷售數(shù)量1234567891011120.00 2000.00 4000.00 6000.00 8000.00 10000.00 12000.00 14000.00 16000.00 銷售單價單位成本12345678910 11120.0%100.0%200.0%300.0%400.0%500.0%600.0%銷售成本率1

57、234567891011120.00 200.00 400.00 600.00 800.00 1000.00 銷售收入銷售成本銷售數(shù)量1234567891011120.00 100.00 200.00 300.00 400.00 500.00 600.00 700.00 800.00 銷售單價單位成本1234567891011 120.0%500.0%1000.0%1500.0%2000.0%2500.0%銷售成本率1234567891011120.00 200.00 400.00 600.00 800.00 1000.00 銷售收入銷售成本銷售數(shù)量1234567891011120.00 10

58、0.00 200.00 300.00 400.00 500.00 600.00 700.00 800.00 900.00 銷售單價單位成本12345678910 11120.0%100.0%200.0%300.0%400.0%500.0%600.0%700.0%800.0%銷售成本率1234567891011120.00 200.00 400.00 600.00 800.00 1000.00 銷售收入銷售成本銷售數(shù)量1234567891011120.00 100.00 200.00 300.00 400.00 500.00 600.00 700.00 銷售單價單位成本1234567891011

59、 120.0%100.0%200.0%300.0%400.0%500.0%銷售成本率1234567891011120.00 200.00 400.00 600.00 800.00 1000.00 1200.00 銷售收入銷售成本銷售數(shù)量1234567891011120.00 500.00 1000.00 1500.00 2000.00 2500.00 3000.00 銷售單價單位成本12345678910 11 120.0%500.0%1000.0%1500.0%2000.0%2500.0%3000.0%3500.0%銷售成本率1234567891011120.00 100.00 200.00

60、 300.00 400.00 500.00 600.00 700.00 800.00 銷售收入銷售成本銷售數(shù)量1234567891011120.00 200.00 400.00 600.00 800.00 1000.00 銷售單價單位成本1234567891011 120.0%50.0%100.0%150.0%200.0%250.0%銷售成本率產(chǎn)品名稱項目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合計I銷售收入482.94547.83346.94135.34969.45548.90817.57695.10937.94445.14266.19365.85655