0% found this document useful (0 votes)
6 views8 pages

Financial Scheduling Analysis for Shrimp Plant

The document contains charts showing projected costs over time for three different project schedules: Early Start, Late Start, and Leveled. The Leveled chart shows costs leveling out around $63,000 after 25 days and $175,000 after 75 days. A table shows the total projected cost is $349,551.46 after 92 days for the Leveled schedule. It analyzes the project completion percentage and cost at 25, 50, and 75 days for each schedule.

Uploaded by

jantonio118
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
6 views8 pages

Financial Scheduling Analysis for Shrimp Plant

The document contains charts showing projected costs over time for three different project schedules: Early Start, Late Start, and Leveled. The Leveled chart shows costs leveling out around $63,000 after 25 days and $175,000 after 75 days. A table shows the total projected cost is $349,551.46 after 92 days for the Leveled schedule. It analyzes the project completion percentage and cost at 25, 50, and 75 days for each schedule.

Uploaded by

jantonio118
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Chart Title

$400,000

$350,000

$300,000

$250,000

$200,000
$

$150,000

$100,000

$50,000

$0
3 15 27 39 5 1 63 75 87 99 11 2 3 3 5 4 7 59 71 83 95 0 7 1 9 3 1 4 3 5 5 67
1 1 1 1 1 1 1 1 2 2 2 2 2 2

Dias
Inicio Temprano Inicio Tardio Nivelado
Programacin Financiera mas Temprana
$400,000

$350,000

$300,000

$250,000

$200,000
$

$150,000

$100,000

$50,000

$0
3 15 2 7 39 51 63 75 87 99 11 2 3 3 5 47 59 7 1 83 95 0 7 19 3 1 4 3 55 67
1 1 1 1 1 1 1 1 2 2 2 2 2 2

Dias
Inicio Tardio
$400,000

$350,000

$300,000

$250,000

$200,000
$

$150,000

$100,000

$50,000

$0
3 15 2 7 39 51 63 75 87 99 11 2 3 3 5 47 59 7 1 83 95 0 7 19 3 1 4 3 55 67
1 1 1 1 1 1 1 1 2 2 2 2 2 2

Dias
NIVELADO
$400,000.00

$350,000.00

$300,000.00

$250,000.00

$200,000.00
$

$150,000.00

$100,000.00

$50,000.00

$-
3 15 27 39 51 63 75 87 99 11 2 3 3 5 47 59 71 8 3 9 5 0 7 1 9 31 43 55 6 7
1 1 1 1 1 1 1 1 2 2 2 2 2 2

Dias
PERT/Cost Analysis for Planta Procesadora de camaron (Using Normal Time)

9/10/2017 Project Time Cost Schedul Cost Schedul Total Cost Total Cost
20:23:12 in day Based on ES Based on LS Based on ES Based on LS NIVELADO
1 3 $75 $75 $75 $75 $ 75.00
2 6 $75 $75 $150 $150 $ 150.00
3 9 $92.14 $92.14 $242.14 $242.14 $ 242.14
4 12 $75 $75 $317.14 $317.14 $ 317.14
5 15 $482.27 $382.27 $799.41 $699.41 $ 749.41
6 18 $200 $125 $999.41 $824.41 $ 911.91
7 21 $200 $150 $1,199.41 $974.41 $ 1,086.91
8 24 $149.98 $149.98 $1,349.39 $1,124.39 $ 1,236.89
9 27 $166.61 $166.61 $1,516 $1,291 $ 1,403.50
10 30 $164.96 $164.96 $1,680.96 $1,455.96 $ 1,568.46
11 33 $469.12 $169.14 $2,150.07 $1,625.10 $ 1,887.59
12 36 $602.42 $185.81 $2,752.49 $1,810.91 $ 2,281.70
13 39 $554.92 $104.99 $3,307.41 $1,915.90 $ 2,611.66
14 42 $554.95 $121.65 $3,862.36 $2,037.55 $ 2,949.96
15 45 ### $147.81 ### $2,185.36 $ 61,080.62
16 48 $395.80 $242.47 ### $2,427.83 $ 61,399.75
17 51 $348.04 $184.70 ### $2,612.53 $ 61,666.12
18 54 $504.15 $154.15 ### $2,766.68 $ 61,995.27
19 57 $454.15 $154.15 ### $2,920.83 $ 62,299.42
20 60 $560.14 $154.15 ### $3,074.98 $ 62,656.57
21 63 $474.80 $154.15 ### $3,229.13 $ 62,971.04
22 66 $242.48 $154.15 ### $3,383.28 $ 63,169.35
23 69 $304.15 $154.15 ### $3,537.43 $ 63,398.50
24 72 $287.48 $154.15 ### $3,691.58 $ 63,619.32
25 75 $254.15 $154.15 ### $3,845.72 $ 63,823.47
26 78 $545.71 $305.72 ### $4,151.44 $ 64,249.18
27 81 $708.86 $608.85 ### $4,760.29 $ 64,908.04
28 84 $688.86 $608.85 ### $5,369.15 $ 65,556.90
29 87 $728.85 $608.85 ### $5,978.00 $ 66,225.75
30 90 $728.85 $608.85 ### $6,586.86 $ 66,894.61
31 93 $728.85 $608.85 ### $7,195.71 $ 67,563.46
32 96 $5,712.50 $5,592.50 ### $12,788.21 $ 73,215.96
33 99 $8,204.32 $8,084.32 ### $20,872.53 $ 81,360.28
34 102 $8,204.32 $8,084.32 ### $28,956.86 $ 89,504.61
35 105 $8,184.32 $8,084.32 ### $37,041.18 $ 97,638.94
36 108 $8,084.32 $8,084.32 ### $45,125.50 $ 105,723.26
37 111 $3,755.53 $3,755.53 ### $48,881.03 $ 109,478.79
38 114 $1,591.13 $1,591.13 ### $50,472.16 $ 111,069.92
39 117 $1,591.13 $1,591.13 ### $52,063.29 $ 112,661.05
40 120 $2,829.66 $2,829.66 ### $54,892.95 $ 115,490.70
41 123 $5,306.71 $5,306.71 ### $60,199.66 $ 120,797.42
42 126 $2,638.60 $2,638.60 ### $62,838.26 $ 123,436.02
43 129 $1,304.55 $1,304.55 ### $64,142.80 $ 124,740.57
44 132 $1,304.55 $1,304.55 ### $65,447.35 $ 126,045.12
45 135 $1,304.55 $1,304.55 ### $66,751.90 $ 127,349.66
46 138 $1,304.55 $1,304.55 ### $68,056.45 $ 128,654.21
47 141 $1,304.55 $1,304.55 ### $69,360.99 $ 129,958.76
48 144 $1,304.55 $1,304.55 ### $70,665.54 $ 131,263.30
49 147 $1,304.55 $1,304.55 ### $71,970.09 $ 132,567.85
50 150 $2,889.98 $2,889.98 ### $74,860.06 $ 135,457.83
51 153 $2,889.98 $2,889.98 ### $77,750.04 $ 138,347.81
52 156 $2,889.98 $2,889.98 ### $80,640.02 $ 141,237.79
53 159 $987.13 $1,053.80 ### $81,693.81 $ 142,258.25
54 162 $35.70 $135.69 ### $81,829.50 $ 142,343.95
55 165 $35.70 $135.69 ### $81,965.19 $ 142,429.64
56 168 $35.70 $135.70 ### $82,100.88 $ 142,515.34
57 171 $35.70 $135.70 ### $82,236.58 $ 142,601.04
58 174 $1,450 $1,550.00 ### $83,786.58 $ 144,101.04
59 177 $1,450 $1,583.33 ### $85,369.91 $ 145,617.71
60 180 $1,450 $1,600 ### $86,969.91 $ 147,142.71
61 183 $1,450 $1,550 ### $88,519.91 $ 148,642.71
62 186 $178.42 $284.41 ### $88,804.32 $ 148,874.12
63 189 $206.54 $310.53 ### $89,114.85 $ 149,132.66
64 192 $262.80 $351.13 ### $89,465.98 $ 149,439.63
65 195 $2,324.74 $2,474.74 ### $91,940.73 $ 151,839.38
66 198 $3,355.71 $3,489.05 ### $95,429.77 $ 155,261.75
67 201 $4,821.39 $4,921.40 ### ### $ 160,133.15
68 204 $7,752.74 $7,992.74 ### ### $ 168,005.90
69 207 $7,752.74 $7,852.75 ### ### $ 175,808.65
70 210 $7,752.74 $7,899.41 ### ### $ 183,634.73
71 213 $7,752.74 $8,072.72 ### ### $ 191,547.47
72 216 $5,218.49 $5,505.14 ### ### $ 196,909.28
73 219 $149.97 $473.28 ### ### $ 197,220.90
74 222 $149.97 $563.26 ### ### $ 197,577.52
75 225 $88,037.07 ### ### ### $ 299,600.58
76 228 $336.64 $88,203.74 ### ### $ 343,870.77
77 231 $193.31 $393.31 ### ### $ 344,164.08
78 234 $100 $100 ### ### $ 344,264.08
79 237 $466.66 $400 ### ### $ 344,697.41
80 240 $900 $900 ### ### $ 345,597.41
81 243 $466.66 $433.33 ### ### $ 346,047.41
82 246 $433.32 $349.98 ### ### $ 346,439.05
83 249 $499.98 $399.97 ### ### $ 346,889.02
84 252 $300 $433.31 ### ### $ 347,255.68
85 255 $300 $453.31 ### ### $ 347,632.33
86 258 $300 $599.96 ### ### $ 348,082.32
87 261 $240 $403.32 ### ### $ 348,403.97
88 264 $99.99 $119.99 ### ### $ 348,513.97
89 267 $99.99 $366.66 ### ### $ 348,747.30
90 270 $139.99 $373.32 ### ### $ 349,003.96
91 273 $113.33 $463.33 ### ### $ 349,292.30
92 276 $80 $438.32 ### ### $ 349,551.46
25 50 75
### $189,251.97 $235,420.63
35% 54% 67%

$3,537.43 $68,056.45 $116,196.66


1.0% 19.5% 33.2%

$63,398.50 $ 128,654.21 $ 175,808.65


18% 37% 50%

You might also like