Phase 1
1. Using Microsoft 2010 Excel, replicate a ten page hard copy set of State sales tax forms. Two of the hard copy pages are instructional and have no calculations, but need to be viewable in the same relative location as shown on the hard copy forms.
2. This spreadsheet must look exactly like the official sales tax forms.
3. The Excel system must allow the entry of all tax data in cells that represent the fields on the hard copy forms. There is no requirement (in this Phase 1) to create formulas to perform calculations.
4. All text areas of the spreadsheet must be protected so that I do not accidentally alter the form.
5. I have identified one company that has a website showing a similar product. Their product is for the creation of the US Income Tax forms and not my specific sales tax data. [login to view URL]
6. The following State site has a copy of my sales tax book and the specific forms (pages 29 - 38) : [login to view URL]
7. When I complete data entry in the spreadsheet forms, I must be able to print the Excel pages and produce the exact appearance of the State forms.
8. My State forms are printed on both sides to reduce paperwork and handling. Please advise me of how I can best print this computerized set of forms and get them to print front and back.
9. Developer will create a tutorial explaining how the spreadsheet was created and how I can make minor modifications.
Phase 2
1. Develop a front end system that allows for the entry, deletion, and edit of detailed sales data. This front end system should be a Microsoft 2010 Access system with the appropriate interface of data to the Excel Spreadsheet. This involves understanding the various tables of tax values and sales tax locations related to South Carolina zip codes.
2. The appropriate totals and detail created in the front end system will then populate the data fields in the Excel spreadsheet developed in Phase 1.
3. The spreadsheet created in Phase 1 will now require the development of the formulas to complete the automation of my sales tax calculations and subsequent printing of the completed State forms.
Notes:
A. Developer may bid on an individual Phase or both.
B. Please show me examples of similar development.