图状分析表模板.xls

销售收入、成本、费用、税金分析表共16页第1页被审计单位名称：查验人员：日期：索引号：所属时期或截至时间：复核人员：日期：金额单位：人民币元月份销售收入销售成本销售费用销售税金销售成本率销售费用率销售税金率114031.937620.31704.29204.5154.31%5.02%1.46%26792.866627.93628.345.2297.57%9.25%0.08%38031.837870.64382.96406.6397.99%4.77%5.06%411611.138404.38533.74476.3472.38%4.60%4.10%58388.2710281.91438.94457.76122.57%5.23%5.46%69840.738139.76577.20489.8282.71%5.87%4.98%78199.808116.02300.46147.0998.98%3.66%1.79%810420.187808.77274.26112.4774.94%2.63%1.08%99285.637808.97606.36309.9284.10%6.53%3.34%1010834.109570.91185.51305.0488.34%1.71%2.82%1111867.759549.10254.90148.0680.46%2.15%1.25%129361.976818.56550.47244.3172.83%5.88%2.61%合计118666.1998617.265437.433307.1783.10%4.58%2.79%一、销售收入、成本相关情况二、销售成本率变化情况回归函数为：0.1175120097056.046267平均值：85.60%Y=0.1175X+7056.0463(Y:销售成本 X:销售收入)标准差：16.63%相关系数为：r=0.2145异常销售收入、成本对比表1234567891011120.00 2000.00 4000.00 6000.00 8000.00 10000.00 12000.00 14000.00 16000.00 销售收入销售成本销售成本率变化情况1234567891011120.00%20.00%40.00%60.00%80.00%100.00%120.00%140.00%销售成本率销售收入、成本、费用、税金分析表共16页第2页被审计单位名称：查验人员：日期：索引号：所属时期或截至时间：复核人员：日期：金额单位：人民币元三、销售收入、费用相关情况四、销售费用率变化情况回归函数为：0.003555148417.9628798平均值：4.77%Y=0.0036X+417.9629(Y:销售费用 X:销售收入)标准差：2.00%相关系数为：r=0.0417异常五、销售收入、税金相关情况六、销售税金率变化情况回归函数为：0.00597536216.508075平均值：2.83%Y=0.0060X+216.5081(Y:销售税金 X:销售收入)标准差：1.70%相关系数为：r=0.0753异常销售收入、费用对比表12345678910 11 120.00 5000.00 10000.00 15000.00 销售收入销售费用销售费用率变化情况12345678910 11 120.00%2.00%4.00%6.00%8.00%10.00%销售费用率销售收入、费用对比表123456789 10 11 120.00 5000.00 10000.00 15000.00 销售收入销售税金销售税金率变化情况12345678910 11 120.00%1.00%2.00%3.00%4.00%5.00%6.00%销售税金率销售收入、成本、费用、税金分析表共16页第3页销售收入、成本、费用、税金分析表共16页第4页销售收入、成本、费用、税金年度对比表共16页第5页被审计单位名称：查验人员：日期：索引号：所属时期或截至时间：复核人员：日期：金额单位：人民币元月份上年度本年度增减金额增减比率销售收入105251.80118666.1913414.3912.7%销售成本86371.9598617.2612245.3114.2%销售费用243.245437.435194.192135.4%销售税金2602.493307.17704.6827.1%销售成本率82.06%83.10%1.04%1.3%销售费用率0.23%4.58%4.35%1882.7%销售税金率2.47%2.79%0.31%12.7%一、销售收入、成本、费用、税金对比图二、销售成本率、销售费用率、销售税金率对比图销售收入、成本对比表销售成本率变化情况销售收入、费用对比表销售费用率变化情况销售收入、费用对比表销售税金率变化情况销售收入销售成本销售费用销售税金0.00 20000.00 40000.00 60000.00 80000.00 100000.00 120000.00 140000.00 上年度本年度销售成本率销售费用率销售税金率0.00%10.00%20.00%30.00%40.00%50.00%60.00%70.00%80.00%90.00%上年度本年度销售收入、成本汇总表共16页第6页被审计单位名称：查验人员：日期：索引号：所属时期或截至时间：复核人员：日期：金额单位：人民币元产品名称上年销售情况本年销售情况销售收入销售成本销售数量销售单价单位成本销售成本率销售收入销售成本销售数量销售单价单位成本销售成本率A4104.262801.399.61114.09111.1597.43%6295.174292.05148.7442.3228.86 68.18%B3591.223223.9447.2176.0768.2989.77%5722.544069.93109.5152.2637.17 71.12%C920.137900.5435.1926.15224.53858.63%5955.746056.0881.6372.9674.19#D581.367867.0210.1757.17773.58#6676.345410.5799.9666.7954.13 81.04%E5378.686316.7284.9763.3074.34117.44%7467.454992.64117.3363.6542.55 66.86%F3301.007532.7028.53115.72264.07228.19%7550.745868.28148.6250.8139.49 77.72%G2623.794863.0815.08173.96322.44185.35%5076.805226.77106.0947.8549.27#H897.095792.7967.5513.2885.75645.73%5846.595181.5194.8061.6754.66 88.62%I7816.372442.3424.33321.23100.3731.25%6249.534932.16126.0049.6039.14 78.92%J6005.664787.2667.3989.1271.0479.71%5786.974207.5991.8463.0145.81 72.71%K9077.913829.7935.28257.33108.5642.19%5409.045100.37160.1833.7731.84 94.29%L8630.925457.2459.30145.5492.0263.23%5345.605239.85129.7141.2140.40 98.02%M5063.031151.9684.3960.0013.6522.75%5645.024703.48136.0341.5034.58 83.32%N2894.722554.0994.1530.7527.1388.23%7547.764417.11124.2960.7335.54 58.52%O3502.46201.2372.9947.992.765.75%5262.284764.91126.8341.4937.57 90.55%P8302.623900.824.621797.35844.4546.98%6658.805901.73151.2844.0239.01 88.63%Q8885.297817.6724.75359.07315.9387.98%6696.564041.65129.2351.8231.27 60.35%R4756.22366.8067.4770.495.447.71%5771.004841.36141.4840.7934.22 83.89%S6288.531678.796.50967.83258.3726.70%4965.053441.6490.4354.9038.06 69.32%T8548.56711.5295.1989.807.478.32%2737.235927.58111.5024.5553.16#合计105251.8086371.9582.06%118666.1998617.2683.10%一、上年销售收入结构图二、本年销售收入结构图销售收入、成本对比表销售成本率变化情况销售收入、费用对比表销售费用率变化情况销售收入、费用对比表销售税金率变化情况4%4%1%1%5%3%3%1%8%6%9%8%5%3%3%8%9%5%6%8%ABCDEFGHIJKLMNOPQRST5%5%5%6%6%6%4%5%5%5%5%5%5%6%4%6%6%5%4%2%ABCDEFGHIJKLMNOPQRST销售收入、成本汇总表共16页第7页三、上年销售成本结构图四、本年销售成本结构图五、销售收入对比图六、销售成本对比图七、销售成本率对比图3%4%10%10%8%9%6%7%3%6%5%7%1%3%0%5%10%0%2%1%ABCDEFGHIJKLMNOPQRST4%4%6%5%5%6%5%5%5%4%5%5%5%4%5%6%4%5%3%6%ABCDEFGHIJKLMNOPQRSTABCDEFGHIJKLM NOPQRST0.00 1000.00 2000.00 3000.00 4000.00 5000.00 6000.00 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%500.00%1000.00%1500.00%上年销售成本率本年销售成本率4%4%1%1%5%3%3%1%8%6%9%8%5%3%3%8%9%5%6%8%ABCDEFGHIJKLMNOPQRST5%5%5%6%6%6%4%5%5%5%5%5%5%6%4%6%6%5%4%2%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 200.00 400.00 600.00 800.00 1000.00 1200.00 1400.00 1600.00 1800.00 2000.00 上年销售单价本年销售单价ABCDEFGHIJKLM NOPQRST0.00 100.00 200.00 300.00 400.00 500.00 600.00 700.00 800.00 900.00 上年单位成本本年单位成本ABCDEFGHIJKLM NOPQRST0.00%500.00%1000.00%1500.00%上年销售成本率本年销售成本率被审计单位名称：查验人员：日期：索引号：所属时期或截至时间：复核人员：日期：金额单位：人民币元销售收入、成本汇总表共16页第9页ABCDEFGHIJKLM NOPQRST0.00 100.00 200.00 300.00 400.00 500.00 600.00 700.00 800.00 900.00 上年单位成本本年单位成本被审计单位名称：查验人员：日期：索引号：所属时期或截至时间：复核人员：日期：金额单位：人民币元分产品销售收入、成本分析表共16页第10页被审计单位名称：查验人员：日期：索引号：所属时期或截至时间：复核人员：日期：金额单位：人民币元产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计A销售收入231.6751.70693.44602.20714.52309.61331.95210.24496.46699.06766.11910.646295.17销售成本582.7765.68153.93598.32464.4421.88285.26325.84433.83689.52427.86582.904292.05销售数量5.6515.412.4011.4412.6610.4418.8519.9411.9311.063.4613.14148.74销售单价28.283.35289.4052.6256.4329.6617.6110.5441.6063.22221.5869.3142.32单位成本13.474.2664.2452.2836.682.1015.1316.3436.3662.36123.7544.3628.86销售成本率47.6%127.0%22.2%99.4%65.0%7.1%85.9%155.0%87.4%98.6%55.8%64.0%68.2%收入、成本、数量对比图单价、成本对比图销售成本率趋势图产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计B销售收入305.2424.96133.20543.22599.57370.04519.74948.22760.67588.65181.28594.095722.54销售成本481.91597.76119.5948.21161.4425.63213.57460.02575.95767.82744.7226.324069.93销售数量16.855.5017.487.3215.1614.078.445.070.2210.8110.7613.02109.51销售单价275.984.547.6274.2439.5626.3061.55187.213385.2254.4616.8545.6452.26单位成本197.79108.626.846.5910.651.8225.2990.822563.1571.0469.242.0237.17销售成本率71.7%2394.6%89.8%8.9%26.9%6.9%41.1%48.5%75.7%130.4%410.8%4.4%71.1%收入、成本、数量对比图单价、成本对比图销售成本率趋势图销售收入、成本对比表销售成本率变化情况销售收入、费用对比表销售费用率变化情况销售收入、费用对比表销售税金率变化情况1234567891011120.00 200.00 400.00 600.00 800.00 1000.00 销售收入销售成本销售数量1234567891011120.00 50.00 100.00 150.00 200.00 250.00 300.00 350.00 销售单价单位成本123456789 10 11 120.0%50.0%100.0%150.0%200.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 500.00 1000.00 1500.00 2000.00 2500.00 3000.00 3500.00 4000.00 销售单价单位成本123456789 10 11 120.0%500.0%1000.0%1500.0%2000.0%2500.0%3000.0%销售成本率分产品销售收入、成本分析表共16页第11页产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计C销售收入509.84771.8012.75773.17664.096.42350.44474.710.35524.97731.44772.005955.74销售成本258.57645.54683.08611.81271.71347.16622.07674.30548.29104.86480.57564.586056.08销售数量7.112.442.886.267.660.941.5210.547.480.0513.139.3581.63销售单价45.08316.214.42123.4386.726.84230.9945.050.0510144.4755.7282.6072.96单位成本25.91264.48236.7897.6735.48370.09410.0364.0073.302026.3336.6160.4074.19销售成本率57.5%83.6%5357.8%79.1%40.9%5410.7%177.5%142.0%158844.3%20.0%65.7%73.1%101.7%收入、成本、数量对比图单价、成本对比图销售成本率趋势图产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计D销售收入602.58225.5070.95745.31811.09692.10559.87415.74598.79822.17556.58354.296676.34销售成本396.63577.82484.02498.28781.70287.17766.08686.827.51553.26240.05454.455410.57销售数量8.434.163.3412.024.534.9915.9515.2217.1913.053.611.8299.96销售单价200.8954.2621.2762.01179.18138.7335.1027.3134.8463.02154.30194.8566.79单位成本17.90139.04145.0841.46172.6957.5648.0245.110.4442.4066.55249.9454.13销售成本率8.9%256.2%682.2%66.9%96.4%41.5%136.8%165.2%1.3%67.3%43.1%128.3%81.0%收入、成本、数量对比图单价、成本对比图销售成本率趋势图销售收入、成本对比表销售成本率变化情况销售收入、费用对比表销售费用率变化情况销售收入、费用对比表销售税金率变化情况1234567891011120.00 100.00 200.00 300.00 400.00 500.00 600.00 700.00 800.00 900.00 销售收入销售成本销售数量1234567891011120.00 2000.00 4000.00 6000.00 8000.00 10000.00 12000.00 销售单价单位成本12 34 56 78 9 10 11 120.0%50000.0%100000.0%150000.0%200000.0%销售成本率销售收入、成本对比表销售成本率变化情况销售收入、费用对比表销售费用率变化情况销售收入、费用对比表销售税金率变化情况1234567891011120.00 100.00 200.00 300.00 400.00 500.00 600.00 700.00 800.00 900.00 销售收入销售成本销售数量1234567891011120.00 50.00 100.00 150.00 200.00 250.00 300.00 销售单价单位成本123456789 10 11 120.0%200.0%400.0%600.0%800.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 500.00 1000.00 1500.00 2000.00 2500.00 3000.00 3500.00 4000.00 销售单价单位成本123456789 10 11 120.0%500.0%1000.0%1500.0%2000.0%2500.0%3000.0%销售成本率被审计单位名称：查验人员：日期：索引号：所属时期或截至时间：复核人员：日期：金额单位：人民币元分产品销售收入、成本分析表共16页第12页产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计E销售收入537.30926.08933.51443.51222.57610.39447.05405.17520.69961.41877.48547.747467.45销售成本559.60478.13410.26570.18642.56327.14173.56594.74350.96213.97202.30601.304992.64销售数量16.588.4716.897.559.7111.536.385.3813.7619.6411.791.52117.33销售单价121.28109.3455.2758.7422.9252.9570.0275.2637.8448.9674.46361.3863.65单位成本90.6756.4524.2975.5266.1828.3827.19110.4725.5110.9017.17396.7242.55销售成本率74.8%51.6%43.9%128.6%288.7%53.6%38.8%146.8%67.4%22.3%23.1%109.8%66.9%收入、成本、数量对比图单价、成本对比图销售成本率趋势图产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计F销售收入839.97417.88510.27438.94645.90627.48108.58781.39824.75998.54760.93648.207550.74销售成本773.74505.5972.56353.71444.58431.97549.15436.86618.74761.26504.59602.855868.28销售数量5.372.8611.221.0619.9917.6317.7213.388.8218.965.9618.81148.62销售单价64.54146.2745.46414.5232.3135.596.1358.4193.5552.67127.6234.4550.81单位成本48.04176.976.46334.0322.2424.5031.0032.6570.1940.1684.6332.0439.49销售成本率74.4%121.0%14.2%80.6%68.8%68.8%505.7%55.9%75.0%76.2%66.3%93.0%77.7%收入、成本、数量对比图单价、成本对比图销售成本率趋势图销售收入、成本对比表销售成本率变化情况销售收入、费用对比表销售费用率变化情况销售收入、费用对比表销售税金率变化情况1234567891011120.00 200.00 400.00 600.00 800.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%销售成本率销售收入、成本对比表销售成本率变化情况销售收入、费用对比表销售费用率变化情况销售收入、费用对比表销售税金率变化情况1234567891011120.00 200.00 400.00 600.00 800.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%销售成本率1234567891011120.00 100.00 200.00 300.00 400.00 500.00 600.00 700.00 800.00 900.00 销售收入销售成本销售数量1234567891011120.00 50.00 100.00 150.00 200.00 250.00 300.00 销售单价单位成本123456789 10 11 120.0%200.0%400.0%600.0%800.0%销售成本率被审计单位名称：查验人员：日期：索引号：所属时期或截至时间：复核人员：日期：金额单位：人民币元分产品销售收入、成本分析表共16页第13页产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计G销售收入76.67122.4193.78315.49171.15768.32263.0397.17132.26707.72689.19812.055076.80销售成本667.3350.88620.96753.80787.16138.73379.83505.57554.31787.27194.33162.355226.77销售数量17.095.950.184.9216.967.336.1416.3210.144.888.2611.32106.09销售单价66.1420.56518.1864.1110.09104.8342.825.9513.05144.9183.4071.7347.85单位成本21.338.553431.21153.1846.4118.9361.8330.9854.67161.2023.5214.3449.27销售成本率32.2%41.6%662.2%238.9%459.9%18.1%144.4%520.3%419.1%111.2%28.2%20.0%103.0%收入、成本、数量对比图单价、成本对比图销售成本率趋势图产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计H销售收入541.54188.30303.30771.01896.59301.97141.93188.09683.57820.06493.0962.025846.59销售成本441.71103.16484.86503.47286.45335.24642.34461.51395.82719.78627.7491.995181.51销售数量17.606.6711.5518.211.441.9915.014.349.8611.730.471.0994.80销售单价80.1228.2226.2742.34621.36151.599.4543.3569.3569.911042.7757.1461.67单位成本42.5415.4641.9927.65198.51168.2942.79106.3640.1661.361327.5384.7654.66销售成本率53.1%54.8%159.9%65.3%31.9%111.0%452.6%245.4%57.9%87.8%127.3%148.3%88.6%收入、成本、数量对比图单价、成本对比图销售成本率趋势图销售收入、成本对比表销售成本率变化情况销售收入、费用对比表销售费用率变化情况销售收入、费用对比表销售税金率变化情况1234567891011120.00 100.00 200.00 300.00 400.00 500.00 600.00 700.00 800.00 900.00 销售收入销售成本销售数量1234567891011120.00 500.00 1000.00 1500.00 2000.00 2500.00 3000.00 3500.00 4000.00 销售单价单位成本123456789 10 11 120.0%200.0%400.0%600.0%800.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 200.00 400.00 600.00 800.00 1000.00 1200.00 1400.00 销售单价单位成本123456789 10 11 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 销售收入销售成本销售数量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页第14页产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计I销售收入70.36747.22125.80208.39508.54656.50979.22679.73490.1413.83743.12445.046249.53销售成本409.00103.01153.06414.69769.32710.87446.71240.46211.13222.46778.67143.094932.16销售数量4.2611.835.322.488.535.5318.1712.927.403.8318.5211.55126.00销售单价32.7263.1523.6583.9359.64118.8053.9052.6266.233.6140.1338.5349.60单位成本37.078.7128.78167.0290.23128.6424.5918.6128.5358.0442.0512.3939.14销售成本率113.3%13.8%121.7%199.0%151.3%108.3%45.6%35.4%43.1%1608.9%104.8%32.2%78.9%J销售收入943.5085.50639.21793.69592.9848.88333.51726.33890.8046.13653.25291.635786.97销售成本679.10667.60334.52347.05721.0723.77340.12209.09180.81688.49215.48140.494207.59销售数量15.522.720.9816.303.214.374.5718.262.890.6414.9117.4691.84销售单价123.9831.48655.2648.70184.6711.1873.0239.77308.0371.6343.8116.7063.01单位成本61.37245.82342.9221.29224.565.4474.4711.4562.521069.0614.458.0545.81销售成本率49.5%780.8%52.3%43.7%121.6%48.6%102.0%28.8%20.3%1492.5%33.0%48.2%72.7%K销售收入907.78125.48860.11955.84400.47926.78284.04185.31216.09622.60395.43132.385409.04销售成本102.21125.81181.5821.70705.01686.53771.29625.74527.48198.37346.41350.495100.37销售数量13.9319.1814.8817.8313.4915.126.974.4619.753.5814.9418.02160.18销售单价25.456.5457.7953.6229.6861.3040.7341.5710.94174.0326.477.3533.77单位成本46.796.5612.201.2252.2545.41110.59140.3726.7155.4523.1819.4631.84销售成本率183.9%100.3%21.1%2.3%176.0%74.1%271.5%337.7%244.1%31.9%87.6%264.8%94.3%L销售收入816.7615.89440.04660.13210.91360.69601.91642.46494.54182.95187.65664.085345.60销售成本799.74138.13777.73675.58442.51350.13358.58139.49493.34413.30764.32340.145239.85销售数量14.4819.119.5117.2315.6716.4716.127.442.6113.742.881.64129.71销售单价121.170.8346.2738.3113.4621.9037.3486.35189.5113.3165.26404.4441.21单位成本47.497.2381.7939.2028.2421.2622.2518.75189.0530.07265.83207.1640.40销售成本率39.2%869.1%176.7%102.3%209.8%97.1%59.6%21.7%99.8%225.9%407.3%51.2%98.0%M销售收入818.52280.30248.14441.53342.3645.39513.36104.85758.73878.09574.86458.145645.02销售成本556.5510.36592.88734.82321.02492.270.21615.45146.5986.65419.73659.834703.48销售数量16.0614.529.2519.4817.975.588.0315.281.440.5815.2511.31136.03销售单价57.6619.3026.8222.6719.058.1363.976.86526.861506.8537.6840.5041.50单位成本35.990.7164.0837.7217.8788.160.0340.28101.79148.7027.5158.3334.58销售成本率62.4%3.7%238.9%166.4%93.8%1084.4%0.0%587.0%19.3%9.9%73.0%144.0%83.3%N销售收入854.42688.36834.76940.661