销售费用管理表.xls

被审计单位名称：查验人员：日期：所属时期或截至时间：复核人员：日期：产产品品名名称称 项项目目1 1月月份份2 2月月份份3 3月月份份4 4月月份份5 5月月份份6 6月月份份A A销销售售收收入入7596.408025.667168.889049.952529.293345.97销售成本783.94535.61215.07665.50469.42784.46销售数量125311801019119418601526销售单价6.066.807.047.581.362.19单单位位成成本本0.630.450.210.560.250.51销销售售成成本本率率10%7%3%7%19%23%产产品品名名称称 项项目目1 1月月份份2 2月月份份3 3月月份份4 4月月份份5 5月月份份6 6月月份份B B销销售售收收入入8780.871052.306784.761080.971598.116866.81销售成本437.74713.22341.87681.72290.0572.77销售数量11217331810589199销售单价78.406.0821.3410.2917.9634.51单单位位成成本本3.914.121.086.493.260.37销销售售成成本本率率4.99%67.78%5.04%63.07%18.15%1.06%C C销销售售收收入入7191.702319.523630.686174.305369.092665.87销售成本364.25526.31304.9593.67321.37144.64销售数量191135372144151150销售单价37.6517.189.7642.8835.5617.77单单位位成成本本1.913.900.820.652.130.96销销售售成成本本率率5.06%22.69%8.40%1.52%5.99%5.43%D D销销售售收收入入4677.022479.937585.068370.513046.881261.04销售成本515.65523.73105.25308.0396.10658.94销售数量862357717015592销售单价54.3810.5598.5149.2419.6613.71单单位位成成本本6.002.231.371.810.627.16销销售售成成本本率率11.03%21.12%1.39%3.68%3.15%52.25%E E销销售售收收入入5433.596878.972926.844610.057862.916688.61销售成本723.67576.42730.25573.85242.03456.21销售数量1702511851765745销售单价31.9627.4115.8226.19137.95148.64单单位位成成本本4.262.303.953.264.2510.14销销售售成成本本率率13.32%8.38%24.95%12.45%3.08%6.82%F F销销售售收收入入8539.733935.388145.141059.429438.154675.96收入、成本、数量分析表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 9 1011120.00 2.00 4.00 6.00 8.00 销售单价单位成本销售成本380.48691.42331.427.44446.93195.40销售数量16128548116951171销售单价53.0413.8116.936.27185.0627.34单单位位成成本本2.362.430.690.048.761.14销销售售成成本本率率4.46%17.57%4.07%0.70%4.74%4.18%G G销销售售收收入入8482.805651.145213.535132.308412.698428.70销售成本520.8079.0527.05551.79449.67391.01销售数量122197199134156320销售单价69.5328.6926.2038.3053.9326.34单单位位成成本本4.270.400.144.122.881.22销销售售成成本本率率6.14%1.40%0.52%10.75%5.35%4.64%H H销销售售收收入入1432.802550.311566.432508.867802.227443.15销售成本378.6129.23309.86635.59318.97456.17销售数量96782594104114销售单价14.9332.7062.6626.6975.0265.29单单位位成成本本3.940.3712.396.763.074.00销销售售成成本本率率26.42%1.15%19.78%25.33%4.09%6.13%合合计计销销售售收收入入52134.932893.243021.337986.446059.341376.1销销售售成成本本4105.13675.02365.73517.62634.53159.6F F索引号：金额单位：人民币元7 7月月份份8 8月月份份9 9月月份份1010月月份份1111月月份份1212月月份份合合计计4844.972481.255881.832412.203888.068879.8766104.33798.7074.9769.03102.05400.15121.275020.1717466971088136912663785179832.773.565.411.763.072.353.680.460.110.060.070.320.030.2816%3%1%4%10%1%8%7 7月月份份8 8月月份份9 9月月份份1010月月份份1111月月份份1212月月份份合合计计5569.666596.117175.402461.347561.344470.1259997.79699.90330.71351.58360.85777.76230.155288.32415183107154483157249513.4236.0467.0615.9815.6528.4724.051.691.813.292.341.611.472.1212.57%5.01%4.90%14.66%10.29%5.15%8.81%2149.886523.373199.278875.953531.701347.7152979.04421.94292.4432.36252.63589.68459.063803.3043955419018714110827624.9011.7816.8447.4625.0512.4819.180.960.530.171.354.184.251.3819.63%4.48%1.01%2.85%16.70%34.06%7.18%5151.456350.057957.028890.789428.357247.7372445.82186.76318.75362.07330.35188.40389.913983.94146263149100159197182935.2824.1453.4088.9159.3036.7939.611.281.212.433.301.181.982.183.63%5.02%4.55%3.72%2.00%5.38%5.50%5299.868723.074022.428537.357017.804110.9572112.42481.47327.03473.41771.31779.13518.186652.961321083919214773157540.1580.77103.1444.4747.7456.3145.793.653.0312.144.025.307.104.229.08%3.75%11.77%9.03%11.10%12.60%9.23%5334.533731.941491.207448.07853.508458.2463111.26销售成本率趋势图123456789 10 11 120%5%10%15%20%25%销售成本率单价、单位成本分析表1 2 3 4 5 6 7 8 9 1011120.00 2.00 4.00 6.00 8.00 销售单价单位成本511.60580.0038.71757.1074.05424.204438.757721038105827178369.2817.7739.2470.93106.69313.2735.406.642.761.027.219.2615.712.499.59%15.54%2.60%10.17%8.68%5.02%7.03%7798.237314.084414.622064.118593.261468.9572974.41479.90773.1417.90571.40683.98503.565049.25552841864211521322358141.7925.7523.734.9056.5311.1330.958.732.720.101.364.503.812.146.15%10.57%0.41%27.68%7.96%34.28%6.92%4220.557947.971077.424641.401059.235823.0748073.41368.97239.94249.50129.20143.00266.003525.04116260196130153161152736.3830.575.5035.706.9236.1731.483.180.921.270.990.931.652.318.74%3.02%23.16%2.78%13.50%4.57%7.33%40369.149667.835219.245331.241933.241806.6507798.53949.22937.01594.63274.93636.22912.337761.7被审计单位名称：查验人员：所属时期或截至时间：复核人员：产产品品名名称称上年销售情况销售收入销售成本销售数量销售单价单单位位成成本本销销售售成成本本率率A A82406.751978.30767107.442.582%B B68063.154898.6090874.965.397%C C34582.443305.70191181.0617.3110%D D71962.205330.60610117.978.747%E E29389.485200.00265110.9019.6218%F F78230.466167.70546143.2811.308%G G90734.008383.20613148.0213.689%H H87454.706063.00475184.1212.767%合合计计542823.1841327.10一、上年销售收入结构图二、本年销售收放结构图五、销售收入对比图六、销售成本对比图七、销售数量对比图八、销售单价对比图15%13%6%13%6%14%17%16%上年销售收入结构图ABCDEFGH5%12%8%13%12%15%20%15%上年销售成本结构图ABCDEFGH销售收入对比图ABCDEFGH0.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 上年单位成本本年单位成本销售成本率对比图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 上年销售单价本年销售单价日期：索引号：日期：金额单位：人民币元本年销售情况销售收入销售成本销售数量销售单价单单位位成成本本销销售售成成本本率率66104.335020.17179833.680.288%59997.795288.32249524.052.129%52979.043803.30276219.181.387%72445.823983.94182939.612.185%72112.426652.96157545.794.229%63111.264438.75178335.402.497%72974.415049.25235830.952.147%48073.413525.04152731.482.317%507798.4837761.73三、上年销售成本结构图四、本年销售成本结构图13%12%10%14%14%12%14%9%本年销售收入结构图ABCDEFGH13%14%10%11%18%12%13%9%本年销售成本结构图ABCDEFGH5%12%8%13%12%15%20%15%上年销售成本结构图ABCDEFGH销售成本对比图ABCDEFGH0.00 2000.00 4000.00 6000.00 8000.00 10000.00 上年销售成本本年销售成本销售单价对比图ABCDEFGH0.00 50.00 100.00 150.00 200.00 上年销售单价本年销售单价销售单价对比图ABCDEFGH0.00 50.00 100.00 150.00 200.00 上年销售单价本年销售单价销售成本率对比图ABCDEFGH0%2%4%6%8%10%12%14%16%18%20%上年销售成本率本年销售成本率四、本年销售成本结构图13%14%10%11%18%12%13%9%本年销售成本结构图ABCDEFGH被审计单位名称：查验人员：日期：索引号：所属时期或截至时间：复核人员：日期：金额单位：人民币元月份 销售收入 销售成本 销售费用销售税金销售成本率 销售费用率 销售税金率1 52134.914105.146405.751281.157.87%12.29%2.46%2 32893.213674.991372.80274.5611.17%4.17%0.83%3 43021.322365.727425.701485.145.50%17.26%3.45%4 37986.363517.593177.56635.519.26%8.37%1.67%5 46059.342634.543239.80647.965.72%7.03%1.41%6 41376.113159.62575.90515.187.64%6.23%1.25%7 40369.133949.245308.411061.689.78%13.15%2.63%8 49667.842936.987285.581457.125.91%14.67%2.93%9 35219.181594.567722.261544.454.53%21.93%4.39%10 45331.203274.892215.00443.007.22%4.89%0.98%11 41933.243636.152707.98541.608.67%6.46%1.29%12 41806.642912.338454.901690.986.97%20.22%4.04%合计507798.5 37761.73 57891.6411578.337.44%11.40%2.28%一、销售收入、成本相关情况二、销售成本率变化情况三、销售收入、费用相关情况四、销售费用率变化情况五、销售收入、税金相关情况六、销售税金变化情况销售收入、成本对比表1 23 4 56 7 89 10 11 120200004000060000销售收入销售成本销售成本率变化情况1234567891011120.00%5.00%10.00%15.00%销售成本率销售收入、销售费用对比表1234567891011120100002000030000400005000060000销售收入销售费用销售费用率变化情况1234567891011120.00%5.00%10.00%15.00%20.00%25.00%销售费用率销售收入、销售税金对比表1234567891011120100002000030000400005000060000销售收入销售税金销售税金率变化情况1234567891011120.00%1.00%2.00%3.00%4.00%5.00%销售税金率销售收入、销售税金对比表1234567891011120100002000030000400005000060000销售收入销售税金销售税金率变化情况1234567891011120.00%1.00%2.00%3.00%4.00%5.00%销售税金率金额单位：人民币元销售成本率变化情况1234567891011120.00%5.00%10.00%15.00%销售成本率销售费用率变化情况1234567891011120.00%5.00%10.00%15.00%20.00%25.00%销售费用率销售税金率变化情况1234567891011120.00%1.00%2.00%3.00%4.00%5.00%销售税金率销售税金率变化情况1234567891011120.00%1.00%2.00%3.00%4.00%5.00%销售税金率被审计单位名称：查验人员：日期：索引号：所属时期或截至时间：复核人员：日期：金额单位：人民币元项目上年度本年度增减金额增减比率销售收入542823.18507798.48-3502470.00%-6.45%销售成本41327.137761.73-356537.00%-8.63%销售费用9855.0257891.644803662.00%487.43%销售税金1971.00411578.328960732.40%487.43%销售成本率7.61%7.44%-0.18%-2.32%销售费用率1.82%11.40%9.59%527.95%销售税金率0.36%2.28%1.92%527.95%一、销售收入、成本、费用、税金对比表二、销售成本率、销售费用率和销售税金率对比表三、比率增减趋势图销售收入销售成本销售费用销售税金0100000200000300000400000500000600000上年度本年度销售成本率销售费用率销售税金率0.00%2.00%4.00%6.00%8.00%10.00%12.00%上年度本年度增减比率销售收入销售成本销售费用销售税金 销售成本率销售费用率销售税金率-100.00%0.00%100.00%200.00%300.00%400.00%500.00%600.00%增减比率增减比率销售收入销售成本销售费用销售税金 销售成本率销售费用率销售税金率-100.00%0.00%100.00%200.00%300.00%400.00%500.00%600.00%增减比率