60全面财务预算管理系统.xlsx

利利润润预预算算表表收收入入预预算算表表销销售售及及管管理理费费用用预预算算全全部部税税金金预预算算表表成成本本预预算算表表营营业业税税金金及及附附加加预预算算全全面面财财务务预预算算管管理理系系统统销销售售费费用用预预算算（销销1销销售售费费用用预预算算（销销2外外购购存存货货进进销销存存人人员员预预算算表表销销售售费费用用预预算算（销销3管管理理费费用用预预算算内内购购存存货货进进销销存存固固定定资资产产变变动动预预算算融融资资预预算算表表制制造造费费用用预预算算表表固固定定资资产产购购置置预预算算采采购购资资金金预预算算全全面面财财务务预预算算管管理理系系统统利利润润预预算算表表项 目1月2月3月4月5月6月一、营业收入 2,846,697.00#减：营业成本2,164,036.40#营业税金及附加 8,431.285,890.287,820.316,507.497,131.825,927.24主营业务利润（亏损以“-”号填列）674,229.32 657,737.92 659,257.69 682,025.71 640,770.48 647,198.66 减：销售费用143,217.00129,154.00140,325.00132,908.00128,197.00140,414.00 管理费用230,071.00235,196.00223,049.00254,230.00248,938.00240,367.00 财务费用895.70826.80848.90769.60382.20405.60二、营业利润（亏损以“-”号填列）530,116.62 527,757.12 518,083.79 548,348.11 512,191.28 506,379.06加：营业外收入16,000.00减：营业外支出35.50三、利润总额（亏损总额以“-”号填列）530,116.62 527,757.12 518,083.79 548,312.61 528,191.28 506,379.06减：所得税费用 95,629.08116,635.80172,934.7859,547.2239,584.9546,101.10四、净利润（净亏损以“-”号填列）434,487.54 411,121.32 345,149.02 488,765.38 488,606.33 460,277.967月8月9月10月11月12月合计#33,432,874.40#25,399,933.605,828.516,232.527,734.146,412.127,933.907,351.2283,200.81676,340.29 661,200.48 667,904.46 663,820.48 669,325.10 649,929.38 7,949,739.99140,133.00136,006.00131,459.00145,711.00136,415.00150,963.001,654,902.00267,828.00211,413.00243,834.00244,892.00248,674.00255,471.002,903,963.00666.90434.20622.70503.10678.60835.907,870.20535,540.39 524,760.28 535,822.76 517,606.38 532,231.50 498,130.48 6,286,967.79100,000.00116,000.00250.58286.08535,540.39 624,760.28 535,572.18 517,606.38 532,231.50 498,130.48 6,402,681.71114,517.78186,265.45107,421.18141,808.7362,248.85173,419.031,316,113.93421,022.62 438,494.83 428,151.00 375,797.66 469,982.65 324,711.46 5,086,567.78利利润润预预算算表表收收入入预预算算表表项 目1月2月3月4月5月6月7月一、营业收入 2,846,697.002,752,711.002,774,047.602,857,962.602,709,013.902,745,447.702,835,686.40A产品收入796,638.00796,514.00811,626.50816,323.00785,121.50778,689.00801,722.00 销售数量51,396.0051,388.0052,363.0052,666.0050,653.0050,238.0051,724.00 销售单价15.5015.5015.5015.5015.5015.5015.50B产品收入1,334,676.201,272,235.801,309,705.101,321,267.201,288,984.401,331,969.101,320,862.40 销售数量52,754.0050,286.0051,767.0052,224.0050,948.0052,647.0052,208.00 销售单价25.3025.3025.3025.3025.3025.3025.30C产品收入430,112.80419,671.20417,716.00431,532.40430,248.00431,459.60420,992.00 销售数量82,714.0080,706.0080,330.0082,987.0082,740.0082,973.0080,960.00 销售单价5.205.205.205.205.205.205.20D产品收入285,270.00264,290.00235,000.00288,840.00204,660.00203,330.00292,110.00 销售数量28,527.0026,429.0023,500.0028,884.0020,466.0020,333.0029,211.00 销售单价10.0010.0010.0010.0010.0010.0010.008月9月10月11月12月合计2,770,137.802,821,810.002,770,836.002,823,692.402,724,832.0033,432,874.40796,405.50775,387.50816,168.00790,283.00818,663.509,583,541.5051,381.0050,025.0052,656.0050,986.0052,817.00618,293.0015.5015.5015.5015.5015.50186.001,281,571.501,320,786.501,271,274.401,324,657.401,271,805.70 15,649,795.7050,655.0052,205.0050,248.0052,358.0050,269.00618,569.0025.3025.3025.3025.3025.30303.60420,960.80428,766.00420,123.60424,502.00422,442.805,098,527.2080,954.0082,455.0080,793.0081,635.0081,239.00980,486.005.205.205.205.205.2062.40271,200.00296,870.00263,270.00284,250.00211,920.003,101,010.0027,120.0029,687.0026,327.0028,425.0021,192.00310,101.0010.0010.0010.0010.0010.00120.00成成本本预预算算表表项 目1月2月3月4月5月6月7月一、营业成本2,164,036.402,089,082.802,106,969.602,169,429.402,061,111.602,092,321.802,153,517.60A产品成本 513,960.00513,880.00523,630.00526,660.00506,530.00502,380.00517,240.00 销售数量51,396.0051,388.0052,363.0052,666.0050,653.0050,238.0051,724.00 销售单价10.0010.0010.0010.0010.0010.0010.00B产品成本 1,097,283.201,045,948.801,076,753.601,086,259.201,059,718.401,095,057.601,085,926.40 销售数量52,754.0050,286.0051,767.0052,224.0050,948.0052,647.0052,208.00 销售单价20.8020.8020.8020.8020.8020.8020.80C产品成本 347,398.80338,965.20337,386.00348,545.40347,508.00348,486.60340,032.00 销售数量82,714.0080,706.0080,330.0082,987.0082,740.0082,973.0080,960.00 销售单价4.204.204.204.204.204.204.20D产品成本 205,394.40190,288.80169,200.00207,964.80147,355.20146,397.60210,319.20 销售数量28,527.0026,429.0023,500.0028,884.0020,466.0020,333.0029,211.00 销售单价7.207.207.207.207.207.207.208月9月10月11月12月合计2,102,704.802,146,171.402,100,603.402,146,433.402,067,551.4025,399,933.60513,810.00500,250.00526,560.00509,860.00528,170.006,182,930.0051,381.0050,025.0052,656.0050,986.0052,817.00618,293.0010.0010.0010.0010.0010.001,053,624.001,085,864.001,045,158.401,089,046.401,045,595.20 12,866,235.2050,655.0052,205.0050,248.0052,358.0050,269.00618,569.0020.8020.8020.8020.8020.80340,006.80346,311.00339,330.60342,867.00341,203.804,118,041.2080,954.0082,455.0080,793.0081,635.0081,239.00980,486.004.204.204.204.204.20195,264.00213,746.40189,554.40204,660.00152,582.402,232,727.2027,120.0029,687.0026,327.0028,425.0021,192.00310,101.007.207.207.207.207.20营营业业税税金金及及附附加加预预算算表表项 目1月2月3月4月5月销售收入2,846,697.002,752,711.002,774,047.602,857,962.602,709,013.90税负率2.96%2.14%2.82%2.28%2.63%增值税84,312.8258,902.7778,203.0565,074.9271,318.17营业税金及附加8,431.285,890.287,820.316,507.497,131.82 城市维护建设税4,215.642,945.143,910.153,253.753,565.91 教育费附加2,529.381,767.082,346.091,952.252,139.54 地方教育费附加1,686.261,178.061,564.061,301.501,426.366月7月8月9月10月11月12月2,745,447.702,835,686.402,770,137.802,821,810.002,770,836.002,823,692.402,724,832.002.16%2.06%2.25%2.74%2.31%2.81%2.70%59,272.3558,285.0962,325.1777,341.4064,121.1979,338.9773,512.155,927.245,828.516,232.527,734.146,412.127,933.907,351.222,963.622,914.253,116.263,867.073,206.063,966.953,675.611,778.171,748.551,869.762,320.241,923.642,380.172,205.361,185.451,165.701,246.501,546.831,282.421,586.781,470.24营营业业税税金金及及附附加加预预算算表表合计33,432,874.402.49%832,008.0783,200.8141,600.4024,960.2416,640.16税税金金预预算算表表项 目1月2月3月4月5月6月7月8月1支付增值税-销项税 进项税2营业税3城建税4教育费附加5企业所得税6房产税7.土地使用税8.车船使用税9印花税10.防洪保安费11.个人所得税12其他税种合 计-9月10月11月12月合计-销销售售费费用用预预算算表表序序号号项项目目20182018年年1 1月月2 2月月3 3月月1销售费用-印刷费5,612.005,719.005,357.002销售费用-人员工资53,255.0050,598.0055,661.003销售费用-差旅费14,962.007,779.009,040.004销售费用-交通费10,573.0012,709.006,527.005销售费用-业务招待费12,964.0010,942.009,042.006销售费用-公关费13,195.0010,479.0014,189.007销售费用-通讯费9,073.006,153.006,570.008销售费用-广告宣传费8,637.005,062.0013,628.009销售费用-网络通信费5,985.0010,760.008,456.0010销售费用-其他费用（包括日常办公费等）8,961.008,953.0011,855.00小计143,217.00129,154.00140,325.0011管理费用-快递费13,887.005,980.005,477.0012管理费用-差旅费（日常）7,798.008,762.0010,608.0013管理费用-人员工资59,150.0058,019.0050,644.0014管理费用-社会医疗保险公积金5,277.0010,911.005,832.0015管理费用-电话费6,622.006,276.0011,518.0016管理费用-通讯费9,227.008,874.009,669.0017管理费用-办公费12,452.009,718.005,078.0018管理费用-会务费13,746.0014,535.0010,939.0019管理费用-车辆费7,278.0010,031.006,581.0020管理费用-交通费6,338.008,482.0011,473.0021管理费用-房租租赁费12,395.006,791.0011,438.0022管理费用-水电、物业费14,131.0010,954.009,528.0023管理费用-标书费7,131.007,331.008,567.0024管理费用-业务招待费10,347.0013,486.0011,764.0025管理费用-公关费7,438.0013,082.0014,383.0026管理费用-广告宣传费7,013.0012,906.0011,286.0027管理费用-咨询服务费7,469.007,116.0011,377.0028管理费用-印花税8,827.007,937.005,422.0029管理费用-福利费8,455.008,947.006,407.0030管理费用-折旧费5,090.005,058.005,058.00小计230,071.00235,196.00223,049.00合合计计3 37 73 3,2 28 88 8.0 00 03 36 64 4,3 35 50 0.0 00 03 36 63 3,3 37 74 4.0 00 0销售收入（不含税）2,846,697.002,752,711.002,774,047.60费用率13.11%13.24%13.10%人数102.00103.00103.00人均费用3,659.693,537.383,527.90部门负责人:4 4月月5 5月月6 6月月7 7月月8 8月月9 9月月5,721.005,613.005,909.005,998.005,117.005,857.0050,496.0053,899.0055,323.0050,591.0051,394.0053,287.0011,417.008,423.0010,742.0012,045.0014,498.008,419.007,513.009,151.008,376.0011,976.0012,961.006,817.0011,120.006,355.0013,870.007,141.008,484.0014,275.0010,503.006,045.0012,839.0011,213.0012,980.005,342.006,155.005,231.005,978.005,433.005,546.007,365.005,407.0013,003.008,247.0011,515.007,251.007,412.0014,018.0013,599.008,421.0010,206.0011,371.0011,469.0010,558.006,878.0010,709.0014,015.006,404.0011,216.00132,908.00128,197.00140,414.00140,133.00136,006.00131,459.0014,233.0010,089.0011,721.009,544.0010,642.0012,643.0011,196.008,464.007,309.0014,741.0011,399.0014,390.0052,852.0055,569.0050,620.0052,519.0058,614.0051,599.005,299.0010,152.006,721.0014,828.0011,361.006,172.009,521.005,708.006,989.0014,756.0012,187.0010,264.009,432.0014,705.008,398.008,366.006,599.0014,159.0011,835.005,054.0013,408.0013,393.0014,275.006,907.0010,462.008,259.0012,288.0014,401.005,410.006,235.0012,965.0013,594.0011,115.0011,015.005,987.008,547.0013,635.009,698.0012,724.009,206.008,213.0013,697.0011,224.0014,300.006,368.008,241.007,605.0014,231.0010,809.0013,445.0010,209.008,302.009,409.009,281.0012,757.0012,236.0010,668.0014,466.006,045.009,877.0011,158.0012,002.0010,917.0011,985.005,299.006,394.006,005.0014,439.0010,438.008,901.006,083.0014,891.007,647.007,153.0014,827.0014,552.006,301.0014,734.009,750.0011,058.0011,100.0013,312.007,585.008,877.0014,717.008,504.0010,575.0012,105.006,122.009,280.0013,675.009,451.008,914.008,137.007,219.006,598.005,058.005,058.005,058.005,058.005,058.005,058.00254,230.00248,938.00240,367.00267,828.00211,413.00243,834.003 38 87 7,1 13 38 8.0 00 03 37 77 7,1 13 35 5.0 00 03 38 80 0,7 78 81 1.0 00 04 40 07 7,9 96 61 1.0 00 03 34 47 7,4 41 19 9.0 00 03 37 75 5,2 29 93 3.0 00 02,857,962.602,709,013.902,745,447.702,835,686.402,770,137.802,821,810.0013.55%13.92%13.87%14.39%12.54%13.30%98.00103.00100.00104.0098.00101.003,950.393,661.503,807.813,922.703,545.093,715.77 制表:销销售售费费用用预预算算表表20182018年年备备注注1010月月1111月月1212月月全全年年合合计计5,348.005,133.005,188.0066,572.0055,138.0058,469.0054,212.00642,323.005,570.007,286.0011,821.00122,002.0012,246.009,414.0013,955.00122,218.0013,926.006,411.0010,593.00125,123.0012,832.007,206.0013,315.00130,138.009,628.008,953.009,948.0086,033.0012,748.0010,631.005,144.00108,685.007,728.0011,872.0014,189.00128,074.0010,547.0011,040.0012,598.00123,734.00145,711.00136,415.00150,963.001,654,902.006,527.0014,665.0014,024.00129,432.0013,381.0011,536.005,394.00124,978.0054,786.0051,058.0056,841.00652,271.0012,498.006,621.0012,241.00107,913.009,554.006,725.0010,304.00110,424.0013,903.0014,849.0010,771.00128,952.009,394.006,173.0010,705.00118,392.0010,347.0013,046.0011,898.00131,566.0010,019.0011,525.009,743.00118,400.007,049.007,001.009,211.00116,727.0011,697.0014,673.0013,199.00132,162.0014,969.0014,872.009,736.00135,645.005,290.007,839.008,167.00110,374.0011,739.005,776.0014,880.00125,747.006,897.005,644.008,145.00116,346.007,496.0012,010.008,847.00124,772.0013,312.0011,668.0011,834.00124,458.0012,635.0013,102.0011,211.00120,437.008,341.0014,833.0013,262.00114,239.005,058.005,058.005,058.0060,728.00244,892.00248,674.00255,471.002,903,963.003 39 90 0,6 60 03 3.0 00 03 38 85 5,0 08 89 9.0 00 04 40 06 6,4 43 34 4.0 00 04,558,865.002,770,836.002,823,692.402,724,832.00-14.10%13.64%14.92%-102.00105.00102.00-3,829.443,667.513,984.65-销销售售一一部部费费用用预预算算表表序序号号项项目目20182018年年1 1月月2 2月月3 3月月1销售费用-印刷费2,171.802,018.602,073.802销售费用-人员工资21,052.0020,145.2022,059.403销售费用-差旅费5,623.802,924.603,554.004销售费用-交通费3,741.204,765.602,486.805销售费用-业务招待费5,044.604,219.803,220.806销售费用-公关费4,813.003,701.605,654.607销售费用-通讯费3,559.202,023.202,365.008销售费用-广告宣传费3,083.801,916.805,017.209销售费用-网络通信费2,142.004,121.002,963.4010销售费用-其他费用（包括日常办公费等）3,562.403,492.204,602.00小计54,793.8049,328.6053,997.00销售收入（不含税）1,051,799.801,050,122.401,103,977.04费用率5.21%4.70%4.89%人数28.0028.0027.00人均费用1,956.921,761.741,999.89部门负责人:4 4月月5 5月月6 6月月7 7月月8 8月月9 9月月1,827.402,047.202,118.602,037.201,593.802,183.8019,777.4021,282.6022,119.2019,767.4020,062.6021,085.804,463.802,919.204,047.804,545.005,691.203,319.602,804.203,169.403,157.404,636.404,713.402,520.804,433.002,500.005,215.002,467.402,907.605,337.003,960.202,057.005,052.604,446.204,833.002,129.802,299.001,689.402,069.202,109.202,001.402,680.001,897.804,824.203,169.804,421.002,888.402,492.805,170.205,204.603,325.403,637.404,476.404,363.603,813.202,712.204,136.605,265.002,308.604,088.4050,446.2048,405.8054,411.6053,332.2051,476.4050,201.601,091,418.041,031,178.561,037,109.081,044,900.561,018,985.121,103,881.004.62%4.69%5.25%5.10%5.05%4.55%27.0027.0026.0027.0029.0026.001,868.381,792.812,092.751,975.271,775.051,930.83 制表:销销售售一一部部费费用用预预算算表表20182018年年备备注注1010月月1111月月1212月月全全年年合合计计1,855.201,720.201,784.2023,431.8021,765.2023,153.6021,254.80253,525.201,987.002,500.404,673.4046,249.804,595.403,764.605,582.0045,937.205,137.402,407.403,825.2046,715.204,666.802,560.405,239.0049,114.203,656.203,431.203,933.2031,816.204,983.203,803.401,950.6040,449.002,752.204,520.805,308.6047,985.603,849.804,028.004,862.2046,720.6055,248.4051,890.0058,413.20631,944.801,048,184.401,073,665.961,058,072.8012,713,294.765.27%4.83%5.52%27.0029.0026.00327.002,046.241,789.312,246.66-销销售售二二部部费费用用预预算算表表序序号号项项目目20182018年年1 1月月2 2月月3 3月月1销售费用-印刷费1,756.601,997.701,676.102销售费用-人员工资16,226.5015,273.4016,903.303销售费用-差旅费4,849.602,520.702,774.004销售费用-交通费3,659.904,130.702,082.105销售费用-业务招待费4,030.203,439.603,108.606销售费用-公关费4,423.503,633.704,277.707销售费用-通讯费2,791.902,283.902,234.008销售费用-广告宣传费2,962.101,626.604,522.409销售费用-网络通信费2,047.503,411.002,955.8010销售费用-其他费用（包括日常办公费等）2,710.302,774.903,696.50小计45,458.1041,092.2044,230.50销售收入（不含税）940,888.10876,775.30837,856.28费用率4.83%4.69%5.28%人数21.0022.0023.00人均费用2,164.671,867.831,923.07部门负责人:4 4月月5 5月月6 6月月7 7月月8 8月月9 9月月2,177.301,881.902,017.702,161.401,988.101,916.1015,569.8016,446.7016,606.9015,646.3015,913.2016,215.103,528.102,976.903,471.603,886.504,457.402,573.702,454.903,236.302,705.803,746.804,359.302,251.103,351.001,948.504,494.002,531.303,031.204,655.503,391.902,174.503,934.703,402.904,253.001,609.602,009.501,972.302,115.401,693.901,880.802,475.501,887.104,277.902,603.103,639.502,187.302,695.604,642.404,314.702,569.303,506.803,483.303,664.703,577.402,102.403,359.704,545.502,174.203,762.8042,589.4041,332.1043,878.2044,760.9043,727.8041,819.70909,155.78865,131.17884,704.31940,079.92920,111.34871,386.004.68%4.78%4.96%4.76%4.75%4.80%23.0022.0022.0023.0022.0022.001,851.711,878.731,994.461,946.131,987.631,900.90 制表:销销售售二二部部费费用用预预算算表表20182018年年备备注注1010月月1111月月1212月月全全年年合合计计1,888.401,872.901,847.4023,181.6016,831.4017,774.7016,693.60196,100.901,912.002,599.803,601.3039,151.603,976.802,825.204,186.5039,615.404,610.802,080.303,589.9040,870.904,315.602,483.804,081.5041,982.403,083.402,835.903,030.4028,406.903,940.403,638.301,650.2035,630.502,657.403,789.604,623.7041,666.203,533.103,700.003,956.4039,893.2046,749.3043,600.5047,260.90526,499.60891,400.80902,918.72849,309.6010,689,717.325.24%4.83%5.56%22.0024.0022.00268.002,124.971,816.692,148.22-销销售售三三部部费费用用预预算算表表序序号号项项目目20182018年年1 1月月2 2月月3 3月月1销售费用-印刷费1,683.601,715.701,607.102销售费用-人员工资15,976.5015,179.4016,698.303销售费用-差旅费4,488.602,333.702,712.004销售费用-交通费3,171.903,812.701,958.105销售费用-业务招待费3,889.203,282.602,712.606销售费用-公关费3,958.503,143.704,256.707销售费用-通讯费2,721.901,845.901,971.008销售费用-广告宣传费2,591.101,518.604,088.409销售费用-网络通信费1,795.503,228.002,536.8010销售费用-其他费用（包括日常办公费等）2,688.302,685.903,556.50小计42,965.1038,746.2042,097.50销售收入（不含税）854,009.10825,813.30832,214.28费用率5.03%4.69%5.06%人数21.0024.0023.00人均费用2,045.961,614.431,830.33部门负责人:4 4月月5 5月月6 6月月7 7月月8 8月月9 9月月1,716.301,683.901,772.701,799.401,535.101,757.1015,148.8016,169.7016,596.9015,177.3015,418.2015,986.103,425.102,526.903,222.603,613.504,349.402,525.702,253.902,745.302,512.803,