project 3 - analyzing new businesses opportunities in buffalo, ny
DESCRIPTION
For project 3, we were given a number of companies that were relocating their employees to downtown Buffalo. We had to analyze how much money this relocation would bring the NFTA (Niagara Frontier Transit Authority) Busses if they all took busses from the downtown area (district 1) and traveled to their respective companies.TRANSCRIPT
![Page 1: Project 3 - Analyzing New Businesses Opportunities in Buffalo, NY](https://reader033.vdocuments.us/reader033/viewer/2022060112/557020c2d8b42aa8558b4a54/html5/thumbnails/1.jpg)
Raymond Chetti & Yang GaoPD356 Fall 2008 – Project 3
New Erie County Businessesand
Potential Bus Profit
NFTA Metro Bus
![Page 2: Project 3 - Analyzing New Businesses Opportunities in Buffalo, NY](https://reader033.vdocuments.us/reader033/viewer/2022060112/557020c2d8b42aa8558b4a54/html5/thumbnails/2.jpg)
NFTA Bus Routes, Fare Zones, and Erie County Businesses
![Page 3: Project 3 - Analyzing New Businesses Opportunities in Buffalo, NY](https://reader033.vdocuments.us/reader033/viewer/2022060112/557020c2d8b42aa8558b4a54/html5/thumbnails/3.jpg)
![Page 4: Project 3 - Analyzing New Businesses Opportunities in Buffalo, NY](https://reader033.vdocuments.us/reader033/viewer/2022060112/557020c2d8b42aa8558b4a54/html5/thumbnails/4.jpg)
NFTA Bus Zone Charge Analysis
Company Employees Zone Zone Charges RT (1 Day) RT (5 Days) RT (127 Days /6 Months)
Sportservice Corp 4 3 $1.65 $13.20$66.00
$1,676.40
Alterations & Repr Unlimited 4 3 $1.65 $13.20$66.00
$1,676.40
Shamrock Park 9 2 $1.45 $26.10$130.50
$3,314.70
Super Buffet Restaurant Inc 10 2 $1.45 $29.00$145.00
$3,683.00
Sub Delicious 10 4 $1.85 $37.00$185.00
$4,699.00
Bank of America Mortgage 14 2 $1.45 $40.60$203.00
$5,156.20
Picture it By Stephanie 3 3 $1.65 $9.90$49.50
$1,257.30
Hennessy Snowplowing & Removal 8 2 $1.45 $23.20$116.00
$2,946.40
Horohoe Language Services 5 2 $1.45 $14.50$72.50
$1,841.50
Musakovskiy 8 2 $1.45 $23.20$116.00
$2,946.40
Total$229.90 $1,149.50 $29,197.30
Total Profit: Daily: $229.90 Weekly: $1,149.50 6 Months: $29,197.30
![Page 5: Project 3 - Analyzing New Businesses Opportunities in Buffalo, NY](https://reader033.vdocuments.us/reader033/viewer/2022060112/557020c2d8b42aa8558b4a54/html5/thumbnails/5.jpg)
Create address locator
Geocoding from Database file
Data supplied:Bus Routes# of EmployeesFare Zones (preprinted maps)
Digitize the Zone Lines
Created Excel database/table to calculate fares