It project

faisalonka

Unknown-1.pdf

Home >Computer Science homework help >It project

TARSHEED PLATFORM P ropo s e d B y :

Fa i s a l A l f a ye z A l i A lmu t a i r i S a lman A l o t a i b i

2030 INITIATIVE TO REDUCE ENERGY CONSUMPTION

• Our country is aiming to reduce the consumption of electrical energy, and reduce the pollution caused by it.

• Saudis support those initiatives, but they don’t see how to start and contribute.

SAUDI LABEL & STANDARDS CARD I s i t e n o u g h ?

We looked around and found limited efforts to guide people on how to

incorporate those changes in their purchase choices.

A good example is the Saudi Label & Standards Card which is done

through the cooperation between The Saudi Energy Efficiency Center and

the Saudi Standards, Metrology, and Quality Organization

WHAT IS TARSHEED PLATFORM?

T h e I d e a :

Our project and idea is to provide the consumer

with an online platform where ONLY the

appliances that are designated as efficient are sold.

We will work with different sectors in the

government to provide great discounts to

consumers who purchase the appliances from our

website. Additionally, the Saudi citizen who

actively purchases high efficiency appliances will

receive a discount on his/her electricity bill.

O u r P a r t n e r s :

WIN-WIN SITUATION E v e r y o n e i s b e n e f i t e d

• This deal will not be a burden on the government because when

people use efficient appliances, they will consume less energy,

thus the government spending on energy will be less.

• It is merely a process of shifting the funds from spending on

energy to spending on people, which is eventually better

utilization of the money.

FOR THE GOVERNMENT:

• More people use efficient appliances

• Less energy consumption

• Better spending of funds.

FOR THE CITIZENS:

• Getting a high quality and efficient

appliance with a reduced price

• Reduction in the electricity bill for

active participants

• Sense of contribution to the

environment, and participation in

the national initiatives

PROCESS BREAKDOWN

• The user chooses the appliance and purchases it with the discounted price

Consumer Purchase

• The store will receive a notification about the transaction and will package and prepare the shipment

Procurement

• The logistics company will deliver the appliance to the costomer's location and collect the delivery symbolic fee

Delivery

• The transaction will be forwarded to the government to pay the difference of the price back to us to forward it to the vendors

Compensation

• The names of participants will be logged by their Saudi ID number and will be sent to the Saudi Elictricity Company to put their properties on the list of reduced bills.

Participation Registry

PROJECT DOCUMENTS

The Saudi 2030 Vision has a broad goal to reduce energy consumption. One of the main reasons for energy loss is inefficient home appliances. They are cheaper and easier to purchase, however, they increase the electrical bill on the consumer.

This initiative is designed to help the consumer purchase highly efficient appliances by motivating them with discounts on the purchase price and a reduction on the electrical bill.

Team Members

Faisal Alfayz Ali Almutairi Salman Alotaibi

Business Case Expected Goals/Deliverables

After finishing the project, the platform should :

- Allow the consumer to see different appliances from different vendors that are high efficient Including their prices and the amount shouldered by the government. - Be integrated with the vendors system to allow real-time update of inventory - Be integrated with the National Information System to allow linking the amount of purchases to the consumer ID and therefore be eligible for electricity bill reduction. - Be integrated to the Saudi Electricity Company system to allow active participants to request reduction in their bill

Risks & Constraints

Risks that might face the project are:

- Shift in the government direction to reduce energy consumption (Very low) - Resistance from the private sector to import high efficiency appliances (Very low) - Resistance from Saudi consumers to purchase highly efficient appliances (Low) - Refusal of the government to fund the program (Low) - Refusal of the different sectors to integrate their systems with the project (Mild) - Lack of participation from the Saudi Electric Company in the initiative to avoid losing revenues (High)

Milestones

The project milestones are:

- The negotiations with different stakeholders will start early January 2020 and end on mid February. - Upon agreement, the contracts between the project team and stakeholders will be signed on 20 February 2020 - The software will be finalized and tested on 23 March 2020 - The go live of the project will be on 24 March 2020

Project Sponsor Saudi Government (Non For Profit) Date of Start 01-Jan-20

Project Charter Project Name

Project Description

Tarsheed Online Platform

An online platform that allows the consumer to purchase high efficiency electrical appliances and gets a discount on them, in addition to a deduction of the electrical bill for active participants.

Add a Footer 11 11

GANTT CHART

Crea te a Tarsheed Platform Gantt Chart Enter Company Name in cell B2.Tarsheed (ترشيد)

Enter the name of the Project Lead in cell B3. Enter the Project Start date in cell E3. Pooject Start: label is in cell C3. Project Lead:

Project Start: The Disp Display Week: 1

Cells 30 31 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 This row TASK Duration (days) START END M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S

1 Initiating

1.1 Prepare project charter 1 1/1/20 1/1/20

1.2 Defining the business case 3 1/2/20 1/4/20

1.3 Performing feasibility study 10 1/2/20 1/11/20

1.4 Defining stakeholders 3 1/12/20 1/14/20

2 Planning

2.1 Perform cost estimation and management 15 1/15/20 1/29/20

2.2 Conduct meetings with different stakeholders to explain the idea and its benefits 20 1/30/20 2/18/20

2.3 Negotiate with private sector to get reduced prices and integrate ERP 20 1/30/20 2/18/20

2.4 Negotiate a deal with logistics services company to provide delivery to customers 10 1/30/20 2/8/20

2.5 Sign contracts with the different stakehloders based on the negotiations 2 2/19/20 2/20/20

2.6 Build the app and conduct integration testing with the ERP of vendors and logistics 30 2/21/20 3/21/20

2.7 Final test of the app and complete process scinario 2 3/22/20 3/23/20

3 Excuting

3.1 Go live of the application 1 3/24/20 3/24/20

3.2 Advertise in different government platforms 15 3/25/20 3/29/20

3.3 Sustain communication with different stakeholders regarding any problems faced or quality issues 21 3/24/20 4/13/20

4 Controlling and Monitoring

4.1 Keep track on the types of appliances included in the website to make sure of their efficiency 21 3/24/20 4/13/20

4.2 Consult government agencies to add or remove items 21 3/24/20 4/13/20

4.3 log all expenses and payments done 21 3/24/20 4/13/20

5 Closing

5.1 Provide all stakeholders with achivement list of the project 1 4/14/20 4/14/20

5.2 Submit the final document and close the project 1 4/15/20 4/15/20

Go Live Date

Faisal Alfayz Ali Almutairi Salman Alotaibi

Feb 10, 2020 Feb 17, 2020

Wed, 1/1/2020

Dec 30, 2019 Jan 6, 2020 Jan 13, 2020 Jan 20, 2020 Jan 27, 2020 Feb 3, 2020 Mar 30, 2020 Apr 6, 2020 Apr 13, 2020 Apr 20, 2020Feb 24, 2020 Mar 2, 2020 Mar 9, 2020 Mar 16, 2020 Mar 23, 2020

PROJECT NETWORK & CRITICAL PATH

Task Predecessor(s) Duration (days) 1.1 None 1 1.2 1.1 3 1.3 1.1 10 1.4 1.3 3 2.1 1.4 3 2.2 2.1 20 2.3 2.1 20 72 3.2 87 2.4 2.1 10 78 15 93 2.5 2.2, 2.3, 2.4 2 2.6 2.5 30 1 1.2 4 17 2.2 37 72 3.2 93 2.7 2.6 2 8 3 11 17 20 37 72 21 93 3.1 2.7 1 3.2 3.1 15 0 1.1 1 1 1.3 11 11 1.4 14 14 2.1 17 17 2.3 37 37 2.5 39 39 2.6 69 69 2.7 71 71 3.1 72 72 4.1 93 3.3 3.1 21 0 1 1 1 10 11 11 3 14 14 3 17 17 20 37 37 2 39 39 30 69 69 2 71 71 1 72 72 21 93 4.1 3.1 21 4.2 3.1 21 17 2.4 27 72 4.2 93 4.3 3.1 21 27 10 37 72 21 93 5.1 4.3 1 5.2 5.1 1 72 4.3 93 93 5.1 94 94 5.2 95

72 21 93 93 1 94 94 1 95

Tarsheed Platform Network and Critical Path Legend:

Critical Path

Activity Early Finish Late Start Duration Late Finish Early Start

PROJECT FINANCIAL CALCULATIONS (PART 1 )

Cost Factor Details Amount

Internet Server Cost for server purchase $5,000 Desktops for project team and staff 10 PC's $3,000 Internet Connection Hardware Hubs, Terminals, Cables $2,500 Printers xerox printer $1,000

$11,500

App Developing Programming, Setup, & Instillation $15,000 Graphic Designing Designing $5,000 App licensing Getting the app licensed in App Store and Google play $324 Database Connectivity and Integration Integration between vendors and app ERP $5,000 Internet Service Provider Unlimited Download Speed 100 MB [$150Per Month] $1,800

$27,124

$2,000 $3,000

$10,000 $3,000

$50,000 $68,000

$106,624

BENEFIT Details Amount Government Compensation Compensastion for the difference of appliances prices in $1,500,000

$1,500,000

Vendor Advertisement Revenues generated from advertising vendors over their competitors and making them easier to be chosen by consumers

$100,000

$100,000 $1,600,000

Y0 Y1 Y2 Y3 Y4 $106,624 $82,300 $80,000 $80,000 $80,000

Y0 Y1 Y2 Y3 Y4 $1,600,000 $1,800,000 $1,800,000 $1,800,000 $1,800,000

DISCOUNT RATE 8%

Discount Rate Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Total

Costs $106,624 $82,300 $80,000 $80,000 $80,000 $80,000 $508,924 Discount factor 1 0.93 0.86 0.79 0.74 0.68 Discounted costs 106,624 76,204 68,587 63,507 58,802 54,447 428,170

Benefits $1,600,000 $1,800,000 $1,800,000 $1,800,000 $1,800,000 $1,800,000 $10,600,000 Discount factor 1 0.93 0.86 0.79 0.74 0.68 Discounted benefits 1,600,000 1,666,667 1,543,210 1,428,898 1,323,054 1,225,050 8,786,878 Discounted Benefits - Discounted Costs 1,493,376 1,590,463 1,474,623 1,365,391 1,264,251 1,170,603 8,358,708 Comulative Benefits - Costs -106,624 1,483,839 2,958,462 4,323,853 5,588,105 6,758,708

NPV $8,358,708

ROI 19.52%

Other Costs

The project goes within the budget as it is funded by the government and is not for profit. The amounts paid to the vendors as the difference shouldered by the government is then compensated by the government in a payment received at the end of the year or as agreed.

The Payback of the project will be in Year 1

FINANCIAL COST Hardware Requirements

Sub-Total Software Requirements

Sub-Total

BENEFITS FOR EVERY YEAR

CALCULATIONS

Administrative fees (Cost for setting meetings and providing presentations) Cost for Requested Modifications on the App

Staff Costs, salaries, allowances, and other HR related costs Sub-Total

Estimated Cost for First Year

Advertisement Costs Contract with Logistics Company

Estimated Benefits

Sub-Total Vendor Deals

Sub-Total

FINANCIAL BENEFITS Government Funding

Y5 $1,800,000

COST FOR EVERY YEAR Y5

$80,000

Cost Factor Details Amount

Internet Server Cost for server purchase $5,000 Desktops for project team and staff 10 PC's $3,000 Internet Connection Hardware Hubs, Terminals, Cables $2,500 Printers xerox printer $1,000

$11,500

$27,124

$2,000 $3,000

$10,000 $3,000

$50,000 $68,000

$106,624

BENEFIT Details Amount Government Compensation Compensastion for the difference of appliances prices in $1,500,000

$1,500,000

Vendor Advertisement Revenues generated from advertising vendors over their competitors and making them easier to be chosen by consumers

$100,000

$100,000 $1,600,000

Y0 Y1 Y2 Y3 Y4 $106,624 $82,300 $80,000 $80,000 $80,000

Y0 Y1 Y2 Y3 Y4 $1,600,000 $1,800,000 $1,800,000 $1,800,000 $1,800,000

DISCOUNT RATE 8%

Discount Rate Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Total

Costs $106,624 $82,300 $80,000 $80,000 $80,000 $80,000 $508,924 Discount factor 1 0.93 0.86 0.79 0.74 0.68 Discounted costs 106,624 76,204 68,587 63,507 58,802 54,447 428,170

NPV $8,358,708

ROI 19.52%

Other Costs

The Payback of the project will be in Year 1

FINANCIAL COST Hardware Requirements

Sub-Total Software Requirements

Sub-Total

BENEFITS FOR EVERY YEAR

CALCULATIONS

Administrative fees (Cost for setting meetings and providing presentations) Cost for Requested Modifications on the App

Staff Costs, salaries, allowances, and other HR related costs Sub-Total

Estimated Cost for First Year

Advertisement Costs Contract with Logistics Company

Estimated Benefits

Sub-Total Vendor Deals

Sub-Total

FINANCIAL BENEFITS Government Funding

Y5 $1,800,000

COST FOR EVERY YEAR Y5

$80,000

PROJECT FINANCIAL CALCULATIONS (PART 2 )

THANK YOU

FEEDBACK?