Date: 7th Feb ‘12 National Youth Hostel Nyaya Marg New Delhi India Subject:- Proposal for Booking System for Manali hostel Kind Att : Ms Nishi Further to our meeting with Brig Uberoy, we understand that you would like to customize our existing booking system running in Delhi for Manali hostel so that its reservation, accounts can be managed from Delhi and also Run from Manali. Kindly find the revised proposal attached. Hope its in line with your expectation. Do let me know if you require any clarification. Thanking You. Regards,
Latika Nanda 9811113950
Latika’s Web Consultancy B-4/114, Safdarjung Enclave, New Delhi – 110029 Mobile: 9811113950, Website: www.latika.com, Email: latika@latika.com
Scope of Work To customize our existing YHAI hostel booking application for front and back office with ease to see the availability of beds / rooms at a glance for Manali.. We have the following features in the current system. We will have to make changes to these features.
Modules/ Features • • •
•
•
•
• • • • •
•
Method of payment o pre paid for room/beds booking o post paid for luggage An Room/ Bed Availability application o At a glance, operator can check the availability of room/bed for at least next 7 days. Individual Booking o Payment mode : pre paid o Track of room/bed o Store personal details, with edit details facility Extension of Individual Booking o Payment mode : pre paid o Keeping track of the earlier ref. # o Track of room/bed Group Booking o Payment mode : pre paid o Keep details of all individual, with edit details facility o Track of room/bed for all individual Extension of group booking o Payment mode : pre paid o Keeping track of the earlier ref. # o Keep details of all individual o Track of room/bed for all individual Advance individual booking o with part payment Advance group booking o with part payment Luggage Store application o Payment mode : post paid o Store luggage details corresponding to guest details. Internet o Payment mode : pre paid Laundry o Payment mode : pre paid o Shifting of Room application o Incase due to some reason a member is shifted from one bed and allocated another; the operator has to update the status of bed. Check out application
Latika’s Web Consultancy B-4/114, Safdarjung Enclave, New Delhi – 110029 Mobile: 9811113950, Website: www.latika.com, Email: latika@latika.com
Modules/ Features •
•
•
• •
Hostel Occupancy Report o Reference number wise o Date wise o Week wise o Month wise o Year wise o Type of Room (ac/non ac, single..) o Country wise Hostel Advance Booking Report o Reference number wise o Date wise o Week wise o Month wise o Year wise o Type of Room (ac/non ac, single..) o Country wise Luggage Storage o Reference number wise o Date wise o Range of dates Daily Guest Report o Checkout Report o List of people who are supposed to checkout on a particular date. Accounts Report o Collection of money from hostel booking per day per shift. o Report of collection of money from hostel booking per month and year. o Amount collected from Advance booking. o Total Amount earned from Sale of food date wise/ month wise. o Total Amount earned from internet in a month.
Receipts • • • • • • • • • •
Individual booking Receipt Group Booking Receipt Extension of room/bed booking Advance Individual Receipt Advance Group booking Receipt Luggage Receipt Internet Receipt Canteen Receipt Miscellaneous Receipt Checkout.
Latika’s Web Consultancy B-4/114, Safdarjung Enclave, New Delhi – 110029 Mobile: 9811113950, Website: www.latika.com, Email: latika@latika.com
Admin Control Panel • • • •
A Control panel to administrate the Hostel Booking system. Panel for management of rooms. For Add/delete a Room/bed. To change price rate of Room/bed.
Proposed Solution •
Architecture o ASP/ MS SQL Server as our current booking system is designed in the same language and so can be easily adapted to similar booking application for Manali resulting in lower cost. o Our solution will be multi-user and scalable to future enhancements. o The design of the system will be enhanced and component based architecture will be used so that additional software’s can be easily integrated and customized to the existing solution at any point of time.
Internet / Misc YHAI Hostel Booking Application
Hostel
Multi Operator operators Operators can accessMake system from anywhere as long Bookings as they can be connected to server via internet/intranet
Canteen
Laundry Luggage
Request for Booking of Hostel
Control Panel
Management of room details
Can manage from anywhere as long as they are connected to server via internet or intranet
Visitor
Latika’s Web Consultancy B-4/114, Safdarjung Enclave, New Delhi – 110029 Mobile: 9811113950, Website: www.latika.com, Email: latika@latika.com
YHAI Administrator
Infrastructure Requirement Operating system
:
Windows 2000/ NT / XP Professional
Web server
:
IIS
Database
:
SQL Server
Scripting Language
:
ASP / JavaScript /
Web Browser
:
IE 6 +
Vbscript/HTML
The server, OS, Database, web server to be provided by YHAI for hosting of the hostel booking application. We will implement the application on server provided by YHAI. YHAI will be responsible for operators to be connected to server via internet or intranet.
Commercials Changes Interface Change
Amount 15,000
Changes in above features Modules Reports Receipts Control Panel Testing
65,000
Installation on server
10,000
Miscellaneous Changes Total
5000 105000
10,000
We will include AMC till 31st March 2013 in this estimate. AMC will include handling of errors, changes in CFORM in existing design of application.
Estimate Time The estimate time taken to complete the project is 20-30 working days.
Latika’s Web Consultancy B-4/114, Safdarjung Enclave, New Delhi – 110029 Mobile: 9811113950, Website: www.latika.com, Email: latika@latika.com
What we need from you ? • • • •
The scope of work including all applications modules, reports, receipts to be finalised by YHAI before start of project. Factual information like how many kinds of rooms are available, product features required to be given in writing. One point contact person in YHAI
SQL Server & IIS to be installed on the server.
• Terms & Conditions Payment Terms: Payment to be made in favour of “Latika’s Web Consultancy” 40% of the Estimate due upon signing of Contract. 30% on delivery of prototype. 30% on user acceptance of project, i.e when the application is online for people to access. e. We will include AMC till 31st March 2013 in this estimate. f. AMC will include handling of errors in existing design of application and changes in CFORM. g. Updation / Maintenance charges to be payed to be paid in advance in April 2013 . a. b. c. d.
Customer Deliverables: • • •
•
We will implement the application on server provided by YHAI. No onsite visit will be taken. All the server issues will be handled by remote access. YHAI will be responsible for operators to be connected to server via internet or intranet. i.e to access the application from Manali. All Content to be provided in electronic format by Customer.
Latika’s Web Consultancy B-4/114, Safdarjung Enclave, New Delhi – 110029 Mobile: 9811113950, Website: www.latika.com, Email: latika@latika.com