毛利分析

  • 格式:xls
  • 大小:36.00 KB
  • 文档页数:6

銷售差異分析銷售數量平均售價銷售額百分比銷售數量A類2,540.0 337.28 856,700.00 56.2%2,640.0 其中:產品1120.0 260.00 31,200.00 2.0%100.0 產品2130.0 290.00 37,700.00 2.5%150.0 產品3160.0 320.00 51,200.00 3.4%160.0 產品41,100.0 330.00 363,000.00 23.8%1,000.0 產品51,000.0 370.00 370,000.00 24.3%1,200.0 產品630.0 120.00 3,600.00 0.2%30.0 B類1,560.0 427.44 666,800.00 43.8%1,160.0 其中:產品7300.0 350.00 105,000.00 6.9%200.0 產品880.0 400.00 32,000.00 2.1%80.0 產品950.0 420.00 21,000.00 1.4%40.0 產品101,100.0 450.00 495,000.00 32.5%800.0 產品1130.0 460.00 13,800.00 0.9%40.0 4,100.0 371.59 1,523,500.00 100%3,800.0 成本差異分析銷售數量平均成本銷售額百分比銷售數量A類2,540.0 225.83 573,600.00 37.7%2,640.0 其中:產品1120.0 185.00 22,200.00 2.1%100.0 產品2130.0 210.00 27,300.00 2.6%150.0 產品3160.0 215.00 34,400.00 3.3%160.0 產品41,100.0 225.00 247,500.00 23.6%1,000.0 產品51,000.0 235.00 235,000.00 22.4%1,200.0 產品630.0 240.00 7,200.00 0.7%30.0 B類1,560.0 305.45 476,500.00 31.3%1,160.0 其中:產品7300.0 260.00 78,000.00 7.4%200.0 產品880.0 275.00 22,000.00 2.1%80.0 實際

實際產品950.0 295.00 14,750.00 1.4%40.0 產品101,100.0 320.00 352,000.00 33.5%800.0 產品1130.0 325.00 9,750.00 0.9%40.0 4,100.0 256.12 1,050,100.00 69%3,800.0 毛利473,400.00 注:假設價格為不含稅價量差中的結構差=(單項實際數量-預算單項的占比×實際總量)×預算價格量差中的非結構差=(預算單項的占比×實際總量-單項預算量)×預算價格價差=(實際價格-預算價格)×實際數量銷售占比平均售價銷售額百分比銷售額差異 量差結構差異69.5%341.06 900,400.00 64.5%-43,700.00 -109,484.21 2.6%280.00 28,000.00 2.0%3,200.00 3,389.47 3.9%300.00 45,000.00 3.2%-7,300.00 -9,552.63 4.2%320.00 51,200.00 3.7%- -4,042.11 26.3%340.00 340,000.00 24.4%23,000.00 7,157.89 31.6%360.00 432,000.00 31.0%-62,000.00 -106,105.26 0.8%140.00 4,200.00 0.3%-600.00 -331.58 30.5%426.90 495,200.00 35.5%171,600.00 130,505.26 5.3%380.00 76,000.00 5.4%29,000.00 32,000.00 2.1%400.00 32,000.00 2.3%- -2,526.32 1.1%420.00 16,800.00 1.2%4,200.00 2,873.68 21.1%440.00 352,000.00 25.2%143,000.00 104,210.53 1.1%460.00 18,400.00 1.3%-4,600.00 -6,052.63 100%367.26 1,395,600.00 100%127,900.00 21,021.05

銷售占比平均成本銷售額百分比銷售額差異結構差異69.5%227.84 601,500.00 43.1%-27,900.00 -73,286.84 2.6%180.00 18,000.00 1.9%4,200.00 2,178.95 3.9%195.00 29,250.00 3.1%-1,950.00 -6,209.21 4.2%210.00 33,600.00 3.5%800.00 -2,652.63 26.3%225.00 225,000.00 23.7%22,500.00 4,736.84 31.6%240.00 288,000.00 30.3%-53,000.00 -70,736.84 0.8%255.00 7,650.00 0.8%-450.00 -603.95 30.5%300.86 349,000.00 25.0%127,500.00 92,197.37 5.3%270.00 54,000.00 5.7%24,000.00 22,736.84 2.1%280.00 22,400.00 2.4%-400.00 -1,768.42 預算差異分析

預算差異分析1.1%295.00 11,800.00 1.2%2,950.00 2,018.42 21.1%310.00 248,000.00 26.1%104,000.00 73,421.05 1.1%320.00 12,800.00 1.3%-3,050.00 -4,210.53 100%250.13 950,500.00 68%99,600.00 18,910.53 445,100.00 28,300.00 2,110.53 量差非結構差異單價差異平衡測試71,084.21 -5,300.00 - 2,210.53 -2,400.00 - 3,552.63 -1,300.00 - 4,042.11 - - 26,842.11 -11,000.00 - 34,105.26 10,000.00 - 331.58 -600.00 - - 39,094.74 2,000.00 0.00 - 6,000.00 -9,000.00 - 2,526.32 - - 1,326.32 - 0.00 27,789.47 11,000.00 - 1,452.63 - 0.00 - 110,178.95 -3,300.00 0.00 數量差異單價差異平衡測試47,486.84 -2,100.00 - 1,421.05 600.00 - 2,309.21 1,950.00 - 2,652.63 800.00 - 17,763.16 - - 22,736.84 -5,000.00 - 603.95 -450.00 - - 27,552.63 7,750.00 - - 4,263.16 -3,000.00 - 1,768.42 -400.00 - 異分析

異分析931.58 - 0.00 19,578.95 11,000.00 - 1,010.53 150.00 0.00 - 75,039.47 5,650.00 - 35,139.47 -8,950.00 -