Sweetened Beverage Tax Project
Statement of Work
City of Philadelphia
Department of Revenue
In June 2016, the City of Philadelphia became the first major city in the nation to pass an ordinance to collect tax on Sweetened Beverages. Starting January 1, 2017, the City of Philadelphia will impose a 1.5 cents per ounce tax on the supply of sweetened beverages to retail dealers (example: regular and diet sodas, teas). The tax is also levied on syrups and concentrates used to make sweetened drinks. The liability for payment of the tax is on the registered distributor (a person who supplies sweetened beverages to a dealer) of Sweetened Beverages. In certain cases, a dealer may obtain a waiver to purchase sweetened beverages from an unregistered distributor, but in these cases, the dealer must register, file, and pay the tax themselves. The tax will be due the 15th of each month for the prior month.
Facilitate collection of the Sweetened Beverage Tax (SBT) from businesses that are covered by the SBT ordinance. Provide an easy to use web portal to register the business and pay the SBT.
SCOPE OF WORK
Design a web application that will enable the business owners to register their sweetened beverage business with the City. Access to the web portal should be controlled by proper authentication such as login user id and password. The web application should be developed using Microsoft .NET technologies and the front end of the application should communicate with the backend which is an ADABAS database, using the middleware provided by the City. The application should calculate the tax amount based on some input values and accept payment of the tax online. The taxpayer should be able to pay the tax monthly. In addition to the aforementioned work, the selected vendor should perform detailed requirements analysis, prepare requirements document, prepare data-flow/systems diagram(s), prepare test plan(s), and prepare user-friendly training document(s).
- Detailed requirements analysis
- Design registration webpage
- Design login page
- Design data input page and display calculated tax amount
Present payment page and accept paymentDesign a page to present the tax due and accept payment
- Provide printable/downloadable receipt as PDF on the payment web page and email the same to the email address provided by the taxpayer at the time of registration.
- Prepare test plans and conduct unit testing and integration testing of all components
DELIVERABLES and Time Frame
- Requirements document – 5 days from start the project
- Test web application – 20 Days from start of the project
- Production ready web application – 30 days from start of the project
- System documentation including architectural diagram and data flow diagrams- 35 days from start of the project
- User guide/training document – 35 days from start of the project
INSTRUCTIONS FOR SUBMISSION
Your proposal should include a short description of your qualifications, experience with similar projects, an overview of your firm or organization, and a brief description of your solution. You may include high level architectural diagrams of the proposed solution and URLs for any online examples you may have. Please email all documents to firstname.lastname@example.org. Your submissions must be received on or before
08/04/2016 08/12/2016. Late submissions will not be considered. Please limit the size of the proposal document to a maximum of 12 pages.
Please post any questions as a comment below this solicitation on bigideasphl.com so that additional information provided in any Q&A will be available for all potential submitters to review. Any questions sent via email will be directed back to the comment section below the solicitation on bigideasphl.com.