当前位置:文档之家› 本量利分析模板

本量利分析模板


-
810,170.97 472.53 527.08 685,161.72 399.62 872.14 127.47 12.75% -
499.02 456.57 837,024.16 204.41 703.43 252.16 26.39% 590,031.34 144.09
-
290,209.08 169.26
54,432.15
产量 总成本 468,033.22 234,131.18 976,072.51 1,678,236.91 480.78 34,892.40 109.47 35,482.66 93,355.46 188,496.33 231.52 4,657.54 4,450.00 291,190.85
3,912,978.60
13,165.52 162,615.15 114,428.41 290,209.08 1,785,541.78 1,103,633.43
7.68 94.84 66.74 169.26 #N/A 643.69 1,169.54 999.61
1,713,881.33
-
2,043,391.44
1,246,504.40
5月份 1,941.51 单耗 0.59 单位成本 295.05 116.87 411.92 0.14 14.66 0.41 15.22 72.45 100.16 2.03 3.59 36.65 214.89 642.03 273.46 2,911.78 119.66
74,108.56
1,910,309.93
639,239.38 273,188.94 366,050.44 40,265.55 40,265.55 51,246.31 321,589.38 142,972.75 515,808.44 2,602,804.58 1,054,718.73
-
849,388.30 437.49 546.44 417,207.50 214.89 652.38 331.55 33.70% 643714.14 -
16,499,438.16
17,854.49 单耗 0.49 0.03 0.15 0.68 1.98 0.65 89.83 0.17 30.10 0.06 单位成本 217.91 66.72 131.95 416.59 0.34 19.43 5.07 24.84 65.97 77.92 4.62 14.77 14.61 177.89 619.31
2,004,910.42
4,047.00 单耗 0.22 0.07 0.28 0.57 0.06 13.45 0.00 单位成本 115.65 57.85 241.18 414.69 0.12 8.62 0.03 8.77 23.07 46.58 0.06 1.15 1.10 71.95 495.41
1,448,669.86
单价 470.00 829.06 865.39 1.98 0.65 176.99
单价 470.00 829.06 865.39 1.98 0.65 176.99
175.00
16.67
-
-
-
-
328,071.92 145,049.30 183,022.62 20,132.49 20,132.49 19,668.68 189,920.69 74,930.75 284,520.12 1,753,322.47 925,605.73 9.74 9.51 91.84 36.23 137.58 847.84 447.59 1,091.84 933.20
141,344.01
2月份 2,067.98 单耗 0.40 0.09 0.16 0.65 0.77 68.35 0.08 单位成本 188.21 71.68 140.36 400.25 1.53 44.40 14.98 60.90 77.80 117.62 16.32 27.63 239.37 700.53 耗用量 2,392.20 28.82 442.58 2,863.60 876.12
2,830,627.66
总成本 389,211.70 148,235.93 290,269.11 827,716.74 3,157.92 91,813.20 30,973.45 125,944.57 160,882.81 243,244.12 33,744.61 57,137.01 495,008.55
单位净利率 净利润 盈亏平衡点(销售量) 盈亏临界(不含税销售额)
盈亏平衡点(销售量)=(期间费用+固定成本)/单位边际贡献 目标利润=销售收入-销售成本=销售收入-(变动成本总额+固定成本总额) 盈亏临界点销售量=固定成本/(单价-变动成本单价) 盈亏临界点销售收入=单价*盈亏临界点销售量
1月份 产量 耗用量 828.11 178.80 335.42 1,342.33 1,594.00
产量 耗用量 2,638.32 总成本 1,309,450.98 238,634.87 1,548,085.85 236.92 47,505.49 412.82 48,155.23 170,622.32 235,878.99 5,906.31 11,003.10 27,078.79 450,489.51
847.52 108.07 11.31% 442,531.66 3125.58 2,986,775.78
1,041.41 -41.80 -4.18% -71,660.45 1850.51 1,849,784.94
0.76
0.79
4月份 产量 总成本 572,847.35 226,902.18 799,749.53 281.50 28,461.86 804.01 29,547.38 140,662.46 194,460.60 3,950.52 6,978.26 71,155.65 417,207.50
本量利分析表
产品: 项目 分项 累计 产量 耗用量 8,783.47 主要材料 521.96 2,752.72 主要材料小计 辅助材料 辅助材料小计 人员工资 折旧 固定费用 维修费 物料消耗 其他 固定费用小计 制造成本合计 销项税 进项税 增值税 附加税 12,058.16 3,075.45 537,485.87 1,007.82 总成本 3,890,695.68 1,191,315.16 2,355,910.92 7,437,921.76 6,092.20 346,890.98 90,531.35 443,514.52 1,177,787.45 1,391,160.95 82,538.64 263,678.46 260,916.79 3,176,082.29 11,057,518.58 2,804,904.49 1,177,854.53 1,627,049.95 178,975.49 178,975.49 211,693.69 1,650,500.92 800,414.60 2,662,609.21 13,899,103.28 6,461,181.52 10.02 11.86 92.44 44.83 149.13 778.47 361.88 1,081.20 924.11
89,739.97
3月份 产量 总成本 416,606.54 24,274.87 241,026.94 681,908.34 199.36 57,525.62 55,280.60 113,005.58 215,276.28 262,319.86 19,639.61 140,493.44 47,432.53 685,161.72
44,400.51
单价 474.19 829.06 865.39 1.98 0.64 71.00
耗用量 1,152.80
778.60
21.54
-
-
291,359.83 152,659.37 138,700.45 15,257.05 15,257.05 22.84 79.18 42.07 144.09 835.36 382.98 1,118.04 955.59
-
284,520.12 137.58
-
847.84 85.36 9.15% 176,512.35 1686.17 1,573,532.45
2月份 产量 单耗 0.58 0.01 0.11 0.70 #N/A #N/A #N/A 4,094.83 单位成本 179.38 191.63 93.53 464.54 0.42 21.17 0.72 22.32 96.95 65.15 4.66 10.60 27.06 204.41 691.27 耗用量 878.57 29.28 278.52 1,186.36 100.69
133,460.68
产量 总成本 734,545.90 784,673.18 383,005.31 1,902,224.39 1,735.71 86,692.41 2,950.99 91,379.11 396,988.12 266,761.05 19,066.07 43,409.12 110,799.81 837,024.16
2,046,730.59
单价 496.92
单价 496.32
单耗 0.66 -
822.02 1.98 0.64 37.33
0.14 0.74 0.07 22.87 0.01 -
872.65 1.98 0.64 34.50 1.24
0.07 0.73 0.03 18.58 0.00 -
11.97 -
Hale Waihona Puke -1,929,834.83
665,206.36 212,588.74 452,617.63 49,787.94 49,787.94 93,520.56 324,243.91 172,266.87 590,031.34 3,470,446.94 1,568,222.55
-
973,793.80 470.89 462.31 495,008.55 239.37 710.26 222.94 23.89% 222.94 -
相关主题