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

&"黑体,常规"&20&A&9共&"TimesNewRoman,常规"&N&"宋体,常规"页第&"TimesNewRoman,常规"&P&"宋体,常规"页被审计单位名称：查验人员：日期：索引号：所属时期或截至时间：复核人员：日期：金额单位：人民币元月份销售收入销售成本销售费用销售税金销售成本率销售费用率销售税金率18019.798996.585.15407.92112.18%0.06%5.09%28557.548340.05751.2388.7497.46%8.78%1.04%310182.918405.77578.26356.2682.55%5.68%3.50%49662.596883.84640.10150.2571.24%6.62%1.55%510348.657849.70980.69397.9775.85%9.48%3.85%611554.6511123.63248.83234.5896.27%2.15%2.03%78897.736452.65555.7732.4872.52%6.25%0.37%88871.656383.07905.02191.9171.95%10.20%2.16%910794.067564.03663.26160.8170.08%6.14%1.49%1011317.157077.357.22313.5162.54%0.06%2.77%1110072.998653.76864.07179.2685.91%8.58%1.78%1210334.217832.65308.53446.3775.79%2.99%4.32%合计118613.9295563.076508.112960.0580.57%5.49%2.50%一、销售收入、成本相关情况二、销售成本率变化情况回归函数为：0.34823427694521.4696817643平均值：81.19%Y=0.3482X+4521.4697(Y:销售成本X:销售收入) 标准 excel标准偏差excel标准偏差函数exl标准差函数国标检验抽样标准表免费下载红头文件格式标准下载 差：13.74%相关系数为：r=0.2952异常被审计单位名称：查验人员：日期：索引号：所属时期或截至时间：复核人员：日期：金额单位：人民币元三、销售收入、费用相关情况四、销售费用率变化情况回归函数为：-0.04852203151021.9582713727平均值：5.58%Y=-0.0485X+1021.9583(Y:销售费用X:销售收入)标准差：3.38%相关系数为：r=-0.1619异常五、销售收入、税金相关情况六、销售税金率变化情况回归函数为：0.0277529501-27.6526873295平均值：2.49%Y=0.0278X+-27.6527(Y:销售税金X:销售收入)标准差：1.36%相关系数为：r=0.2278异常&"黑体,常规"&20&A&9共&"TimesNewRoman,常规"&N&"宋体,常规"页第&"TimesNewRoman,常规"&P&"宋体,常规"页被审计单位名称：查验人员：日期：索引号：所属时期或截至时间：复核人员：日期：金额单位：人民币元月份上年度本年度增减金额增减比率销售收入96387.09118613.9222226.8423.1%销售成本84068.5995563.0711494.4813.7%销售费用1771.746508.114736.37267.3%销售税金4672.392960.05-1712.34-36.6%销售成本率87.22%80.57%-6.65%-7.6%销售费用率1.84%5.49%3.65%198.5%销售税金率4.85%2.50%-2.35%-48.5%一、销售收入、成本、费用、税金对比图二、销售成本率、销售费用率、销售税金率对比图&"黑体,常规"&20&A&9共&"TimesNewRoman,常规"&N&"宋体,常规"页第&"TimesNewRoman,常规"&P&"宋体,常规"页被审计单位名称：查验人员：日期：索引号：所属时期或截至时间：复核人员：日期：金额单位：人民币元产品名称上年销售情况本年销售情况销售收入销售成本销售数量销售单价单位成本销售成本率销售收入销售成本销售数量销售单价单位成本销售成本率A621.227241.4375.228.2696.271165.68%6493.025491.89132.9648.8441.3184.58%B7352.625214.1872.81100.9971.6270.92%4142.534778.90132.0531.3736.19115.36%C4931.376822.6447.44103.96143.83138.35%7035.336757.4287.9679.9876.8296.05%D3503.294146.9924.01145.91172.71118.37%5610.954873.19123.8145.3239.3686.85%E196.971181.0647.924.1124.65599.60%5547.074631.9296.7057.3747.9083.50%F3254.953691.9394.7734.3538.96113.42%5781.065951.26107.2853.8955.47102.94%G9660.042883.2731.74304.3590.8429.85%8531.133639.36109.5577.8733.2242.66%H2044.595274.4529.6468.99177.98257.97%4960.545243.59102.0848.5951.36105.71%I522.541763.5314.1736.87124.43337.49%4839.364587.13121.2439.9237.8494.79%J7495.454299.7436.87203.27116.6057.36%6973.354529.12132.0152.8234.3164.95%K2831.82210.4115.30185.0913.757.43%4785.404421.31111.5942.8839.6292.39%L8808.75226.4533.16265.626.832.57%6609.595429.82103.6963.7552.3782.15%M3000.724467.1129.35102.24152.20148.87%5085.204360.28145.0735.0530.0685.74%N7794.587859.1787.1489.4490.19100.83%5871.375467.20118.2749.6446.2393.12%O6058.297013.1745.05134.49155.69115.76%6092.734570.2587.4269.6952.2875.01%P8375.494269.4541.80200.36102.1450.98%6261.284334.82144.8543.2329.9369.23%Q5292.901528.609.03586.26169.3128.88%6692.444325.8095.3470.1945.3764.64%R4177.076970.8554.8676.15127.07166.88%6200.913477.73138.2844.8425.1556.08%S9929.622981.6819.07520.79156.3830.03%5454.804543.51125.6143.4336.1783.29%T534.816022.4726.4520.22227.731126.10%5645.894148.58100.6956.0741.2073.48%合计96387.0984068.5987.22%118613.9295563.0780.57%一、上年销售收入结构图二、本年销售收入结构图三、上年销售成本结构图四、本年销售成本结构图五、销售收入对比图六、销售成本对比图七、销售成本率对比图八、销售数量对比图九、销售单价对比图十、单位成本对比图&"黑体,常规"&20&A&9共&"TimesNewRoman,常规"&N&"宋体,常规"页第&"TimesNewRoman,常规"&P&"宋体,常规"页被审计单位名称：查验人员：日期：索引号：所属时期或截至时间：复核人员：日期：金额单位：人民币元产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计A销售收入390.55994.05627.31971.26222.96899.53327.94722.24448.4173.42761.0354.316493.02销售成本416.86364.58332.8320.28610.91492.82167.28609.50670.16775.67237.23793.745491.89销售数量11.0218.6316.034.5311.218.9817.511.655.8712.0218.377.13132.96销售单价35.4553.3739.13214.1919.89100.1318.72436.6176.456.1141.427.6248.84单位成本37.8319.5720.764.4754.5154.869.55368.46114.2564.5312.91111.3641.31销售成本率106.7%36.7%53.1%2.1%274.0%54.8%51.0%84.4%149.5%1056.4%31.2%1461.4%84.6%收入、成本、数量对比图单价、成本对比图销售成本率趋势图产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计B销售收入132.4617.73192.90460.39123.83960.9426.53419.49753.94628.18137.72288.424142.53销售成本666.9828.18551.43799.19483.55546.92329.14119.17611.1517.39390.38235.424778.90销售数量11.822.3017.6615.8717.030.4918.2110.3318.154.4212.902.87132.05销售单价11.207.6910.9329.027.271947.121.4640.6341.55142.0810.68100.6731.37单位成本56.4212.2331.2350.3728.391108.2218.0711.5433.683.9330.2682.1736.19销售成本率503.5%159.0%285.9%173.6%390.5%56.9%1240.8%28.4%81.1%2.8%283.5%81.6%115.4%收入、成本、数量对比图单价、成本对比图销售成本率趋势图产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计C销售收入119.97886.11206.12173.39764.43807.11570.59603.09755.05819.51494.24835.717035.33销售成本428.49422.60574.64775.10553.41608.84765.17728.11482.13352.94697.47368.526757.42销售数量4.630.964.885.5413.672.5914.411.194.092.8014.4918.7287.96销售单价25.90925.3442.2531.2755.94311.7439.61507.03184.80292.8634.1044.6479.98单位成本92.51441.31117.79139.7940.49235.1653.11612.15118.01126.1348.1219.6976.82销售成本率357.2%47.7%278.8%447.0%72.4%75.4%134.1%120.7%63.9%43.1%141.1%44.1%96.0%收入、成本、数量对比图单价、成本对比图销售成本率趋势图产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计D销售收入405.23706.25985.83364.26164.6955.98566.99109.42342.29709.96649.91550.135610.95销售成本39.43387.44565.37455.03671.29661.73381.73702.54187.92220.23123.98476.494873.19销售数量1.7017.3311.151.429.9017.2614.369.1111.3117.407.355.52123.81销售单价238.2040.7588.42257.3716.643.2439.4912.0130.2540.8088.4699.6145.32单位成本23.1822.3650.71321.5067.8338.3326.5977.1216.6112.6516.8786.2739.36销售成本率9.7%54.9%57.3%124.9%407.6%1182.2%67.3%642.0%54.9%31.0%19.1%86.6%86.9%收入、成本、数量对比图单价、成本对比图销售成本率趋势图产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计E销售收入107.93500.63657.91391.24272.96809.29684.41104.05861.32237.97629.48289.875547.07销售成本534.33688.84486.34744.70280.09791.1510.9226.37237.74122.91559.82148.724631.92销售数量1.1414.082.449.5912.439.228.525.0710.083.9217.542.6696.70销售单价94.7435.57269.2840.8021.9587.7680.3020.5185.4760.7435.89108.8757.37单位成本469.0248.94199.0677.6622.5385.801.285.2023.5931.3731.9255.8647.90销售成本率495.1%137.6%73.9%190.3%102.6%97.8%1.6%25.3%27.6%51.6%88.9%51.3%83.5%收入、成本、数量对比图单价、成本对比图销售成本率趋势图产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计F销售收入70.11561.32137.28877.70374.03247.94852.52101.10767.64956.2595.92739.255781.06销售成本677.31714.699.13661.76770.93748.03593.27136.14574.05450.61327.79287.555951.26销售数量7.4211.8918.223.5417.851.284.469.093.9815.684.339.55107.28销售单价9.4547.197.53248.2420.96193.57191.1611.12192.7660.9822.1677.4353.89单位成本91.3460.090.50187.1743.20583.98133.0314.98144.1428.7475.7330.1255.47销售成本率966.1%127.3%6.6%75.4%206.1%301.7%69.6%134.7%74.8%47.1%341.7%38.9%102.9%收入、成本、数量对比图单价、成本对比图销售成本率趋势图产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计G销售收入976.73388.12805.54619.16966.88966.56881.69619.03269.12802.11979.98256.218531.13销售成本669.58220.13711.36440.66159.08585.08155.57230.02108.968.26341.469.223639.36销售数量18.273.006.3613.2310.7614.9010.6414.3914.020.033.230.73109.55销售单价53.45129.39126.6846.7989.8264.8882.9043.0219.2025156.60303.66351.8377.87单位成本36.6473.39111.8733.3014.7839.2714.6315.987.77258.97105.8012.6633.22销售成本率68.6%56.7%88.3%71.2%16.5%60.5%17.6%37.2%40.5%1.0%34.8%3.6%42.7%收入、成本、数量对比图单价、成本对比图销售成本率趋势图产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计H销售收入585.47357.75581.37499.60785.16991.38253.25146.34347.75119.50246.0546.924960.54销售成本779.77514.44409.6222.74165.39723.0977.29371.64780.48562.30382.09454.735243.59销售数量4.5417.7017.0510.716.0110.805.5211.586.524.901.834.93102.08销售单价128.9820.2134.1046.66130.7091.7645.8812.6353.3524.40134.459.5248.59单位成本171.7929.0624.032.1227.5366.9314.0032.08119.73114.81208.7892.3151.36销售成本率133.2%143.8%70.5%4.6%21.1%72.9%30.5%254.0%224.4%470.5%155.3%969.2%105.7%收入、成本、数量对比图单价、成本对比图销售成本率趋势图产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计I销售收入735.9776.25788.53463.87413.98397.61192.29188.70310.60350.54347.67573.364839.36销售成本400.25716.57555.9124.95571.93158.52412.04561.21307.73512.60220.34145.084587.13销售数量8.8610.167.729.3616.0010.147.1111.3212.7918.763.575.44121.24销售单价83.037.50102.1649.5725.8739.2327.0516.6724.2918.6897.35105.3539.92单位成本45.1570.5072.022.6735.7415.6457.9549.5724.0727.3261.7026.6637.84销售成本率54.4%939.8%70.5%5.4%138.2%39.9%214.3%297.4%99.1%146.2%63.4%25.3%94.8%J销售收入928.14905.3745.01351.55525.58240.44622.87722.85653.08992.10208.00778.346973.35销售成本184.73596.43400.10196.96110.57512.86534.84128.03383.27415.77673.18392.374529.12销售数量6.887.431.0819.2710.6511.743.1015.8417.7513.9518.535.80132.01销售单价134.88121.9341.8518.2549.3420.49201.1945.6336.7971.1011.22134.1452.82单位成本26.8580.33372.0510.2210.3843.70172.758.0821.5929.8036.3267.6234.31销售成本率19.9%65.9%889.0%56.0%21.0%213.3%85.9%17.7%58.7%41.9%323.6%50.4%64.9%K销售收入435.6341.45365.91244.53812.6519.0516.51398.15783.57310.06635.22722.664785.40销售成本730.03289.7534.39259.55100.09404.20454.14265.35114.72477.45731.53560.114421.31销售数量17.189.0310.6317.771.635.869.903.4016.852.486.4310.43111.59销售单价25.354.5934.4213.76498.143.251.67117.2646.49125.0498.7769.3142.88单位成本42.4932.113.2414.6161.3568.9345.8778.156.81192.54113.7453.7239.62销售成本率167.6%699.0%9.4%106.1%12.3%2121.8%2750.4%66.6%14.6%154.0%115.2%77.5%92.4%L销售收入123.34624.51190.13733.84845.70341.42877.77136.76885.21501.08584.93764.896609.59销售成本618.86707.22627.1785.7954.58214.88286.49142.61691.87545.19717.09738.055429.82销售数量7.2713.666.214.511.675.5319.674.6319.680.0118.502.36103.69销售单价16.9745.7330.63162.77505.7461.7444.6229.5644.9890541.4031.63323.8263.75单位成本85.1451.79101.0319.0332.6438.8614.5730.8235.1598511.6938.77312.4652.37销售成本率501.7%113.2%329.9%11.7%6.5%62.9%32.6%104.3%78.2%108.8%122.6%96.5%82.2%M销售收入54.93232.80666.0531.91748.71849.49355.17239.85405.65753.25460.51286.905085.20销售成本270.53578.3280.68159.37183.62702.68168.46489.25517.60292.70629.68287.374360.28销售数量13.5912.990.577.3616.0119.1912.9815.1318.263.2212.2013.56145.07销售单价4.0417.921161.854.3346.7644.2727.3615.8522.21233.7037.7621.1635.05单位成本19.9144.51140.7521.6511.4736.6212.9832.3328.3490.8151.6321.2030.06销售成本率492.5%248.4%12.1%499.5%24.5%82.7%47.4%204.0%127.6%38.9%136.7%100.2%85.7%N销售收入135.43432.94821.83963.14716.61454.68530.7750.39738.61334.33380.51312.135871.37销售成本348.06604.81649.99281.15772.44787.0468.07282.67727.96125.76725.0394.245467.20销售数量17.280.276.190.757.923.8215.5014.1610.7311.5818.7511.32118.27销售单价7.841630.45132.781285.4790.43118.9834.253.5668.8428.8820.2927.5749.64单位成本20.142277.73105.01375.2497.47205.944.3919.9667.8410.8638.668.3246.23销售成本率257.0%139.7%79.1%29.2%107.8%173.1%12.8%560.9%98.6%37.6%190.5%30.2%93.1%产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计O销售收入420.6617.01903.85113.54456.30704.33428.23756.27141.00823.59854.36473.586092.73销售成本686.33399.79277.36439.91672.85705.6590.71258.1936.89557.70109.83335.044570.25销售数量5.973.9118.0712.213.9518.4410.592.475.480.892.892.5687.42销售单价70.434.3550.019.30115.6238.1940.44306.6725.75921.02295.91185.1269.69单位成本114.91102.3015.3536.03170.4938.278.57104.696.74623.6738.04130.9652.28销售成本率163.2%2350.7%30.7%387.4%147.5%100.2%21.2%34.1%26.2%67.7%12.9%70.7%75.0%P销售收入733.48346.62405.99960.6592.22549.7483.99822.18169.79902.69502.86691.056261.28销售成本69.0317.68166.30188.43549.65592.28541.23249.03317.63508.60391.31743.664334.82销售数量14.326.205.3315.2115.3717.013.2913.5711.4514.5313.9814.58144.85销售单价51.2255.9376.1563.186.0032.3325.5260.5714.8362.1135.9647.3843.23单位成本4.822.8531.1912.3935.7634.83164.4618.3527.7334.9927.9850.9929.93销售成本率9.4%5.1%41.0%19.6%596.0%107.7%644.4%30.3%187.1%56.3%77.8%107.6%69.2%Q销售收入60.69596.29656.19388.07553.71596.01115.85818.99747.76645.64576.94936.306692.44销售成本10.15422.84371.16513.61710.82336.32114.79315.94189.67135.70798.11406.694325.80销售数量5.120.4213.558.959.083.375.717.0216.093.8811.8610.2895.34销售单价11.851436.5748.4143.3860.95176.6720.27116.6246.48166.5248.6491.0570.19单位成本1.981018.7127.3857.4178.2499.6920.0944.9911.7935.0067.2939.5545.37销售成本率16.7%70.9%56.6%132.3%128.4%56.4%99.1%38.6%25.4%21.0%138.3%43.4%64.6%R销售收入330.34126.73194.70451.07572.57637.50976.07977.39994.14504.78166.15269.476200.91销售成本283.61420.19429.5022.0614.52190.65432.53334.40388.94105.77226.43629.133477.73销售数量2.8210.927.3012.2318.9711.8113.177.7310.4119.6817.665.58138.28销售单价117.2811.6026.6536.8930.1853.9774.10126.4395.5325.659.4148.3144.84单位成本100.6938.4758.801.800.7716.1432.8443.2537.385.3712.82112.7825.15销售成本率85.9%331.6%220.6%4.9%2.5%29.9%44.3%34.2%39.1%21.0%136.3%233.5%56.1%S销售收入894.44222.93645.74327.84669.29679.98491.49101.5737.9529.83493.05860.685454.80销售成本676.63207.84743.67767.70357.23692.01135.7871.50125.36190.49313.64261.664543.51销售数量4.998.6916.1017.1412.898.306.0519.572.6912.2010.406.59125.61销售单价179.3025.6740.1019.1351.9481.8881.215.1914.102.4447.40130.6443.43单位成本135.6423.9346.1844.7927.7283.3322.443.6546.5715.6230.1539.7236.17销售成本率75.6%93.2%115.2%234.2%53.4%101.8%27.6%70.4%330.3%638.7%63.6%30.4%83.3%T销售收入378.28522.68304.71275.59266.38345.6842.82833.77381.17822.35868.45604.015645.89销售成本505.6137.69428.8224.8856.74668.88733.22361.39109.80699.3157.37464.874148.58销售数量7.593.617.5315.8017.0215.482.092.953.587.436.0711.54100.69销售单价49.85144.6840.4917.4415.6522.3320.48282.40106.44110.66143.1752.3456.07单位成本66.6310.4356.981.573.3343.21350.63122.4130.6694.109.4640.2841.20销售成本率133.7%7.2%140.7%9.0%21.3%193.5%1712.3%43.3%28.8%85.0%6.6%77.0%73.5%合计销售收入8019.798557.5410182.919662.5910348.6511554.658897.738871.6510794.0611317.1510072.9910334.21118613.92销售成本8996.588340.058405.776883.847849.7011123.636452.656383.077564.037077.358653.767832.6595563.07