全部
搜索
稻壳儿首页 >

表格模板

 >当前作品

财务预算管理系统（经营业绩分析

收藏
  • 财务预算管理系统（经营业绩分析-表格模板,,公司主要财务状况分析（总括）,一、销售收入、回款、利润、毛利率、现金流量情况分析,1、主要经营指标,2、年度三年数据对比,3、月度三年数据对比,4、销售收入情况分析,5、回款情况分析,6、利润情况分析,7、现金流量情况分析,8、毛利率分析,二、应收帐款、存货、应付帐款情况分析,1、应收账款情况分析,2、存货情况分析,3、应付帐款情况分析,三、费用支出情况分析,1、营业费用分析,2、管理费用分析,四、公司财务状况分析（明细）,,返回目录,主要经营指标汇总分析,序号项目累计预算本年实际累计最近二年增减情况累计预算完成比率,20年同期增减比率或天19年同期增减比率或天,一、收入、利润、现金流情况销售收入(万元)12650.09615.012336.011361.00.08581991021921.28299531981,毛利率(%)0.29660.28090.32170.31880.009096612296111.14524741901,净利润(万元)-386.0-460.0249.0169.00.4733727810651.54130434783,净利润率-0.0305138339921-0.05597503900160.02361624513620.01740427779240.3569218681651.42190672052,经营净现金流量(万元)-3089.0488.0-2591.427833-10160.9788460.744962776493,二、应收款、存货、应付款情况应收帐款（万元）13592.015061.30959119869.238477-0.097555234631-0.241978518279,应收账款周转天数(天)140.0102.0153.0181.0-51.0-28.0,存货（万元）7634.06212.07707.00.228911783645-0.193979499157,存货周转天数(天)117.087.0122.0137.0-35.0-15.0,应付帐款（万元）11899.07062.07396.00.684933446616-0.0451595457004,应付账款周转天数(天)113.0145.0119.0-32.026.0,三、费用情况管理费用(万元)448.0534.0576.0326.00.7668711656441.07865168539,管理费用率0.03541501976280.06497971918880.05463035019460.03357274887770.62722303120.840729244087,营业费用(万元)2690.01739.01782.01806.0-0.01328903654491.02472685451,营业费用率0.2126482213440.2116099843990.1690126459140.185988909427-0.09127567640940.798698825077,制造费用(万元)798.0521.0716.335481679.0379.00.05498598085420.7915567282320.8976635100251.30326295585,制造费用率0.06308300395260.06339781591260.06439931906610.03903089516770.6499575218421.01579712391,财务费用(万元)147.0228.084.090.0180.0-0.0666666666667-0.50.5714285714290.394736842105,财务费用率0.01162055335970.0277441497660.00853599221790.0185371006073-0.539518482490.307668185542,每万元产值工资性支出（元）821.0780.0635.0783.0858.0-0.18901660281-0.08741258741260.7734470158341.00384615385,四、税金、质理损失、资本支出情况税费金(万元)802.0368.0798.0256.02.11718752.16847826087,质量损失(元/万元销售收入)12.016.010.07.767752918299.90705043570.287373595066-0.2159368755920.8333333333330.485484557393,资本支出(万元)243.0138.042.0128.0-0.6718750.304347826087,,返回目录,年度主要经营指标预算三年数据对比,单位：万元,序号项目18年19年20年占销售收入比率实际完成预算比率,预算增减完成预算比率预算增减18年实际19年实际20年预算18年19年20年,一、收入、利润、现金流情况销售收入(万元)45695.051562.057525.7285155963.7285151.1156613109561558.8095999-61558.80959991.11566131095,毛利率(%)0.30380.30560.3048-0.00080.3525-0.3525,净利润(万元)4504.04800.04598.0-202.05000.0-5000.00.09856658277710.07992945276310.0812231430805,经营净现金流量(万元)2062.06000.014290.08290.02.381666666677000.0-7000.00.04512528723060.2484105872080.1137124003132.38166666667,净现金流量(万元)-2887.04948.07694.02746.01.554971705745875.0-5875.0-0.06317977896930.1337488494040.09543719311961.55497170574,二、存货、应收款、应付款情况应收账款周转天数(天)143.098.0112.094.0-94.0,存货周转天数(天)102.080.074.0-6.075.0-75.0,应付账款周转天数(天)89.0-98.0100.0-100.0,三、费用情况管理费用(万元)1497.01866.01407.0-459.00.7540192926051361.56536738-1361.565367380.03276069591860.02445862114780.02211812372960.754019292605,营业费用(万元)7946.06878.08715.01837.01.267083454499651.0-9651.00.1738921107340.1514974294980.1567769107741.26708345449,制造费用(万元)1762.02401.02259.00.9408579758432477.58774467-2477.587744670.03856001750740.03926938533970.04024749277590.940857975843,财务费用(万元)726.0334.0440.0106.01.31736526946442.0-442.00.01588795273010.007648751460580.007180125848321.31736526946,每万元产值工资性支出（元）835.392255192780.121019355743.644422144-36.47659721120.953242386366736.720721316-736.7207213160.953242386366,四、税金、质理损失、资本支出情况税费金(万元)3796.02297.03326.01029.01.447975620374898.0-4898.00.08307254623040.05781760763160.07956619096171.44797562037,质量损失(元/万元销售收入)26.016.4214.4-2.0212.0-12.00.876979293544,资本支出(万元)583.0433.0284.0-149.00.655889145497405.0-405.00.655889145497,注:（1）质量损失(元/万元销售收入)=本年度质量损失总额（元）/本年度销售收入（万元）, （2）每万元产值工资性支出（元）=本年度工资性支出总额（元）/本年度销售收入（万元）,19年实际数以审计部确认的数据为准。,,返回目录,月度主要经营指标预算三年数据对比,单位:万元,万套,项目/年度/金额/比率月份,1月2月3月4月5月6月7月8月9月10月11月12月本年累计,销量,4.9738.8732.6442.1235.2839.0136.3140.1136.9648.8457.7148.1989461.0189,25.556914.871538.680332.869435.007646.544147.764247.627337.158738.463152.895453.7571471.1956,预算数量25.31949.446242.124748.989854.156665.162246.741947.326647.095758.579242.491629.7686517.2025,19.6637.1744.5731.0132.4,销售收入,2112.02296.03305.03648.03229.03241.03252.04248.03827.05235.06214.05088.045695.0,2926.351702.82224135.553571.64007.255916.06292.896364.409743965.4754754012.35437592.02687039.057525.728515,2817.15128571042.37753812.03674978.03735716048.98228544.61315729.86027145161.30776205.41759059.50854867.16553292.351985761558.8095999,2136.74828.04865.04904.016733.7,净利润5290.91671.0959.0974.01315.01046.0-2711.07544.91,-133.054.018.0230.01.044.0176.0180.0-117.0411.01685.01955.04504.0,51.029.0156.013.0-1074.01313.0710.0418.0252.0327.01120.01283.04598.0,-87.9205752713-384.78870591-28.9072528709115.766206586733.2973792381464.75376958440.746419174423.580875083665.2812005041974.86154074373.599515259-467.6782981755222.59207394,290.0505.0-238.0330.0887.0,回款,2056.01294.02454.02805.01952.03107.03123.02567.04497.04894.06885.014126.7449760.74,2703.16691196.561612341.1138132782.7346373397.2162736495.9189763339.5245335218.5004077498.1043643936.08711.26149312478.92540260099.028408,2905.01554.02982.03292.05140.06396.03938.06243.07279.05100.05847.09614.060290.0,4214.091681.04249.05621.015765.09,经营性净现金流,-4917.0-4280.8343-583.216337-379.928209-1142.723916-829.689434267.93-1205.6170192493.436704743.632795.09101.02061.987489,-1476.188611-841.301624189.517147-463.454745-279.0586523430.666207-243.7031811208.6546033084.801033-755.7938323998.9881946437.014290.126539,-3020.42642605573.18217788520.5644633588-662.565031947763.647720843836.833210773-1313.727076322183.536953312781.79774788-726.737270551871.6365952234422.873098496730.6161629,-1509.9-3025.167998500.942129.0-1905.127998,毛利率,0.33830.30510.26840.320.330.28450.36640.280.280.3050.32150.34840.3038,0.302279395240.302279395240.3226890670620.3357234533580.2372786726540.3735452295380.3094597861880.2433736600080.335350502870.2457743164530.3345966610330.2684838559490.3048,预算比率0.3388798641560.2077917555530.2960355095130.2918573168960.3635070942430.384169118350.3194344663460.342890292870.3426231498230.4360974992770.3407274069840.3427107240260.3525,0.36530.33750.29830.34090.3325,产量,26.101421.885134.549637.665536.82833.596134.406540.807540.425541.419253.590348.2046449.4793,35.07811.691327.955523.984640.872749.251248.791541.326135.082731.041963.134949.8246458.035,预算数量24.997910.711242.124748.939854.156665.112246.741947.330647.095758.586442.492828.4036516.6934,31.6724.8742.5343.0142.07,存货,7931.07728.07448.07707.07457.06997.08160.07942.08781.07993.07646.07241.07752.58333333,0.203069701280.197871977240.1907027027030.197334281650.190933143670.1791550497870.208933143670.2033513513510.2248335704130.2046571834990.1957724039830.1854025604550.198501422475,187.928875812178.662367125151.184322387136.694345317132.233599334128.155400077127.627282645121.884760062120.801499711114.042550942106.0505314102.235768215102.0,7353.4703776444.06212.366017.06092.86464.325489.055887.127315.7060826697.966647.926596776420.15573234,0.1495602152840.1310627469590.126351484590.1223781111810.1239197865720.1314760298610.1116402810670.1197365175170.1487921376560.1362279696810.1352103540280.130577784945,166.410547878132.520549015121.82881241114.994550984101.90248115390.732590158581.130116457681.701566312888.170953213884.43335507374.865604858574.0,6632.06383.07107.07634.06939.0,172.0101.089.087.087.0,应收账款,14427.55843314527.54974219869.23847717167.27705217188.58136817364.28287219333.40124519260.40769520619.53869920388.35234311291.53702817403.4295413,0.3157360418650.317924274910.4348230326510.3756926808620.3761589094650.3800040020130.4230966461320.4214992383190.4512427770870.4461834411420.2471066205930.380860696822,12674.370914367.52667615061.30959115573.9142115293.62671518329.36585719094.83488315341.20605516772.02594915755.57480211365.26249815420.8198305,0.2203252566670.24975827420.2618186675740.270729543320.265857158350.3186290087960.3319355595470.2666842550460.2915569499420.2738874449520.1975683366620.268068223187,10085.012541.012899.013592.012279.25,应付账款6382.5835485411.4490855415.5335555435.3118486790.0009358022.3835678846.2792239053.83076710309.85569710304.32904812516.2304897518.7234088000.5425975,与产量/采购支出比率,7551.2742626648.2734566943.1318147396.023897334.3544036149.88496043.7717466529.9860837413.6613927463.4266047565.6020697851.3226947074.22610942,与产量/采购支出比率,7580.5875777868.6464087342.0534757062.2832287479.8860389237.5715159137.2697669443.9980149097.8669079368.66809210474.88495211898.08832.64299767,与采购支出比率0.2910657837490.07929996510910.1803397919370.2887906944150.3466876486560.4773948313280.3656381312360.2490841455610.298575997810.3195843953570.4313059884380.264986949569,11379.011351.012273.012899.011975.5,与采购支出比率0.2806925037350.146506915690.311170862870.295294208853,资本支出,58.2325.6623.3322.33146.34130.842.0531.6438.52583.0,4.4493.823431.66952.044.07.57217.6013410.0289622.411284.446718.8935837.48461284.0,19.147546.7705147.352529.96336.302519.69827.192524.92624.304516.60058.4354.6245405.0,8.6055.34177.57772441.1232.622724,营业费用,808.53468.85528.95502.54548.3528.39482.42855.5661.4885728661.48643281899.9362837946.0,0.2146052858440.1659771558250.1696467927630.1820909879220.1979361308240.1901034132840.1328699152540.2615455970730.1478398529470.1245476547110.4368957254540.203453769559,823.479824466.46491.78475.1621.2899.53806.31828.396636375.7443985.4053861941.1748548715.0,0.2081303854020.13196750130.1610993952290.1387153284670.1228539553750.1672443185880.1482278386430.2444155991460.1095668024630.1518598830050.322655857250.177251992512,686.153620889399.953550436746.425725425857.580680621871.4306092861025.21587529845.348063251811.36013186864.5975147171087.282436784.592422261670.9886032249650.92923326,213.03633.5066695.0702.02243.5366,管理费用,161.5776.6887.5896.5132.13109.13126.06169.817220.2167.2150.01497.0,0.04288495916520.02714541603630.02808898026320.03496593372560.04769888923170.03926263837640.03471991525420.05191687744970.04921375358170.03148117154810.03449292452830.0383300142248,200.0115.0126.0139.092.080.0147.0112.0130.096.0169.01406.0,0.05054899448330.03253497116470.04127561877030.04058394160580.01819472616630.01487392914860.02702371579240.03304521761040.03790791855050.0147944683230.02809063787470.0285962480175,111.894492974109.633449313116.042584533110.578264155110.795445149111.680869436117.78498424112.761858072114.264534441114.957989005112.796503261118.3743927971361.56536738,161.092.0475.043.0771.0,0.08815931108720.02229494614750.1142343268240.0102589722675,制造费用,150.933661128.099.57115.14167.24163.33278.24182.268879202.276504149.923614125.121762.0,0.05900178288290.0619370720010.0469624371130.06226861973810.08437957847470.0927440630940.1064359698680.07739402361510.06504738023130.04160397276790.04415546057890.0648020977932,349.51283195.134033134.073807193.592406165.202002239.830938234.661811242.64587768.313025215.303867221.1439772259.414573,0.1245436470330.07842144735980.06202206425140.0888043365570.05305319447420.06551956062740.06564962734810.1089053220380.03532531823140.05032861017790.05592338686430.070970830477,184.8312196.037169667217.494501667199.156655333192.764935667211.668626667234.989177667220.964785231.862424203.071339667194.011339667190.7355896672477.58774467,157.97170.6947221.0167.0716.6647,0.1362851170690.06243854215190.07574322878470.0604505921986,每万元销售质量损失,0.912.210.336.178.2510.06.7114.679.1715.488.0140.29122.2,4.308712121219.625435540070.99848714069616.91337719325.549705791330.854674483220.633456334634.533898305123.961327410529.570200573112.890247827579.186320754726.7425320057,3.922.491.786.489.943.733.755.581.490.5529.5169.22,15.67276641557.044528539135.8310001119918.919708029219.65821501016.934969465546.8938050490816.4635994884.344830664630.84759974767249.050575365814.0784657736,12.0,0.020.825.647.1713.65,0.1095146721581.9871582435813.563823227117.10623980429.54391437638,税费金361.43690185275.69480541591.94296257354.40959448350.58847671298.55104876309.30451805255.56586697382.29423018558.621333821614.59409781330.803578177683.80741476,3.15097216.56432178.955567157.59975621.089893203.130265430.034653349.296796471.25594160.041746769.861481135.4632343796.0,0.0017455668750.00844087786150.027950987410.0505459743750.007641738869620.07332996298980.1547172644560.09620462601690.1440735431930.03576864237250.1449529983260.2611029842330.0971948790896,28.04792685.969892339.614528343.912655291.36134348.73336662.62300.59352.55292.87828.56351.093326.0,0.01121399471010.05906945166680.09608129457030.112660378080.08506900525550.009637937494930.01164256804110.05525890292540.1040186738260.08540070850670.1276885903510.05835705355870.0676466009289,178.56782769966.0726585487241.613165246315.5212317383.444907529541.592045137363.176245934327.137997608393.319895546574.229182354308.5187853651205.070173154898.26411582,1037.07276.92252.39334.01900.38,0.5678719052740.06710778790390.0606981089414,每万元产值工资性支出,998.9082969431042.39401496881.661442006667.96548845860.142228242937.279774489906.26939789833.9393939391132.2011322761.350407451589.126409695851.769911504835.392255192,833.01553.0831.772199326569.0768.0721.461187215628.242074928776.505724241886.904761905943.396226415494.980479643872.199779655743.644422144,948.4844151281580.17472012727.215765571659.365221278821.0,639.0630.0644.0629.21635.0,一月二月三月四月五月六月七月八月九月十月十一月十二月,2003年4639.01989.03262.02753.02502.02649.02773.02566.03130.03044.013353.07975.050635.0,2004年1832.02005.02552.03593.02953.02838.03222.04125.03003.04295.05941.04520.040879.0,2005年3210.0918.02669.04627.03753.04380.05205.04018.03360.03074.07172.05446.047832.0,2006年2121.03406.04254.0,10000.0,,返回目录,一、（1）销售收入情况分析,1/1-4/30,一、发货销售收入预算完成情况分析点击链接：销售收入明细情况分析,1.32289016635,0.3564849343020.271838187219,当月销售收入,累计销售收入,项目年度预算本月累计,预算完成率增减比率本月完成年度预算比率预算完成率增减比率累计完成年度预算比率,销售收入（万元）61558.80959990.9851304717520.3730586543850.07966392335841.322890166350.3564849343020.271838187219,二、20年度每月销售情况趋势分析,月份合计1月2月3月4月5月6月7月8月9月10月11月12月,18年度实际45695.02112.02296.03305.03648.03229.03241.03252.04248.03827.05235.06214.05088.0,19年度实际57525.7285152926.351702.82224135.554007.255916.06292.896364.409743965.4754754012.35437592.02687039.0,20年度实际16733.716292136.74828.04865.0,20年度预算12649.18864282817.15128571042.03812.0,,返回目录,一、（2）回款情况分析,1/1-4/30,一、回款情况分析点击链接：回款情况明细分析,1.46884041964,0.747096998661, ,当月回款,累计回款,项目年度预算本月累计,预算完成率增减比率本月完成年度预算比率预算完成率增减比率累计完成年度预算比率,汇入款61090.751.707515559541.020006200830.09201296795341.468840419640.7470969986610.258059759031,二、20年度每月回款情况趋势分析,月份合计1月2月3月4月5月6月7月8月9月10月11月12月,18年度49760.742056.01294.02454.02805.01952.03107.03123.02567.04497.04894.06885.014126.74,19年度60099.0284082703.16691196.561612341.1138133397.2162736495.9189763339.5245335218.5004077498.1043643936.08711.26149312478.925402,20年度实际15765.094214.091681.04249.05621.0,20年度预算60290.02905.01554.02982.05140.06396.03938.06243.07279.05100.05847.09614.0,,返回目录,一、（3）利润情况分析,1/1-4/30,一、利润总体情况分析点击链接：毛利率情况分析,1）从利润总额情况看：当月实现净利润330万元。第一季度累计888万元，预算-386万元。,2）从全年绩效目标（5000万）完成情况看：第一季度累计实际利润的全年绩效目标完成率为18%。 ,1、当月累计利润情况分析,月份,当月销售收入12.53,累计销售收入-385.85888.0248.29,项目年度预算本月累计,预算完成率增减比率本月完成年度预算比率预算完成率增减比率累计完成年度预算比率,利润5000.02.8504793988112.5325.33679169990.066-385.85888.0-2.30141246598248.292.576463006970.1776,二、利润影响因素情况分析,1月份数量对利润影响结构对利润影响价格对利润影响成本对利润影响营业费用对利润的影响管理费用对利润的影响财务费用对利润的影响税金对利润的影响其他对利润的影响合计,当月影响,累计影响,产品名称销售数量（万）销售收入销售单价销售成本生产成本毛利,当月情况上升幅度上升幅度,DD202126450.064489.01284.206643.38101.55840253199.7658515406-0.0179675807142604.681107143337.19447.819779133552.28705670730.0854375414338679.524892857306.186,DD20155930.041255.0360.46269.6364.448417664965.35692643320.0139007266376149.425789185264.946526.716572355564.22167010060.583994431884211.0342108154.6835,DD862-B27516.09761.0145.77456.2352.977903765157.60680258170.080353336918149.136706683530.18617.857503519230.92511013220.42255651013496.637293316526.044,DT862系列17763.022644.0299.3075480.75168.50053482212.3078961310.20633882257865.3650732165172.1678436.798442389576.03243243240.516016504901233.942426784308.58216,其他单相表10000.063.063.015.49924456315.49924456347.500755437,其他三相表1000.083.5835.00.04598183.5-0.045981,单相电子表238777.0142327.01726.9171146.8172.323423110380.57571648390.102416630391645.535278973418.848327.035069498829.42859049930.08133318517421081.38172103727.9617,三相电子表12462.025004.01014.87285712307.23814.373982587922.7443609020.117443555233332.832240933132.751476267.07770898153.0920956647-4.03046085557682.0406161672174.478524,小计489898.0305480.04978.03735714904.032172.18266448160.535223255-12.53087889641862.47544071356.1400973115.56191643547.889903,三、每月利润趋势情况,月份1月2月3月4月5月6月7月8月9月10月11月12月合计,18年-133.054.018.0230.01.044.0176.0180.0-117.0411.01685.01955.04504.0,19年51.029.0156.013.0-1074.01313.0710.0418.0252.0327.01120.01283.04598.0,20年度实际290.0505.0-238.0887.0,20年度预算-88.0-385.0-29.0-386.23,,返回目录,一、（4）现金流量总括指标分析,1/1-4/30,一、现金流量结构总体分析点击链接：现金流量明细分析,名称,经营活动15582.19170417487.048191,投资活动-69.360724,筹资活动,名称当月,全年绩效目标完成率,经营活动3448.7263732129.26718115582.19170417487.0481917000.0-0.272122355286,投资活动41.1-41.1-69.360724,筹资活动,3489.8263732088.167181,备注期初余额本月本年累计,借款还款期末余额借款还款期末余额,内部欠集团借款,2、累计经营活动现金流量明细情况,项目当月,实际去年同期增减预算实际去年同期增减预算,现金流入结构分析一、现金流入总额小计8393.861298-2815.8677443372.07518930.815128-3185.36142410893.15,1、本期内销现金流入5535.5255972705.2985412830.2270563372.07515273.1358169236.8325716036.30324510893.15,2、税款返还和财政补助10.0-10.025.1-25.1,3、出售固定资产、无形资产收入2330.971557-2330.9715573567.951557-3404.689557,4、银行贷款所收到的现金3347.3512-3347.35125610.741-5610.741,5、其他现金收入42.4679570.2442.227957309.055888490.19-181.134112,现金流出结构分析二、现金支出总额3489.8263737111.040286-3621.2139134064.6072319520845.343468-3125.67255314675.3781412,1、直接材料1900.6139871574.882994325.7309932400.010530.8247345549.9243044980.900436700.0,2、直接人工251.04567206.05786544.987805186.7063134181301.4371691447.406032-145.9688631682.32125585,3、制造费用34.54901931.5863612.962658143.113215667144.755965130.35564214.400323574.025341,4、营业费用829.93844929.925558-99.987118857.5806806213333.3331443184.498388148.8347562690.10995648,5、管理费用58.92062539.99320418.92742195.8533007681224.444189252.646765-28.202576389.24940784,6、财务费用（支出－收入）38.857095-0.20739.06409536.874243.66219529.60477514.05742147.4968,7、固定资产购置支出41.1232.254-191.15429.963272.1969-39.574176692.963,8、税金333.723537339.621262-5.897725314.5165214731904.4380451589.0891315.3489451799.21238005,9、其他现金支出1.0783756.926042-3755.8480424.152753889.621562-3885.468812,10、还贷支出4500.0-4500.0,合计三、现金多余或者不足2088.1671811282.821012805.346169-692.532231947-1914.52834-59.688871-3782.22814122, 其中：经营活动净现金流量2129.267181-463.2477456331.579021-662.569231947-2621.023997716.16751-3089.26514122,直接法编制的20年1-12月份现金流量表,项目1-12月份合计1月2月3月4月5月6月7月8月9月10月11月12月,销货现金收入152731358.1640392591.7515817589.8541165920.5955355255.97,税款返还财政补助,其它现金收入3090558.882062880.01302331.23300668.07424679.57,经营收入小计155821917.0442455471.7616119921.0841466588.6655779935.54,材料支出105308247.3433958513.225142058.627201535.6719006139.87,工资支出13014371.699008691.073638011.6-2142787.682510456.7,制造费用1447559.65372351.6361554.18368163.68345490.19,营业费用33333331.449808564.217028923.488196459.358299384.4,管理费用2244441.89617488.03418604.1619143.51589206.25,财务费用436621.95159862.5-159862.548051.0388570.95,上交税金19044380.453622535.079923733.02160877.013337235.37,其它支出41527.56461.018578.65707.910780.0,经营支出小计174870481.9157554466.6846371601.0636457150.4434487263.73,经营现金净流量-19048564.87-15098994.92-30251679.985009438.2221292671.81,基建用款,设备用款2326227.2486050.053400.01775777.24411000.0,投资支出小计2326227.2486050.053400.01775777.24411000.0,处置固定资产收入,存款利息收入,投资收入小计,投资活动产生现金净流量-693607.24-86050.0-53400.0-143157.24-411000.0,借款流入,筹资活动产生现金流入,还贷,支付利息,分配股利,筹资活动产生现金流出,筹资活动产生现金净流量,-19742172.11-15185044.92-30305079.984866280.9820881671.81,,返回利润情况分析返回总目录,20年第一季度产品毛利率分析,1、综合毛利率分析,项目本期累计,预算实际增减同期增减,综合毛利率0.29980.32620.02640.31060.0156,其中：内销毛利率0.29980.32620.02640.31060.0156, 外销毛利率0.24320.2424,2、销售额前10位产品盈利能力分析,盈利结构本年累计占累计销售收入比率实际毛利率边际贡献率单位变动成本单位固定成本利润总额,产品数量单价销售收入材料人工变动费用率固定费用率,盈利区,DDS188 - 5(20)5(30)A365835.062.8723000046.450.1959515878140.2111977095590.14804726224545.52.280.760.2827810318924.7394875907753.56226862272.3287895848e-061.0521.81849289542.399759329065.270252224460.08382777516241477051.18589,DSSD188S - 1.5(6)A12173.01619.6863534119716441.980.1679765351960.596921960460.517290199217.41815563317124.330321361781.8384769943.96541362679e-0547.704272191262.9525540171113.4268262080.07003011784958818377.44412,DD202 - 5（20）A173769.0100.16213645717405074.290.1482845676230.3135130456260.25319793001863.760.4505161810697.5507746588774.80129083994.29767144878e-062.897154979083.823206956928.6803619360.0866631068692898550.96878,DDSF2000 - 5(20)A44052.0249.8911008154.280.09378525885850.3081355796550.23893689262162.55.781.941.1239725156618.8380873876190.1820599031.72764711564e-052.677.227981384299.5383467272119.43632811150.07777953544161774045.05117,DD201 - 5(20)A142676.063.579069913.320.07727218813470.2200723611770.16331308802145.820.2859295402794.792257454253.18818699455.86424424555e-061.838740152062.426478456325.735218608380.0902189493217662957.502207,DD202-6 - 10(60)A49931.0101.435064501.330.0431476118650.3110519570150.25078801069164.81.981.110.4562188653537.6463532103175.99257207571.50049466125e-051.992.933827491333.871601538848.795429030170.0867142761528830951.646785,DTS188 - 1.5(6)A12964.0286.053708352.20.03159374061890.3207131620350.252331259485181.51.2866154632221.5640277611213.8706432245.76726890246e-058.273896814510.918580500722.48247731520.0785963199273644270.345326,DDS188-模块液晶 - 5(40)A28337.0126.293578679.730.0304889808330.2103729511440.14594605187492.144.221.410.5680358918029.52043721709107.8584731093.01391801576e-051.9523.65289434964.8205122581110.42540660770.0825513232062226869.43047,DT904 - 1.5(6)A13648.0232.623174797.760.02704806111650.2540624193960.200616998593157.86.133.441.0462943158717.5361794714185.9524737875.85714391418e-056.728452637628.8791476877221.75760032530.0935328016737339970.668511,FKGA自制大用户452.04500.02034000.00.01732890107330.6282778222220.5503966116961637.7219.496.5320.2404110627339.2348363052023.215247370.0009946977617349.0098130.160935729171.76581805310.9365537790.0690970119508978963.385882,843837.0115.85171228697759961.340.832877433134,汇总,3、各型号具体明细盈利能力分析,盈利结构本年累计占累计销售收入比率实际毛利率边际贡献率单位变动成本单位固定成本利润总额,产品数量单价销售收入材料人工变动费用率固定费用率,保本测算区,DD862-B - 10(40)A41900.052.4862199163.40.01873602999150.1411995579770.087989949348141.490.7850.2360751588973.9566843596247.86775951852.17663496576e-051.518139305042.003400161374.921539466410.0937686138476-12708.2274683,DT862-B - 10(40)A26565.0143.723817921.80.03252723165090.1406206512660.0964316687515110.40.64643375065210.8344068164129.8608405673.40134888481e-054.157051040665.4858185266914.77286956740.102789239962-24272.7097199,DX962 - 3(6)A1.0163.0163.01.38869757864e-060.1395092024540.0929386975857126.380.73315266738312.2878396261147.8509922940.9070613024144.714718338636.2217396315816.36645797020.100407717609-1.21745026374,DX862-B - 1.5(6)A50.0143.07150.06.09152618851e-050.1134265734270.069207520787113.755.082.850.64319528488210.7801292426133.1033245270.01861584958435.14.136225290945.458335995814.69456128670.102759169837-239.89429071,DX865(B) - 1.5(6)A204.0141.8228931.280.0002464834262760.09575518262590.0521149194101115.15.122.880.63788779931410.6911743299134.4290621290.004646495493095.144.102094201135.4132951812914.65538938240.103337959261-1481.94810838,DT862-BM - 1.5(6)A250.0203.050750.00.0004323705651290.08527093596060.030904789036172.455.162.90.91306743238415.3032603933196.7263278260.003876380843865.185.8717044347.7485469031418.80025133710.0926120755524-3131.6447907,DX862B - 1.5(6)A151.0133.020083.00.0001710994691520.04676691729320.00522939365102113.755.082.850.59821659363110.0262740508132.3044906440.006587884810265.13.84697876715.0766341779214.0236129450.105440698835-2012.543642,69121.088.6006058946124162.480.0521755190624-43848.1854703,盈利区,DDS188 - 5(20)5(30)A365835.062.8723000046.450.1959515878140.2111977095590.14804726224545.52.280.760.2827810318924.7394875907753.56226862272.3287895848e-061.0521.81849289542.399759329065.270252224460.08382777516241477051.18589,DSSD188S - 1.5(6)A12173.01619.6863534119716441.980.1679765351960.596921960460.517290199217.41815563317124.330321361781.8384769943.96541362679e-0547.704272191262.9525540171113.4268262080.07003011784958818377.44412,DD202 - 5（20）A173769.0100.16213645717405074.290.1482845676230.3135130456260.25319793001863.760.4505161810697.5507746588774.80129083994.29767144878e-062.897154979083.823206956928.6803619360.0866631068692898550.96878,DDSF2000 - 5(20)A44052.0249.8911008154.280.09378525885850.3081355796550.23893689262162.55.781.941.1239725156618.8380873876190.1820599031.72764711564e-052.677.227981384299.5383467272119.43632811150.07777953544161774045.05117,DD201 - 5(20)A142676.063.579069913.320.07727218813470.2200723611770.16331308802145.820.2859295402794.792257454253.18818699455.86424424555e-061.838740152062.426478456325.735218608380.0902189493217662957.502207,DD202-6 - 10(60)A49931.0101.435064501.330.0431476118650.3110519570150.25078801069164.81.981.110.4562188653537.6463532103175.99257207571.50049466125e-051.992.933827491333.871601538848.795429030170.0867142761528830951.646785,DTS188 - 1.5(6)A12964.0286.053708352.20.03159374061890.3207131620350.252331259485181.51.2866154632221.5640277611213.8706432245.76726890246e-058.273896814510.918580500722.48247731520.0785963199273644270.345326,DDS188-模块液晶 - 5(40)A28337.0126.293578679.730.0304889808330.2103729511440.14594605187492.144.221.410.5680358918029.52043721709107.8584731093.01391801576e-051.9523.65289434964.8205122581110.42540660770.0825513232062226869.43047,DT904 - 1.5(6)A13648.0232.623174797.760.02704806111650.2540624193960.200616998593157.86.133.441.0462943158717.5361794714185.9524737875.85714391418e-056.728452637628.8791476877221.75760032530.0935328016737339970.668511,FKGA自制大用户452.04500.02034000.00.01732890107330.6282778222220.5503966116961637.7219.496.5320.2404110627339.2348363052023.215247370.0009946977617349.0098130.160935729171.76581805310.9365537790.0690970119508978963.385882,DD202 - 5(30)A19660.095.9969481181887300.00.01607907325260.3336246489690.27415857640858.970.4317817090397.2367797734669.67856148253.69197061848e-052.776678354263.664220960848.40089931510.0875121499151352257.800719,DTSD188S - 1.5(6)A983.01632.154628691604408.00.01366894174690.5438361127590.465649867576733.777.34121791168123.040824064872.1420419750.00054359118252747.209505272162.2996388845112.2791441570.0687919772938636721.974032,DTSY188 - 1.5(6)A2027.0652.961323549.920.01127613846080.5973566527810.526110853304240.9712.214.092.9369286238949.223728603309.4306572270.0002337884295495.6418.886641020824.923601900849.45024292160.0757324229993596098.335399,DTS(X)188 - 1.5(6)A2277.0534.8208168641217787.00.01037507888470.5732028507450.504986921529204.013.54.522.4055540396140.317744947264.7432989870.0002173970480776.2415.469506215620.414207804242.12371401980.0787622932607519050.811384,DDY17 - 5(10)A16916.063.851080086.60.009201924209460.2043852779950.14752459916747.040.2871889436344.8133653995754.43055434325.03946205269e-051.846839054732.437166107225.754005161950.090117543648462004.5914109,DT862-B - 1.5(6)A6099.0141.56863374.440.007355619596860.1503249505510.106680612826107.170.63671835334210.671574095126.4582924480.0001464698126214.094573791515.4033709340314.62794472550.1033338847522889.47947679,DT902 - 1.5(6)A2873.0222.55639386.150.005447325143070.2796225567290.224767252002146.085.553.121.0010007737816.7770472932172.5280480670.0002698338837455.576.437181388118.4947739571120.50195534520.092122917749884810.9501966,DT962 - 1.5(6)A3474.0176.76614064.240.005231592166980.2024213622990.153257593819127.10.79504334654313.32514437149.6701877170.0002437370196265.112721555436.74696133317.28968288840.097814453996634045.6495182,DTSD188简 - 1.5(6)A706.0776.466005666548185.00.004670326270840.6081605662320.536584045136279.163.4924424735358.5342929618359.8267354350.00065639653663522.45900930229.637848589158.54685789120.0754017013803252813.243111,DSSD188 - 1.5(6)A373.01327.0494971.00.004216963369310.4911454408440.41768254990318.456.185.96867232894100.03658395772.7352562790.001561172788468.5238.383013713950.651831233897.55484494770.0735153315355170352.792242,DDSY188 - 5(20)A1915.0245.07469309.050.003998333382630.2540906679720.187427992118170.217.02.351.1022927864818.4747291852199.1370219720.0004243195863613.247.08856455989.3543664509919.68293101080.080315546622650268.8400387,DT964 - 1.5(6)A2201.0208.83459634.830.0039159127330.3008810994590.250112301971130.476.053.3970.93929000938315.7427579701156.5990479790.0003407031794776.086.04033515747.9710790629620.09141422040.096209424988670739.1226981,DX862 - 1.5(6)A1650.0140.340606061231562.00.001972819562610.1778573341050.130395068438103.764.532.540.6312336789910.5796494497122.0408831290.0005270332918564.554.059303245695.3568264456913.96612969140.09951595680987150.4288468,DD962 - 1.5(6)A3728.050.5866416309188587.00.001606689020020.15036858320.09816048534639.390.790.2275320935313.8135002428645.62103233640.0002419097410551.463201024461.930901307144.79410233160.0947701246226639.377957743,DT904 - 40(100)A750.0238.0178500.00.001520751642870.2452100840340.191167031864163.96.143.451.0704928517617.9417535646192.5022464160.001078443957516.884067267449.0845032657522.11857053320.092935170307517534.3872879,DD202-M - 10(40)A1494.0117.0174798.00.001489212020560.3330769230770.27122772280772.642.11.180.526250687638.8201057439285.26635643160.0004877993823242.113.384184328954.465911269299.960095598250.085129022207232529.6806675,DXS188-1 - 1.5(6)A660.0238.97157720.20.001343715704560.221462945140.156464270398172.217.72.581.0748557848118.0148775182201.5797333030.001278084438793.5576.912124180269.1215283420819.59065252230.081979547735411747.7453553,DS862 - 10(40)A1158.0126.63146637.540.00124929568550.220563847430.17684882365287.02.560.5695651673059.54606829361104.2356334610.0007108386669673.662728731414.8334901199213.07621885130.103263198710790.4150224,DTSF188 - 10(40)A219.0666.534246575145971.00.001243617019950.5450796391060.474873172931278.132.9979838084650.2470302285350.0150140370.0023978393930119.279271384425.441733360351.17100474460.076771756301458111.2618868,DX904 - 1.5(6)A646.0210.939628483136267.00.001160942656130.2274566843040.173978955477148.725.553.120.94877884220215.9017934086174.2405722510.001278670347565.576.101355427938.0516039656719.72295939360.093500493650410966.5585577,SX129ZN-DK2三相四线 - 1.5(6)A23.04502.73913043103563.00.0008823171002250.4387012156850.3599176023972508.1210.723.5920.2527313129339.4413270752882.124058390.0278296694614.952130.240164125171.870371156307.0625352810.068194609189230211.7083456,DT864 - 15(60)A516.0198.666666667102512.00.0008733629827090.2748406040270.221031041226130.835.162.8950.89357666617614.9765898102154.7551664760.001509629765075.185.746364273667.5831427820518.50950705570.093168659676413107.4284574,DD2001-B - 2.5(10)A1140.063.3572219.00.0006152782235080.1752170481450.11853807973148.490.2849400090724.7756726399855.84061264910.0007732122107621.832376728542.418081016325.720457744860.09029925406262039.37975094,DT862(B) - 2.5(10)A425.0169.89672205.80.0006151657645630.2922376041810.242549158666107.142.8660.76416997286912.8076981664128.6878681390.001782237273734.914182741476.484961205216.52914394670.097289776961610488.5698635,DSSY188 - 1.5(6)A95.0655.6362284.850.0005306430698220.6023519363060.53119298099238.4812.374.142.9489379344549.4250079392307.3639458740.004934810726425.7218.963869842725.025516286249.70938612890.075819267161228362.8834598,DD201-B - 5(20)A934.064.2960046.860.0005115762520670.2718929849120.21487473893243.050.2891680060494.8465350280150.47570303410.0008406052045691.859565901782.45396098725.783526888990.08995997649697500.73925188,DS862 - 1.5(6)A378.0123.03174603246506.00.0003962133103820.2354818733070.19282464936982.362.560.5533806918779.2748120500899.3081927420.002135384525483.558650486194.6961441118312.8347945980.1043209985394115.95078549,DDSI188计度 - 10(40)A200.0228.045600.00.0003884945373370.5114035087720.440160471345103.734.271.431.0255141605117.1878983728127.6434125330.002799197643271.976.59482074368.7028014478617.26762219150.075735185050316617.7930551,DS864(B) - 1.5(6)A281.0142.59074733140068.00.0003413640158340.2213379754420.1827616151995.985.870.64135451993710.7492775176116.5306320380.002908321654135.894.124387799755.4427147470315.45710254680.1084018622252979.44658179,DD862 - 1.5(6)A701.054.597717546438273.00.0003260713032350.2022560290540.14801473831339.970.7850.245573388054.1158772832146.51645067130.001215385537361.5792200012.0840048045.0632248050.09273693173532115.64749114,DSS188 - 10A126.0230.68253968329066.00.0002476311890840.4254441615630.359822797618119.731.0375798729317.3901230195147.6777028920.005080771447486.672412271438.805194475218.76760674660.08135685853148093.89098549,DTS188液晶 数码-RS485 - 20(80)A88.0322.89772727328415.00.0002420849183870.4099679746610.341791079407175.828.182.741.4523517180524.3418128121212.534164530.007479646824923.789.3397045170212.325064949225.44476946620.07880132722257472.85380832,DX863 - 1.5(6)A123.0189.57723577223318.00.0001986604302990.3739438202250.319116182843106.554.732.6560.85269359559214.2913783432129.0800719390.00553564078994.755.483455644687.2361975524617.46965319710.09215058509515292.38380828,DS904 - 1.5(6)A81.0286.4938271623206.00.000197706233190.4945479229510.436235680041129.016.163.45891.288611739721.597485902161.5149976420.006960053332836.188.2867343608410.935521464125.40225582490.08866597956658065.7024692,DX865 - 1.5(6)A154.0131.32467532520224.00.0001723007351560.2342642405060.19435810694988.162.570.59068120259.89997883034105.8006600330.005231440863975.253.798520583245.012686730514.06120731370.107072088921765.27242863,DD201-2 - 3(6)A302.062.003311258318725.00.0001595298292030.2564913217620.20031634467342.340.2788827793594.6741518100149.58303458940.00264795912361.793424224822.366677662245.630101887050.0908032453882050.63278412,DTF168 - 1.5(6)A23.0768.8717684.010.0001506609930530.4059463888560.336285795043436.677.834.393.4582766341757.961664131510.3099407650.0288571393467.8622.239297478729.34790767259.44720515060.07731762866374579.59564394,DSS(X)188液晶 - 1.5(6)A31.0561.61290322617410.00.0001483265327860.5795146467550.510742114281211.8913.54.522.5260613376542.3374802872274.7735416250.01578251244266.2416.244458000321.436866611143.92132461140.0782056900037530.45914668,DS864 - 1.5(6)A91.0153.35164835213955.00.0001188912558890.2529848799710.207923419292100.915.322.9860.68975564439611.5604936279121.4662492720.008704138249545.344.435643121125.853460295215.62910341630.1019167617981479.32290533,DTS188计度器 - 15(60)A48.0287.513800.00.0001175707152470.4732521739130.40481226387138.631.2931373734521.6733367639171.1164741370.01239974450278.3158375604610.973927264322.57976482480.07853831243394502.58052982,DX864 - 1.5(6)A70.0195.013650.00.000116292772690.2646666666670.208885842465131.374.692.630.87708447938414.7001762399154.2672607190.01130163082194.75.640307214927.4431854488217.78349266370.09119739827561606.44726319,DX864(B) - 1.5(6)A66.0197.7813053.480.0001112106507290.3480129436750.294674200937115.535.232.940.88958855555214.9097479832139.4993365390.01068675453135.255.720717748557.549298554218.52001630270.09363947973882624.20271246,DS862(B) - 1.5(6)A96.0131.2512600.00.0001073471747910.1804190476190.13962137360194.460.5903453226629.89434939222112.9246947150.008962277358323.796360625435.0098363597913.93619698520.106180548459421.354396791,DX863-B - 1.5(6)A61.0196.50819672111987.00.0001021246495410.3489330107620.296020507583114.45.282.960.88386815085114.8138724327138.3377405840.01154064741675.35.683931280817.5007535918518.48468487270.09406571929862420.83204717,DTSD188简易 - 30(100)A14.0751.57142857110522.08.96434105672e-050.5948355825890.523534212913279.423.3804699238456.6576023428358.0980722670.034033270506221.738942313328.687618055956.87656036920.07567685280074712.3551431,DD201-4 - 2.5(10)A123.066.08118.06.91622511865e-050.3027272727270.24511661169642.260.2968593622534.975444265849.82230362810.006137263319541.909027057362.519231998065.898259055420.08936756144581264.37078993,DX902 - 1.5(6)A28.0211.255915.05.03935348322e-050.2365491124260.182890576193147.125.523.0990.95017485266615.9251909265172.6143657790.02918247942175.546.110332816178.0634509028919.71378371910.0933196862441529.811814049,DTS(X)188计度 - 1.5(6)A4.0591.752367.02.01659335499e-050.4283903675540.355672167252321.769.183.072.6616140547544.6093809741381.2809950290.1610819581874.2417.116163048422.587205073543.94336812190.0742600221748666.102547397,DT862 - 1.5A5.0178.0890.07.58245917171e-060.2601179775280.205964926303120.02.5590.80062070425813.4186224138141.3382431180.1588070147395.148588124396.7942923584116.52288048280.0928251712517100.694381996,DS962 - 1.5(6)A5.0145.0725.06.17672235898e-060.1628965517240.120461439282107.50.65219102313210.9309002809127.5330913040.1759077121444.194074595715.5346763593815.15875095510.10454311003511.5407887042,DSSY188液晶 - 15(60)A1.0620.0620.05.28216256906e-060.57950.508842418148238.4812.374.142.7886788575346.7390218909304.5177007480.4911575818525.7217.933284478223.665512709147.31879718730.0763206406247268.163502064,DX903 - 1.5(6)A208.0416.03.5441606915e-060.2137980769230.160933919388149.175.63.140.9355567780115.6801879892174.5257447670.4195330403065.626.016327695927.9393978120819.5757255080.094114064942327.7970594496,919881.0120.941736279111252005.310.94782448093821816556.989,汇总989002.0118.681426114117376167.79,,返回目录,二、（1）应收帐款情况分析,一、应收帐款账龄结构分析（总体分析）1/1-4/30, 4月底应收款余额13592万，3月底余额12899万，05年12月底11365万，增加2227万。去年同期15061万. 4月份周转天数102天，3月份周转天数105天，年度目标94天。（05年底112天，去年同期153天。）,1-3个月4-6个月7-12个月1-2年2年以上,20年4月底9379.01320.01153.0907.0833.0,20年3月底6479.03599.01046.0961.0814.0,19年12月底6999.01200.01490.0943.0732.0,19年4月底3360.06782.01861.01534.01524.0,科目名称时间帐面金额帐 龄,1-3个月4-6个月7-12个月1-2年2年以上,应收帐款20年4月底13592.09379.00.6900382577991320.00.09711595055921153.00.0848293113596907.00.0667304296645833.00.061286050618,20年3月底12899.06479.00.5022869989923599.00.2790138770451046.00.0810915574851961.00.074501899372814.00.063105667106,19年12月底11364.06999.00.6158922914471200.00.1055966209081490.00.131115804294943.00.082981344597732.00.064413938754,19年4月底15061.03360.00.2230927561256782.00.4503021047741861.00.1235641723661534.00.1018524666361524.00.1011885001,,返回目录,二、（2）存货情况分析,（一）存货总体情况分析存货明细分析（公司本部和营销中心）, 20年4月底存货7634万元，3月底存货7107万元，上升527万（其中储备资金上升195万元，生产资金下降165万元，成品资金上升497万元.（19年12月底6648万元，19年4月底存货6212万元）。存货周转天数：20年4月底87天，目标75天。（20年3月底89天，2月底101天，1月底172天，19年4月底122天.）,时间存货储备资金生产资金成品资金,7634.02367.02341.02926.0,7107.02172.02506.02429.0,6647.02170.01737.02740.0,6211.812231.811572.02408.0,1、存货总体结构比重以及帐龄情况分析,一、存货总体结构帐龄情况分析,存货总体帐龄情况分析,科目名称时间金额帐 龄,1-3月4-6个月7-12个月12-18个月18个月以上,存货资金合计：7634.06847.00.896908566937510.00.0668063924548181.00.023709719675153.00.0069426250982443.00.00563269583442,7107.06450.00.907555930772431.00.060644435064159.00.022372308991153.00.0074574363303814.00.00196988884199,6647.06015.00.904919512562329.00.0494960132391153.00.0230179028133118.00.0177523694932.00.00481420189559,6211.815245.490.844438255517529.00.0851603638875235.00.037831163541732.00.00515147758866170.320.0274187394656,储备资金2367.01985.00.838614279679295.00.12463033375656.00.023658639628228.00.01182931981413.00.00126742712294,2172.01831.00.843001841621282.00.12983425414420.00.0092081031307637.00.01703499079190.000920810313076,2170.02044.00.94193548387137.00.017050691244220.00.0092165898617563.00.02903225806456.00.00276497695853,2231.811970.490.882911179715155.00.069450356437296.00.043014414309510.00.004480668157240.320.000143381381032,生产资金2341.02282.00.97479709525857.00.02434856898760.000854335753951,2506.02478.00.98882681564228.00.0111731843575,1737.01736.00.9994242947611.00.000575705238918,1572.01559.00.9917302798980.001272264631047.00.004452926208654.00.00254452926209,成品资金2926.02580.00.881749829118158.00.053998632946123.00.04203691045825.00.0085440874914640.00.0136705399863,2429.02141.00.881432688349121.00.0498147385755139.00.057225195553716.00.0065870728694912.00.00494030465212,2740.02235.00.815693430657291.00.106204379562133.00.048540145985455.00.020072992700726.00.00948905109489,2408.01716.00.712624584718372.00.154485049834132.00.054817275747518.00.00747508305648170.00.0705980066445,当月底存货明细分析表,公司：仪表公司（汇总）,分厂合计3个月内4-6个月7-12个月12-18个月18个月及以上,公司成品库19151764.906418403453.7953316915.0430413.888889982.222222222,办事处仓库10112571.58037391848.458541267234.83203796572.181253700.488908403215.619831,产成品小计29264336.486825795302.25391584149.832031226986.06989254682.71113403215.619831,仓库189593.989593.9,仓库233836.7733836.77,材料成本差异,1分厂原材料3850601.684813757362.4948193239.19,2分厂原材料11096498.19052042.262471470635.52895521279.10861923436.53572829104.664231,3分厂原材料8598023.346918182.062481382848.0282240245.6493256747.6,材料合计23668553.794819851017.48982946722.74717561524.757919280184.13572829104.664231,1分厂在产品7657156.176937088644.73438568511.442549,2分厂在产品13213665.388413213665.3884,3分厂在产品2536901.905232520892.1072316009.798,在产品23407723.470622823202.23568511.44254916009.798,合计76340613.752168469521.97375099384.021751804520.62581534866.846858432320.284062,,返回目录,二、（3）应付账款情况分析, 20年4月底应付款余额11899万元,3月底余额12273万，19年12月底应付帐款余额11898万，18年12月底应付帐款余额7800万.应付帐款周转天数20年4月底113天,3月底122天，2月底143天.20年度目标周转天数100天.,1、应付帐款帐龄结构比重,科目名称时间帐面金额帐 龄,1-3个月4-6个月7-12个月1-2年2年以上,应付帐款43922.011899.07249.00.6092108580554113.00.345659299101283.00.0237835112194188.00.015799647029266.00.00554668459534,43891.012272.577570.590.6168707939744323.490.352288884887169.490.013810473275151.00.012303861375458.00.00472598648857,19年12月底11898.376110384.84610.846183488871183.00.0963938278616202.00.016459470184394.00.0076593574125134.530.00281359161121,二、20年每月采购额与付款额对比,月份1月2月3月4月5月6月7月8月9月10月11月12月,采购额3194.01663.03819.03809.0,应付款余额11379.011351.012273.011899.0,,返回目录,三、（1）营业费用情况分析,（一）营业费用情况分析营业部门营业费用明细分析,营业费用率,项 目实际费用率 预算费用率 增减比率去年同期,累计费用率0.1568488127610.248816735564-0.009795457669920.169033750748,营业费用额分析,营业费用,项 目实际预算去年同期比去年同期增减数,累计营业费用2243.3449192690.113577371782.26907461.075849,,返回目录,三、（2）管理费用分析,一、管理费用总额分析点击链接：管理部门管理费用明细分析,管理费用率分析,本期,项 目实际费用率 预算费用率 增减比例去年同期,累计费用率0.05396979173410.04145063619440.01251915553960.0546477151399,管理费用,项 目实际预算去年同期比去年同期增减数,累计管理费用额771.90803448.148790975576.198138195.709892,,公司财务状况分析（明细）返回总括目录,一、现金流量明细分析,二、营销部门财务状况分析,（一）营销部门财务状况分析（总体）,1、主要经营指标完成情况,2、回款情况明细分析,3、销售情况分析,4、销量情况明细分析,5、营业部门费用分析,（二）办事处情况分析,三、管理部门财务状况分析,1、总体费用情况分析,2、部门费用分析,四、制造部门财务状况分析,1、生产情况分析,2、制造费用分析,3、产品成本控制分析,五、盈利能力分析,1、毛利率分析,六、资产负债管理能力分析,1、应收账款明细分析,2、存货结构明细分析,3、经营效率分析,4、偿债能力分析,七、税费金上交情况分析,,返回总括分析项目返回明细目录,二、销售情况分析,一、发货销售收入预算完成情况分析,（一）各办事处发货收入情况分析,1、当月发货销售收入对比图,合计,3571.6,4904.01629,4978.0373571,金额,2、累计发货销售收入对比图,12336.3222,16734.035209,12649.6028428,3、当月各办事处发货销售收入比重情况分析,4、各办事处累计发货销售收入比重情况分析,5、各办事处实际、预算、去年同期累计数对比折线图,当月发货销售收入累计,办事处去年同期实际比例预算完成比率06年度发货预算全年预算完成率比例完成比率06年度发货预算全年预算完成率,广州办973.01803.693680.163884790032996.50.80651648770720010.00.04016460169923275.70632401.162040.14348972082227.91.0777692176520010.00.0201802843578,成都办440.4369.20410.0141117190294132.6350.5217634862592700.00.02563114814811175.1379613.79610.0366795033197372.7331.646744720752700.00.227331888889,浙江办205.24212.85480.0434041788226284.80.7473834269664200.15840.0506778030086864.4163690.77910.0412798880469613.60341.125774563834200.15840.164465011605,北京办392.172028.42220.413624686389913.24285712.221120246643499.99999990.5795492000171005.61623746.47940.2238838004831394.85714282.685923371683499.99999991.07042268574,沈阳办102.7244.98440.0499558699468227.391.077375434283631.0750.0674688349869647.92131642.8051830.0981714907661626.22.623451266373631.0750.452429427373,武汉办87.7595.73330.0195214074218152.1950.629017379021801.4010.0531438030733761.5419238.57110.0142566390605339.8270.7020369187851801.4010.13243642032,长沙办142.68131.679350.0268513280163256.150.5140712473162218.6180.0593519704609641.80071009.834350.0603461351304656.8371.53742001442218.6180.455163687485,济南办307.33433.4640.0883895921969325.1221.333234908743300.320.131339991274773.15671535.02020.09173042728961089.4261.409017409173300.320.465112534542,昆明办56.47119.894730.0244482731928171.79550.6978921450211868.5720.0641638267083491.1166660.435550.0394666045429559.03081.181393851641868.5720.353443993595,兰州办147.5925.903090.00528201548857114.2610.2267010616051700.00.0152371117647572.8158403.807490.0241309095479172.0912.346476515331700.00.237533817647,郑州办170.1684.327040.0171955056862166.570.5062558684041981.1750.04256415511482.4353786.289340.04698743191221382.8170.5686141694821981.1750.396880305879,福州办50.8195.36750.0194468154999125.90.7574861000791600.00.0596046875309.6136446.4140.0266770085293477.7650.934379872951600.00.27900875,太原办26.83121.28230.024731218827297.391.245326008831802.7760.0672753020897238.6915410.8564760.0245521460227171.6442.393654750531802.7760.227902122061,贵阳办66.5629.50890.0060172924099386.30.3419339513331000.80.0294853117506231.872247.050.014763324979201.61.225446428571000.80.246852517986,重庆办39.23113.95030.0232361177577144.390.7891841540271704.330.0668592936814193.6071515.481330.0308043650896371.6851.386876871541704.330.302453943778,南宁办22.5327.0160.0055089539680187.090.3102078309791200.010.0225131457238154.7269407.28650.0243388097917337.431.207025160771200.010.339402588312,南昌办43.0237.10010.0075652481162554.720.677998903509520.820.0712340155908156.4594163.85860.00979193589314191.8350.854164255741520.820.314616566184,石家庄办61.3850.6620.010330716091586.090.5884771750491100.00120.0460563133931171.2546273.81730.0163628973275481.8450.5682684265691100.00120.248924546628,合肥办101.6786.92450.0177251654276112.4210.7732051840851300.0030.0668648456965210.9203314.257550.0187795439698327.32650.9600736573421300.0030.241736019071,上海办134.0456.2440.0114689667966363.00.154942148763618.00.0155456053068-22.488297.10360.00580276058866493.00.1969647058823618.00.0268390270868,零售7,出口部35.80.007300138882780.0750.447080861692800.750.0447080861692128.930.00770465690969160.150.805057758352800.750.16101155167,合计3571.64904.016290.9926998611174978.03735710.98513047175261558.80959990.079663923358412336.322216734.0352091.012649.60284281.3228901663561558.80959990.271838187219,,返回总括分析项目返回明细目录,二、销量情况分析,一、八大类产品发货销售情况分析,八大类产品发货销量统计表（包括当月销售情况数据）,各类电表累计发货量比重图,名次型号本期销售情况累计销售情况,去年同期本期预算去年同期累计本期累计预算累计,产品系列1DD202106273.00.3233189531911100.2464489.00.211107110122643.38126450.00.2581149545421284.206368822.00.3293697606944133.6339308613.00.2339091885453044.19313840.00.2493166116013146.498,2.0DD20161494.00.187085861014404.5941255.00.135049757758269.6355930.00.11416662244360.46234394.00.209321286931533.7404208326.00.1578979680471352.06170040.00.1350809222431100.43,3.0DD862-B23458.00.0713672899414126.519761.00.031952992012656.2327516.00.056166793904145.77483412.00.0744895653704448.991755384.00.0419775787099309.4269726.00.0553908044242372.0723,4.0DT86228782.00.0875647258544492.8622644.00.0741259656933480.7517763.00.0362585681101299.307575891.00.06777307348491345.253983560.00.0633332095371627.3745233.00.0359334001165755.095,5.0其他单相表1070.00.0032553073679533.9210000.00.020412412379763.0-719.0-0.000642089837209122.629286.00.0002167699608371.4818000.00.0142993213383113.4,6.0其他三相表1109.00.0033739587579995.951000.00.0020412412379783.51436.00.0012823936108999.725617.01.28849277421e-051.771000.00.00079440674101883.5,7.0产品系列2单相电子表97119.00.295469342306673.74142327.00.465912662041146.81238777.00.4874014590791726.917326622.00.2916838203182838.4792598312.00.4534827580724759.29609215.00.4839645027294519.2374,8.0三相电子表9389.00.0285645615679643.7825004.00.0818515123742307.2312462.00.02543794830761014.872857129923.00.02672218942811814.308564873.00.04916964220075584.2631747.00.02522003080712559.3701428,合计328694.03571.59305480.04904.03489898.04978.03735711119781.012336.76221319371.016679.841258801.012649.6028428,,返回总括分析项目返回明细分析项目,3、回款情况明细分析,一、回款总体分析,（二）各办事处回款情况分析,1、回款总额情况对比柱图,（1）当月回款总额对比情况,（2）累计回款总额对比情况,9023.57696,实际15765.064224,预算10733.0,合计,2、各办事处回款情况对比折线图,（1）当月各办事处回款情况对比折线图,本期实际本期预算,198.7943107.1089,112.5504167.709235.0,724.67263867.42352600.0,172.2309196.34885120.0,131.25844919.17624,449.7168169.82803,123.34682210.6596,59.7592323.5936,147.8162204.374750.0,165.38414263.8872266.0,11.62624.9606,119.4434911309.552,12.92354106.225607,97.00872138.3652,61.186196.027886.0,74.361756160.23,39.9412157.7842,37.48125.55607580.0,23.753513.648960.0,海口,2.92155.149,16.55863.5322185.0,（2）各办事处累计回款情况对比折线图,去年同期累计本期实际累计本期预算累计,983.5933251.94104460.0,754.13281860.1213990.0,1314.582252048.5653412230.0,577.4527672.98425340.0,564.768021644.50934950.0,875.359425656.200635300.0,482.67959635.428445370.0,579.50111782.6483,481.71459703.18308,508.581221180.74986766.0,132.60503187.342330.0,357.8348911610.2863,249.575938624.768935510.0,290.514195.8035380.0,251.60645384.01955357.0,243.962996550.68406,171.9666389.66915,92.293792.326375180.0,77.16066151.29174,6.10655.239,17.315647.1839560.0,电力产品出口部40.118123,3、各办事处回款比重图,（1）当月各办事处回款比重图,（2）各办事处回款比重图,4、回款（与预算比较、与去年同期比较),当月回款额回款额累计,本期实际本期预算预算完成率全年预算本期全年预算完成率去年同期累计本期实际累计本期预算累计预算完成率全年预算本期全年预算完成率,198.7943107.10890.7140593333331770.00.0605135028249983.5933251.94104460.00.5476979130431770.00.142339570621,112.5504167.709235.00.7136553191494200.00.0399307142857754.13281860.1213990.01.878910404044200.00.44288602381,724.67263867.42352600.01.4457058666720030.00.0433062166751314.582252048.5653412230.00.91863916636820030.00.102274854768,172.2309196.34885120.01.636240416672200.00.0892494772727577.4527672.98425340.01.979365441182200.00.305901931818,131.25844919.176242.626217828573500.00.262621782857564.768021644.50934950.01.731062463163500.00.469859811429,449.7168169.828031.69828032500.00.067931212875.359425656.200635300.02.187335452500.00.262480254,123.34682210.65961.31662250.117033111111482.67959635.428445370.01.717374175680.353015802778,59.7592323.59363.2359363650.00.0886557808219579.50111782.64833.56529663650.00.488396794521,147.8162204.374750.04.0874940.1135415481.71459703.183084.68788720.390657266667,165.38414263.8872266.00.9920571428573300.00.0799658181818508.581221180.74986766.01.541448903393300.00.357802987879,11.62624.96060.1664041300.00.0192004615385132.60503187.342330.00.5677030303031300.00.144109230769,119.4434911309.5528.730346666672100.00.623596190476357.8348911610.28633.22057262100.00.766803,12.92354106.2256070.7081707133331710.00.0621202380117249.575938624.768935510.01.225037127451710.00.365361950292,97.00872138.36521.3836521000.00.1383652290.514195.8035380.00.5152723684211000.00.1958035,61.186196.027886.02.279393023261200.00.1633565251.60645384.01955357.01.075685014011200.00.320016291667,74.361756160.231.60231600.00.10014375243.962996550.684061.573383028571600.00.3441775375,39.9412157.78421.5778421700.00.0928142352941171.9666389.669151.113340428571700.00.229217147059,37.48125.55607580.00.31945093750.0511121592.293792.326375180.00.5129243055560.18465275,23.753513.648960.00.2274816666671100.00.012408090909177.16066151.291740.9455733751100.00.137537945455,海口10.2701,2.92155.1496.10655.239,16.55863.5322185.00.0190929729733330.00.0010607207207217.315647.1839560.00.08425696428573330.00.0141693393393,电力产品出口部800.7540.118123800.750.0501006843584,合计2782.7346375621.1412223292.01.7075155595461090.750.09201296795349023.5769615765.06422410733.01.4688404196461090.750.258059759031,,返回总括分析项目返回明细分析项目,五、营业费用分析,一、营业费用总额分析,营业费用率分析,营业费用率,项 目实际费用率 预算费用率 增减比率,累计费用率0.1568488127610.248816735564-0.09196792280290.169033750748,年度预算费用率18.30%,营业费用额分析,营业费用,项 目实际比去年同期增减数,累计营业费用2243.3449192690.113577371782.26907461.075849,二、营业费用明细情况分析,1、各项费用比重图, 营业费用明细表,当月累计,营业费用明细科目实际费用增减金额实际费用增减金额,薪金-管理人员61.03716753.75132948727.2858375128348.12623192.707167201.780317949-9.07315094868154.941893,社会保险费8.5216368.4256930.09594331.17163633.702772-2.531136,材料、零配件领用0.1162790.221945333333-0.1056663333339.34821.8622792.63378133333-0.77150233333315.806705,办公、邮寄费1.6743.6649-1.99093.2965059.17414.6596-5.485614.132224,差旅费9.043417.587-8.543629.9191259.933470.348-10.414664.47066,电话费2.6978089.223-6.525192-3.13440910.78780836.892-26.1041928.897779,汽车费3.80997.338333-3.5284336.99748134.149929.3533324.79656830.890415,业务招待费60.237244.5815.657261.706861225.8372175.3450.4972259.137207,会务费2.713310.152-7.43877.062.713340.608-37.89477.06,维修费0.011.18-1.170.0775.045-4.9685.49587,运杂费18.668345.919-27.250717.300306131.1783182.41-51.2317135.267672,水电气费0.19751.3316-1.13410.71755.6788-4.9613,租赁费3.391112.51698-9.125885.152634.851152.30392-17.4528229.2176,广告、宣传、展览费0.014.121-4.1115.468216.164-10.695816.1,计量测试费4.005-4.0050.3114.12-13.81,基础业务费391.809259258.44395213133.36530687157.80567804.389259641.149558631163.239700369596.449315,业务员分成119.3522210.452655402-91.1004554019104.035108396.6022565.753015522-169.150815522344.866564,其他费用18.86167164.666292269-145.80462226944.162485301.41467602.171479935-300.75680993599.535166,合 计702.150719857.580680621-155.429961621491.7761572243.3449192690.11357737-446.7686583711782.26907,,返回总括分析项目返回明细分析项目,六、管理费用分析,一、管理费用总额分析,管理费用率分析,本期,项 目实际费用率 预算费用率 增减比例,累计费用率0.05396979173410.04145063619440.01251915553960.0546477151399,管理费用额分析,管理费用,项 目比去年同期增减数,累计管理费用额771.90803448.148790975576.198138195.709892,二、管理费用明细情况分析, 管理费用明细表,当月费用累计费用,管理费用明细科目增减金额增减百分比增减金额增减百分比,工资51.59276746.25277456.3939333333-4.80116633333-0.0851362203263201.26843185.67144225.575733333-24.3073033333-0.107756729743,社会保险费7.48286351.9616444.7276362.7552270.58279169546926.679915127.24843418.9105447.7693710.410848624979,折旧费-34.51298716.59672714.0938803871-48.6068673871-3.4487923873450.44786866.38738356.3755215483-5.92765354833-0.105145875116,辅助材料消耗-22.40447813.71347312.225039-34.629517-2.8326712904630.56416434.35409751.288656-20.724492-0.404075552301,办公费-1.7673050.9439210.835-2.602305-3.116532934134.7503185.760723.341.4103180.422250898204,差旅费5.62779.22855.073223333330.5544766666670.10929474817818.65719.09987820.2928933333-1.63589333333-0.0806141000429,电话通讯费2.2340321.8304351.60.6340320.396278.3222836.1204876.41.9222830.30035671875,空调费0.587273.024320.58720.2452.7793211.3441632653,汽车费-1.72770.46180.6486999-2.3763999-3.663327063872.08871.016462.5947996-0.5060996-0.195043809934,业务招待费5.26281.51292.40242.86041.190642690648.8825098.80929.4896-0.607091-0.0639743508683,会务费0.91620.8816666666670.03453333333330.0391682419660.91620.83.52666666667-2.61046666667-0.740207939509,维修费2.63330.0990.2512.38239.491235059764.0963752.9270411.0043.0923753.08005478088,计量、测试、认证费23.00749.36440.91522.092424.144699453661.792833.87046.41255.38088.6370555209,水电气费2.17563.05782.265-0.0894-0.03947019867558.00196.6225249.09-1.0881-0.119702970297,无形资产摊销0.631083-0.6310831.8932491.8932492.524332-0.631083-0.25,税金0.93660.8914241.02113586812-0.0845358681231-0.0827861117822.9352722.1169492.594790326730.3404816732720.131217412738,广告、宣传、制作费0.050.1362860.1664-0.1164-0.6995192307693.08350.1362860.58758752.49591254.24772906163,咨询、培训、教育费0.141.51241666667-1.512416666670.4136750.66.64966666667-6.23599166667-0.937790114793,诉讼费1.55-1.556.2-6.2,其他1.2573880.624613.38475-2.127362-0.62851377502334.08955272.1763915.047319.04255221.2030671895,合计42.76418157.402894110.578264155-67.8140841552-0.613267758119771.90803576.198138448.148790975323.7592390250.722436935109,1、各项管理费用结构组成,,返回总括分析项目返回明细分析项目,八、财务费用分析,一、财务费用总额分析,项 目实际费用率 预算费用率 增减比例,累计数费用率0.007295529294780.00501970976820.0084-0.0033802902318,累计财务费用额分析,项 目实际预算比去年同期增减数,财务费用总额90.084.0147.48-6.0,利息支出89.083.0142.8-6.0,二、财务费用明细分析,（2）财务费用明细表,3月份截止3月底累计,财务费用明细科目实际费用 预算费用实际费用 预算费用,利息支出6.560.0722.0541.34109.9356.17,工本、手续费0.10.20.320.260.40.43,利息收入-0.1-0.1,合计6.560.2722.3741.5110.3356.6,,返回目录,三、生产情况分析 ,（一）总体生产情况分析,一、两大类电表产量情况对比分析,2、两大类电表累计产量情况对比分析,3、电表产量汇总表,类型机械表当月产量机械表累计产量电子表当月产量电子表累计产量当月产量累计产量,预算238159.0
  • 财务预算管理系统（经营业绩分析-表格模板
  • 财务预算管理系统（经营业绩分析-表格模板
  • 财务预算管理系统（经营业绩分析-表格模板
模板介绍：
这个模板还没有相关介绍

关注稻壳领福利

相关推荐 查看更多
财务记账管理系统.xls
财务记账管理系统.xls

财务记账管理系统

财务三大报表管理系统.xls
财务三大报表管理系统.xls

财务三大报表管理系统

理财管理系统.xls
理财管理系统.xls

理财管理系统

财务会计系统-收支管理系统.xlsx
财务会计系统-收支管理系统.xlsx

财务会计系统-收支管理系统

财务收支记账管理系统.xlsx
财务收支记账管理系统.xlsx

财务收支记账管理系统

财务报销管理系统.xlsx
财务报销管理系统.xlsx

财务报销管理系统

财务账簿管理系统.xls
财务账簿管理系统.xls

财务账簿管理系统

财务收支管理系统（带组合查询分析）.et
财务收支管理系统（带组合查询分析）.et

财务收支管理系统（带组合查询分析）

财务销售系统-业绩管理.xlsx
财务销售系统-业绩管理.xlsx

财务销售系统-业绩管理

财务收支管理系统.xls
财务收支管理系统.xls

财务收支管理系统

财务费用年度支出记账管理系统.xlsx
财务费用年度支出记账管理系统.xlsx

财务费用年度支出记账管理系统

财务收支管理系统.xlsx
财务收支管理系统.xlsx

财务收支管理系统

模板单价：￥29.99
开通会员可免费下载任意模板与19项权益包
登录后使用
以29.99元购买此模板
  • 页数：23页
  • 时间：2019-11-27
  • 编号：20203222
  • 类型：VIP模板
  • 格式：et
  • 提示：数字产品不支持退货
    数字产品本身（包括但不限于文字模板、表格模板、演示模板等）及其包含的全部素材 （包括但不限于字体、图片、图标、文本框、艺术字等）均不支持商用，仅能为个人学习、研究或欣赏目的使用。

Office办公之家

设计作品1462 独家高品质原创文档

举报

猜你在找

    我的

    关注稻壳领福利

    福利

    反馈

    微信咨询在线客服

    客服