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.
8 freelancers are bidding on average $102 for this job
Hi, I'll be happy to help you with this project. I have experience in both job costing concepts and Microsoft Excel Please feel free to message me if you need to discuss any questions you might have prior to award
Hi there. I am ready to kick off with the project. I have done a few very similar projects in Excel before and I can design a profit/loss sheet as required. Kindly discuss. Regards. Usman.
Hello I'm a software engineer with good knowledge in excel macro. I can help you to do your job. please contact me for future details. best regards hossein