收入、成本、费用、税金分析表excel表格.xls
《收入、成本、费用、税金分析表excel表格.xls》由会员分享,可在线阅读,更多相关《收入、成本、费用、税金分析表excel表格.xls(16页珍藏版)》请在淘文阁 - 分享文档赚钱的网站上搜索。
1、销售收入、成本、费用、税金分析表共16页第1页被审计单位名称:查验人员:日期:索引号:所属时期或截至时间:复核人员:日期:金额单位:人民币元月份销售收入销售成本销售费用销售税金销售成本率销售费用率销售税金率19950.297636.80648.40279.4076.75%6.52%2.81%210962.979016.90960.22114.5082.25%8.76%1.04%39988.726527.34587.18253.9265.35%5.88%2.54%413279.158293.61332.10110.0762.46%2.50%0.83%510805.888051.95923.832
2、17.3074.51%8.55%2.01%69913.016752.87431.8877.4668.12%4.36%0.78%710089.229782.56293.85383.3296.96%2.91%3.80%810973.748905.47468.60452.8281.15%4.27%4.13%911537.678847.67555.48498.3876.69%4.81%4.32%107256.568644.04913.25395.94119.12%12.59%5.46%1112132.367198.81612.04218.4759.34%5.04%1.80%129399.339465.
3、36973.83325.00100.70%10.36%3.46%合计126288.9099123.377700.653326.5878.49%6.10%2.63%一、销售收入、成本相关情况二、销售成本率变化情况回归函数为:-0.0613407298905.835548平均值:80.28%Y=-0.0613X+8905.8355(Y:销售成本 X:销售收入)标准差:16.82%相关系数为:r=-0.0879异常销售收入、成本对比表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%140.00%销售成本率销售收入、成本、费用、税金分析表共16页第2页被审计单位名称:查验人员:日期:索引号:所属时期或截至时间:复核人员:日期:金额单位:人民币元三、销售收入、费用相关情况四、销售费用率变化情况回归函数为:-0.0726902841406.719106平均值:6.38%Y=-0.0727X+1406.7191(Y:销售费用 X:销售收入)标准差:2.96%相关系数为:r=-0.4431异常五、销售收入、税金相关情况六、销售税金率变化情况回
5、归函数为:-0.028012771572.0236237平均值:2.75%Y=-0.0280X+572.0236(Y:销售税金 X:销售收入)标准差:1.45%相关系数为:r=-0.3049异常销售收入、费用对比表12345678910 11120.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%14.00%销售费用率销售收入、费用对比表12345678910 11120.00 20
6、00.00 4000.00 6000.00 8000.00 10000.00 12000.00 14000.00 销售收入销售税金销售税金率变化情况1234567891011120.00%1.00%2.00%3.00%4.00%5.00%6.00%销售税金率销售收入、成本、费用、税金分析表共16页第3页销售收入、成本、费用、税金分析表共16页第4页销售收入、成本、费用、税金年度对比表共16页第5页被审计单位名称:查验人员:日期:索引号:所属时期或截至时间:复核人员:日期:金额单位:人民币元月份上年度本年度增减金额增减比率销售收入85219.95126288.9041068.9548.2%销售成
7、本90943.3399123.378180.049.0%销售费用6401.877700.651298.7820.3%销售税金1493.523326.581833.06122.7%销售成本率106.72%78.49%-28.23%-26.5%销售费用率7.51%6.10%-1.41%-18.8%销售税金率1.75%2.63%0.88%50.3%一、销售收入、成本、费用、税金对比图二、销售成本率、销售费用率、销售税金率对比图销售收入销售成本销售费用销售税金0.00 20000.00 40000.00 60000.00 80000.00 100000.00 120000.00 140000.00 上
8、年度本年度销售成本率销售费用率销售税金率0.00%20.00%40.00%60.00%80.00%100.00%120.00%上年度本年度销售收入、成本汇总表共16页第6页被审计单位名称:查验人员:日期:索引号:所属时期或截至时间:复核人员:日期:金额单位:人民币元产品名称上年销售情况本年销售情况销售收入销售成本销售数量销售单价单位成本销售成本率销售收入销售成本销售数量销售单价单位成本销售成本率A7713.656517.200.7310514.068883.2584.49%6069.445501.44136.4444.4840.32 90.64%B2390.77109.8174.6832.01
9、1.474.59%6099.953326.71163.6337.2820.33 54.54%C9370.057513.0688.72105.6184.6880.18%7542.755372.6384.4989.2863.59 71.23%D3851.803139.4422.43171.69139.9481.51%6436.494596.44136.1147.2933.77 71.41%E584.607123.1042.8513.64166.22#5152.226381.35115.2244.7255.39#F6044.24648.5869.0787.519.3910.73%5199.70450
10、3.5692.8356.0148.52 86.61%G3364.793005.0576.0244.2639.5389.31%4820.684892.25122.8239.2539.83#H704.414905.413.59196.121365.77696.39%6475.335770.71129.1950.1244.67 89.12%I2577.116251.7538.6566.68161.75242.59%5100.714223.78138.0536.9530.60 82.81%J2117.366360.7875.8027.9383.91300.41%5921.966089.10125.57
11、47.1648.49#K3905.337782.4094.8241.1982.08199.28%7085.724172.7292.1676.8845.28 58.89%L2531.39521.8621.24119.1824.5720.62%7319.385509.04135.4754.0340.66 75.27%M6858.443733.5536.89185.94101.2254.44%6373.174638.1992.7668.7150.00 72.78%N2951.007431.8683.5635.3188.94251.84%5485.304373.62140.0339.1731.23 7
12、9.73%O2230.064639.9930.4773.19152.28208.07%6208.444698.2199.1162.6447.40 75.67%P7845.734235.5861.44127.7068.9453.99%7730.834830.39128.1160.3537.71 62.48%Q5394.634041.6728.43189.76142.1774.92%6576.894491.45165.5039.7427.14 68.29%R5430.64706.7747.21115.0314.9713.01%5882.635311.6488.1866.7160.24 90.29%
13、S3027.237739.8720.03151.14386.43255.68%7216.565440.53116.8761.7546.55 75.39%T6326.704535.6072.3187.5062.7371.69%7590.744999.62147.5051.4633.90 65.86%合计85219.9590943.33106.72%126288.9099123.3778.49%一、上年销售收入结构图二、本年销售收入结构图9%3%11%5%1%7%4%1%3%2%5%3%8%3%3%9%6%6%4%7%ABCDEFGHIJKLMNOPQRST5%5%6%5%4%4%4%5%4%5%
14、5%6%5%4%5%6%5%5%6%6%ABCDEFGHIJKLMNOPQRST销售收入、成本汇总表共16页第7页三、上年销售成本结构图四、本年销售成本结构图五、销售收入对比图六、销售成本对比图七、销售成本率对比图7%0%8%3%8%1%3%5%7%7%9%1%4%8%5%5%4%1%9%5%ABCDEFGHIJKLMNOPQRST6%3%5%5%6%5%5%6%4%6%4%6%5%4%5%5%5%5%5%5%ABCDEFGHIJKLMNOPQRSTABCDEFGHIJKLM NOPQRST0.00 1000.00 2000.00 3000.00 4000.00 5000.00 6000.00
15、 7000.00 8000.00 9000.00 10000.00 上年销售收入本年销售收入ABCDEFGHIJKLM NOPQRST0.00 1000.00 2000.00 3000.00 4000.00 5000.00 6000.00 7000.00 8000.00 9000.00 上年销售成本本年销售成本ABCDEFGHIJKLM NOPQRST0.00%200.00%400.00%600.00%800.00%1000.00%1200.00%1400.00%上年销售成本率本年销售成本率9%3%11%5%1%7%4%1%3%2%5%3%8%3%3%9%6%6%4%7%ABCDEFGHIJK
16、LMNOPQRST5%5%6%5%4%4%4%5%4%5%5%6%5%4%5%6%5%5%6%6%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 2000.00 4000.00 60
17、00.00 8000.00 10000.00 12000.00 上年销售单价本年销售单价ABCDEFGHIJKLMNOPQRST0.00 1000.00 2000.00 3000.00 4000.00 5000.00 6000.00 7000.00 8000.00 9000.00 10000.00 上年单位成本本年单位成本ABCDEFGHIJKLM NOPQRST0.00%200.00%400.00%600.00%800.00%1000.00%1200.00%1400.00%上年销售成本率本年销售成本率被审计单位名称:查验人员:日期:索引号:所属时期或截至时间:复核人员:日期:金额单位:人民币
18、元销售收入、成本汇总表共16页第9页ABCDEFGHIJKLMNOPQRST0.00 1000.00 2000.00 3000.00 4000.00 5000.00 6000.00 7000.00 8000.00 9000.00 10000.00 上年单位成本本年单位成本被审计单位名称:查验人员:日期:索引号:所属时期或截至时间:复核人员:日期:金额单位:人民币元分产品销售收入、成本分析表共16页第10页被审计单位名称:查验人员:日期:索引号:所属时期或截至时间:复核人员:日期:金额单位:人民币元产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计A销
19、售收入396.80339.1822.14974.87875.09820.53759.40252.09225.43741.77541.57120.576069.44销售成本693.99544.29726.10345.0481.89159.10748.23540.08663.70255.65660.1483.255501.44销售数量12.365.929.5316.1612.874.479.767.705.0417.3018.0717.26136.44销售单价32.1157.302.3260.3268.00183.6477.8232.7344.6942.8829.976.9944.48单位成本56
20、.1691.9576.2121.356.3635.6176.6770.11131.5614.7836.534.8240.32销售成本率174.9%160.5%3278.9%35.4%9.4%19.4%98.5%214.2%294.4%34.5%121.9%69.0%90.6%收入、成本、数量对比图单价、成本对比图销售成本率趋势图产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计B销售收入730.79116.52566.99793.21753.89244.08211.89537.47926.22234.78587.40396.716099.95销售成本
21、171.08319.45185.1731.76440.80734.88501.4439.18294.29339.2413.62255.803326.71销售数量19.0618.434.2716.4015.9717.948.6012.9316.3216.663.8113.24163.63销售单价38.346.32132.8448.3747.2213.6124.6341.5756.7614.09154.2029.9637.28单位成本8.9717.3343.381.9427.6140.9758.293.0318.0320.363.5719.3220.33销售成本率23.4%274.2%32.7%4
22、.0%58.5%301.1%236.7%7.3%31.8%144.5%2.3%64.5%54.5%收入、成本、数量对比图单价、成本对比图销售成本率趋势图1234567891011120.00 200.00 400.00 600.00 800.00 1000.00 1200.00 销售收入销售成本销售数量1234567891011120.00 20.00 40.00 60.00 80.00 100.00 120.00 140.00 160.00 180.00 200.00 销售单价单位成本1234567891011 120.0%500.0%1000.0%1500.0%2000.0%2500.0%
23、3000.0%3500.0%销售成本率1234567891011120.00 100.00 200.00 300.00 400.00 500.00 600.00 700.00 800.00 900.00 1000.00 销售收入销售成本销售数量1234567891011120.00 20.00 40.00 60.00 80.00 100.00 120.00 140.00 160.00 180.00 销售单价单位成本1234567891011120.0%50.0%100.0%150.0%200.0%250.0%300.0%350.0%销售成本率分产品销售收入、成本分析表共16页第11页产品名称项
24、目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计C销售收入89.59537.30487.44995.79637.13167.24938.87826.72702.55230.27985.14944.697542.75销售成本215.53659.16561.46134.9637.35554.89434.53532.92383.30746.67447.81664.065372.63销售数量7.757.021.473.9711.846.9611.928.034.664.5815.071.2284.49销售单价11.5676.49332.40251.0253.8024
25、.0378.77102.97150.6050.2465.38777.0589.28单位成本27.8193.84382.8734.023.1579.7336.4666.3882.17162.9029.72546.2363.59销售成本率240.6%122.7%115.2%13.6%5.9%331.8%46.3%64.5%54.6%324.3%45.5%70.3%71.2%收入、成本、数量对比图单价、成本对比图销售成本率趋势图产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计D销售收入403.28473.27458.21513.81655.96450.5
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 收入 成本 费用 税金 分析 excel 表格
限制150内