Sales Planning Excel Spreadsheet Application - 021418

Looking for an experienced Excel user to develop a spreadsheet application to help salespeople plan their time and lead generation channels. Using channels, conversion rates, average time, quota, desired income, commission rate, etc. the application should help them optimize their lead generation channel choices and determine time required to hit their goal as well as total revenue and commission. - It should alert them when the number of activities they have planned is unrealistic. - It should alert them based on sales cycle time when there is not enough time or activities remaining in the year to achieve their quota and personal goal. - It should suggest/recommend an ideal mix of channels based on the assumptions given. - To facilitate scheduling into their calendar the final solution should include approximate following output: Daily Activities You should schedule [X] [Channel] Activities per Day. You should schedule [X] [Channel] Activities per Day. You should schedule [X] [Channel] Activities per Day. etc. Weekly Activities You should schedule [X] [Channel] Activities per Week. You should schedule [X] [Channel] Activities per Week. You should schedule [X] [Channel] Activities per Week. etc. Monthly Activities You should schedule [X] [Channel] Activities per Month. You should schedule [X] [Channel] Activities per Month. You should schedule [X] [Channel] Activities per Month. etc. Yearly Activities You should schedule [X] [Channel] Activities per Year. You should schedule [X] [Channel] Activities per Year. You should schedule [X] [Channel] Activities per Year. etc. The end result should be a stand-alone spreadsheet application that can be used by independent sales reps. I have attached a planning form and supporting materials that perform this function today. I have also attached a previous attempt to complete this project. You may build on it or gather inspiration from it. "[login to view URL]"