 |
|
|
|
利率計算方式 |
|
|
|
|
|
|
|
|
|
今天小編要跟大家介紹「利率計算方式」,此利率計算方式有:銷售利潤計算方式、單項利率(%)計算方式及總利潤率計算方式.在此如有疑問,您可以撥千奧客服專線Tel:02-27078066/客服部凌先生詢問喔! |
|
|
|
|
|
|
|
|
|
我們以「客戶交易總額排行表」(不排行)為範例來說明. |
|
|
|
|
排行 |
客戶編號 |
銷售總額 |
銷售成本 |
銷售利潤 |
單項利率(%) |
總利潤率(%) |
|
01 |
001 |
62,600.00 |
36,845.83 |
25,754.17 |
41.140847 |
5.212274 |
|
02 |
A001 |
3,900.00 |
2,651.67 |
1,248.33 |
32.008462 |
0.252644 |
|
03 |
C0001 |
626,600.00 |
449,117.21 |
177,482.79 |
28.324735 |
35.919970 |
|
04 |
C0002 |
193,200.00 |
178,178.55 |
15,021.45 |
7.775078 |
3.040126 |
|
05 |
C0003 |
255,150.00 |
166,359.05 |
88,790.95 |
34.799510 |
17.970014 |
|
06 |
C0004 |
145,500.00 |
54,676.46 |
90,823.54 |
62.421677 |
18.381381 |
|
07 |
C0005 |
142,885.00 |
47,900.05 |
94,984.95 |
66.476502 |
19.223591 |
|
總計 |
1,429,835.00
|
935,728.82 |
494,106.18
|
|
100.00 |
|
|
|
|
|
|
|
|
|
|
|
一、銷售利潤計算方式: |
|
|
|
銷售利潤 = 銷售總額 -
銷售成本 -----------------例如:排行01 客戶編號 001 |
|
|
|
(25,754.17) = ( 62,600.00 ) -
36,845.83 |
|
|
|
|
|
|
|
二、單項利率(%)計算方式: |
|
|
|
單項利率(%) = 銷售利潤 /
銷售總額--------------- 例如:排行01 客戶編號 001 |
|
|
|
41.140847 (%) = 25,754.17 /
62,600.00 |
|
|
|
|
|
|
|
|
|
三、總利潤率(%)計算方式: |
|
|
|
總利潤率(%) = 單項的銷售利潤 / 總計的銷售利潤 -----例如:排行01 客戶編號 001 |
|
|
|
5.212274 (%) = 25,754.17 / 494,106.18 |
|
|
|
[完] |
|
|
|
 |