最全面预算表(公式自动计算).xls

项 目1月2月3月4月5月6月7月 一、营业收入2,846,697.00 # # # # # # 减：营业成本2,164,036.40 # # # # # # 营业税金及附加8,431.285,890.287,820.316,507.497,131.825,927.245,828.51 主营业务利润（亏损以“-”号填列） 674,229.32# # # # # # 减：销售费用143,217.00129,154.00140,325.00132,908.00128,197.00140,414.00140,133.00 管理费用230,071.00235,196.00223,049.00254,230.00248,938.00240,367.00267,828.00 财务费用895.70826.80848.90769.60382.20405.60666.90 二、营业利润（亏损以“-”号填列） 530,116.62# # # # # # 加：营业外收入16,000.00 减：营业外支出35.50 三、利润总额（亏损总额以“-”号填列）530,116.62# # # # # # 减：所得税费用 95,629.08116,635.80172,934.7859,547.2239,584.9546,101.10114,517.78 四、净利润（净亏损以“-”号填列）434,487.54# # # # # # 福建XXX光电科技股份有限公司福建XXX光电科技股份有限公司利润预算表利润预算表 8月9月10月11月12月合计 # # # # # 33,432,874.40 # # # # # 25,399,933.60 6,232.527,734.146,412.127,933.907,351.2283,200.81 # # # # # 7,949,739.99 136,006.00131,459.00145,711.00136,415.00150,963.001,654,902.00 211,413.00243,834.00244,892.00248,674.00255,471.002,903,963.00 434.20622.70503.10678.60835.907,870.20 # # # # # 6,286,967.79 100,000.00116,000.00 250.58286.08 # # # # # 6,402,681.71 186,265.45107,421.18141,808.7362,248.85173,419.031,316,113.93 # # # # # 5,086,567.78 福建XXX光电科技股份有限公司福建XXX光电科技股份有限公司利润预算表利润预算表 项 目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.40 A产品收入796,638.00 796,514.00 811,626.50 816,323.00 785,121.50 778,689.00 801,722.00 销售数量51,396.00 51,388.00 52,363.00 52,666.00 50,653.00 50,238.00 51,724.00 销售单价15.50 15.50 15.50 15.50 15.50 15.50 15.50 B产品收入1,334,676.20 1,272,235.80 1,309,705.10 1,321,267.20 1,288,984.40 1,331,969.10 1,320,862.40 销售数量52,754.00 50,286.00 51,767.00 52,224.00 50,948.00 52,647.00 52,208.00 销售单价25.30 25.30 25.30 25.30 25.30 25.30 25.30 C产品收入430,112.80 419,671.20 417,716.00 431,532.40 430,248.00 431,459.60 420,992.00 销售数量82,714.00 80,706.00 80,330.00 82,987.00 82,740.00 82,973.00 80,960.00 销售单价5.20 5.20 5.20 5.20 5.20 5.20 5.20 D产品收入285,270.00 264,290.00 235,000.00 288,840.00 204,660.00 203,330.00 292,110.00 销售数量28,527.00 26,429.00 23,500.00 28,884.00 20,466.00 20,333.00 29,211.00 销售单价10.00 10.00 10.00 10.00 10.00 10.00 10.00 福建XXX光电科技股份有限公司福建XXX光电科技股份有限公司收入预算表收入预算表 8月9月10月11月12月合计 2,770,137.802,821,810.002,770,836.002,823,692.402,724,832.0033,432,874.40 796,405.50 775,387.50 816,168.00 790,283.00 818,663.50 9,583,541.50 51,381.00 50,025.00 52,656.00 50,986.00 52,817.00 618,293.00 15.50 15.50 15.50 15.50 15.50 186.00 1,281,571.50 1,320,786.50 1,271,274.40 1,324,657.40 1,271,805.70 # 50,655.00 52,205.00 50,248.00 52,358.00 50,269.00 618,569.00 25.30 25.30 25.30 25.30 25.30 303.60 420,960.80 428,766.00 420,123.60 424,502.00 422,442.80 5,098,527.20 80,954.00 82,455.00 80,793.00 81,635.00 81,239.00 980,486.00 5.20 5.20 5.20 5.20 5.20 62.40 271,200.00 296,870.00 263,270.00 284,250.00 211,920.00 3,101,010.00 27,120.00 29,687.00 26,327.00 28,425.00 21,192.00 310,101.00 10.00 10.00 10.00 10.00 10.00 120.00 福建XXX光电科技股份有限公司福建XXX光电科技股份有限公司收入预算表收入预算表 项 目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.60 A产品成本 513,960.00 513,880.00 523,630.00 526,660.00 506,530.00 502,380.00 517,240.00 销售数量51,396.00 51,388.00 52,363.00 52,666.00 50,653.00 50,238.00 51,724.00 销售单价10.00 10.00 10.00 10.00 10.00 10.00 10.00 B产品成本 1,097,283.20 1,045,948.80 1,076,753.60 1,086,259.20 1,059,718.40 1,095,057.60 1,085,926.40 销售数量52,754.00 50,286.00 51,767.00 52,224.00 50,948.00 52,647.00 52,208.00 销售单价20.80 20.80 20.80 20.80 20.80 20.80 20.80 C产品成本 347,398.80 338,965.20 337,386.00 348,545.40 347,508.00 348,486.60 340,032.00 销售数量82,714.00 80,706.00 80,330.00 82,987.00 82,740.00 82,973.00 80,960.00 销售单价4.20 4.20 4.20 4.20 4.20 4.20 4.20 D产品成本 205,394.40 190,288.80 169,200.00 207,964.80 147,355.20 146,397.60 210,319.20 销售数量28,527.00 26,429.00 23,500.00 28,884.00 20,466.00 20,333.00 29,211.00 销售单价7.20 7.20 7.20 7.20 7.20 7.20 7.20 福建XXX光电科技股份有限公司福建XXX光电科技股份有限公司成本预算表成本预算表 8月9月10月11月12月合计 2,102,704.802,146,171.402,100,603.402,146,433.402,067,551.4025,399,933.60 513,810.00 500,250.00 526,560.00 509,860.00 528,170.00 6,182,930.00 51,381.00 50,025.00 52,656.00 50,986.00 52,817.00 618,293.00 10.00 10.00 10.00 10.00 10.00 1,053,624.00 1,085,864.00 1,045,158.40 1,089,046.40 1,045,595.20 # 50,655.00 52,205.00 50,248.00 52,358.00 50,269.00 618,569.00 20.80 20.80 20.80 20.80 20.80 340,006.80 346,311.00 339,330.60 342,867.00 341,203.80 4,118,041.20 80,954.00 82,455.00 80,793.00 81,635.00 81,239.00 980,486.00 4.20 4.20 4.20 4.20 4.20 195,264.00 213,746.40 189,554.40 204,660.00 152,582.40 2,232,727.20 27,120.00 29,687.00 26,327.00 28,425.00 21,192.00 310,101.00 7.20 7.20 7.20 7.20 7.20 福建XXX光电科技股份有限公司福建XXX光电科技股份有限公司成本预算表成本预算表 项 目1月2月3月4月 销售收入2,846,697.00 2,752,711.00 2,774,047.60 2,857,962.60 税负率2.96%2.14%2.82%2.28% 增值税84,312.82 58,902.77 78,203.05 65,074.92 营业税金及附加8,431.28 5,890.28 7,820.31 6,507.49 城市维护建设税4,215.64 2,945.14 3,910.15 3,253.75 教育费附加2,529.38 1,767.08 2,346.09 1,952.25 地方教育费附加1,686.26 1,178.06 1,564.06 1,301.50 福建XXX光电科技股份有限公司福建XXX光电科技股份有限公司营业税金及附加预算表营业税金及附加预算表 5月6月7月8月9月10月11月 2,709,013.90 2,745,447.70 2,835,686.40 2,770,137.80 2,821,810.00 2,770,836.00 2,823,692.40 2.63%2.16%2.06%2.25%2.74%2.31%2.81% 71,318.17 59,272.35 58,285.09 62,325.17 77,341.40 64,121.19 79,338.97 7,131.82 5,927.24 5,828.51 6,232.52 7,734.14 6,412.12 7,933.90 3,565.91 2,963.62 2,914.25 3,116.26 3,867.07 3,206.06 3,966.95 2,139.54 1,778.17 1,748.55 1,869.76 2,320.24 1,923.64 2,380.17 1,426.36 1,185.45 1,165.70 1,246.50 1,546.83 1,282.42 1,586.78 福建XXX光电科技股份有限公司福建XXX光电科技股份有限公司营业税金及附加预算表营业税金及附加预算表 12月合计 2,724,832.00 33,432,874.40 2.70%2.49% 73,512.15 832,008.07 7,351.22 83,200.81 3,675.61 41,600.40 2,205.36 24,960.24 1,470.24 16,640.16 项 目 1月2月3月4月5月6月7月8月 1支付增值税- - - - - 销项税- 进项税- 2营业税- 3城建税- 4教育费附加- 5企业所得税- 6房产税- 7.土地使用税- 8.车船使用税- 9印花税- 10.防洪保安费- 11.个人所得税- 12其他税种- 合 计- - - - - 福建XXX光电科技股份有限公司福建XXX光电科技股份有限公司税金预算表税金预算表 9月10月11月12月合计 福建XXX光电科技股份有限公司福建XXX光电科技股份有限公司税金预算表税金预算表 1月1月2月2月 15,612.00 5,719.00 253,255.00 50,598.00 314,962.00 7,779.00 410,573.00 12,709.00 512,964.00 10,942.00 613,195.00 10,479.00 79,073.00 6,153.00 88,637.00 5,062.00 95,985.00 10,760.00 108,961.00 8,953.00 小计143,217.00 129,154.00 1113,887.00 5,980.00 127,798.00 8,762.00 1359,150.00 58,019.00 145,277.00 10,911.00 156,622.00 6,276.00 169,227.00 8,874.00 1712,452.00 9,718.00 1813,746.00 14,535.00 197,278.00 10,031.00 206,338.00 8,482.00 2112,395.00 6,791.00 2214,131.00 10,954.00 237,131.00 7,331.00 2410,347.00 13,486.00 257,438.00 13,082.00 267,013.00 12,906.00 277,469.00 7,116.00 288,827.00 7,937.00 298,455.00 8,947.00 305,090.00 5,058.00 小计230,071.00 235,196.00 373,288.00373,288.00 364,350.00364,350.00 2,846,697.00 2,752,711.00 13.11%13.24% 102.00 103.00 3,659.69 3,537.38 部门负责人: 管理费用-折旧费 管理费用-交通费 管理费用-通讯费 管理费用-广告宣传费 管理费用-房租租赁费 管理费用-办公费 管理费用-福利费 管理费用-会务费 管理费用-咨询服务费 管理费用-标书费 管理费用-业务招待费 管理费用-印花税 管理费用-水电、物业费 管理费用-公关费 管理费用-车辆费 管理费用-差旅费（日常） 管理费用-社会医疗保险公积金 管理费用-电话费 销售费用-印刷费 销售费用-广告宣传费 销售费用-网络通信费 销售费用-其他费用（包括日常办公费等） 管理费用-快递费 管理费用-人员工资 合计合计 销售收入（不含税） 费用率 人数 人均费用 销售费用-通讯费 销售费用-人员工资 销售费用-差旅费 销售费用-交通费 销售费用-业务招待费 销售费用-公关费 序号序号项目项目 3月3月4月4月5月5月6月6月7月7月8月8月 5,357.00 5,721.00 5,613.00 5,909.00 5,998.00 5,117.00 55,661.00 50,496.00 53,899.00 55,323.00 50,591.00 51,394.00 9,040.00 11,417.00 8,423.00 10,742.00 12,045.00 14,498.00 6,527.00 7,513.00 9,151.00 8,376.00 11,976.00 12,961.00 9,042.00 11,120.00 6,355.00 13,870.00 7,141.00 8,484.00 14,189.00 10,503.00 6,045.00 12,839.00 11,213.00 12,980.00 6,570.00 6,155.00 5,231.00 5,978.00 5,433.00 5,546.00 13,628.00 5,407.00 13,003.00 8,247.00 11,515.00 7,251.00 8,456.00 14,018.00 13,599.00 8,421.00 10,206.00 11,371.00 11,855.00 10,558.00 6,878.00 10,709.00 14,015.00 6,404.00 140,325.00 132,908.00 128,197.00 140,414.00 140,133.00 136,006.00 5,477.00 14,233.00 10,089.00 11,721.00 9,544.00 10,642.00 10,608.00 11,196.00 8,464.00 7,309.00 14,741.00 11,399.00 50,644.00 52,852.00 55,569.00 50,620.00 52,519.00 58,614.00 5,832.00 5,299.00 10,152.00 6,721.00 14,828.00 11,361.00 11,518.00 9,521.00 5,708.00 6,989.00 14,756.00 12,187.00 9,669.00 9,432.00 14,705.00 8,398.00 8,366.00 6,599.00 5,078.00 11,835.00 5,054.00 13,408.00 13,393.00 14,275.00 10,939.00 10,462.00 8,259.00 12,288.00 14,401.00 5,410.00 6,581.00 12,965.00 13,594.00 11,115.00 11,015.00 5,987.00 11,473.00 13,635.00 9,698.00 12,724.00 9,206.00 8,213.00 11,438.00 11,224.00 14,300.00 6,368.00 8,241.00 7,605.00 9,528.00 10,809.00 13,445.00 10,209.00 8,302.00 9,409.00 8,567.00 12,757.00 12,236.00 10,668.00 14,466.00 6,045.00 11,764.00 11,158.00 12,002.00 10,917.00 11,985.00 5,299.00 14,383.00 6,005.00 14,439.00 10,438.00 8,901.00 6,083.00 11,286.00 7,647.00 7,153.00 14,827.00 14,552.00 6,301.00 11,377.00 9,750.00 11,058.00 11,100.00 13,312.00 7,585.00 5,422.00 14,717.00 8,504.00 10,575.00 12,105.00 6,122.00 6,407.00 13,675.00 9,451.00 8,914.00 8,137.00 7,219.00 5,058.00 5,058.00 5,058.00 5,058.00 5,058.00 5,058.00 223,049.00 254,230.00 248,938.00 240,367.00 267,828.00 211,413.00 363,374.00363,374.00 387,138.00387,138.00 377,135.00377,135.00 380,781.00380,781.00 407,961.00407,961.00 347,419.00347,419.00 2,774,047.60 2,857,962.60 2,709,013.90 2,745,447.70 2,835,686.40 2,770,137.80 13.10%13.55%13.92%13.87%14.39%12.54% 103.00 98.00 103.00 100.00 104.00 98.00 3,527.90 3,950.39 3,661.50 3,807.81 3,922.70 3,545.09 福建XXX光电科技股份有限公司福建XXX光电科技股份有限公司销售费用预算表销售费用预算表 2018年2018年 备注备注 9月9月10月10月11月11月12月12月全年合计全年合计 5,857.00 5,348.00 5,133.00 5,188.00 66,572.00 53,287.00 55,138.00 58,469.00 54,212.00 642,323.00 8,419.00 5,570.00 7,286.00 11,821.00 122,002.00 6,817.00 12,246.00 9,414.00 13,955.00 122,218.00 14,275.00 13,926.00 6,411.00 10,593.00 125,123.00 5,342.00 12,832.00 7,206.00 13,315.00 130,138.00 7,365.00 9,628.00 8,953.00 9,948.00 86,033.00 7,412.00 12,748.00 10,631.00 5,144.00 108,685.00 11,469.00 7,728.00 11,872.00 14,189.00 128,074.00 11,216.00 10,547.00 11,040.00 12,598.00 123,734.00 131,459.00 145,711.00 136,415.00 150,963.00 1,654,902.00 12,643.00 6,527.00 14,665.00 14,024.00 129,432.00 14,390.00 13,381.00 11,536.00 5,394.00 124,978.00 51,599.00 54,786.00 51,058.00 56,841.00 652,271.00 6,172.00 12,498.00 6,621.00 12,241.00 107,913.00 10,264.00 9,554.00 6,725.00 10,304.00 110,424.00 14,159.00 13,903.00 14,849.00 10,771.00 128,952.00 6,907.00 9,394.00 6,173.00 10,705.00 118,392.00 6,235.00 10,347.00 13,046.00 11,898.00 131,566.00 8,547.00 10,019.00 11,525.00 9,743.00 118,400.00 13,697.00 7,049.00 7,001.00 9,211.00 116,727.00 14,231.00 11,697.00 14,673.00 13,199.00 132,162.00 9,281.00 14,969.00 14,872.00 9,736.00 135,645.00 9,877.00 5,290.00 7,839.00 8,167.00 110,374.00 6,394.00 11,739.00 5,776.00 14,880.00 125,747.00 14,891.00 6,897.00 5,644.00 8,145.00 116,346.00 14,734.00 7,496.00 12,010.00 8,847.00 124,772.00 8,877.00 13,312.00 11,668.00 11,834.00 124,458.00 9,280.00 12,635.00 13,102.00 11,211.00 120,437.00 6,598.00 8,341.00 14,833.00 13,262.00 114,239.00 5,058.00 5,058.00 5,058.00 5,058.00 60,728.00 243,834.00 244,892.00 248,674.00 255,471.00 2,903,963.00 375,293.00375,293.00 390,603.00390,603.00 385,089.00385,089.00 406,434.00406,434.00 4,558,865.00 2,821,810.00 2,770,836.00 2,823,692.40 2,724,832.00 - 13.30%14.10%13.64%14.92%- 101.00 102.00 105.00 102.00 - 3,715.77 3,829.44 3,667.51 3,984.65 - 制表: 1月1月2月2月3月3月 12,171.80 2,018.60 2,073.80 221,052.00 20,145.20 22,059.40 35,623.80 2,924.60 3,554.00 43,741.20 4,765.60 2,486.80 55,044.60 4,219.80 3,220.80 64,813.00 3,701.60 5,654.60 73,559.20 2,023.20 2,365.00 83,083.80 1,916.80 5,017.20 92,142.00 4,121.00 2,963.40 103,562.40 3,492.20 4,602.00 小计54,793.80 49,328.60 53,997.00 1,051,799.80 1,050,122.40 1,103,977.04 费用率5.21%4.70%4.89% 28.00 28.00 27.00 1,956.92 1,761.74 1,999.89 部门负责人: 销售费用-广告宣传费 福建XXX光电科技股份有限公司福建XXX光电科技股份有限公司销售三部销售三部费用预算表费用预算表 序号序号项目项目 销售费用-印刷费 销售费用-人员工资 销售费用-差旅费 销售费用-交通费 销售费用-业务招待费 销售费用-公关费 销售费用-通讯费 销售费用-网络通信费 销售费用-其他费用（包括日常办公费等） 销售收入（不含税） 人数 人均费用 4月4月5月5月6月6月7月7月8月8月9月9月 1,827.40 2,047.20 2,118.60 2,037.20 1,593.80 2,183.80 19,777.40 21,282.60 22,119.20 19,767.40 20,062.60 21,085.80 4,463.80 2,919.20 4,047.80 4,545.00 5,691.20 3,319.60 2,804.20 3,169.40 3,157.40 4,636.40 4,713.40 2,520.80 4,433.00 2,500.00 5,215.00 2,467.40 2,907.60 5,337.00 3,960.20 2,057.00 5,052.60 4,446.20 4,833.00 2,129.80 2,299.00 1,689.40 2,069.20 2,109.20 2,001.40 2,680.00 1,897.80 4,824.20 3,169.80 4,421.00 2,888.40 2,492.80 5,170.20 5,204.60 3,325.40 3,637.40 4,476.40 4,363.60 3,813.20 2,712.20 4,136.60 5,265.00 2,308.60 4,088.40 50,446.20 48,405.80 54,411.60 53,332.20 51,476.40 50,201.60 1,091,418.04 1,031,178.56 1,037,109.08 1,044,900.56 1,018,985.12 1,103,881.00 4.62%4.69%5.25%5.10%5.05%4.55% 27.00 27.00 26.00 27.00 29.00 26.00 1,868.38 1,792.81 2,092.75 1,975.27 1,775.05 1,930.83 制表: 福建XXX光电科技股份有限公司福建XXX光电科技股份有限公司销售三部销售三部费用预算表费用预算表 2018年2018年 备注备注 10月10月11月11月12月12月全年合计全年合计 1,855.20 1,720.20 1,784.20 23,431.80 21,765.20 23,153.60 21,254.80 253,525.20 1,987.00 2,500.40 4,673.40 46,249.80 4,595.40 3,764.60 5,582.00 45,937.20 5,137.40 2,407.40 3,825.20 46,715.20 4,666.80 2,560.40 5,239.00 49,114.20 3,656.20 3,431.20 3,933.20 31,816.20 4,983.20 3,803.40 1,950.60 40,449.00 2,752.20 4,520.80 5,308.60 47,985.60 3,849.80 4,028.00 4,862.20 46,720.60 55,248.40 51,890.00 58,413.20 631,944.80 1,048,184.40 1,073,665.96 1,058,072.80 12,713,294.76 5.27%4.83%5.52% 27.00 29.00 26.00 327.00 2,046.24 1,789.31 2,246.66 - - 1月1月2月2月3月3月 11,756.60 1,997.70 1,676.10 216,226.50 15,273.40 16,903.30 34,849.60 2,520.70 2,774.00 43,659.90 4,130.70 2,082.10 54,030.20 3,439.60 3,108.60 64,423.50 3,633.70 4,277.70 72,791.90 2,283.90 2,234.00 82,962.10 1,626.60 4,522.40 92,047.50 3,411.00 2,955.80 102,710.30 2,774.90 3,696.50 小计45,458.10 41,092.20 44,230.50 940,888.10 876,775.30 837,856.28 费用率4.83%4.69%5.28% 21.00 22.00 23.00 2,164.67 1,867.83 1,923.07 部门负责人: 销售费用-广告宣传费 福建XXX光电科技股份有限公司福建XXX光电科技股份有限公司销售三部销售三部费用预算表费用预算表 序号序号项目项目 销售费用-印刷费 销售费用-人员工资 销售费用-差旅费 销售费用-交通费 销售费用-业务招待费 销售费用-公关费 销售费用-通讯费 销售费用-网络通信费 销售费用-其他费用（包括日常办公费等） 销售收入（不含税） 人数 人均费用 4月4月5月5月6月6月7月7月8月8月9月9月 2,177.30 1,881.90 2,017.70 2,161.40 1,988.10 1,916.10 15,569.80 16,446.70 16,606.90 15,646.30 15,913.20 16,215.10 3,528.10 2,976.90 3,471.60 3,886.50 4,457.40 2,573.70 2,454.90 3,236.30 2,705.80 3,746.80 4,359.30 2,251.10 3,351.00 1,948.50 4,494.00 2,531.30 3,031.20 4,655.50 3,391.90 2,174.50 3,934.70 3,402.90 4,253.00 1,609.60 2,009.50 1,972.30 2,115.40 1,693.90 1,880.80 2,475.50 1,887.10 4,277.90 2,603.10 3,639.50 2,187.30 2,695.60 4,642.40 4,314.70 2,569.30 3,506.80 3,483.30 3,664.70 3,577.40 2,102.40 3,359.70 4,545.50 2,174.20 3,762.80 42,589.40 41,332.10 43,878.20 44,760.90 43,727.80 41,819.70 909,155.78 865,131.17 884,704.31 940,079.92 920,111.34 871,386.00 4.68%4.78%4.96%4.76%4.75%4.80% 23.00 22.00 22.00 23.00 22.00 22.00 1,851.71 1,878.73 1,994.46 1,946.13 1,987.63 1,900.90 制表: 福建XXX光电科技股份有限公司福建XXX光