销售收入、成本、费用、税金excel分析表

《销售收入、成本、费用、税金excel分析表》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、销售收入、成本、费用、税金EXCEL分析表销售收入、成本、费用、税金分析表被审计单位名称：查验人员：日期：索引号：所属时期或截至时间：复核人员：日期：金额单位：人民币元月份销售收入销售成本销售费用销售税金销售成本率销售费用率销售税金率19423.<#004699'>729583.9516<#004699'>7.33<#004699'>71.18101.<#004699'>70%1.<#004699'>78%0.<#004699'>76%212450.566814.59912.<#004699'>7469.<#004699'>7354.<#004699'>73%<#004699'>7.3

2、3%0.56%39644.086410.80325.00450.9266.4<#004699'>7%3.3<#004699'>7%4.68%490<#004699'>73.86<#004699'>79<#004699'>73.96913.6<#004699'>741<#004699'>7.348<#004699'>7.88%10.0<#004699'>7%4.60%58<#004699'>72<#004699'>7.656426.12863.84480.44<#004699'>73.63%9.90%5.50%68348.588115.34685.56200.1<#004699'>79<

3、#004699'>7.21%8.21%2.40%<#004699'>7<#004699'>73<#004699'>73.54641<#004699'>7.38<#004699'>733.522<#004699'>75.458<#004699'>7.03%9.95%3.<#004699'>74%88148.586<#004699'>789.5<#004699'>7126.9065.4983.32%1.56%0.80%910821.64<#004699'>7<#004699'>769.41818.08268.83<#004699'>71.80%<#004699'>7.56%2.48%10<

4、#004699'>7063.386441.44<#004699'>76.49194.2091.19%1.08%2.<#004699'>75%119646.866012.06120.<#004699'>78493.<#004699'>7662.32%1.25%5.12%128690.6353<#004699'>79.6230<#004699'>7.<#004699'>7<#004699'>766.9361.90%3.54%0.<#004699'>7<#004699'>7%合计109413.0884134.236051.693054.43<#004699'>76.90%5.53%2.<#0

5、04699'>79%一、销售收入、成本相关情况二、销售成本率变化情况回归函数为：0.12<#004699'>7515612<#004699'>75848.529<#004699'>72<#004699'>75956平均值：<#004699'>78.2<#004699'>7%Y=0.12<#004699'>75X+5848.529<#004699'>7(Y:销售成本X:销售收入)标准差：14.5<#004699'>7%相关系数为：r=0.1635异常被审计单位名称：查验人员：日期：索引号：所属时期或截至时间：复核人员：日期：金额单位：人民币元三、销售收入、费用相关情况四、销售费用率变化情

6、况回归函数为：0.08938<#004699'>73063-310.<#004699'>7041416855平均值：5.4<#004699'>7%Y=0.0894X+-310.<#004699'>7041(Y:销售费用X:销售收入)标准差：3.54%相关系数为：r=0.3818异常五、销售收入、税金相关情况六、销售税金率变化情况回归函数为：-0.0050596158300.668133820<#004699'>7平均值：2.85%Y=-0.0051X+300.6681(Y:销售税金X:销售收入)标准差：1.<#004699'>78%相关系数为：r=-0.043<#004699'>7异常

7、&C&;黑体,常规;&20&A&R&9共&;TimesNewRoman,常规;&N&;宋体,常规;页第&;TimesNewRoman,常规;&P&;宋体,常规;页销售收入、成本、费用、税金分析表93<#004699'>70.804129<#004699'>71<#004699'>7810363.88581548863<#004699'>7.55996