资源描述:
《项目管理操作实务-销售收入成本(xls)》由会员上传分享,免费在线阅读,更多相关内容在教育资源-天天文库。
1、项目管理操作实务-销售收入成本(xls)销售收入、成本、费用、税金分析表被审计单位名称:查验人员:日期:索引号:所属时期或截至时间:复核人员:日期:金额单位:人民币元月份销售收入销售成本销售费用销售税金销售成本率销售费用率销售税金率112,166.8527,749.178980.96310.2210.6370.0810.00128,501.9886,968.947970.687460.1720.820.1140.054310,960.7948,361.143324.2451.0190.7630.030.041411,735.9685,989.03
2、7180.54363.4650.510.0150.005510,878.7136,835.019322.484391.5270.6280.030.03667,561.8569,158.287325.838290.551.2110.0430.038712,878.0648,423.814262.819101.9280.6540.020.008810,8><#004699'>409.8128,256.45354.602138.040.7930.0340.013911,880.5567,951.866755.112298.4160.6690.0640.
3、0251010,835.0968,217.844162.696349.2340.7580.0150.0321110,458.3317,998.31152.425435.6870.7650.0050.042127,632.3866,394.06580.926483.750.8380.0110.063合计125,900.41792,303.9614,773.2943,474.0080.7330.0380.028一、销售收入、成本相关情况二、销售成本率变化情况回归函数为:0.0317,361.883平均值:0.7540(Y:销售成本X:销售收入)标准差
4、:0.165相关系数为:00被审计单位名称:查验人员:日期:索引号:所属时期或截至时间:复核人员:日期:金额单位:人民币元三、销售收入、费用相关情况四、销售费用率变化情况回归函数为:0.022167.548平均值:0.0380(Y:销售费用X:销售收入)标准差:0.031相关系数为:00五、销售收入、税金相关情况六、销售税金率变化情况回归函数为:-0.058902.434平均值:0.030(Y:销售税金X:销售收入)标准差:0.019相关系数为:00销售收入、成本、费用、税金分析表6222.16170180257690.0150665032945
5、7.376<#004699'>40646537879.315501308210929.47317602637410.523868253511375.37328929287614.654667852110062.675011661877<#004699'>40.22833658039188.16198802537004.824781910611270.85463078918617.471055060710371.23599218799021.3064<#004699'>4099966510.2<#004699'>4028984187065.4370
6、39812713619.24244314246683.103558911210783.69688134487600.77339658849602.9485288546565.2599954953销售收入销售成本销售收入、成本对比表销售收入、成本、费用、税金年度对比表1.23590729960.83313967450.67803120510.66939822320.76920186010.76237497670.76458009060.86983908651.08528053120.49071037440.70483930330.683671267
7、8销售成本率销售成本率变化情况销售收入、成本汇总表6222.1617018025887.31013210999457.376<#004699'>4064653125.155269078610929.4731760263361.224621050311375.3732892928798.330334763610062.6750116618613.54471338919188.1619880253833.957194485211270.8546307891504.93<#004699'>403867610371.2359921879168.52083
8、726816510.2<#004699'>402898418254.46981018213619.2424431424359.33279