收入成本费用分析表

&"黑体,常规"&20&A&9共&"TimesNewRoman,常规"&N&"宋体,常规"页第&"TimesNewRoman,常规"&P&"宋体,常规"页被审计单位名称：查验人员：日期：索引号：所属时期或截至时间：复核人员：日期：金额单位：人民币元月份销售收入销售成本销售费用销售税金销售成本率销售费用率销售税金率110513.367107.46817.36177.6167.60%7.77%1.69%210876.056499.6197.3761.7459.76%0.90%0.57%39107.399635.2840.4173.61105.80%0.44%0.81%410412.438797.76472.90401.6884.49%4.54%3.86%510098.967803.88548.33424.6677.27%5.43%4.20%67753.247745.80802.94116.0399.90%10.36%1.50%710077.558461.25926.43124.1383.96%9.19%1.23%811727.749174.76996.30433.4378.23%8.50%3.70%910162.448162.85869.50168.5980.32%8.56%1.66%108601.076328.84118.82373.1273.58%1.38%4.34%1111298.238326.97544.91287.0573.70%4.82%2.54%129888.607621.24668.92458.2877.07%6.76%4.63%合计120517.0595665.696904.183099.9279.38%5.73%2.57%一、销售收入、成本相关情况二、销售成本率变化情况回归函数为：0.18673197716096.775114平均值：80.14%Y=0.1867X+6096.7751(Y:销售成本X:销售收入) 标准 excel标准偏差excel标准偏差函数exl标准差函数国标检验抽样标准表免费下载红头文件格式标准下载 差：12.11%相关系数为：r=0.2074异常被审计单位名称：查验人员：日期：索引号：所属时期或截至时间：复核人员：日期：金额单位：人民币元三、销售收入、费用相关情况四、销售费用率变化情况回归函数为：0.0742562688-170.4142519平均值：5.72%Y=0.0743X+-170.4143(Y:销售费用X:销售收入)标准差：3.25%相关系数为：r=0.2467异常五、销售收入、税金相关情况六、销售税金率变化情况回归函数为：0.0349124749-92.30228212平均值：2.56%Y=0.0349X+-92.3023(Y:销售税金X:销售收入)标准差：1.43%相关系数为：r=0.2542异常&"黑体,常规"&20&A&9共&"TimesNewRoman,常规"&N&"宋体,常规"页第&"TimesNewRoman,常规"&P&"宋体,常规"页被审计单位名称：查验人员：日期：索引号：所属时期或截至时间：复核人员：日期：金额单位：人民币元月份上年度本年度增减金额增减比率销售收入84333.18120517.0536183.8842.9%销售成本91566.5195665.694099.184.5%销售费用6538.556904.18365.635.6%销售税金535.033099.922564.89479.4%销售成本率108.58%79.38%-29.20%-26.9%销售费用率7.75%5.73%-2.02%-26.1%销售税金率0.63%2.57%1.94%305.4%一、销售收入、成本、费用、税金对比图二、销售成本率、销售费用率、销售税金率对比图&"黑体,常规"&20&A&9共&"TimesNewRoman,常规"&N&"宋体,常规"页第&"TimesNewRoman,常规"&P&"宋体,常规"页被审计单位名称：查验人员：日期：索引号：所属时期或截至时间：复核人员：日期：金额单位：人民币元产品名称上年销售情况本年销售情况销售收入销售成本销售数量销售单价单位成本销售成本率销售收入销售成本销售数量销售单价单位成本销售成本率A889.446120.6824.0437.00254.62688.15%6071.544211.70104.6558.0240.2469.37%B3071.673453.8064.8047.4053.30112.44%5646.695842.43108.2352.1753.98103.47%C368.797399.8161.895.96119.562006.53%6066.815172.57148.9540.7334.7385.26%D8911.121292.0679.19112.5316.3214.50%6052.977144.23153.2739.4946.61118.03%E7816.297660.3390.6786.2184.4998.00%5311.475107.32150.0135.4134.0596.16%F5831.097773.6343.34134.53179.34133.31%5126.284868.18117.8243.5141.3294.97%G1255.273899.3756.6722.1568.81310.64%4513.913797.62167.1827.0022.7284.13%H1777.70432.9119.5590.9322.1424.35%6645.674044.26120.8754.9833.4660.86%I5585.205722.6530.36183.94188.47102.46%6012.054967.18106.1156.6646.8182.62%J7073.995191.5238.01186.12136.5973.39%6758.014181.91131.0051.5931.9261.88%K334.864717.057.2746.07649.031408.65%5095.483302.37118.8942.8627.7864.81%L1250.343547.0626.5447.12133.67283.69%6783.655556.39122.2955.4745.4381.91%M5011.051462.9768.7772.8721.2729.19%6067.794723.09111.4154.4642.3977.84%N3300.726342.272.931126.202163.97192.15%6453.473715.5384.3476.5244.0557.57%O8058.75741.2279.57101.279.319.20%6259.523668.33134.2046.6427.3358.60%P6973.525124.7545.33153.83113.0573.49%6120.014815.90122.0150.1639.4778.69%Q7499.536998.4773.45102.1095.2893.32%5961.975062.76112.0153.2345.2084.92%R3054.535516.6760.5450.4591.12180.61%6900.895533.70133.3451.7541.5080.19%S410.966772.9729.4313.96230.151648.07%6410.104622.43109.8558.3642.0872.11%T5858.351396.327.85746.19177.8523.83%6258.785327.79144.1143.4336.9785.13%合计84333.1891566.51108.58%120517.0595665.6979.38%一、上年销售收入结构图二、本年销售收入结构图三、上年销售成本结构图四、本年销售成本结构图五、销售收入对比图六、销售成本对比图七、销售成本率对比图八、销售数量对比图九、销售单价对比图十、单位成本对比图&"黑体,常规"&20&A&9共&"TimesNewRoman,常规"&N&"宋体,常规"页第&"TimesNewRoman,常规"&P&"宋体,常规"页被审计单位名称：查验人员：日期：索引号：所属时期或截至时间：复核人员：日期：金额单位：人民币元产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计A销售收入752.78500.6063.63896.97255.81235.13452.66409.92719.98329.61763.51690.946071.54销售成本571.4019.8170.18539.88204.6749.66502.32526.03640.16104.78673.37309.444211.70销售数量19.784.9214.335.944.036.088.326.998.996.150.6418.49104.65销售单价38.05101.694.44151.1163.4538.6554.4158.6880.0953.641189.0337.3758.02单位成本28.884.024.9090.9550.778.1660.3875.3071.2117.051048.6516.7440.24销售成本率75.9%4.0%110.3%60.2%80.0%21.1%111.0%128.3%88.9%31.8%88.2%44.8%69.4%收入、成本、数量对比图单价、成本对比图销售成本率趋势图产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计B销售收入333.21429.69810.15633.00580.54586.7984.3821.79482.58257.73855.74571.105646.69销售成本654.95288.32756.68709.56775.10373.12415.73513.64116.34348.13380.97509.905842.43销售数量16.337.407.0710.3512.9210.6415.203.3711.246.134.083.50108.23销售单价20.4058.04114.6561.1744.9555.155.556.4742.9242.03209.77163.0152.17单位成本40.1038.95107.0968.5760.0235.0727.35152.5410.3556.7793.39145.5453.98销售成本率196.6%67.1%93.4%112.1%133.5%63.6%492.7%2357.3%24.1%135.1%44.5%89.3%103.5%收入、成本、数量对比图单价、成本对比图销售成本率趋势图产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计C销售收入647.89880.39850.89878.0775.77462.3685.21378.99609.2915.37345.85836.726066.81销售成本202.28565.13383.08707.48164.12217.64466.21783.8620.52769.51769.48123.265172.57销售数量13.891.436.6816.1216.0018.3614.072.433.1020.0019.3617.52148.95销售单价46.65615.85127.4554.484.7425.196.06155.79196.270.7717.8647.7740.73单位成本14.57395.3257.3843.9010.2611.8633.14322.216.6138.4839.747.0434.73销售成本率31.2%64.2%45.0%80.6%216.6%47.1%547.1%206.8%3.4%5005.3%222.5%14.7%85.3%收入、成本、数量对比图单价、成本对比图销售成本率趋势图产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计D销售收入938.57835.81368.38458.77615.03183.34122.19493.26978.33355.57361.12342.606052.97销售成本628.47484.69794.82779.63285.08642.85470.85722.79688.07630.95491.95524.097144.23销售数量18.934.0317.3519.4416.864.4218.828.646.6510.5015.2912.32153.27销售单价49.58207.1921.2323.6036.4841.516.4957.07147.0533.8523.6227.8039.49单位成本33.20120.1545.8040.1016.91145.5625.0283.63103.4260.0732.1742.5346.61销售成本率67.0%58.0%215.8%169.9%46.4%350.6%385.3%146.5%70.3%177.4%136.2%153.0%118.0%收入、成本、数量对比图单价、成本对比图销售成本率趋势图产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计E销售收入321.07398.40348.61926.47641.21275.68254.33321.10410.95727.16187.61498.895311.47销售成本558.61110.63416.87237.57561.91702.07712.0252.58481.42220.30361.06692.275107.32销售数量12.5017.346.5517.347.500.0018.8619.0713.1718.539.579.58150.01销售单价25.6822.9853.1953.4285.49103332.3213.4916.8431.2139.2519.6152.0835.41单位成本44.686.3863.6113.7074.92263157.3837.762.7636.5711.8937.7372.2634.05销售成本率174.0%27.8%119.6%25.6%87.6%254.7%280.0%16.4%117.1%30.3%192.5%138.8%96.2%收入、成本、数量对比图单价、成本对比图销售成本率趋势图产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计F销售收入26.18651.36409.42105.99807.3327.91338.55850.32162.98776.75932.3037.185126.28销售成本50.76217.22697.43605.20657.08601.01672.39635.3640.378.16349.28333.924868.18销售数量2.7712.329.827.951.1019.0011.8919.163.755.6918.236.13117.82销售单价9.4552.8841.6713.34734.451.4728.4844.3843.49136.4151.136.0643.51单位成本18.3317.6370.9976.15597.7631.6356.5533.1610.771.4319.1654.4441.32销售成本率193.8%33.3%170.3%571.0%81.4%2153.7%198.6%74.7%24.8%1.1%37.5%898.1%95.0%收入、成本、数量对比图单价、成本对比图销售成本率趋势图产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计G销售收入301.09114.3834.45690.58471.5784.77666.42453.47719.02165.08625.81187.274513.91销售成本117.18172.92566.5433.77100.25567.59718.44313.12258.74337.12434.79177.163797.62销售数量10.342.337.6419.9016.827.6913.4913.6118.3419.4518.4019.16167.18销售单价29.1149.174.5134.6928.0411.0249.3833.3139.218.4934.029.7727.00单位成本11.3374.3374.111.705.9673.8153.2423.0014.1117.3323.649.2522.72销售成本率38.9%151.2%1644.3%4.9%21.3%669.6%107.8%69.1%36.0%204.2%69.5%94.6%84.1%收入、成本、数量对比图单价、成本对比图销售成本率趋势图产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计H销售收入681.69863.22976.91787.41300.16285.17427.98961.03594.91632.9020.45113.846645.67销售成本31.37240.16411.55781.6095.30194.43324.39473.93346.86238.55485.62420.494044.26销售数量8.911.656.313.6319.653.277.9516.6416.1516.726.5513.43120.87销售单价76.54523.39154.91216.9115.2787.2053.8357.7536.8337.843.128.4754.98单位成本3.52145.6265.26215.314.8559.4540.8028.4821.4814.2674.0931.3033.46销售成本率4.6%27.8%42.1%99.3%31.8%68.2%75.8%49.3%58.3%37.7%2374.6%369.4%60.9%收入、成本、数量对比图单价、成本对比图销售成本率趋势图产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计I销售收入967.08694.45277.83269.17954.97542.32804.7438.90597.25252.39369.19243.766012.05销售成本367.78521.30350.89144.32331.379.28323.35764.28658.1848.99686.44761.014967.18销售数量5.302.864.177.5018.676.794.0613.0514.5212.064.0613.06106.11销售单价182.32242.9366.5935.9151.1679.88197.992.9841.1320.9290.9018.6656.66单位成本69.34182.3684.1019.2517.751.3779.5558.5645.334.06169.0158.2646.81销售成本率38.0%75.1%126.3%53.6%34.7%1.7%40.2%1964.7%110.2%19.4%185.9%312.2%82.6%J销售收入553.55763.17796.45576.98803.37351.91189.66959.05415.63246.43249.37852.466758.01销售成本173.7155.57766.98225.48609.28194.58151.69643.76797.99241.50212.49108.874181.91销售数量19.8514.185.145.402.0113.9018.5513.043.607.8417.2010.30131.00销售单价27.8953.81154.92106.93400.6725.3210.2273.56115.3931.4214.5082.7751.59单位成本8.753.92149.1841.79303.8714.008.1849.38221.5430.7912.3510.5731.92销售成本率31.4%7.3%96.3%39.1%75.8%55.3%80.0%67.1%192.0%98.0%85.2%12.8%61.9%K销售收入587.79118.80717.15729.55118.4374.11734.34774.19140.6637.02685.15378.295095.48销售成本446.54370.24451.58168.18642.54108.58126.81234.1844.41105.80145.36458.143302.37销售数量9.4414.8014.726.2813.631.0613.570.8311.5916.551.9214.48118.89销售单价62.268.0348.71116.148.6969.7054.10938.2512.132.24357.4326.1242.86单位成本47.3025.0230.6726.7747.14102.139.34283.803.836.3975.8331.6327.78销售成本率76.0%311.6%63.0%23.1%542.6%146.5%17.3%30.2%31.6%285.8%21.2%121.1%64.8%L销售收入696.40452.80183.89319.29216.92978.40370.15814.48752.46600.03510.03888.806783.65销售成本74.36250.86711.63619.18785.97718.06444.76649.72508.27479.51178.28135.795556.39销售数量19.011.407.584.944.5612.1112.528.0515.7218.3817.300.72122.29销售单价36.64323.8924.2664.5847.5880.8029.58101.1247.8732.6429.471236.7255.47单位成本3.91179.4593.88125.23172.4059.3035.5480.6732.3326.0810.30188.9445.43销售成本率10.7%55.4%387.0%193.9%362.3%73.4%120.2%79.8%67.5%79.9%35.0%15.3%81.9%M销售收入566.6323.50293.52693.28799.27727.50560.33569.97511.40163.58845.11313.706067.79销售成本95.60309.18749.03660.2345.58757.66720.0197.9879.74295.89448.41463.794723.09销售数量8.5518.817.968.857.514.039.454.6213.182.3714.6611.42111.41销售单价66.241.2536.8778.32106.49180.6359.27123.3238.8168.9257.6527.4754.46单位成本11.1816.4494.0974.596.07188.1276.1621.206.05124.6730.5940.6142.39销售成本率16.9%1315.6%255.2%95.2%5.7%104.1%128.5%17.2%15.6%180.9%53.1%147.8%77.8%N销售收入325.18968.48919.90368.66583.03422.49745.13613.93105.40680.16586.77134.356453.47销售成本453.93207.59349.0554.89509.85384.53575.79334.97199.06158.39416.5770.913715.53销售数量4.774.631.820.4319.280.9813.3711.047.631.823.2415.3484.34销售单价68.23209.22506.10860.9030.23432.9555.7355.6213.81374.16181.178.7676.52单位成本95.2444.85192.03128.1726.44394.0643.0630.3526.0787.13128.624.6244.05销售成本率139.6%21.4%37.9%14.9%87.4%91.0%77.3%54.6%188.9%23.3%71.0%52.8%57.6%产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计O销售收入696.87610.80938.11135.27680.6657.69828.03471.20251.21223.99828.26537.436259.52销售成本8.14572.5012.58311.71383.35395.0838.4272.57799.22556.33231.89286.533668.33销售数量9.8218.029.6616.6416.9219.3212.793.6515.353.403.025.62134.20销售单价71.0033.9097.128.1340.242.9964.75129.1316.3765.93273.9895.5746.64单位成本0.8331.771.3018.7322.6620.443.0019.8952.07163.7576.7150.9627.33销售成本率1.2%93.7%1.3%230.4%56.3%684.8%4.6%15.4%318.1%248.4%28.0%53.3%58.6%P销售收入324.78254.48337.52240.95535.66579.04304.63789.69405.93936.41541.71869.206120.01销售成本674.25221.72442.38500.15498.91183.75401.35210.48670.2176.99224.19711.534815.90销售数量3.6418.0914.151.5218.6614.665.221.090.8116.8818.738.57122.01销售单价89.1414.0723.85158.7928.7139.5158.37727.41500.7955.4928.92101.4250.16单位成本185.0512.2531.26329.6126.7412.5476.90193.88826.834.5611.9783.0239.47销售成本率207.6%87.1%131.1%207.6%93.1%31.7%131.7%26.7%165.1%8.2%41.4%81.9%78.7%Q销售收入413.28178.74163.4663.71686.05589.59700.93977.32544.43766.52812.0665.875961.97销售成本562.31739.83604.06528.97207.13501.63124.61203.85745.0785.53558.95200.815062.76销售数量14.3317.9012.025.404.068.444.333.782.5114.6315.319.29112.01销售单价28.859.9813.6011.79168.8869.88161.94258.33216.9052.3853.037.0953.23单位成本39.2541.3350.2697.9050.9959.4528.7953.88296.845.8436.5021.6245.20销售成本率136.1%413.9%369.5%830.2%30.2%85.1%17.8%20.9%136.9%11.2%68.8%304.9%84.9%R销售收入115.35571.85281.07469.02703.94280.06918.01787.75624.73654.02657.65837.446900.89销售成本729.77621.23687.42211.35538.23636.95380.58621.31305.36541.4878.33181.685533.70销售数量4.0710.514.1714.501.0112.6411.2919.4218.859.3410.0317.51133.34销售单价28.3254.4067.3732.34700.3522.1681.3440.5733.1470.0065.5947.8251.75单位成本179.1459.10164.7614.57535.4850.4033.7232.0016.2057.957.8110.3841.50销售成本率632.7%108.6%244.6%45.1%76.5%227.4%41.5%78.9%48.9%82.8%11.9%21.7%80.2%S销售收入944.19577.02269.06634.42102.46206.58544.41475.80567.49507.61949.85631.226410.10销售成本361.44301.50271.08367.72335.5535.41349.75591.50208.83552.67721.69525.274622.43销售数量3.6310.930.6412.427.8111.648.3110.9813.803.1815.6210.89109.85销售单价259.9552.77421.9951.0913.1317.7565.5543.3441.11159.4160.8257.9558.36单位成本99.5127.57425.1629.6142.993.0442.1153.8715.13173.5646.2148.2342.08销售成本率38.3%52.3%100.8%58.0%327.5%17.1%64.2%124.3%36.8%108.9%76.0%83.2%72.1%T销售收入319.78988.1266.98534.87166.78802.41945.48565.58567.79272.75170.70857.546258.78销售成本344.60229.21141.43610.8772.60471.92541.78728.85554.01528.28477.86626.385327.79销售数量18.2214.472.179.308.989.969.4610.6718.6318.2117.966.08144.11销售单价17.5568.2930.8657.5318.5780.5999.9753.0030.4814.989.50140.9643.43单位成本18.9115.8465.1765.718.0947.4057.2868.3029.7429.0126.60102.9636.97销售成本率107.8%23.2%211.2%114.2%43.5%58.8%57.3%128.9%97.6%193.7%279.9%73.0%85.1%合计销售收入10513.3610876.059107.3910412.4310098.967753.2410077.5511727.7410162.448601.0711298.239888.60120517.05销售成本7107.466499.619635.288797.767803.887745.808461.259174.768162.856328.848326.977621.2495665.69