销售收入、成本、费用、税金分析表.xls
《销售收入、成本、费用、税金分析表.xls》由会员分享,可在线阅读,更多相关《销售收入、成本、费用、税金分析表.xls(16页珍藏版)》请在淘文阁 - 分享文档赚钱的网站上搜索。
1、销售收入、成本、费用、税金分析表共16页第1页被审计单位名称:查验人员:日期:索引号:所属时期或截至时间:复核人员:日期:金额单位:人民币元月份销售收入销售成本销售费用销售税金销售成本率销售费用率销售税金率110577.425595.10168.36356.7252.90%1.59%3.37%211811.619212.56402.07244.3778.00%3.40%2.07%310405.526299.41997.39271.1760.54%9.59%2.61%48729.176934.01219.32479.3879.43%2.51%5.49%512091.697824.52641.94
2、115.6664.71%5.31%0.96%68627.108197.89965.79477.7195.02%11.19%5.54%710970.739333.35264.85144.2285.07%2.41%1.31%811148.998115.61233.12393.7572.79%2.09%3.53%97874.228964.97301.85402.84113.85%3.83%5.12%1011550.059017.5514.98147.6278.07%0.13%1.28%118801.847933.38566.66485.7090.13%6.44%5.52%1210388.211034
3、7.80460.85459.5299.61%4.44%4.42%合计122976.5597776.175237.173978.6579.51%4.26%3.24%一、销售收入、成本相关情况二、销售成本率变化情况回归函数为:0.1078155637043.115246平均值:80.84%Y=0.1078X+7043.1152(Y:销售成本 X:销售收入)标准差:16.54%相关系数为:r=0.1113异常销售收入、成本对比表1234567891011120.00 2000.00 4000.00 6000.00 8000.00 10000.00 12000.00 14000.00 销售收入销售成本
4、销售成本率变化情况1234567891011120.00%20.00%40.00%60.00%80.00%100.00%120.00%销售成本率销售收入、成本、费用、税金分析表共16页第2页被审计单位名称:查验人员:日期:索引号:所属时期或截至时间:复核人员:日期:金额单位:人民币元三、销售收入、费用相关情况四、销售费用率变化情况回归函数为:-0.042627323873.2774089平均值:4.41%Y=-0.0426X+873.2774(Y:销售费用 X:销售收入)标准差:3.14%相关系数为:r=-0.1945异常五、销售收入、税金相关情况六、销售税金率变化情况回归函数为:-0.077
5、9290171130.174233平均值:3.43%Y=-0.0779X+1130.1742(Y:销售税金 X:销售收入)标准差:1.70%相关系数为:r=-0.7742异常销售收入、费用对比表12345678910 11 120.00 2000.00 4000.00 6000.00 8000.00 10000.00 12000.00 14000.00 销售收入销售费用销售费用率变化情况12345678910 11 120.00%2.00%4.00%6.00%8.00%10.00%12.00%销售费用率销售收入、费用对比表123456789 10 11 120.00 2000.00 4000.
6、00 6000.00 8000.00 10000.00 12000.00 14000.00 销售收入销售税金销售税金率变化情况12345678910 11 120.00%1.00%2.00%3.00%4.00%5.00%6.00%销售税金率销售收入、成本、费用、税金分析表共16页第3页销售收入、成本、费用、税金分析表共16页第4页销售收入、成本、费用、税金年度对比表共16页第5页被审计单位名称:查验人员:日期:索引号:所属时期或截至时间:复核人员:日期:金额单位:人民币元月份上年度本年度增减金额增减比率销售收入95551.45122976.5527425.1028.7%销售成本71259.95
7、97776.1726516.2237.2%销售费用10777.655237.17-5540.48-51.4%销售税金3728.443978.65250.216.7%销售成本率74.58%79.51%4.93%6.6%销售费用率11.28%4.26%-7.02%-62.2%销售税金率3.90%3.24%-0.67%-17.1%一、销售收入、成本、费用、税金对比图二、销售成本率、销售费用率、销售税金率对比图销售收入销售成本销售费用销售税金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%上年度本年度销售收入、成本汇总表共16页第6页被审计单位名称:查验人员:日期:索引号:所属时期或截至时间:复核人员:日期:金额单位:人民币元产品名称上年销售情况本年销售情况销售收入销售成本销售数量销售单价单位成本销售成本率销售收入销售成本销售数量销售单价单位成本销售成本率A1203.031904.1587.0313.8221.88158.28%5497.104737.07152.3236.0931.10 86.17%B7053.802874.3533.24
9、212.1986.4740.75%6584.015662.96139.5947.1740.57 86.01%C24.106085.1564.200.3894.79#7642.564960.8793.5881.6753.01 64.91%D2927.172632.1383.6035.0231.4989.92%4928.164596.10125.0939.4036.74 93.26%E9165.804436.9972.94125.6560.8348.41%6274.583654.96124.4550.4229.37 58.25%F9035.8386.2324.85363.583.470.95%58
10、36.065205.9185.2968.4261.03 89.20%G7025.525101.6950.57138.93100.8972.62%6045.085391.73102.1059.2152.81 89.19%H6021.323608.4099.4060.5736.3059.93%7168.974856.94150.1447.7532.35 67.75%I407.821340.8288.454.6115.16328.78%4769.565013.70114.8041.5543.67#J1607.155865.0941.8838.38140.05364.94%7950.915188.91
11、85.4393.0760.74 65.26%K7018.894520.2646.73150.2096.7364.40%5562.655189.62139.4139.9037.22 93.29%L2697.501251.1586.0231.3614.5546.38%6818.894600.02139.2048.9933.05 67.46%M7383.165306.6616.34451.81324.7471.88%4877.464652.78127.9238.1336.37 95.39%N7289.965405.3080.6990.3466.9974.15%5634.174573.99111.98
12、50.3240.85 81.18%O3209.604718.8273.2043.8564.47147.02%5421.046173.04124.2443.6349.68#P8276.913712.5911.15742.05332.8544.85%7442.214470.1997.3076.4945.94 60.07%Q890.453155.7099.928.9131.58354.40%4711.784241.96131.4835.8432.26 90.03%R9741.567708.6552.74184.70146.1579.13%7331.494674.05155.0947.2730.14
13、63.75%S4558.11429.419.83463.5343.679.42%6273.424519.46103.4260.6643.70 72.04%T13.781116.4322.420.6149.80#6206.445411.92152.9340.5835.39 87.20%合计95551.4571259.9574.58%122976.5597776.1779.51%一、上年销售收入结构图二、本年销售收入结构图1%7%0%3%10%10%7%6%0%2%7%3%8%8%3%9%1%10%5%0%ABCDEFGHIJKLMNOPQRST4%5%6%4%5%5%5%6%4%6%5%6%4%
14、5%4%6%4%6%5%5%ABCDEFGHIJKLMNOPQRST销售收入、成本汇总表共16页第7页三、上年销售成本结构图四、本年销售成本结构图五、销售收入对比图六、销售成本对比图七、销售成本率对比图3%4%8%4%6%0%7%5%2%8%6%2%7%8%7%5%4%11%1%2%ABCDEFGHIJKLMNOPQRST5%6%5%5%4%5%5%5%5%5%5%5%5%5%6%5%4%5%5%5%ABCDEFGHIJKLMNOPQRSTABCDEFGHIJKLM NOPQRST0.00 2000.00 4000.00 6000.00 8000.00 10000.00 12000.00 上年
15、销售收入本年销售收入ABCDEFGHIJKLM NOPQRST0.00 1000.00 2000.00 3000.00 4000.00 5000.00 6000.00 7000.00 8000.00 9000.00 上年销售成本本年销售成本ABCDEFGHIJKLM NOPQRST0.00%5000.00%10000.00%15000.00%20000.00%25000.00%30000.00%上年销售成本率本年销售成本率1%7%0%3%10%10%7%6%0%2%7%3%8%8%3%9%1%10%5%0%ABCDEFGHIJKLMNOPQRST4%5%6%4%5%5%5%6%4%6%5%6%
16、4%5%4%6%4%6%5%5%ABCDEFGHIJKLMNOPQRST被审计单位名称:查验人员:日期:索引号:所属时期或截至时间:复核人员:日期:金额单位:人民币元销售收入、成本汇总表共16页第8页八、销售数量对比图九、销售单价对比图十、单位成本对比图ABCDEFGHIJKLM NOPQRST0.00 20.00 40.00 60.00 80.00 100.00 120.00 140.00 160.00 180.00 上年销售数量本年销售数量ABCDEFGHIJKLMNOPQRST0.00 100.00 200.00 300.00 400.00 500.00 600.00 700.00 80
17、0.00 上年销售单价本年销售单价ABCDEFGHIJKLM NOPQRST0.00 50.00 100.00 150.00 200.00 250.00 300.00 350.00 上年单位成本本年单位成本ABCDEFGHIJKLM NOPQRST0.00%5000.00%10000.00%15000.00%20000.00%25000.00%30000.00%上年销售成本率本年销售成本率被审计单位名称:查验人员:日期:索引号:所属时期或截至时间:复核人员:日期:金额单位:人民币元销售收入、成本汇总表共16页第9页ABCDEFGHIJKLM NOPQRST0.00 50.00 100.00 1
18、50.00 200.00 250.00 300.00 350.00 上年单位成本本年单位成本被审计单位名称:查验人员:日期:索引号:所属时期或截至时间:复核人员:日期:金额单位:人民币元分产品销售收入、成本分析表共16页第10页被审计单位名称:查验人员:日期:索引号:所属时期或截至时间:复核人员:日期:金额单位:人民币元产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计A销售收入12.24645.47420.87389.48772.90745.77640.58827.804.01440.012.62595.375497.10销售成本686.69139
19、.36140.05200.14105.09526.52750.53633.63370.93342.18261.49580.454737.07销售数量18.4912.3715.596.5419.874.0213.5611.4011.608.8113.9016.16152.32销售单价0.6652.1626.9959.5238.91185.6447.2372.590.3549.930.1936.8336.09单位成本37.1411.268.9830.595.29131.0655.3455.5631.9938.8318.8135.9131.10销售成本率5608.9%21.6%33.3%51.4%1
20、3.6%70.6%117.2%76.5%9261.2%77.8%9978.2%97.5%86.2%收入、成本、数量对比图单价、成本对比图销售成本率趋势图产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计B销售收入162.15711.45823.15144.27973.88779.65239.61550.16581.27961.26304.91352.246584.01销售成本727.40209.8928.62732.36572.70190.40585.37548.87568.31438.90547.08513.065662.96销售数量15.3319
21、.6913.199.6618.411.946.725.882.6314.6117.8913.64139.59销售单价10.5836.1362.4114.9452.89401.2635.6893.63221.4065.8017.0425.8247.17单位成本47.4510.662.1775.8331.1097.9987.1793.41216.4630.0430.5737.6140.57销售成本率448.6%29.5%3.5%507.6%58.8%24.4%244.3%99.8%97.8%45.7%179.4%145.7%86.0%收入、成本、数量对比图单价、成本对比图销售成本率趋势图12345
22、67891011120.00 100.00 200.00 300.00 400.00 500.00 600.00 700.00 800.00 900.00 销售收入销售成本销售数量1234567891011120.00 20.00 40.00 60.00 80.00 100.00 120.00 140.00 160.00 180.00 200.00 销售单价单位成本123456789 10 11 120.0%2000.0%4000.0%6000.0%8000.0%10000.0%12000.0%销售成本率1234567891011120.00 200.00 400.00 600.00 800.
23、00 1000.00 1200.00 销售收入销售成本销售数量1234567891011120.00 50.00 100.00 150.00 200.00 250.00 300.00 350.00 400.00 450.00 销售单价单位成本123456789 10 11 120.0%100.0%200.0%300.0%400.0%500.0%600.0%销售成本率分产品销售收入、成本分析表共16页第11页产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计C销售收入974.81842.38804.38304.08557.3145.26969.5843
24、8.19881.42345.59941.67537.917642.56销售成本677.40122.3875.105.21693.3730.89412.85688.03752.82313.92697.89491.004960.87销售数量16.876.144.648.0710.370.114.642.348.9216.743.1211.6293.58销售单价57.77137.27173.3437.7053.75399.85209.12187.0798.7820.64301.5846.3081.67单位成本40.1419.9416.180.6566.87272.9389.04293.7384.37
25、18.75223.5142.2653.01销售成本率69.5%14.5%9.3%1.7%124.4%68.3%42.6%157.0%85.4%90.8%74.1%91.3%64.9%收入、成本、数量对比图单价、成本对比图销售成本率趋势图产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计D销售收入483.9656.51493.44435.32594.3429.73937.68184.55381.28902.8321.48407.044928.16销售成本11.60778.3387.51799.77441.24243.47257.36294.1921.2
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 销售收入 成本 费用 税金 分析
限制150内