Số lượng vận chuyển kho đến cây xăng

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 13

Số lượng vận chuyển kho đế

Đơn vị ngàn đồng/ng A B C D Lượng xăn A B


Kho Q Bình Tân 100 200 120 300 250 100 30
Kho Q Bình Thạnh 200 350 150 500 100 0 0
Kho Q8 400 300 300 400 400 0 40
Nhu cầu tiêu thụ 100 70 100 120 100 70

YC1: Từ 1 cây xăng thì Tổng săn chuy


YC2: Lượng xăng ở các cây xăng lớn
YC3: Lượng xăng >=0
lượng vận chuyển kho đến cây xăng Chi phí
C D Tổng A B C D Tổng
0 120 250 10000 6000 0 36000 52000
100 0 100 0 0 15000 0 15000
0 0 40 0 12000 0 0 12000
100 120 390 10000 18000 15000 36000 79000

cây xăng thì Tổng săn chuyển đến các cây xăng nhỏ hơn trữ lượng kho đó
ng xăng ở các cây xăng lớn hơn hoặc bằng nhu cầu tiêu thụ
Mua xe 15000 Phí 2000 C1
N(tháng) 48 Thực nhận 13000
r(%/năm) 15% C2
r(%/tháng) 0.0125
a.PMT,
PPM $417.46
Thong thuong Hàm

Năm Nợ gốc vào


Hoàn trả đầu tháng
Thanh
toán vào
Năm
cuối
Nợ gốc vào tháng
đầu tháng Lãi vay Nợ gốc
0 -13000 0
1 15000 $417.46 187.5 $230.0 1 $15,000
2 $14,770.04 $417.46 $184.63 $232.8 2 $14,770.04
3 $14,537.20 $417.46 $181.72 $235.7 3 $14,537.20
4 $14,301.46 $417.46 $178.77 $238.7 4 $14,301.46
5 $14,062.76 $417.46 $175.78 $241.7 5 $14,062.76
6 $13,821.09 $417.46 $172.76 $244.7 6 $13,821.09
7 $13,576.39 $417.46 $169.70 $247.8 7 $13,576.39
8 $13,328.63 $417.46 $166.61 $250.9 8 $13,328.63
9 $13,077.78 $417.46 $163.47 $254.0 9 $13,077.78
10 $12,823.79 $417.46 $160.30 $257.2 10 $12,823.79
11 $12,566.63 $417.46 $157.08 $260.4 11 $12,566.63
12 $12,306.25 $417.46 $153.83 $263.6 12 $12,306.25
13 $12,042.62 $417.46 $150.53 $266.9 13 $12,042.62
14 $11,775.69 $417.46 $147.20 $270.3 14 $11,775.69
15 $11,505.42 $417.46 $143.82 $273.6 15 $11,505.42
16 $11,231.78 $417.46 $140.40 $277.1 16 $11,231.78
17 $10,954.71 $417.46 $136.93 $280.5 17 $10,954.71
18 $10,674.19 $417.46 $133.43 $284.0 18 $10,674.19
19 $10,390.15 $417.46 $129.88 $287.6 19 $10,390.15
20 $10,102.57 $417.46 $126.28 $291.2 20 $10,102.57
21 $9,811.39 $417.46 $122.64 $294.8 21 $9,811.39
22 $9,516.57 $417.46 $118.96 $298.5 22 $9,516.57
23 $9,218.07 $417.46 $115.23 $302.2 23 $9,218.07
24 $8,915.83 $417.46 $111.45 $306.0 24 $8,915.83
25 $8,609.82 $417.46 $107.62 $309.8 25 $8,609.82
26 $8,299.98 $417.46 $103.75 $313.7 26 $8,299.98
27 $7,986.27 $417.46 $99.83 $317.6 27 $7,986.27
28 $7,668.64 $417.46 $95.86 $321.6 28 $7,668.64
29 $7,347.03 $417.46 $91.84 $325.6 29 $7,347.03
30 $7,021.41 $417.46 $87.77 $329.7 30 $7,021.41
31 $6,691.72 $417.46 $83.65 $333.8 31 $6,691.72
32 $6,357.90 $417.46 $79.47 $338.0 32 $6,357.90
33 $6,019.91 $417.46 $75.25 $342.2 33 $6,019.91
34 $5,677.70 $417.46 $70.97 $346.5 34 $5,677.70
35 $5,331.21 $417.46 $66.64 $350.8 35 $5,331.21
36 $4,980.39 $417.46 $62.25 $355.2 36 $4,980.39
37 $4,625.18 $417.46 $57.81 $359.6 37 $4,625.18
38 $4,265.54 $417.46 $53.32 $364.1 38 $4,265.54
39 $3,901.39 $417.46 $48.77 $368.7 39 $3,901.39
40 $3,532.70 $417.46 $44.16 $373.3 40 $3,532.70
41 $3,159.40 $417.46 $39.49 $378.0 41 $3,159.40
42 $2,781.43 $417.46 $34.77 $382.7 42 $2,781.43
43 $2,398.74 $417.46 $29.98 $387.5 43 $2,398.74
44 $2,011.26 $417.46 $25.14 $392.3 44 $2,011.26
45 $1,618.94 $417.46 $20.24 $397.2 45 $1,618.94
46 $1,221.71 $417.46 $15.27 $402.2 46 $1,221.71
47 $819.52 $417.46 $10.24 $407.2 47 $819.52
48 $412.31 $417.46 $5.15 $412.3 48 $412.31
49 $0.00 $417.46 $0.00 $417.5 49 $0.00
r 2% <--Giá trị bất kỳ
NPV ($0.00)
IRR 2%

Hoan trả
Thanh
toán vào
cuối năm Lãi vay Nợ gốc

$417.46 $187.50 $229.96


$417.46 $184.63 $232.84
$417.46 $181.72 $235.75
$417.46 $178.77 $238.69
$417.46 $175.78 $241.68
$417.46 $172.76 $244.70
$417.46 $169.70 $247.76
$417.46 $166.61 $250.85
$417.46 $163.47 $253.99
$417.46 $160.30 $257.16
$417.46 $157.08 $260.38
$417.46 $153.83 $263.63
$417.46 $150.53 $266.93
$417.46 $147.20 $270.27
$417.46 $143.82 $273.64
$417.46 $140.40 $277.06
$417.46 $136.93 $280.53
$417.46 $133.43 $284.03
$417.46 $129.88 $287.58
$417.46 $126.28 $291.18
$417.46 $122.64 $294.82
$417.46 $118.96 $298.50
$417.46 $115.23 $302.24
$417.46 $111.45 $306.01
$417.46 $107.62 $309.84
$417.46 $103.75 $313.71
$417.46 $99.83 $317.63
$417.46 $95.86 $321.60
$417.46 $91.84 $325.62
$417.46 $87.77 $329.69
$417.46 $83.65 $333.81
$417.46 $79.47 $337.99
$417.46 $75.25 $342.21
$417.46 $70.97 $346.49
$417.46 $66.64 $350.82
$417.46 $62.25 $355.21
$417.46 $57.81 $359.65
$417.46 $53.32 $364.14
$417.46 $48.77 $368.69
$417.46 $44.16 $373.30
$417.46 $39.49 $377.97
$417.46 $34.77 $382.69
$417.46 $29.98 $387.48
$417.46 $25.14 $392.32
$417.46 $20.24 $397.22
$417.46 $15.27 $402.19
$417.46 $10.24 $407.22
$417.46 $5.15 $412.31
$417.46 Err:502 Err:502
Mua xe 15000
N(tháng) 48
r(%/năm) 15%
r(%/tháng) 0.0125
a.PMT,
PPM $417.46
Thong thuong Hàm

Thanh
Năm Nợ gốc vào toán vào
Hoàn trả đầu tháng cuối năm
Thanh
toán vào
Năm
cuối
Nợ gốc vào tháng
đầu tháng Lãi vay Nợ gốc
0
0 1 $15,000.00 $417.46
1 15000 $417.46 187.5 $230.0 2 $14,770.04 $417.46
2 $14,770.04 $417.46 $184.63 $232.8 3 $14,537.20 $417.46
3 $14,537.20 $417.46 $181.72 $235.7 4 $14,301.46 $417.46
4 $14,301.46 $417.46 $178.77 $238.7 5 $14,062.76 $417.46
5 $14,062.76 $417.46 $175.78 $241.7 6 $13,821.09 $417.46
6 $13,821.09 $417.46 $172.76 $244.7 7 $13,576.39 $417.46
7 $13,576.39 $417.46 $169.70 $247.8 8 $13,328.63 $417.46
8 $13,328.63 $417.46 $166.61 $250.9 9 $13,077.78 $417.46
9 $13,077.78 $417.46 $163.47 $254.0 10 $12,823.79 $417.46
10 $12,823.79 $417.46 $160.30 $257.2 11 $12,566.63 $417.46
11 $12,566.63 $417.46 $157.08 $260.4 12 $12,306.25 $417.46
12 $12,306.25 $417.46 $153.83 $263.6 13 $12,042.62 $417.46
13 $12,042.62 $417.46 $150.53 $266.9 14 $11,775.69 $417.46
14 $11,775.69 $417.46 $147.20 $270.3 15 $11,505.42 $417.46
15 $11,505.42 $417.46 $143.82 $273.6 16 $11,231.78 $417.46
16 $11,231.78 $417.46 $140.40 $277.1 17 $10,954.71 $417.46
17 $10,954.71 $417.46 $136.93 $280.5 18 $10,674.19 $417.46
18 $10,674.19 $417.46 $133.43 $284.0 19 $10,390.15 $417.46
19 $10,390.15 $417.46 $129.88 $287.6 20 $10,102.57 $417.46
20 $10,102.57 $417.46 $126.28 $291.2 21 $9,811.39 $417.46
21 $9,811.39 $417.46 $122.64 $294.8 22 $9,516.57 $417.46
22 $9,516.57 $417.46 $118.96 $298.5 23 $9,218.07 $417.46
23 $9,218.07 $417.46 $115.23 $302.2 24 $8,915.83 $417.46
24 $8,915.83 $417.46 $111.45 $306.0 25 $8,609.82 $417.46
25 $8,609.82 $417.46 $107.62 $309.8 26 $8,299.98 $417.46
26 $8,299.98 $417.46 $103.75 $313.7 27 $7,986.27 $417.46
27 $7,986.27 $417.46 $99.83 $317.6 28 $7,668.64 $417.46
28 $7,668.64 $417.46 $95.86 $321.6 29 $7,347.03 $417.46
29 $7,347.03 $417.46 $91.84 $325.6 30 $7,021.41 $417.46
30 $7,021.41 $417.46 $87.77 $329.7 31 $6,691.72 $417.46
31 $6,691.72 $417.46 $83.65 $333.8 32 $6,357.90 $417.46
32 $6,357.90 $417.46 $79.47 $338.0 33 $6,019.91 $417.46
33 $6,019.91 $417.46 $75.25 $342.2 34 $5,677.70 $417.46
34 $5,677.70 $417.46 $70.97 $346.5 35 $5,331.21 $417.46
35 $5,331.21 $417.46 $66.64 $350.8 36 $4,980.39 $417.46
36 $4,980.39 $417.46 $62.25 $355.2 37 $4,625.18 $417.46
37 $4,625.18 $417.46 $57.81 $359.6 38 $4,265.54 $417.46
38 $4,265.54 $417.46 $53.32 $364.1 39 $3,901.39 $417.46
39 $3,901.39 $417.46 $48.77 $368.7 40 $3,532.70 $417.46
40 $3,532.70 $417.46 $44.16 $373.3 41 $3,159.40 $417.46
41 $3,159.40 $417.46 $39.49 $378.0 42 $2,781.43 $417.46
42 $2,781.43 $417.46 $34.77 $382.7 43 $2,398.74 $417.46
43 $2,398.74 $417.46 $29.98 $387.5 44 $2,011.26 $417.46
44 $2,011.26 $417.46 $25.14 $392.3 45 $1,618.94 $417.46
45 $1,618.94 $417.46 $20.24 $397.2 46 $1,221.71 $417.46
46 $1,221.71 $417.46 $15.27 $402.2 47 $819.52 $417.46
47 $819.52 $417.46 $10.24 $407.2 48 $412.31 $417.46
48 $412.31 $417.46 $5.15 $412.3 49 $0.00 $417.46
49 $0.00 $417.46 $0.00 $417.5
Hoan trả

Lãi vay Nợ gốc

$187.50 $229.96
$184.63 $232.84
$181.72 $235.75
$178.77 $238.69
$175.78 $241.68
$172.76 $244.70
$169.70 $247.76
$166.61 $250.85
$163.47 $253.99
$160.30 $257.16
$157.08 $260.38
$153.83 $263.63
$150.53 $266.93
$147.20 $270.27
$143.82 $273.64
$140.40 $277.06
$136.93 $280.53
$133.43 $284.03
$129.88 $287.58
$126.28 $291.18
$122.64 $294.82
$118.96 $298.50
$115.23 $302.24
$111.45 $306.01
$107.62 $309.84
$103.75 $313.71
$99.83 $317.63
$95.86 $321.60
$91.84 $325.62
$87.77 $329.69
$83.65 $333.81
$79.47 $337.99
$75.25 $342.21
$70.97 $346.49
$66.64 $350.82
$62.25 $355.21
$57.81 $359.65
$53.32 $364.14
$48.77 $368.69
$44.16 $373.30
$39.49 $377.97
$34.77 $382.69
$29.98 $387.48
$25.14 $392.32
$20.24 $397.22
$15.27 $402.19
$10.24 $407.22
$5.15 $412.31
Err:502 Err:502
Câu 4.3
0 1 2 3 4 5
-500 600 300 300 200 -1000

r 10%
NPV $34.46

r 5.00% 15.00% 25% 35.00% 45.00% 55.00% 65.00%


NPV $34.46

IRR1 6%
IRR2 60%
75.00% 85.00%

NPV
1
0.9
0.8
0.7
0.6
0.5
0.4
0.3
0.2
0.1
0
5.00% 15.00% 25.00% 35.00% 45.00% 55.00% 65.00% 75.00% 85.00%

NPV

You might also like