费用管理表（超简单函数自动汇总分析）

1、被审计单位名称：查验人员：日期：所属时期或截至时间：复核人员：日期：产产品品名名称称 项项目目1 1月月份份2 2月月份份3 3月月份份4 4月月份份5 5月月份份6 6月月份份7 7月月份份A A销销售售收收入入7596.408025.667168.889049.952529.293345.974844.97销售成本783.94535.61215.07665.50469.42784.46798.70销售数量1253118010191194186015261746销售单价6.066.807.047.581.362.192.77单单位位成成本本0.630.450.210.560.250.510.

2、46销销售售成成本本率率10%7%3%7%19%23%16%产产品品名名称称 项项目目1 1月月份份2 2月月份份3 3月月份份4 4月月份份5 5月月份份6 6月月份份7 7月月份份B B销销售售收收入入8780.871052.306784.761080.971598.116866.815569.66销售成本437.74713.22341.87681.72290.0572.77699.90销售数量11217331810589199415销售单价78.406.0821.3410.2917.9634.5113.42单单位位成成本本3.914.121.086.493.260.371.69销销售售成

3、成本本率率4.99%67.78%5.04%63.07%18.15%1.06%12.57%C C销销售售收收入入7191.702319.523630.686174.305369.092665.872149.88销售成本364.25526.31304.9593.67321.37144.64421.94销售数量191135372144151150439销售单价37.6517.189.7642.8835.5617.774.90单单位位成成本本1.913.900.820.652.130.960.96销销售售成成本本率率5.06%22.69%8.40%1.52%5.99%5.43%19.63%D D销销售

4、售收收入入4677.022479.937585.068370.513046.881261.045151.45销售成本515.65523.73105.25308.0396.10658.94186.76销售数量862357717015592146销售单价54.3810.5598.5149.2419.6613.7135.28单单位位成成本本6.002.231.371.810.627.161.28销销售售成成本本率率11.03%21.12%1.39%3.68%3.15%52.25%3.63%E E销销售售收收入入5433.596878.972926.844610.057862.916688.61529

5、9.86销售成本723.67576.42730.25573.85242.03456.21481.47销售数量1702511851765745132销售单价31.9627.4115.8226.19137.95148.6440.15单单位位成成本本4.262.303.953.264.2510.143.65销销售售成成本本率率13.32%8.38%24.95%12.45%3.08%6.82%9.08%F F销销售售收收入入8539.733935.388145.141059.429438.154675.965334.53销售成本380.48691.42331.427.44446.93195.40511

6、.60收入、成本、数量分析表1 2 3 4 5 6 7 8 91011120.00 2000.00 4000.00 6000.00 8000.00 10000.00 销售收入销售成本销售数量单价、单位成本分析表1 2 3 4 5 6 7 8 91011120.00 2.00 4.00 6.00 8.00 销售单价单位成本销售数量1612854811695117177销售单价53.0413.8116.936.27185.0627.3469.28单单位位成成本本2.362.430.690.048.761.146.64销销售售成成本本率率4.46%17.57%4.07%0.70%4.74%4.18%

7、9.59%G G销销售售收收入入8482.805651.145213.535132.308412.698428.707798.23销售成本520.8079.0527.05551.79449.67391.01479.90销售数量12219719913415632055销售单价69.5328.6926.2038.3053.9326.34141.79单单位位成成本本4.270.400.144.122.881.228.73销销售售成成本本率率6.14%1.40%0.52%10.75%5.35%4.64%6.15%H H销销售售收收入入1432.802550.311566.432508.867802.2

8、27443.154220.55销售成本378.6129.23309.86635.59318.97456.17368.97销售数量96782594104114116销售单价14.9332.7062.6626.6975.0265.2936.38单单位位成成本本3.940.3712.396.763.074.003.18销销售售成成本本率率26.42%1.15%19.78%25.33%4.09%6.13%8.74%合合计计销销售售收收入入52134.932893.243021.337986.446059.341376.140369.1销销售售成成本本4105.13675.02365.73517.626

9、34.53159.63949.2F F索引号：金额单位：人民币元8 8月月份份9 9月月份份1010月月份份1111月月份份1212月月份份合合计计2481.255881.832412.203888.068879.8766104.3374.9769.03102.05400.15121.275020.176971088136912663785179833.565.411.763.072.353.680.110.060.070.320.030.283%1%4%10%1%8%8 8月月份份9 9月月份份1010月月份份1111月月份份1212月月份份合合计计6596.117175.402461.34

10、7561.344470.1259997.79330.71351.58360.85777.76230.155288.32183107154483157249536.0467.0615.9815.6528.4724.051.813.292.341.611.472.125.01%4.90%14.66%10.29%5.15%8.81%6523.373199.278875.953531.701347.7152979.04292.4432.36252.63589.68459.063803.30554190187141108276211.7816.8447.4625.0512.4819.180.530.17

11、1.354.184.251.384.48%1.01%2.85%16.70%34.06%7.18%6350.057957.028890.789428.357247.7372445.82318.75362.07330.35188.40389.913983.94263149100159197182924.1453.4088.9159.3036.7939.611.212.433.301.181.982.185.02%4.55%3.72%2.00%5.38%5.50%8723.074022.428537.357017.804110.9572112.42327.03473.41771.31779.1351

12、8.186652.961083919214773157580.77103.1444.4747.7456.3145.793.0312.144.025.307.104.223.75%11.77%9.03%11.10%12.60%9.23%3731.941491.207448.07853.508458.2463111.26580.0038.71757.1074.05424.204438.75销售成本率趋势图123456789 10 11 120%5%10%15%20%25%销售成本率单价、单位成本分析表1 2 3 4 5 6 7 8 91011120.00 2.00 4.00 6.00 8.00 销

13、售单价单位成本21038105827178317.7739.2470.93106.69313.2735.402.761.027.219.2615.712.4915.54%2.60%10.17%8.68%5.02%7.03%7314.084414.622064.118593.261468.9572974.41773.1417.90571.40683.98503.565049.25284186421152132235825.7523.734.9056.5311.1330.952.720.101.364.503.812.1410.57%0.41%27.68%7.96%34.28%6.92%7947.

14、971077.424641.401059.235823.0748073.41239.94249.50129.20143.00266.003525.04260196130153161152730.575.5035.706.9236.1731.480.921.270.990.931.652.313.02%23.16%2.78%13.50%4.57%7.33%49667.835219.245331.241933.241806.6507798.52937.01594.63274.93636.22912.337761.7被审计单位名称：查验人员：日期：所属时期或截至时间：复核人员：日期：产产品品名名称称

15、上年销售情况本年销售情况销售收入销售成本销售数量销售单价单单位位成成本本销销售售成成本本率率销售收入A A82406.751978.30767107.442.582%66104.33B B68063.154898.6090874.965.397%59997.79C C34582.443305.70191181.0617.3110%52979.04D D71962.205330.60610117.978.747%72445.82E E29389.485200.00265110.9019.6218%72112.42F F78230.466167.70546143.2811.308%63111.26

16、G G90734.008383.20613148.0213.689%72974.41H H87454.706063.00475184.1212.767%48073.41合合计计542823.1841327.10507798.48一、上年销售收入结构图二、本年销售收放结构图五、销售收入对比图六、销售成本对比图七、销售数量对比图八、销售单价对比图15%13%6%13%5%14%17%16%上年销售收入结构图ABCDEFGH5%12%8%13%13%15%20%15%上年销售成本结构图ABCDEFGH13%12%10%14%14%12%14%9%本年销售收入结构图ABCDEFGH销售收入对比图ABC

17、DEFGH0.00 50000.00 100000.00 上年销售收入本年销售收入销售成本对比图ABCDEFGH0.00 2000.00 4000.00 6000.00 8000.00 10000.00 上年销售成本本年销售成本销售数量对比图ABCDEFGH0 5000 10000 15000 20000 上年销售数量本年销售数量销售单价对比图ABCDEFGH0.00 50.00 100.00 150.00 200.00 上年销售单价本年销售单价九、单位成本对比图十、销售成本率对比图单位成本对比图ABCDEFGH0.00 5.00 10.00 15.00 20.00 25.00 上年单位成本本

18、年单位成本销售成本率对比图ABCDEFGH0%2%4%6%8%10%12%14%16%18%20%上年销售成本率本年销售成本率销售数量对比图ABCDEFGH0 5000 10000 15000 20000 上年销售数量本年销售数量销售单价对比图ABCDEFGH0.00 50.00 100.00 150.00 200.00 上年销售单价本年销售单价索引号：金额单位：人民币元销售成本销售数量销售单价单单位位成成本本销销售售成成本本率率5020.17179833.680.288%5288.32249524.052.129%3803.30276219.181.387%3983.94182939.612

19、.185%6652.96157545.794.229%4438.75178335.402.497%5049.25235830.952.147%3525.04152731.482.317%37761.73三、上年销售成本结构图四、本年销售成本结构图13%14%10%11%18%12%13%9%本年销售成本结构图ABCDEFGH本年销售情况13%12%10%14%14%12%14%9%本年销售收入结构图ABCDEFGH13%14%10%11%18%12%13%9%本年销售成本结构图ABCDEFGH销售费用分析表月份销售收入销售成本销售费用销售税金销售成本率销售费用率销售税金率152134.9141

20、05.146405.751281.157.87%12.29%2.46%232893.213674.991372.80274.5611.17%4.17%0.83%343021.322365.727425.701485.145.50%17.26%3.45%437986.363517.593177.56635.519.26%8.37%1.67%546059.342634.543239.80647.965.72%7.03%1.41%641376.113159.62575.90515.187.64%6.23%1.25%740369.133949.245308.411061.689.78%13.15%2.

21、63%849667.842936.987285.581457.125.91%14.67%2.93%935219.181594.567722.261544.454.53%21.93%4.39%1045331.203274.892215.00443.007.22%4.89%0.98%1141933.243636.152707.98541.608.67%6.46%1.29%1241806.642912.338454.901690.986.97%20.22%4.04%合计507798.4837761.7357891.6411578.337.44%11.40%2.28%一、销售收入、成本相关情况二、销售成本率变化情况销售收入、成本对比表123456789 10 11 120100002000030000400005000060000销售收入销售成本销售成本率变化情况1 2 3 4 5 6 7 8 9 1011120.00%2.00%4.00%6.00%8.00%10.00%12.00%销售成本率销售费用对比表项目上年度本年度增减金额增减比率销售收入542823.18507798.48-3502470.00%-6.45%销售成本41327.137761.73-356537.00%-8.63%