I am looking to create a production summary report that tracks daily gross production (current month), monthly gross production (current month), Gross production (YTD), and monthly average. I would like to compare this to our monthly goal, YTD goal and Monthly average goal. The spread sheet would compute the difference between actual and the goal. I'd also like to see the prior year of the current month and the prior Year YTD. The spreadshee should out put a graph that shows production dollars on the Y axis and months on the x axis. The bars of the graph would show current year production, prior year production, and our goal. I am attaching an example of the graph and data.
30 freelancers are bidding on average $115 for this job
Dear Sir, quality and expert researcher here to search a targeted group of people, images, email addresses, database or anything that you are needed you may hire me in full confidence.
Hi: Please note that I have 100% completion rate and 5-star feedback on projects. More than 90% of my projects are related to Excel. Please connect with me to discuss more
I can generate the various YTD, Gross production, comparison etc graphs. Please share your sample Excel sheet and I'll provide you a demo of the graphs.