首页 销售收入表格大全

销售收入表格大全

举报
开通vip

销售收入表格大全&"黑体,常规"&20&A&9共&"TimesNewRoman,常规"&N&"宋体,常规"页第&"TimesNewRoman,常规"&P&"宋体,常规"页被审计单位名称:查验人员:日期:索引号:所属时期或截至时间:复核人员:日期:金额单位:人民币元月份销售收入销售成本销售费用销售税金销售成本率销售费用率销售税金率18125.565889.01998.52211.9572.48%12.29%2.61%29565.047166.24301.4067.2674.92%3.15%0.70%310764.427926.321...

销售收入表格大全
&"黑体,常规"&20&A&9共&"TimesNewRoman,常规"&N&"宋体,常规"页第&"TimesNewRoman,常规"&P&"宋体,常规"页被审计单位名称:查验人员:日期:索引号:所属时期或截至时间:复核人员:日期:金额单位:人民币元月份销售收入销售成本销售费用销售税金销售成本率销售费用率销售税金率18125.565889.01998.52211.9572.48%12.29%2.61%29565.047166.24301.4067.2674.92%3.15%0.70%310764.427926.32119.96461.0973.63%1.11%4.28%410258.528003.7787.01184.5678.02%0.85%1.80%512230.2010475.75220.51223.9585.65%1.80%1.83%611447.208282.54830.98282.0472.35%7.26%2.46%79764.028006.62254.41223.9382.00%2.61%2.29%87462.046687.73785.87450.6689.62%10.53%6.04%99746.018496.64632.97184.0687.18%6.49%1.89%1011138.479351.82195.61260.0883.96%1.76%2.33%118414.417507.6870.30166.8989.22%0.84%1.98%129127.007824.8290.92343.0685.73%1.00%3.76%合计118042.9195618.924588.463059.5481.00%3.89%2.59%一、销售收入、成本相关情况二、销售成本率变化情况回归函数为:0.7108858545975.3235671316平均值:81.23%Y=0.7109X+975.3236(Y:销售成本X:销售收入)标准差:6.33%相关系数为:r=0.8536被审计单位名称:查验人员:日期:索引号:所属时期或截至时间:复核人员:日期:金额单位:人民币元三、销售收入、费用相关情况四、销售费用率变化情况回归函数为:-0.07327064181103.12874573平均值:4.14%Y=-0.0733X+1103.1287(Y:销售费用X:销售收入)标准差:3.85%相关系数为:r=-0.3117异常五、销售收入、税金相关情况六、销售税金率变化情况回归函数为:-0.0058970322312.969835615平均值:2.67%Y=-0.0059X+312.9698(Y:销售税金X:销售收入)标准差:1.35%相关系数为:r=-0.0728异常&"黑体,常规"&20&A&9共&"TimesNewRoman,常规"&N&"宋体,常规"页第&"TimesNewRoman,常规"&P&"宋体,常规"页被审计单位名称:查验人员:日期:索引号:所属时期或截至时间:复核人员:日期:金额单位:人民币元月份上年度本年度增减金额增减比率销售收入96255.83118042.9121787.0922.6%销售成本77173.2895618.9218445.6423.9%销售费用659.754588.463928.72595.5%销售税金2930.923059.54128.624.4%销售成本率80.18%81.00%0.83%1.0%销售费用率0.69%3.89%3.20%467.1%销售税金率3.04%2.59%-0.45%-14.9%一、销售收入、成本、费用、税金对比图二、销售成本率、销售费用率、销售税金率对比图&"黑体,常规"&20&A&9共&"TimesNewRoman,常规"&N&"宋体,常规"页第&"TimesNewRoman,常规"&P&"宋体,常规"页被审计单位名称:查验人员:日期:索引号:所属时期或截至时间:复核人员:日期:金额单位:人民币元产品名称上年销售情况本年销售情况销售收入销售成本销售数量销售单价单位成本销售成本率销售收入销售成本销售数量销售单价单位成本销售成本率A1664.664530.3192.5018.0048.97272.15%4950.734284.22108.9445.4439.3386.54%B498.98292.3320.0024.9414.6158.59%5389.924082.5999.0054.4441.2475.74%C1094.26454.3326.7240.9517.0041.52%7681.094797.93109.6770.0443.7562.46%D7631.457928.9851.01149.61155.44103.90%5488.494854.32122.2644.8939.7188.45%E9487.336414.6080.36118.0679.8267.61%5342.214937.4697.2454.9450.7892.42%F5682.294674.866.12927.93763.4182.27%6236.025740.49116.7053.4449.1992.05%G9124.407125.8418.10504.05393.6478.10%7202.174834.38113.7563.3142.5067.12%H1886.331970.3986.0021.9322.91104.46%7129.913731.4593.2676.4540.0152.34%I1581.421187.8396.5916.3712.3075.11%4552.985215.80149.7730.4034.82114.56%J9416.037936.5859.65157.86133.0684.29%5184.815454.3892.6555.9658.87105.20%K3910.981160.4389.6543.6312.9429.67%7853.084099.88127.5461.5732.1452.21%L623.76468.7840.3115.4711.6375.15%6572.825395.54111.2359.0948.5182.09%M6159.791081.7111.47537.1294.3217.56%6081.814564.16138.2444.0033.0275.05%N3510.344660.7613.36262.82348.95132.77%5236.024132.32127.7440.9932.3578.92%O6298.872491.5947.36132.9952.6139.56%6306.984779.79106.4359.2644.9175.79%P6021.572319.8082.8372.7028.0138.52%6039.264003.41132.6145.5430.1966.29%Q9736.905003.4213.85703.26361.3851.39%4478.944664.5384.6152.9355.13104.14%R3257.257122.5890.6335.9478.59218.67%5366.385576.94106.2450.5152.49103.92%S7947.883645.0273.61107.9749.5245.86%5659.876357.8678.5072.1080.99112.33%T721.336703.1659.3112.16113.02929.28%5289.444111.48119.7344.1834.3477.73%合计96255.8377173.2880.18%118042.9195618.9281.00%一、上年销售收入结构图二、本年销售收入结构图三、上年销售成本结构图四、本年销售成本结构图五、销售收入对比图六、销售成本对比图七、销售成本率对比图八、销售数量对比图九、销售单价对比图十、单位成本对比图&"黑体,常规"&20&A&9共&"TimesNewRoman,常规"&N&"宋体,常规"页第&"TimesNewRoman,常规"&P&"宋体,常规"页被审计单位名称:查验人员:日期:索引号:所属时期或截至时间:复核人员:日期:金额单位:人民币元产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计A销售收入482.79478.72545.67970.89556.60670.77283.4787.59297.85303.18191.7981.404950.73销售成本268.60195.75295.65182.82613.29719.64277.54595.18212.20612.63160.75150.184284.22销售数量15.599.7415.060.9414.625.024.6111.281.8810.9914.344.88108.94销售单价30.9749.1336.231037.0638.06133.5061.487.77158.7727.6013.3816.6945.44单位成本17.2320.0919.63195.2741.94143.2360.1952.78113.1155.7711.2130.7939.33销售成本率55.6%40.9%54.2%18.8%110.2%107.3%97.9%679.5%71.2%202.1%83.8%184.5%86.5%收入、成本、数量对比图单价、成本对比图销售成本率趋势图产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计B销售收入217.94419.44119.92785.20286.53504.14126.64860.46374.41892.5846.27756.415389.92销售成本73.80522.3781.07638.36141.36535.48579.02315.1142.08477.73602.2773.934082.59销售数量17.853.152.460.3717.643.118.1211.201.372.6011.9219.1999.00销售单价12.21133.0048.682106.4516.24162.1015.6176.83273.47342.673.8839.4154.44单位成本4.13165.6432.911712.518.01172.1871.3528.1430.74183.4150.523.8541.24销售成本率33.9%124.5%67.6%81.3%49.3%106.2%457.2%36.6%11.2%53.5%1301.8%9.8%75.7%收入、成本、数量对比图单价、成本对比图销售成本率趋势图产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计C销售收入593.88705.85459.17691.04580.68567.01760.38562.82236.31791.98773.44958.537681.09销售成本604.30123.94477.27447.39584.62108.82643.91405.13293.19376.7277.04655.594797.93销售数量18.6214.2615.764.292.6917.096.982.4414.924.505.562.57109.67销售单价31.9049.4829.13161.18215.9433.18108.95230.3515.84176.02139.19373.5770.04单位成本32.468.6930.28104.35217.406.3792.26165.8119.6583.7313.86255.5043.75销售成本率101.8%17.6%103.9%64.7%100.7%19.2%84.7%72.0%124.1%47.6%10.0%68.4%62.5%收入、成本、数量对比图单价、成本对比图销售成本率趋势图产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计D销售收入191.06915.66398.26255.1661.57950.92655.2958.65417.10982.78480.21121.825488.49销售成本472.07663.52300.8428.37562.84592.92148.88436.136.36648.86643.60349.934854.32销售数量11.306.8212.4712.860.7711.2716.189.850.6915.9110.5213.62122.26销售单价16.91134.3031.9319.8479.8284.3640.505.96605.4261.7745.668.9544.89单位成本41.7897.3224.122.21729.5952.609.2044.309.2440.7861.2025.6939.71销售成本率247.1%72.5%75.5%11.1%914.1%62.4%22.7%743.6%1.5%66.0%134.0%287.2%88.4%收入、成本、数量对比图单价、成本对比图销售成本率趋势图产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计E销售收入586.72344.93367.32503.60263.74386.83361.36639.53666.40123.44388.81709.545342.21销售成本240.83544.93619.96433.49304.59381.3949.34564.36477.32422.76739.18159.304937.46销售数量4.456.2118.874.716.600.550.044.9414.2718.8210.257.5397.24销售单价131.8355.5619.47107.0139.95697.188696.48129.4546.706.5637.9294.2854.94单位成本54.1187.7832.8692.1146.14687.381187.49114.2433.4522.4672.1021.1750.78销售成本率41.0%158.0%168.8%86.1%115.5%98.6%13.7%88.2%71.6%342.5%190.1%22.5%92.4%收入、成本、数量对比图单价、成本对比图销售成本率趋势图产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计F销售收入309.16227.10983.05733.66322.72853.22131.02388.58868.55869.59363.96185.396236.02销售成本596.15777.79783.17312.03616.7455.83124.82597.44473.30654.24411.83337.145740.49销售数量8.629.4215.0419.252.0614.753.1910.854.960.5918.579.40116.70销售单价35.8924.1165.3638.11156.6157.8341.0835.82175.191474.6619.6019.7253.44单位成本69.2082.5752.0716.21299.303.7839.1455.0795.471109.4822.1835.8749.19销售成本率192.8%342.5%79.7%42.5%191.1%6.5%95.3%153.7%54.5%75.2%113.2%181.9%92.1%收入、成本、数量对比图单价、成本对比图销售成本率趋势图产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计G销售收入331.26917.03766.24198.11472.13864.51861.05896.79279.22862.00448.35305.477202.17销售成本147.13148.95371.46247.65715.14753.21627.74182.10230.15728.61175.80506.424834.38销售数量14.732.2618.517.6515.109.347.5815.592.395.2913.501.79113.75销售单价22.49405.4641.3925.8831.2792.53113.5457.53116.82163.0333.20170.4263.31单位成本9.9965.8620.0632.3547.3680.6282.7711.6896.30137.8013.02282.5342.50销售成本率44.4%16.2%48.5%125.0%151.5%87.1%72.9%20.3%82.4%84.5%39.2%165.8%67.1%收入、成本、数量对比图单价、成本对比图销售成本率趋势图产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计H销售收入416.78797.45939.56612.14860.99463.86842.62382.00322.69575.0937.76878.967129.91销售成本30.3841.35370.37675.68144.30557.03120.68263.57687.11281.69187.61371.683731.45销售数量9.5211.6512.375.160.6211.454.851.2213.454.108.5810.2893.26销售单价43.7668.4375.93118.651379.3840.51173.84313.1623.99140.334.4085.5476.45单位成本3.193.5529.93130.97231.1848.6524.90216.0851.0868.7421.8636.1740.01销售成本率7.3%5.2%39.4%110.4%16.8%120.1%14.3%69.0%212.9%49.0%496.8%42.3%52.3%收入、成本、数量对比图单价、成本对比图销售成本率趋势图产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计I销售收入225.35137.8586.22979.61805.71158.45301.66586.48651.0979.3199.37441.884552.98销售成本650.47517.16678.62313.33504.45565.10104.62133.50377.80605.50181.48583.775215.80销售数量4.309.0519.4018.070.3113.2417.8819.8814.6412.4217.772.82149.77销售单价52.4615.234.4454.232633.3711.9616.8729.5044.486.395.59156.7030.40单位成本151.4157.1334.9717.341648.7342.675.856.7225.8148.7510.22207.0234.82销售成本率288.6%375.2%787.1%32.0%62.6%356.6%34.7%22.8%58.0%763.5%182.6%132.1%114.6%J销售收入920.96824.38859.56212.96372.55210.35156.76150.37535.99429.29211.59300.055184.81销售成本285.47564.32235.92618.15446.24166.50445.10113.68473.15721.41598.12786.315454.38销售数量4.3316.579.467.7412.3316.664.615.891.678.131.963.3192.65销售单价212.5849.7690.8727.5130.2312.6333.9725.51321.8552.83108.0190.7455.96单位成本65.8934.0624.9479.8436.2010.0096.4519.29284.1288.77305.32237.7958.87销售成本率31.0%68.5%27.4%290.3%119.8%79.2%283.9%75.6%88.3%168.0%282.7%262.1%105.2%K销售收入621.81343.58606.47793.40906.36820.62819.44662.67405.00787.31275.59810.837853.08销售成本235.69313.62173.88263.46328.97459.92608.5635.35673.347.62573.29426.184099.88销售数量2.432.4515.5212.3110.6415.8714.223.0813.4114.8513.389.40127.54销售单价256.13140.3939.0864.4485.2051.7357.64215.3930.2153.0220.5986.2461.57单位成本97.08128.1511.2021.4030.9228.9942.8111.4950.220.5142.8445.3332.14销售成本率37.9%91.3%28.7%33.2%36.3%56.0%74.3%5.3%166.3%1.0%208.0%52.6%52.2%L销售收入562.06314.74436.55137.05514.43754.91825.62504.81759.70132.71717.02913.236572.82销售成本13.2439.19588.2269.84456.34427.74709.04234.12783.55745.97605.70722.585395.54销售数量18.2614.085.380.6113.7616.767.314.2512.4615.242.310.81111.23销售单价30.7822.3581.13226.1437.3945.04113.00118.8660.958.71309.921127.6559.09单位成本0.732.78109.32115.2333.1725.5297.0455.1362.8648.96261.80892.2448.51销售成本率2.4%12.5%134.7%51.0%88.7%56.7%85.9%46.4%103.1%562.1%84.5%79.1%82.1%M销售收入118.61469.61602.82676.97921.01118.03358.46623.26414.09760.37224.15794.456081.81销售成本198.76331.34316.62417.42722.86323.23589.32238.37791.22119.81233.33281.874564.16销售数量13.4910.4217.174.6517.647.599.7116.3614.825.344.0816.97138.24销售单价8.7945.0935.10145.6752.2215.5436.9038.1027.94142.4854.9546.8144.00单位成本14.7431.8118.4489.8240.9842.5760.6714.5753.3822.4557.2116.6133.02销售成本率167.6%70.6%52.5%61.7%78.5%273.9%164.4%38.2%191.1%15.8%104.1%35.5%75.0%N销售收入435.41310.81995.5995.14821.83277.98419.0493.163.11924.87691.58167.485236.02销售成本156.6987.08142.28624.63697.02122.27149.14751.72513.10572.03307.688.674132.32销售数量19.6810.0810.8013.414.1015.957.214.880.869.2818.4313.05127.74销售单价22.1330.8292.197.10200.2017.4358.1219.093.6199.6537.5212.8340.99单位成本7.968.6413.1746.59169.807.6720.69154.02595.5261.6316.690.6632.35销售成本率36.0%28.0%14.3%656.5%84.8%44.0%35.6%806.9%16510.4%61.8%44.5%5.2%78.9%产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计O销售收入607.12157.36474.39714.41843.24877.33798.61125.61430.14420.68755.72102.386306.98销售成本399.67514.9869.55649.94381.11227.82666.6991.25605.96600.62255.80316.404779.79销售数量11.566.733.368.6712.4116.8311.977.154.441.722.4919.12106.43销售单价52.5323.40141.2582.4267.9352.1266.7117.5896.97244.86303.755.3659.26单位成本34.5876.5720.7174.9930.7013.5355.6912.77136.61349.60102.8216.5544.91销售成本率65.8%327.3%14.7%91.0%45.2%26.0%83.5%72.6%140.9%142.8%33.8%309.0%75.8%P销售收入155.90648.65788.48347.79854.00878.77322.5489.13913.62259.97519.07261.346039.26销售成本675.54530.6039.23179.22631.85765.71163.3889.665.43325.95280.27316.574003.41销售数量2.262.6514.7111.0018.9915.2019.573.911.4713.6018.4910.76132.61销售单价68.84244.6553.6031.6244.9757.8016.4822.77623.1919.1228.0824.2945.54单位成本298.32200.132.6716.2933.2750.368.3522.903.7023.9715.1629.4330.19销售成本率433.3%81.8%5.0%51.5%74.0%87.1%50.7%100.6%0.6%125.4%54.0%121.1%66.3%Q销售收入174.73623.82370.35610.86486.60124.32529.56456.32561.33321.9672.31146.764478.94销售成本33.3830.63748.76579.34737.41400.77135.48531.44786.3632.36512.70135.904664.53销售数量8.998.382.029.4510.515.550.665.007.199.311.1416.4084.61销售单价19.4374.48183.4164.6346.2822.41799.2591.1878.0334.6063.168.9552.93单位成本3.713.66370.8161.2970.1372.23204.48106.19109.313.48447.828.2955.13销售成本率19.1%4.9%202.2%94.8%151.5%322.4%25.6%116.5%140.1%10.0%709.0%92.6%104.1%R销售收入109.88662.8815.0372.85983.82209.62577.44138.50625.02854.41768.86348.095366.38销售成本169.41467.70740.17394.23728.59425.74429.08790.06263.69164.00223.11781.165576.94销售数量18.6619.294.1411.871.094.6315.741.6311.672.667.107.76106.24销售单价5.8934.373.636.14903.9145.2836.6984.7153.57320.71108.2344.8650.51单位成本9.0824.25178.8033.21669.4191.9727.26483.2422.6061.5631.41100.6652.49销售成本率154.2%70.6%4924.5%541.2%74.1%203.1%74.3%570.5%42.2%19.2%29.0%224.4%103.9%S销售收入218.8183.65135.99858.54937.91785.10449.7778.41437.385.19843.56825.565659.87销售成本502.73693.72624.52688.27718.27363.68635.44185.47376.82520.27299.08749.606357.86销售数量3.570.200.586.872.4310.3612.8818.365.539.080.598.0678.50销售单价61.35415.13234.41125.03386.4275.7534.924.2779.110.571440.60102.3972.10单位成本140.963442.661076.51100.24295.9335.0949.3410.1068.1557.30510.7592.9780.99销售成本率229.8%829.3%459.2%80.2%76.6%46.3%141.3%236.5%86.2%10018.6%35.5%90.8%112.3%T销售收入845.33181.51813.779.15377.79970.47183.2876.91547.02761.77505.0117.435289.44销售成本134.6957.29268.74240.15439.78329.72798.83134.08424.48733.03439.04111.644111.48销售数量2.427.596.4619.1818.545.125.8512.898.279.0216.318.08119.73销售单价348.9223.91125.880.4820.37189.6731.335.9766.1884.4430.972.1644.18单位成本55.607.5541.5712.5223.7164.44136.5710.4051.3581.2526.9213.8234.34销售成本率15.9%31.6%33.0%2625.6%116.4%34.0%435.9%174.3%77.6%96.2%86.9%640.6%77.7%合计销售收入8125.569565.0410764.4210258.5212230.2011447.209764.027462.049746.0111138.478414.419127.00118042.91销售成本5889.017166.247926.328003.7710475.758282.548006.626687.738496.649351.827507.687824.8295618.92
本文档为【销售收入表格大全】,请使用软件OFFICE或WPS软件打开。作品中的文字与图均可以修改和编辑, 图片更改请在作品中右键图片并更换,文字修改请直接点击文字进行修改,也可以新增和删除文档中的内容。
该文档来自用户分享,如有侵权行为请发邮件ishare@vip.sina.com联系网站客服,我们会及时删除。
[版权声明] 本站所有资料为用户分享产生,若发现您的权利被侵害,请联系客服邮件isharekefu@iask.cn,我们尽快处理。
本作品所展示的图片、画像、字体、音乐的版权可能需版权方额外授权,请谨慎使用。
网站提供的党政主题相关内容(国旗、国徽、党徽..)目的在于配合国家政策宣传,仅限个人学习分享使用,禁止用于任何广告和商用目的。
下载需要: ¥17.6 已有0 人下载
最新资料
资料动态
专题动态
机构认证用户
熊猫图文
公司专注课件、范文、教案设计制作等。用户至上,受到广大客户的一致好评,公司秉着用户至上的原则服务好每一位客户
格式:xls
大小:350KB
软件:Excel
页数:0
分类:
上传时间:2021-10-29
浏览量:135