Financial Evaluation of a Project within Grameen phone, Network Operation

View With Charts And Images

Financial Evaluation of a Project within Grameen phone, Network Operation

Overview of the Organization (GrameenPhone Ltd.)

2.1 Company Introduction:

Grameenphone is the largest cellular operator in the country. It is a joint venture enterprise between Telenor and Grameen Telecom Corporation, a non-profit sister concern of the internationally acclaimed microfinance organization and community development bank Grameen Bank. Telenor, the largest telecommunications company in Norway, owns 55.8% shares of Grameenphone, Grameen Telecom owns the remaining 34.2% 2 and the other 10% shares belong to the general retail and institutional investors.

GrameenPhone was the first company to introduce GSM technology in Bangladesh. It was offered the cellular license in Bangladesh by the Ministry of Posts and Telecommunications in the year 1996. Grameenphone launched its service on the Independence day, 26th March, 1997.

It also established the first 24-hour Call Center to support its subscribers. With the slogan Stay Close, stated goal of Grameenphone is to provide affordable telephony to the entire population of Bangladesh.

After almost 10 years of operation, Grameenphone had over 10 million subscribers and it is now the leading telecommunications service provider in the country with more than 29.97 million subscribers as of December 2010.

In the fast-paced world of telecommunications, vibrant and dynamic Corporate Governance practices are an essential ingredient to success. Grameenphone believes in the continued improvement of corporate governance. This in turn has led the Company to commit considerable resources and implement internationally accepted Corporate Standards in its day-to-day operations.

2.2 Shares:

Fig 1: Distribution of GrameenPhone Share

2.3 Vision and Mission Statements:

2.3.1 Vision: To be leading provider of telecommunication services all over Bangladesh with satisfied customers and shareholders, and enthusiastic employees.

2.3.2 Mission: Grameenphone Ltd. aims at providing reliable, widespread, convenient mobile and cost effective telephone services to the people in Bangladesh irrespective of where they live. Such services will also help Bangladesh keep pace with other countries including those in South Africa region and reducing her existing disparity in telecom services between urban and rural areas.

2.4 Purpose of Grameenphone:

· To receive an economic return on its investment.

· To contribute to the economic development of Bangladesh where telecommunication plays an important role.

2.5 History and Major Milestones:

Time Stamp Milestone Achieved
Mar-97Started operation on the independence day of Bangladesh
Jun-98Launched M2M service (without PSTN)
Aug-99Launched first prepaid service in the country
2001Launched WAP service
2002Bangladesh Business Award for “Best Joint Venture Enterprise”
Aug-03Reached 1 million subscribers
Oct-03Launched Prepaid product with PSTN connectivity
Aug-04Reached 2 million subscribers
Apr-05Launch of Youth Product Djuice
Apr-05Launched Electronic Recharge System (Flexi Load)
Sep-05Launched EDGE and Voice SMS
Jan-06Launch of Business and PCO product
Feb-06Launch of Community Information Centers
Jul-06Launch of CellBazaar Service
Feb-07Re-launched Business Solution
Feb-07New VAS launch- Stock Information, Missed Call Alert
Apr-07Re-branding of Djuice
Apr-07Launched Pay for Me Service
Oct-07Reached 16 million subscribers
Jan-08Introduced Black Berry Service to Bangladesh
Mar-08Lowest on-net tariff offer
Apr-08Brand positioning and launching of ‘stay close’ campaign
May-08Launch of ‘Customer Care Campaign’
Jun-08Reached 20 million subscribers
Jan-09Launch of Phone Back Up and In-flight Roaming Service
Feb-09Launched GP Internet Modem
Mar-09Reached 21 million subscribers
Apr-09Launched Internet Modem
Jun-09Launched new Network campaign
Sep-09Launch of Grameenphone Handset
Oct-09Launch of Study Line Service
Jan-10New Prepaid Price Plan Campaign
Mar-10Mobitaka Brand launch with E-ticketing
Apr-10Launch of Internet Minipack
Apr-10Launch of Internet Minipack
Apr-10Introduction of New Generation Grameenphone Internet Modem
May-10Reached 25 million subscriber base
Jun-101st Annual General Meeting of Grameenphone
Jul-10Shift to GP’s new Headquarter, GP House
Jul-10Launch of new Network Campaign
Dec-10Amar Desh Amar Gorbo event held on the occasion of Victory Day

Table 1: History and Major Milestones of Grameenphone

2.6 Strategy:

Grameenphone basic strategy is coverage of both urban and rural areas. In contrast to the “island” strategy followed by some companies, which involves connecting isolated islands of urban coverage through transmission links, Grameenphone builds continuous coverage, cell after cell. While the intensity of coverage may vary from area to area depending on market conditions, the basic strategy of cell-to-cell coverage is applied throughout Grameenphone network.

2.7 People:

The people who are making it happen- the employees- are young, dedicated and energetic. All of them are well educated at home or abroad, with both sexes (genders) and minority groups in Bangladesh being well represented. They know in their hearts that Grameenphone is more than just about phones. This sense of purpose gives them the dedication and the drive, producing the biggest coverage and subscriber- base in the country. Grameenphone knows that the talents and energy of its employees are critical to its operation and treats them accordingly.

2.8 Organogram:

The success story of Grameenphone has been possible due to the alignment and commitment of the different departments collectively. The organization has the following departments to ensure the smooth operations of its services and achieve organizational goals.

Fig. 2: GrameenPhone Organogram

2.9 Values:

· Caring for customers

· Integrity

· Sense of urgency

· Creativity

· Honesty

· Empowerment

· Courage

2.10 Products offered by GrameenPhone:

Grameenphone was the first operator to introduce the pre-paid mobile phone service in Bangladesh in September 1999. Besides smile, Grameenphone also offers a youth based mobile to mobile connectivity within Bangladesh named “Djuice” and postpaid mobile service called “Xplore Postpaid”.

2.10.1 Prepaid and Postpaid Connections:

Xplore : Xplore is a postpaid connection and is available with Mobile to Mobile with BTCL connectivity. BTCL incoming is absolutely free in Xplore.

Shohoj : Grameenphone prepaid connection comes with this pre-activated package where you will be able to talk to any operator number at a low, flat rate of Tk 0.79.

Bondhu : This package with the highest number of F&Fs allows you to talk to your near and dear ones at the lowest rate.

Aapon : One can talk to over 25 million Grameenphone numbers at a very low rate of 49 Paisa per minute.

Baadhon : Grameenphone Ltd. introduces a new package named Baadhon, designed to serve the rural population of Bangladesh.

Smile: The Grameenphone Smile prepaid connection now gives you more freedom, more opportunities and more reasons to smile!!

2.10.2 Business packages:

Business Solutions: We are here to help you grow and win. No matter how unique or diverse your business is, we offer customized solution for you to win the tough war of business.

Ekota : For Small and SOHO enterprises Grameenphone offers a unique package Ekota.

GPPP: GP Public Phone is the package for PCO entrepreneurs.

GPVP : Village Phone Program is a noble effort by tri party (GP-GTC-GB) to eliminate poverty by providing self-employment opportunity.

2.10.3 Other Services:

Internet: GP provides internet service in its coverage area. As it has EDGE/GPRS enabled network, any subscriber can access to internet through this network. Grameenphone was the first mobile operator in Bangladesh to offer EDGE services to its subscribers.

BillPay: A service to enable users to pay their utility bills (Electricity, Gas etc) through mobile.

CellBazaar: Services to enable users sell or buy products through mobile or internet. Various other services like Stock Information, Instant Messaging, SMS Based Alerts/Services, Voice-based Services, Downloads, Music, Cricket Updates, Web SMS, Mobile Backup etc.

Chapter 3: Overview of Network Operation, Grameenphone:

3.1 Structure of Technology Division:

Technology division is a separate division in Grameenphone under Chief Technology Officer (CTO). The structure of it is as below

Fig 3: Organogram of Technology Division

3.2 Structure of Network Operation:

Network Operation is separate department within Technology Division under Director, Network Operation.

Fig 4: Organogram of Network Operation

3.3 Functions of Network Operation:

· O & M support of Network Elements

· Running projects for installation of new Systems

· Maintain GSM features for GSM network.

· Software & hardware update/upgrade

· Vendor escalation and trouble management

Chapter 4: Project Management at GrameenPhone, Network operation

At Network Operation, a typical project follows the following sequences:

1. Formulation of Project Proposal

2. Writing Project Memo

3. Formulating the Project Plan and Follow-up

4.1 Project Proposal:

A project proposal is the first step to initiate a project. Project proposal is meant to obtain a goo d understanding of the project goals, outcomes etc. Project Proposal encompasses the following information

· Project Name and Description

· Financial Information like Capital Expenditure (CaPex), output in the format of Operation Expenditure (OpEx) Savings, Revenue etc.

· Background, Project Goals, Limitations, Risk Factors, Stakeholders involved in the project.

The project proposal for the Battery Units Addition project is as below

Project information:

Project name:Project code / project identification:
Addition of 350 Battery Units in BTSBattery Addition
Associated program or connection with other projects:Project type:
Sponsor:Project Owner:Project Manager:
CTODepartment HeadFaisal Aziz

Key information:

Total budget for project establishment / Scope definition / planning phase (kUSD):Charge to cost location(s):Stipulated total budget for entire project ( BDT):
76 Mn BDTOperations/Technology76 Mn BDT
Expected financial benefit (could be expressed as IRR, NPV, payback time or other):
OpEx Saving of 57 Mn BDT yearly with a Payback Period of 1.98 year. NPV will be BDT 38 Mn and Internal Rate of Return (IRR) and Return on Investment (ROI) will be 42% and 50% respectively.
Start date for establishment / Scope definition / planning phase (D1):End date for establishment / scope definition / planning phase (D2):Stipulated date for delivery of project result (D4):
October 6, 2010October 10, 2010April,2011
Brief description of background and purpose:Focusing upon the goal of “Being Efficient in cost & resources” Technology team feels the necessity to reduce operational expense as much as possible. And with course of time we took a lot of initiatives to reduce the OPEX as well as overall Energy cost. But now management decided to go one step further in energy efficiency program and for this they want to go for addition of Battery Backup Unit as an alternative to Generators as the secondary source of power.

The typical concept of using Generator as a backup to PDB supplied power for running BTS is not cost efficient, because it involves the high cost of fuel and maintenance. In addition, it is an obstacle towards becoming Green by reducing the emission of Carbon Dioxide, which Grameenphone promotes in every sphere of its business. Technology team took a strategy to replace 10% of its 12,000 Generator Backup Unit with Battery Backup Unit by 2012. These systems have the capacity to supply power for running BTS and Air Conditioner in case of a power outage for 48 hours. To implement it in Network we already had an RFQ. That RFQ was floated to 32 vendors and from that comprehensive evaluation we selected a pool of 9 vendors who fulfils the technical standards.

But to achieve the best cost efficiency, we need to install these systems before awarding the maintenance contract (AMC) for the maintenance of these targeted generators to concerned vendors. So for sourcing of these systems technology team have a very short time. But as we already have done a RFQ for Battery Backup Unit and we have a selected pool of 9 technically competent vendors we can eliminate the Technical Evaluation phase and go for commercial evaluation directly. By doing that we can accelerate the whole process and be ready for sourcing a lot earlier. So we the technology teams are proposing for an E-auction directly to on board these systems.

Note: Strategically we also want to include our partner Huawei with the list of competent vendor base upon following criteria:

1. Huawei already have their BTS deployed with these kinds of Backup Power Source with other operators.

2. Moreover Huawei is going to be the sole vendor for BTS. Exploring this product may bring more flexibility in maintaining BTS within their claimed temperature range. With their inclusion in commercial evaluation we will also have the opportunity to explore the better manageability of same vendor products.

3. Our experiences from ongoing and previous projects suggest that it will be very difficult to source this huge no of Ventilation systems from local market within such a short time. So introduction of Huawei will bring more competition in commercial evaluation as well as will provide us to the opportunity to source world class products.

Effect goal:OpEx Saving of 58 Mn BDT yearly after implementation for 3 years
Key deliverables:RFQ, Vendor selection through Commercial Evaluation
Limitations:Sourcing of all the required Battery Units within the timeline

Risk factors:

R. no.Creation dateRisk descriptionActivity / Action
106/11/2010Sourcing of all the Battery Units within agreed timeline
229/11/2010Capability of Vendors to produce amount with this high scale

Relationship with other projects / partners:

Project / partner:Description of relationship:
Generator Maintenance Contract (AMC)The new Battery Units must be sourced and installed before the current Management Contract of existing Generators (AMC) approaches deadline.

Realization of effect goals:

Responsible for realizing effects (proposal):Department Head

Resources in establishment / scope definition / planning phase:

RoleNameUnitPeriod (weeks)Engagement (%)Clarified with providing unit
Project ManagerFaisal AzizOperations
Project MemberAAAAAAOperations
Project MemberBBBBBBBOperations
Project MemberCCCCCCCOperations
Project MemberDDDDDDOperations
Project MemberEEEEEEESourcing
Project MemberFFFFFFFSourcing
Project MemberGGGGGGImplementation
Project MemberHHHHHHHOperations

Steering Committee:

RoleNameUnitComments
ChairpersonChief Technology OfficerProject Sponsor & Head
MemberDepartment HeadProject Owner
MemberHead of SourcingMember
MemberHead of Regional Operation & Maintenance, OperationsMember
MemberSourcingMember

Reporting from Project Manager:

Bi-Weekly meeting & Weekly status report by mail

Authorization:

Finalize Work scope, Launch RFQ, Evaluate & Assessment of Vendor Performance & Initiate Action To Improve, Financial Follow up

Additional important information:

Necessary resources to be selected & assigned as and when necessary from related teams

Attachments to project proposal:

Attachment

no.

Type documentDocument name/ ID (Saved As)Document format
1Project GoalProject Goal.DocMS Word Documents
2Project plan (Tentative)MS Word Documents

Signatures (Date and names):

Project Sponsor:

Approves strategic foundation and the above scope.

Acceptance to start establishment /planning phase is provided:

Chief Technology Officer
Project OwnerDepartment Head
Project Manager

Assumes the responsibility for the project according to the above scope.

Faisal Aziz

4.2 Memo:

The next step involves writing a memo for the project. At Grameenphone Network Operation, an internal MIS tool is used to write the memo for approval from concerned stakeholders. Also, a Financial Evaluation Report is also needed to be submitted along with the memo for evaluation and approval. At any time, the initiator and other concerned stakeholders can view the approval status of the project.

The memo of the project is as below

Request Details

Top of Form

Category:Others
Reference:TE-OP-OP-5485
Title:350 battery addition in BTS
Amount:BDT 75,681,000
Subject:Approval of Vendor Sourcing for 350 battery addition in BTS
Description:Focusing upon the goal of “Being Efficient in cost & resources” Technology team feels the necessity to reduce operational expense as much as possible. And with course of time we took a lot of initiatives to reduce the OPEX as well as overall Energy cost. But now management decided to go one step further in energy efficiency program and for this they want to go for addition of Battery Backup Unit as an alternative to Generators as the secondary source of power.

The typical concept of using Generator as a backup to PDB supplied power for running BTS is not cost efficient, because it involves the high cost of fuel and maintenance. In addition, it is an obstacle towards becoming Green by reducing the emission of Carbon Dioxide, which Grameenphone promotes in every sphere of its business. Technology team took a strategy to replace 10% of its 12,000 Generator Backup Unit with Battery Backup Unit by 2012. These systems have the capacity to supply power for running BTS and Air Conditioner in case of a power outage for 48 hours. To implement it in Network we already had an RFQ. That RFQ was floated to 32 vendors and from that comprehensive evaluation we selected a pool of 9 vendors who fulfils the technical standards.

But to achieve the best cost efficiency, we need to install these systems before awarding the maintenance contract (AMC) for the maintenance of these targeted generators to concerned vendors. So for sourcing of these systems technology team have a very short time. But as we already have done a RFQ for Battery Backup Unit and we have a selected pool of 9 technically competent vendors we can eliminate the Technical Evaluation phase and go for commercial evaluation directly. By doing that we can accelerate the whole process and be ready for sourcing a lot earlier. So we the technology teams are proposing for an E-auction directly to on board these systems.

Note: Strategically we also want to include our partner Huawei with the list of competent vendor base upon following criteria:

2. Huawei already have their BTS deployed with these kinds of Backup Power Source with other operators.

2. Moreover Huawei is going to be the sole vendor for BTS. Exploring this product may bring more flexibility in maintaining BTS within their claimed temperature range. With their inclusion in commercial evaluation we will also have the opportunity to explore the better manageability of same vendor products.

3. Our experiences from ongoing and previous projects suggest that it will be very difficult to source this huge no of Ventilation systems from local market within such a short time. So introduction of Huawei will bring more competition in commercial evaluation as well as will provide us to the opportunity to source world class products.

So we are proposing a list of technically competent vendors who should be directly contacted for Commercial Evaluation

1. Rahimafrooz Energy Services Ltd.

2. Electromechanical Service Ltd.

3. Energypac Power Generation Ltd.

4. Cross World

5. Mega Power Engineering LTD.

6. Navana Iterlinks Ltd

7. Alliance Computer Ltd

8. Swiftex Solution

9. Electrocom Ideas and Technologies Ltd

Requests Status:Pending
Requested By:Faisal Aziz
Request Date:2010-10-07 10:55:52.0
Attachment:
Action History:
SequenceApprover Name Action Comment Action Date
9CEOPending
8Finance HeadPending
7Sourcing HeadPending
6Chief Technology OfficerPending2010-10-14 17:14:49.0
5Head of Business ControlAPPROVEDAlong with this we need to float a new RFQ for this considering the volume of work and the experience from the first one.2010-10-13 15:34:59.0
4Department Head (Network Operation)APPROVED2010-10-10 14:07:09.0
3Unit HeadAPPROVED2010-10-10 12:50:48.0
2SupervisorAPPROVED2010-10-10 12:36:33.0
1Faisal AzizSUBMITTEDSubmitted2010-10-07 11:02:42.0
CC:
  • Supervisor
  • Unit Head
Search Approver:
Search Informed:

Fig 5: Project Memo

4.3 Project Plan:

Project plan details the breakdown of different activities according to schedule and keeps track of those. The Project Plan for “Addition of 350 Battery Units in BTS” is as below

Project information:

Project name:Project code / project identification:
Addition of 350 Battery Units in BTSBattery Addition
Associated program or connection with other projects:Project type:
Generator Maintenance Contract (AMC)
Sponsor:Project Owner:Project Manager:
Chief Technology OfficerDepartment HeadFaisal Aziz
Limitations:· Timeline for sourcing is limited

Fig 6: Project Plan

Chapter 5: Financial Evaluation of the Project

In a climate of increasing financial control, it is more important than ever that investment analysis is of a high standard. Investments can have many risks that can keep away many potential investors. To avoid this to happen, the most accurate financial/economical analysis has to be made. Financial evaluation is a rational method for making choices .Any good commercial organization should be able to identify more viable investment opportunities than it has money to invest in, so it has to choose which projects to fund.

5.1 Objectives of Financial Evaluation:

The objectives of economic evaluation are:

· To decide which investments will make the best use of the organization’s money?

· To ensure that the optimum benefits are available from each of these investments.

· To minimize any risk to the organization.

· To provide a basis for the later analysis of the performance of each investment.

The process of economic evaluation:

· Produces measures of the financial improvement that each project could make to the business.

· Identifies the risks and uncertainties in each project.

· Defines the expected costs and benefits.

The decision maker can the use the results of the evaluation to choose between projects. Financial evaluation helps organizations make the right choices. However, as projects to improve energy efficiency are likely to be competing for funds against other projects, what is really being evaluated is project’s position within a list of possibilities. To give energy projects the best chance of being funded, an economic evaluation should be presented with the proposal. The decision maker will then be able to compare the benefits of the energy project directly with the other investment proposals.

5.2 Key Stages in Financial Evaluation:

Financial evaluation produce financial measures of the potential of each of the possible investments open to the organization. These measures can then be used to decide which projects should be funded and the priority they should be given. Financial evaluation tries to show the benefits of projects in relation to their capital costs; however, it is often difficult to find any single parameter which measures this. There are many different measures that can be used for economic evaluation, each of which highlights a different aspect of a project. No one measure is better than any other, and each as its strengths and weaknesses.

5.2.1 Cash Flow:

The first step in any economic evaluation is to gather the information on the project costs and benefits and calculate the cash flows. This gives a statement of how much money will be spent or will be earned in each year of the project.

To determine the cash flow for a project, the costs and savings must be collected for the years in which they occur. The cash flow for each year is found by adding the savings (Positive amounts) to the costs (Negative amounts) for that year. According to the type of project, prediction of the cash flows becomes more or less difficult. There are even cases where a quantitative estimation is almost impossible and the financial evaluation becomes almost unfeasible.

In our case study we considered battery cells as a substitution investment. The cost savings, namely the conservation and maintenance cost savings are known and they can be predicted with a satisfactory degree of accuracy.

5.2.2 Financial Evaluation Techniques

5.2.2.1 Net Present Value (NPV):

NPV is the difference between the present value of cash inflows and the present value of cash outflows. NPV is used in capital budgeting to analyze the profitability of an investment or project. NPV analysis is sensitive to the reliability of future cash inflows that an investment or project will yield.

Formula:

The NPV is a financial parameter of particular interest to the financial manager, because it indicates the amount that the project will earn for the business over its expected lifetime in today’s money. If the NPV is positive, the project is viable. If the NPV has been calculated using a realistic discount rate, it can provide information on how to finance the project. For example, the current interest rate to borrow the capital required could be used as a realistic discount rate. If the NPV is negative, it would not be worthwhile borrowing the money for the project. A positive NPV would show the project could repay the loan and still give the investing organization a profit.

5.2.2.2 Internal Rate of Return (IRR):

IRR is the discount rate often used in capital budgeting that makes the net present value of all cash flows from a particular project equal to zero. Generally speaking, the higher a project’s internal rate of return, the more desirable it is to undertake the project. As such, IRR can be used to rank several prospective projects a firm is considering. Assuming all other factors are equal among the various projects, the project with the highest IRR would probably be considered the best and undertaken first.

The IRR measures the project’s profitability. It represents the rate of return that money would have to earn if invested outside, or elsewhere in the organization on another project, to be a better investment than the project being proposed. The higher the IRR, the better the project is As with NP, the IRR can help assess ways of financing the project. The IRR can be compared with the current interest rate for borrowing the capital required .If the IRR is lower than this interest rate, the project would lose money if it was financed by borrowing. If the IRR is greater than the cost of borrowing the capital, the project will generate enough income to repay the loan and still provide profit.

5.2.2.3 Payback Period:

It is the length of time required to recover the cost of an investment.

Calculated as:

The easiest financial parameter to calculate is simple payback, which is defined as the capital cost divided by the average annual savings. Using Payback has some obvious benefits like ease of calculation, tangibility and accuracy, but Payback has some serious disadvantages like it takes no account of any savings after the Payback period and it does not take into account any income from reselling the capital asset later on.

Payback, however, is an useful screening method for projects. A project with a Payback of a few months clearly deserves further investigation, whereas a project with a Payback of 10 years would usually have little chance to receiving funding.

5.2.2.4 Return on Investment (ROI):

A performance measure used to evaluate the efficiency of an investment or to compare the efficiency of a number of different investments. To calculate ROI, the benefit (return) of an investment is divided by the cost of the investment; the result is expressed as a percentage or a ratio.

The return on investment formula:

In the above formula “gains from investment”, refers to the proceeds obtained from selling the investment of interest. Return on investment is a very popular metric because of its versatility and simplicity. That is, if an investment does not have a positive ROI, or if there are other opportunities with a higher ROI, then the investment should be not be undertaken.

ROI > 1 means that the is profitable

ROI < 1 means that for the discount rate used the NPV < 0 and the project is not profitable.

5.3 Financial Evaluation of the Targeted Project:

In the Financial Evaluation of the project, Addition of 350 Battery Units in BTS, we have tried to determine whether the project is financially viable by calculating Net Present Value (NPV), Internal Rate of Return (IRR), Payback Period and Return on Investment (ROI) by first determining the Cash Flows during the lifetime of the project. The following information have been taken into consideration while determining the Cash Flows

1. 300 sets of batteries will be make 300 generators free. Therefore, 300 generators will be offloaded by adding these 300 sets of batteries.

2. Battery lifetime has been considered as 36 months but savings is calculated for 32 months considering any los due to any unwanted situation.

3. A portion of these 300 sets will be used just for addition with existing batteries to enhance capacity. Rest sets will be used as replacement of existing batteries where some cells are faulty.

4. After installing 300 sets we’ll make 50 sets free from some sites which will be used to reduce outage in some additional sites.

5. Fuel Cost/Running Hour (RH) is TK. 196 and TK. 225 for Generator and Non-AG (Outage Reduction) respectively.

6. The Weighted Average Cost of Capital (WACC) has been accepted as 15.6% and the lifetime of the project has been taken as 3 years.

7. All the figures are in TK.

5.3.1 Capital Expenditure (CaPex):

Serial NoItem CodeItem NameRequirementStockRequired QuantityUnit CostTotal CostEquivalent BDT
11009313Battery-YUASA- GS SNS500C -(2V 500AH)7,2007,200$146.00$1,051,20073,188,000
21007479Galvanize Battery Rack. Yuasa UXL-5503003006,700.002,010,0002,010,000
31007881PVC CABLE NYY, 1X50 RM (Black)4,2002,9001,300350.00455,000455,000
41002245Cable Shoe-50/103,0001,6001,40020.0028,00028,000
Total75,681,000.35

Table 2: Capital Expenditure Calculation

5.3.2 Generator Deployment Plan:

HeadMajorBattery BackupDeployment PlanDeployment Plan
Sub HeadSubOverallGenerator Off LoadingOutage Reduction (Non AG Sites)
QuantityPlanned Quantity35030050
JanJan000
FebFeb000
MarMar000
AprApr3003000
MayMay50050
JunJun000
JulJul000
AugAug000
SepSep000
OctOct000
NovNov000
DecDec000
QPlanned Quantity35030050

Table 3: Generator Deployment Plan

5.3.3 Detailed Breakdown of Savings:

HeadFUELFUEL SAVINGSGENERATOR MAINTENANCE COST SAVINGSGENERATOR MOBILIZATION COST
Sub HeadSubOverallGenerator Off LoadingOutage Reduction (Battery Re-use)Generator Off LoadingOutage Reduction (Non AG Sites)
SavingsSavings / Unit / Month8928.751176033753002.5522674500
JanJanuary00000
FebFebruary00000
MarMarch00000
AprApril00000
MayMay352800035280000900765.680
JunJune722475070560001687501801531.36225000
JulJuly10921500105840003375002702297.04450000
AugAugust14618250141120005062503603062.72675000
SepSeptember18315000176400006750004503828.4900000
OctOctober22011750211680008437505404594.081125000
NovNovember257085002469600010125006305359.761350000
DecDecember294052502822400011812507206125.441575000
SPlanned Savings294052502822400011812507206125.441575000
Savings HeadElectricity0000
FFuel*11760337500
AGMGenerator Maintenance**003002.5522670
ACMA/C Maintenance0000
RRent0000
OOther0004500

Table 4: Savings Breakdown

5.3.4 Saving Calculation:

Generator Off LoadingTABLE – A : Savings (Generator Off Loading)
Possible Reduction of RH / Day2.00No of Sites 300
Yearly Savings (Fuel)42,336,000
Fuel Cost SavingsFuel Cost / RH196.00Yearly Savings (Generator Maintenance)10,809,188
Monthly Savings11,760.00Total 53,145,188
Maintenance Cost SavingsMaintenance Cost / Year36,030.63
Monthly Savings3,002.55
Total Savings / Month14,762.55
Outage Reduction ( Battery Re-use)TABLE – B : Savings (Outage Reduction – Battery Re-use)
Possible Reduction of PG Run / Day0.50No of Sites 50
Yearly Savings (Fuel)2,025,000
Fuel Cost SavingsFuel Cost / RH225.00Yearly Savings (Generator Maintenance)2,700,000
Monthly Savings3,375.00Total 4,725,000
Mobilization & Other Cost SavingsUnit Cost / RH300.00
Monthly Savings4,500.00
Total Savings / Month7,875.00
Yearly Savings : A + B57870188.16

Table 5: Savings Calculation

5.3.5 Cost Benefit Analysis:

DescriptionInvestmentSavings Year 1Savings Year 2Savings Year 3
Year2011201120122013
Exchange Rate
(a) Cash Inflow
Fuel29,405,25044,361,00044,361,000
Generator Mainten