年收支预算表模板.xls

年年收收支支预预算算表表通通力力电电讯讯器器材材有有限限公公司司财财年年始始于于：2012年1月2012/01%2012/02%2012/03%2012/04%2012/05%2012/06%2012/07%2012/08%2012/09%2012/10%2012/11%2012/12%年年 度度%销销售售收收入入阿尔卡特OT715233,00013.3246,50013.2256,21513.8226,98013.8228,00013.6245,68213.8268,71213.3269,26513.9286,98213.4256,98213.4236,98713.8256,87913.23,012,18413.5西门子8008238,60013.6253,31213.6259,20014.0229,66614.0231,68213.8248,36914.0275,69713.6271,91814.0292,96813.7262,66413.7239,62114.0263,86113.63,067,55813.8飞利浦826244,20014.0260,12413.9262,18514.1232,35214.1235,36414.1251,05614.1282,68213.9274,57114.1298,95414.0268,34614.0242,25514.1270,84313.93,122,93214.0摩托罗拉V70249,80014.3266,93614.3265,17014.3235,03814.3239,04614.3253,74314.3289,66714.3277,22414.3304,94014.3274,02814.3244,88914.3277,82514.33,178,30614.3松下GD88255,40014.6273,74814.7268,15514.4237,72414.4242,72814.5256,43014.4296,65214.6279,87714.4310,92614.6279,71014.6247,52314.4284,80714.63,233,68014.5诺基亚3650261,00014.9280,56015.0271,14014.6240,41014.6246,41014.7259,11714.6303,63715.0282,53014.6316,91214.8285,39214.9250,15714.6291,78915.03,289,05414.8NEC N700266,60015.2287,37215.4274,12514.8243,09614.8250,09214.9261,80414.7310,62215.3285,18314.7322,89815.1291,07415.2252,79114.7298,77115.43,344,42815.0销销售售收收入入合合计计1,748,600 100.01,868,552 100.01,856,190 100.01,645,266 100.01,673,322 100.01,776,201 100.02,027,669 100.01,940,568 100.02,134,580 100.01,918,196 100.01,714,223 100.01,944,775 100.022,248,142 100.0销销售售成成本本阿尔卡特OT7151,0000.41,1200.51,1300.47800.38200.41,1000.41,3000.51,1200.41,5000.51,1100.48200.31,2000.513,0000.4西门子80081,1210.51,1780.51,1990.58280.48760.41,1580.51,3560.51,1780.41,5560.51,1680.48760.41,2560.513,7500.4飞利浦8261,2420.51,2360.51,2680.58760.49320.41,2160.51,4120.51,2360.51,6120.51,2260.59320.41,3120.514,5000.5摩托罗拉V701,3630.51,2940.51,3370.59240.49880.41,2740.51,4680.51,2940.51,6680.51,2840.59880.41,3680.515,2500.5松下GD881,4840.61,3520.51,4060.59720.41,0440.41,3320.51,5240.51,3520.51,7240.61,3420.51,0440.41,4240.516,0000.5诺基亚36501,6050.61,4100.51,4750.51,0200.41,1000.41,3900.51,5800.51,4100.51,7800.61,4000.51,1000.41,4800.516,7500.5NEC N7001,7260.61,4680.51,5440.61,0680.41,1560.51,4480.61,6360.51,4680.51,8360.61,4580.51,1560.51,5360.517,5000.5销销售售成成本本合合计计9,5410.59,0580.59,3590.56,4680.46,9160.48,9180.510,2760.59,0580.511,6760.58,9880.56,9160.49,5760.5106,7500.5毛毛利利1,739,05999.51,859,49499.51,846,83199.51,638,79899.61,666,40699.61,767,28399.52,017,39399.51,931,51099.52,122,90499.51,909,20899.51,707,30799.61,935,19999.522,141,39299.5费费用用工资40,0002.340,0002.140,0002.240,0002.440,0002.440,0002.340,0002.040,0002.140,0001.940,0002.140,0002.340,0002.1480,0002.2津贴0.00.00.00.00.00.00.00.00.00.00.00.00.0劳务费0.00.00.00.00.00.00.00.00.00.00.00.00.0补助0.00.00.00.00.00.00.00.00.00.00.00.00.0维修0.00.00.00.00.00.00.00.00.00.00.00.00.0广告600,00034.3600,00032.1600,00032.3600,00036.5600,00035.9600,00033.8600,00029.6600,00030.9600,00028.1600,00031.3600,00035.0600,00030.97,200,00032.4运输0.00.00.00.00.00.00.00.00.00.00.00.00.0审计0.00.00.00.00.00.00.00.00.00.00.00.00.0租金1,000,00057.21,000,00053.51,000,00053.91,000,00060.81,000,00059.81,000,00056.31,000,00049.31,000,00051.51,000,00046.81,000,00052.11,000,00058.31,000,00051.412,000,00053.9电话[phone].00.00.00.00.00.0保险0.00.00.00.00.00.00.00.00.00.00.00.00.0税金0.00.00.00.00.00.00.00.00.00.00.00.00.0利息0.00.00.00.00.00.00.00.00.00.00.00.00.0折旧0.00.00.00.00.00.00.00.00.00.00.00.00.0费费用用合合计计1,640,00093.81,640,00087.81,640,00088.41,640,00099.71,640,00098.01,640,00092.31,640,00080.91,640,00084.51,640,00076.81,640,00085.51,640,00095.71,640,00084.319,680,00088.5纯纯利利99,0595.7219,49411.7206,83111.1-1,202-0.126,4061.6127,2837.2377,39318.6291,51015.0482,90422.6269,20814.067,3073.9295,19915.22,461,39211.1