ImageVerifierCode 换一换
格式:XLSX , 页数:80 ,大小:149.93KB ,
资源ID:3143441      下载积分:2 积分
快捷下载
登录下载
邮箱/手机:
温馨提示:
快捷下载时,用户名和密码都是您填写的邮箱或者手机号,方便查询和重复下载(系统自动生成)。 如填写123,账号就是123,密码也是123。
特别说明:
请自助下载,系统不会自动发送文件的哦; 如果您已付费,想二次下载,请登录后访问:我的下载记录
支付方式: 支付宝扫码支付 微信扫码支付   
验证码:   换一换

加入VIP,免费下载
 

温馨提示:由于个人手机设置不同,如果发现不能下载,请复制以下地址【https://www.wnwk.com/docdown/3143441.html】到电脑端继续下载(重复下载不扣费)。

已注册用户请登录:
账号:
密码:
验证码:   换一换
  忘记密码?
三方登录: QQ登录  

下载须知

1: 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。
2: 试题试卷类文档,如果标题没有明确说明有答案则都视为没有答案,请知晓。
3: 文件的所有权益归上传用户所有。
4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
5. 本站仅提供交流平台,并不能对任何下载内容负责。
6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。

版权提示 | 免责声明

本文(14-【预算系统】-03-全面财务预算管理系统 (2).xlsx)为本站会员(a****2)主动上传,蜗牛文库仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对上载内容本身不做任何修改或编辑。 若此文所含内容侵犯了您的版权或隐私,请立即通知蜗牛文库(发送邮件至admin@wnwk.com或直接QQ联系客服),我们立即给予删除!

14-【预算系统】-03-全面财务预算管理系统 (2).xlsx

1、利利润润预预算算表表收收入入预预算算表表销销售售及及管管理理费费用用预预算算全全部部税税金金预预算算表表成成本本预预算算表表营营业业税税金金及及附附加加预预算算全全面面财财务务预预算算管管理理系系统统销销售售费费用用预预算算(销销1销销售售费费用用预预算算(销销2外外购购存存货货进进销销存存人人员员预预算算表表销销售售费费用用预预算算(销销3管管理理费费用用预预算算内内购购存存货货进进销销存存固固定定资资产产变变动动预预算算融融资资预预算算表表制制造造费费用用预预算算表表固固定定资资产产购购置置预预算算采采购购资资金金预预算算全全面面财财务务预预算算管管理理系系统统利利润润预预算算表表项 目1

2、月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.00

3、248,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.2

4、239,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.0

5、0131,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

6、 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,

7、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,

8、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,2

9、70.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.0

10、0818,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.604

11、24,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,03

12、6.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.

13、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.

14、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.60

15、513,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,

16、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

17、月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.26

18、1,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

19、.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企

20、业所得税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

21、,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.

22、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.0

23、011,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.0

24、030管理费用-折旧费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

25、,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,

26、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,54

27、4.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,

28、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,

29、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,6

30、75.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

31、 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.005

32、8,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.

33、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,

34、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

35、,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.00

36、2,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,

37、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.

38、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,

39、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

40、,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.20

41、23,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.4

42、051,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销售费用-交

43、通费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.30

44、837,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

45、,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,58

46、9.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

47、.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,95

48、6.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.70

49、2,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,0

50、09.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,

copyright@ 2008-2023 wnwk.com网站版权所有

经营许可证编号:浙ICP备2024059924号-2