I need a custom Excel spreadsheet for job cost management.
Basically, I need it to do the following:
1. On the first tab, have a reports list with charts stating profits/losses, etc, by software feature that graphs the amount of work to complete the feature as well as a return on investment calculation that is based on the number of sales opportunities that could use this feature to help close the deal.
2. Needs to have summary by software feature on the first page as well (only total profit or loss)
3. On the inner pages, I need to be enter the software feature title, the estimated final price of the project, i.e. number of engineers, salary, and hours to complete. These features need to be able to be tracked individually and referenced to various sales opportunities. Additionally, i need a tab that allows me to enter sales opportunities and multiple features that are requirement to help secure the deal.
4. Each tab should be a different project. However a single tab is needed to list all of the sales opportunites. This Opportunity tab should read Customer Name, Model Number, QTY, Revenue, SFDC #, Close Date, iDate, FEATURES Required
5. Projects (tabs) should automatically be in alphabetical order
6. Each time I create a new tab, the default template needs to be there.
I'm looking to spend $75.