Business Case Study

profilesinister670
FijiGovtWellContracts.xls
Home>Business & Finance homework help>Management homework help>Business Case Study

Well Contract Data

Exhibit 1
Fiji Government Water Well Drilling Contracts
Volume Flavor Purity (particulate PPM) MTBF ISO 5667 Corrosion Resistant Automation Price Wholesaler
1.05 A 110 3 Yes Unknown 1 $23,380 2
1.16 A 100 5 Yes Unknown 1 $27,750 2
1 BBB 100 2 No Unknown 1 $20,700 2
1 BBB 90 2 No Unknown 1 $26,780 2
1 BB 100 2 No Unknown 1 $21,680 2
1.02 BB 100 2 No Unknown 1 $26,010 2
1.18 BB 110 2 No Unknown 1 $20,310 2
1 BB 90 2 No Unknown 1 $21,010 2
1.01 BB 90 2 No Unknown 1 $26,400 2
1.02 BB 100 5 Yes Unknown 1 $30,890 2
1.01 B 100 2 No Unknown 1 $21,920 2
1.02 B 100 2 No Unknown 1 $22,130 2
1.23 B 110 3 Yes Unknown 1 $19,880 2
1 CCC 70 2 No Unknown 1 $27,800 2
1 CCC 80 2 No Unknown 1 $27,450 2
1 CCC 80 2 Yes Unknown 1 $31,250 2
1.12 CC 100 2 Yes Unknown 1 $24,930 2
1.58 CC 110 2 Yes Unknown 1 $26,200 2
1 CC 80 2 No Unknown 1 $23,800 2
1 C 90 2 No Unknown 1 $18,560 2
1.03 AAA 100 2 No Unknown 2 $26,920 2
1.16 AAA 110 2 Yes Unknown 2 $27,140 2
1 AAA 100 3 No Unknown 2 $31,260 2
0.83 AAA 80 3 Yes Unknown 2 $30,410 1
0.81 AAA 80 4 Yes Unknown 2 $30,440 1
1 AA 90 2 No Unknown 2 $30,800 2
1 AA 100 3 No Unknown 2 $22,430 2
1 AA 100 3 No Unknown 2 $27,300 2
1.01 AA 100 3 No Unknown 2 $25,110 2
1.14 AA 100 3 No Unknown 2 $31,120 2
0.81 AA 80 6 Yes Unknown 2 $30,310 1
1.01 AA 100 5 No Unknown 2 $25,110 2
1 AA 110 5 Yes Unknown 2 $23,160 2
1.01 AA 110 5 Yes Unknown 2 $24,950 2
1 AA 90 5 No Unknown 2 $31,050 2
1.06 A 100 2 No Unknown 2 $27,450 2
1 A 100 3 No Unknown 2 $23,590 2
1 A 100 6 No Unknown 2 $21,280 2
0.8 A 70 4 Yes Unknown 2 $30,530 1
0.85 A 80 4 Yes Unknown 2 $30,510 1
1.01 A 100 5 No Unknown 2 $21,490 2
1.04 A 110 5 Yes Unknown 2 $21,620 2
1 BBB 100 6 Yes Unknown 2 $31,360 2
1.01 BBB 100 5 Yes Unknown 2 $31,080 2
1.03 BBB 100 5 Yes Unknown 2 $31,410 2
1.09 BBB 110 5 Yes Unknown 2 $23,300 2
1.11 BBB 110 5 Yes Unknown 2 $24,380 2
1.2 BBB 110 5 Yes Unknown 2 $25,650 2
1.01 BBB 90 5 No Unknown 2 $31,180 2
1 BB 100 3 Yes Unknown 2 $26,250 2
1 BB 80 3 No Unknown 2 $31,350 2
0.82 BB 70 4 Yes Unknown 2 $30,720 1
1.03 BB 100 5 No Unknown 2 $24,510 2
1.19 BB 110 5 Yes Unknown 2 $26,000 2
1 B 100 2 No Unknown 2 $21,700 2
1 B 100 2 No Unknown 2 $23,640 2
1.01 B 100 2 No Unknown 2 $21,920 2
1.16 B 100 2 No Unknown 2 $22,920 2
1.2 B 100 2 No Unknown 2 $30,930 2
1.05 B 100 2 Yes Unknown 2 $24,130 2
1 B 90 2 No Unknown 2 $26,600 2
0.81 B 50 3 Yes Unknown 2 $30,570 1
0.92 B 80 4 Yes Unknown 2 $30,000 1
0.83 B 60 4 Yes Unknown 2 $30,410 1
1.02 B 110 5 Yes Unknown 2 $20,350 2
1.43 B 110 5 Yes Unknown 2 $31,080 2
1.02 B 90 5 No Unknown 2 $31,300 2
1 CCC 100 2 No Unknown 2 $22,280 2
1.02 CCC 100 2 No Unknown 2 $21,000 2
1.15 CCC 100 2 No Unknown 2 $23,680 2
1.25 CCC 110 2 Yes Unknown 2 $23,970 2
1 CCC 90 2 No Unknown 2 $23,100 2
1.01 CCC 90 2 No Unknown 2 $26,540 2
1.04 CCC 100 3 No Unknown 2 $19,660 2
1.15 CCC 90 3 No Unknown 2 $24,670 2
1.16 CCC 100 4 No Unknown 2 $25,840 2
1.21 CCC 100 5 Yes Unknown 2 $30,830 2
1 CCC 80 5 No Unknown 2 $31,080 2
1.21 CC 90 2 No Unknown 2 $24,460 2
1.03 CC 90 6 No Unknown 2 $25,110 2
1.02 CC 90 4 No Unknown 2 $23,330 2
1.04 CC 100 5 Yes Unknown 2 $26,250 2
1.09 CC 100 5 Yes Unknown 2 $24,270 2
1.41 CC 110 5 Yes Unknown 2 $27,040 2
1 CC 80 5 No Unknown 2 $23,800 2
1.06 C 90 2 No Unknown 2 $18,920 2
1 C 60 2 Yes Unknown 2 $26,550 2
1.12 C 80 3 No Unknown 2 $27,650 2
1.01 C 90 6 No Unknown 2 $21,560 2
1.23 C 100 5 Yes Unknown 2 $25,860 2
1.21 C 110 5 Yes Unknown 2 $22,630 2
1.07 C 90 5 No Unknown 2 $23,860 2
1.02 AAA 100 2 No Unknown 3 $31,370 2
1 AAA 100 5 No Unknown 3 $31,260 2
1.03 AAA 100 5 No Unknown 3 $26,920 2
1.01 AA 100 5 No Unknown 3 $25,110 2
1.01 AA 100 5 No Unknown 3 $27,570 2
1.07 AA 90 5 No Unknown 3 $31,380 2
1.06 A 110 3 Yes Unknown 3 $23,600 2
0.87 A 80 6 Yes Unknown 3 $30,070 1
1.01 A 100 5 No Unknown 3 $23,820 2
1.03 BBB 100 2 Yes Unknown 3 $30,820 2
1.01 BBB 110 2 Yes Unknown 3 $19,290 2
1.01 BBB 80 2 No Unknown 3 $31,380 2
0.9 BBB 80 2 Yes No 3 $30,430 1
1.1 BBB 100 5 No No 3 $27,720 2
0.82 BB 50 3 Yes No 3 $30,150 1
1 BB 80 6 No No 3 $31,350 2
0.81 BB 70 4 Yes No 3 $30,360 1
1 B 110 2 Yes No 3 $20,450 2
1.01 CCC 70 3 No No 3 $31,450 2
1 CCC 80 3 No No 3 $24,520 2
1.01 CCC 80 5 No No 3 $31,390 2
1 CC 70 3 No No 3 $26,890 2
1 CC 90 5 No No 3 $22,880 2
1.13 CC 50 5 No No 3 $31,240 2
1.33 C 90 5 No No 3 $26,070 2
1.1 B 110 6 Yes Yes 1 $21,950 2
1.01 AAA 100 2 Yes Yes 2 $31,070 2
1 AA 100 2 No Yes 2 $24,860 2
1.01 AA 110 3 No Yes 2 $22,520 2
0.8 AA 80 4 Yes Yes 2 $30,640 1
0.81 AA 80 4 Yes Yes 2 $30,510 1
1 A 100 2 No Yes 2 $23,060 2
0.9 A 80 2 Yes Yes 2 $30,810 1
1.01 A 90 6 No Yes 2 $31,110 2
1.04 BBB 100 6 Yes Yes 2 $30,840 2
1.03 BBB 100 5 Yes Yes 2 $30,820 2
1.19 BB 100 2 No Yes 2 $30,850 2
0.9 BB 80 2 Yes Yes 2 $30,560 1
0.91 BB 80 3 Yes Yes 2 $30,380 1
0.9 BB 80 4 Yes Yes 2 $30,430 1
1.2 B 100 2 No Yes 2 $30,930 2
0.9 B 70 3 Yes Yes 2 $30,810 1
1 B 80 3 No Yes 2 $31,270 2
1.01 B 80 3 No Yes 2 $31,020 2
1.01 B 100 5 Yes Yes 2 $26,510 2
1.11 B 80 5 No Yes 2 $31,220 2
1 CCC 70 2 No Yes 2 $27,800 2
1 CCC 80 2 No Yes 2 $25,910 2
1.05 CCC 100 3 No Yes 2 $19,850 2
1.05 CCC 100 5 Yes Yes 2 $26,930 2
1 CCC 70 5 No Yes 2 $31,140 2
1 CCC 80 5 No Yes 2 $31,080 2
1.22 CC 100 2 No Yes 2 $25,160 2
1.01 CC 70 2 No Yes 2 $26,680 2
1 CC 100 5 Yes Yes 2 $22,260 2
1.26 CC 100 5 Yes Yes 2 $31,250 2
1.23 CC 80 5 Yes Yes 2 $31,370 2
1 C 100 5 Yes Yes 2 $20,490 2
0.8 BB 60 6 Yes Yes 5 $30,800 1
0.88 B 70 6 Yes Yes 5 $30,420 1
0.8 B 50 6 Yes Yes 5 $30,310 1
0.8 B 50 6 Yes Yes 5 $30,310 1
0.81 B 50 6 Yes Yes 5 $30,530 1
0.8 AAA 80 6 Yes Yes 3 $30,080 1
0.8 AAA 80 4 Yes Yes 3 $30,120 1
1.01 AA 100 3 Yes Yes 3 $30,980 2
0.8 AA 80 4 Yes Yes 3 $30,620 1
0.8 AA 80 4 Yes Yes 3 $30,710 1
1.02 AA 100 5 No Yes 3 $25,860 2
1.15 AA 100 5 No Yes 3 $31,400 2
0.84 A 70 3 Yes Yes 3 $30,100 1
1.14 A 100 6 No Yes 3 $26,890 2
0.81 A 70 4 Yes Yes 3 $30,270 1
0.8 A 70 4 Yes Yes 3 $30,220 1
1.1 A 110 5 Yes Yes 3 $26,170 2
1.01 A 90 5 No Yes 3 $26,000 2
0.9 BBB 80 2 Yes Yes 3 $30,430 1
1.01 BBB 100 3 No Yes 3 $23,630 2
1.01 BBB 100 6 No Yes 3 $23,630 2
0.8 BBB 70 6 Yes Yes 3 $30,350 1
0.81 BBB 70 6 Yes Yes 3 $30,040 1
0.81 BBB 80 6 Yes Yes 3 $30,790 1
0.85 BBB 80 6 Yes Yes 3 $30,140 1
1.1 BBB 100 5 No Yes 3 $25,740 2
1 BBB 100 5 Yes Yes 3 $27,790 2
1 BBB 100 5 Yes Yes 3 $31,010 2
1.12 BBB 100 5 Yes Yes 3 $31,120 2
1.1 BBB 110 5 Yes Yes 3 $23,510 2
0.91 BB 80 2 Yes Yes 3 $30,890 1
1.01 BB 80 3 No Yes 3 $30,860 2
1.03 BB 100 6 No Yes 3 $23,670 2
0.8 BB 70 4 Yes Yes 3 $30,860 1
0.8 BB 50 4 Yes Yes 3 $30,590 1
1.1 BB 100 5 Yes Yes 3 $31,240 2
1.05 BB 110 5 Yes Yes 3 $20,650 2
1.17 BB 110 5 Yes Yes 3 $23,010 2
0.92 B 80 3 Yes Yes 3 $30,000 1
1 B 80 3 No Yes 3 $31,270 2
0.9 B 80 3 Yes Yes 3 $30,690 1
0.91 B 80 6 Yes Yes 3 $30,440 1
0.8 B 50 6 Yes Yes 3 $30,670 1
0.9 B 70 4 Yes Yes 3 $30,280 1
0.9 B 80 4 Yes Yes 3 $30,690 1
1.01 CCC 80 6 No Yes 3 $31,390 2
0.91 CCC 70 4 Yes Yes 3 $30,230 1
0.92 CCC 70 4 Yes Yes 3 $30,910 1
0.9 CCC 60 4 Yes Yes 3 $30,060 1
1.04 CCC 70 5 No Yes 3 $31,420 2
1 CCC 80 5 No Yes 3 $27,720 2
1.01 CCC 80 5 No Yes 3 $31,390 2
1.01 CCC 80 5 No Yes 3 $31,390 2
1.01 CCC 80 5 No Yes 3 $31,390 2
1.01 CCC 90 5 No Yes 3 $26,250 2
1 CC 110 2 Yes Yes 3 $19,180 2
1 CC 80 6 Yes Yes 3 $26,820 2
1.04 CC 100 5 No Yes 3 $23,080 2
1.02 CC 80 5 No Yes 3 $26,290 2
1 CC 80 5 Yes Yes 3 $27,450 2
1.01 CC 80 5 Yes Yes 3 $31,350 2
1.11 CC 80 5 Yes Yes 3 $31,080 2
1.14 C 110 5 Yes Yes 3 $24,370 2
1.07 C 80 5 Yes Yes 3 $27,700 2
1.04 AAA 100 6 No Yes 4 $27,720 2
1.02 AAA 90 6 No Yes 4 $31,190 2
0.8 AAA 80 4 Yes Yes 4 $30,120 1
1.01 AAA 100 5 No Yes 4 $26,920 2
0.81 AA 80 6 Yes Yes 4 $30,290 1
0.81 AA 80 6 Yes Yes 4 $30,290 1
0.85 AA 80 6 Yes Yes 4 $30,510 1
0.81 AA 70 4 Yes Yes 4 $30,790 1
0.82 A 80 6 Yes Yes 4 $30,040 1
1.04 A 90 6 No Yes 4 $30,930 2
0.81 A 70 4 Yes Yes 4 $30,490 1
1.02 BBB 100 6 No Yes 4 $26,250 2
0.82 BBB 70 6 Yes Yes 4 $30,150 1
0.83 BBB 80 6 Yes Yes 4 $30,140 1
1.04 BB 100 6 No Yes 4 $23,900 2
1.01 BB 100 5 No Yes 4 $23,210 2
0.82 B 60 6 Yes Yes 4 $30,850 1
0.9 CCC 60 3 Yes Yes 4 $30,640 1
1 CCC 80 6 No Yes 4 $31,080 2
1.01 CCC 80 6 No Yes 4 $31,390 2
1.01 CCC 80 6 No Yes 4 $31,390 2
1.01 CCC 80 6 No Yes 4 $24,760 2
1.01 CCC 70 5 No Yes 4 $31,110 2
1.04 CCC 70 5 No Yes 4 $30,890 2
1.01 CC 70 6 No Yes 4 $27,160 2
1.02 CC 60 6 No Yes 4 $30,930 2

Data description

Data info
Volume This is the volume rating describing how much water the well can produce
Flavor AAA to A = Flavorless, Odorless
BBB to B = Near Flavorless, near odorless
CCC to C = Moderate mineral flavors or odors (e.g. Sulfuric, Metalic, other)
Below C = notable undesirable flavors or odors
Purity Particulate matter Parts Per Million that pass through the filtration system
MTBF Mean Time Between Failure - Manufacturer's rating for the installed well system
ISO 5667 Is the installed well system ISO 5667-5: 2006 certified as compliant with standards
Corrosion Does the installed system use the latest materials and coatings for corrosion resistance
Automation 1 = Completely user serviced with periodic maintenance required
5 = Completely automated and self-contained processes with no user intervention needed
Price Contract price for installation of the contracted well
Wholesale Wholesaler ID number