Must know measurement, weight, and etc calculation. SEE ATTACHMENT.
I need a cost estimating database to be able to capture all possible cost to come up with unit price by the following:
Services: Seal Coats, Crack Seal, Prime Coats, Tack Coats, Marking & Striping.
Cost estimating need to include Labor, Material, Hotel, Gas, Rent and Purchase of Equipment, Supplies, Insurance, bonding, Storage, and etc if identify.
The challenge part of this project is calculating the unit price for the quote.
Figuring out the material cost and how much material is need for a project.
Striping services you will have to know how much area do a gallon of paint cover, how much is a gallon of paint, how much paint you need to do a project that is 2000 sqft. (No need to research, I will find out the correct numbers in the future. You can use any number, but make sure it calculates correctly.)
On the spreadsheet, the “Quote Example” tab is what I need to give to my clients. The numbers on this tab will come from the Bid Item Info and Bid Items tabs
The “Bid Item Info” tab is what I will use to evaluate my business decision. This tab has items that are entered in manually. The numbers on this tab will come from the Material, Equipment, Labor, and Other Expenses tabs.
The database needs to be able to calculate cost to do a job with a user-friendly experience.
1. Auto filter.
2. Drop down menu.
3. Show related items only in drop down menu.
4. Create template documents, (Quote and Invoices)
5. Create Reports Easily
6. Easy to update.
7. Intuitive, well thought out.
9. Pleasant, easy-to-navigate GUI.
***Payment will only be paid for a finish product.***