ҪʵÏÖ×î´ó¼¼Äܹ¥»÷Á¦£¬¾ÝÎÒ³¤´ï¶à¸ö·ÖÖÓµÄÑо¿ÓëÁ¦Á¿¡¢ÖÇÁ¦£¬×Ô¼º×°±¸ºÍµÐÈË·ÀÓùÓйأ¬Á¦Á¿¡¢ÖÇÁ¦£¬×Ô¼º×°±¸¿ÉÒÔÖªµÀ£¬µÐÈË·ÀÓù¿ÉÒÔÎÊËû£¬¹þ¹þ¡£ºó¸½EXCEL±í¼ÆËãÈÎÒâµãÊý¡¢µÐÈË·ÀÓùµÄ×î´óÅäµã
ÒÔսʿΪÀý˵Ã÷£º
ÐòºÅ
Á¦ÖÇ×ܵãÊýC
Á¦Á¿L
ÖÇÁ¦Z
ÎäÆ÷W
¼¼Äܹ¥»÷Á¦J
·ÀÓùF/2
×î¸ß¼¼ÄÜÉ˺¦
×îÖÕÉ˺¦
1
23960
1000
22960
200
120
2000
-35693
-57108
2
23960
3000
20960
200
120
2000
-21353
-34164
3
23960
5000
18960
200
120
2000
-9013
-14420
4
23960
7000
16960
200
120
2000
1327
2124
5
23960
9000
14960
200
120
2000
9667
15468
6
23960
10000
13960
200
120
2000
13087
20940
×î¼ÑÖµ
23960
16340
7620
200
120
2000
23136
37018
ÐÞÕý
24032
16352
7680
200
120
2000
23309
37295
×ܵãÊý
40000
Ãô½Ý±È
0.2
ÌåÁ¦±È
0.20
ÌáÉý±È
1.6
Á¦Á¿
16352
Á¦Á¿ÐÞÕý
16352
Ãô½Ý
8000
Ãô½ÝÐÞÕý
8040
ÌåÁ¦
8000
ÌåÁ¦ÐÞÕý
7928
ÖÇÁ¦
7680
ÖÇÁ¦ÐÞÕý
7680
ͳÂÊ
0
ͳÂÊÐÞÕý
0
×î¸ß¼¼ÄÜÉ˺¦£º(L/4+W+J-F/2)*(200+Z/10)/100
¶Ô·½·ÀÓùÁ¦
·ÀÓùF/2
Ñ¡ÓÃÁ¦Á¿
×î¸ß¼¼ÄÜÉ˺¦
×îÖÕÉ˺¦
×î¼ÑÁ¦Á¿
×î¼ÑÖµÉ˺¦
×î¼ÑÖµ×îÖÕÉ˺¦
¹¥»÷²îÖµ
·ÀÓùF1
0
16352
42669
68271
12340
46621
74594
6323
·ÀÓùF2
500
16352
37829
60527
13340
40043
64069
3542
·ÀÓùF3
1000
16352
32989
52783
14340
33965
54344
1561
·ÀÓùF4
1500
16352
28149
45039
15340
28387
45420
381
·ÀÓùF5
5000
16352
-5731
-9169
22340
3341
5346
14515
ÒÔսʿΪÀý˵Ã÷£º
ÐòºÅ
Á¦ÖÇ×ܵãÊýC
Á¦Á¿L
ÖÇÁ¦Z
ÎäÆ÷W
¼¼Äܹ¥»÷Á¦J
·ÀÓùF/2
×î¸ß¼¼ÄÜÉ˺¦
×îÖÕÉ˺¦
1
23960
1000
22960
200
120
2000
-35693
-57108
2
23960
3000
20960
200
120
2000
-21353
-34164
3
23960
5000
18960
200
120
2000
-9013
-14420
4
23960
7000
16960
200
120
2000
1327
2124
5
23960
9000
14960
200
120
2000
9667
15468
6
23960
10000
13960
200
120
2000
13087
20940
×î¼ÑÖµ
23960
16340
7620
200
120
2000
23136
37018
ÐÞÕý
24032
16352
7680
200
120
2000
23309
37295
×ܵãÊý
40000
Ãô½Ý±È
0.2
ÌåÁ¦±È
0.20
ÌáÉý±È
1.6
Á¦Á¿
16352
Á¦Á¿ÐÞÕý
16352
Ãô½Ý
8000
Ãô½ÝÐÞÕý
8040
ÌåÁ¦
8000
ÌåÁ¦ÐÞÕý
7928
ÖÇÁ¦
7680
ÖÇÁ¦ÐÞÕý
7680
ͳÂÊ
0
ͳÂÊÐÞÕý
0
×î¸ß¼¼ÄÜÉ˺¦£º(L/4+W+J-F/2)*(200+Z/10)/100
¶Ô·½·ÀÓùÁ¦
·ÀÓùF/2
Ñ¡ÓÃÁ¦Á¿
×î¸ß¼¼ÄÜÉ˺¦
×îÖÕÉ˺¦
×î¼ÑÁ¦Á¿
×î¼ÑÖµÉ˺¦
×î¼ÑÖµ×îÖÕÉ˺¦
¹¥»÷²îÖµ
·ÀÓùF1
0
16352
42669
68271
12340
46621
74594
6323
·ÀÓùF2
500
16352
37829
60527
13340
40043
64069
3542
·ÀÓùF3
1000
16352
32989
52783
14340
33965
54344
1561
·ÀÓùF4
1500
16352
28149
45039
15340
28387
45420
381
·ÀÓùF5
5000
16352
-5731
-9169
22340
3341
5346
14515

