教你做报表.xls

幕幕墙墙公公司司产产值值收收款款统统计计表表（1010年年4 4月月） 填报单位：武汉弘毅鸿幕墙工程有限公司 序号工程名称合同金额（预）决算金额 09年完 工比例 10年完 工比例 1顶琇晶城1、3#裙楼6,784,530.006,784,530.0015.0%100.0% 2航天首府2,830,000.002,830,000.0020.0%100.0% 3复地东湖国际二期4,777,383.244,777,383.2460.0%100.0% 4正远电气幕墙2,940,000.002,940,000.0085.0%100.0% 5中国家俱CBD6,400,000.006,400,000.0080.0%100.0% 6红安小别墅-吴建华2,550,000.002,550,000.0088.0%100.0% 7马应龙中试基地大楼1,434,104.001,434,104.0094.0%100.0% 8水墨清华二期别墅2,550,000.002,550,000.0020.0%100.0% 9轻轨二期12,000,000.0012,000,000.0080.0%100.0% 10铁桥大酒店3,927,500.003,927,500.0085.0%100.0% 11百瑞景石材幕墙3,927,500.003,927,500.0075.0%100.0% 12湖锦酒楼正银店改造外装饰幕墙工程4,147,355.384,147,355.3835.0%100.0% 13公安局江岸分局幕墙设计合同1,080,000.001,650,000.0050.0%100.0% 14铁客运太原南站站点幕墙装饰工程121,682,189.00121,682,189.0035% 15大冶市应急指挥中心外装饰幕墙工程1,019,920.001,019,920.00100% 16 中国建五局第三分公司温州分公司石材 幕墙装饰工程 41,100,000.0041,000,000.00100% 17新建太原站幕墙工程6,001,204.006,001,204.00100% 18联盛商业广场A地块幕墙工程施工26,600,000.0026,600,000.00100% 19大可阳光水岸叁号楼幕墙安装工程1,697,500.001,697,500.00100% 20大可阳光水岸壹号楼幕墙安装工程1,901,700.001,901,700.00100% 21半岛酒店幕墙更换工程施工合同2,740,628.752,760,628.75100% 22武汉凯迪电力蕲春站5,417,400.005,417,400.00100% 23 欧亚达国际建材家居摩尔城营销中心外 墙立面装修幕墙工程 3,667,000.003,667,000.00100% 24武汉爱佳置业有限公司4,404,872.404,404,872.401000% 25 武汉青莲物业管理有限公司香港青年路 青莲大厦外墙装饰工程 4,260,000.004,260,000.0090% 26华中国电大厦屋顶工程2,016,524.002,016,524.00100% 27F3区天母工程3,898,000.003,898,000.00100% 28宝业徐东苑1、2号楼裙楼石材幕墙工程4,080,000.004,080,000.001000% 29 武汉新国电投资发展有限公司屋顶幕墙 工程 3,093,809.333,093,809.33100% 30卓尔总部基地三期幕墙工程施工6,462,212.006,462,212.00100% 31上海商贸城家居生活广场外墙装饰工程16,807,882.6416,807,882.6475% 32 郑州日产汽车有限公司第二工厂办公楼 及食堂幕墙设计施工工程 6,623,000.006,623,000.0065% 33 武汉市汉口北国际商品交易中心F3区天 幕工程 998,000.00998,000.00100% 34 孝感十五军南大门幕墙、招待所钢结构 、幕墙及室内干挂石材等工程 4,535,000.004,535,000.0070% 35 华中电力宾馆东楼幕墙改造工程设计合 同 150,000.00150,000.00100% 36 武汉市欧亚达徐东家具博览中心有限公 司扩建工程项目 2,500,000.002,500,000.00100% 37 武汉市欧亚达徐东家具博览中心有限公 司外立面幕墙装修项目 4,700,000.004,700,000.00100% 38新建成都东客幕墙工程设计合同877,996.9087,996.90100% 其他4,101,281.07100% 合计336,384,492.71 工程收入工程成本工程毛利 5,766,850.504,651,541.611,115,308.89 2,264,000.001,826,142.40437,857.60 1,910,953.301,541,374.93369,578.37 441,000.00355,710.6085,289.40 1,280,000.001,032,448.00247,552.00 305,000.00246,013.0058,987.00 86,046.2469,404.9016,641.34 2,040,000.001,645,464.00394,536.00 2,400,000.001,935,840.00464,160.00 589,125.00475,188.23113,936.78 981,875.00791,980.38189,894.63 2,695,781.002,177,996.80517,784.19 825,000.00665,445.00159,555.00 42,588,766.1535,072,700.707,516,065.45 1,019,920.00839,924.52179,995.48 41,000,000.0033,296,100.007,703,900.00 6,001,204.004,929,388.001,071,815.03 26,600,000.0021,250,740.005,349,260.00 1,697,500.001,446,779.25250,720.75 1,901,700.001,500,441.30401,258.70 2,740,628.752,224,020.23516,608.52 5,417,400.004,462,014.42955,385.58 3,667,000.002,920,765.50746,234.50 4,404,872.403,632,698.27772,174.13 3,834,000.003,114,358.20719,641.80 2,016,524.001,635,400.96381,123.03 3,898,000.003,204,545.80693,454.20 4,080,000.003,310,512.00769,488.00 3,093,809.332,471,953.65621,855.68 6,462,212.005,324,862.691,137,349.31 12,605,911.9810,223,394.622,382,517.36 4,304,950.003,545,212.42759,737.58 998,000.00821,872.96176,127.04 3,174,500.002,614,264.24560,235.76 150,000.00123,528.0026,472.00 2,500,000.002,058,800.00441,200.00 4,700,