Hi! and Happy New Year. I wish everyone a year filled with health and happiness.
I have attached a spreadsheet which I am having trouble even finding where to begin working with. In the world of sales, everyone has a quota. If you have a quota of 100k, after the end of a quarter, you know how much you need to sell in order to achieve your quota for the year. What is a little more difficult, is adjusting on the fly. For example, if I know I have a 100k quota, I know that I need to sell 8333.33 per month to meet that goal. But if i have a few bad months, and after one quarter of the year, I only have 5k in sales, i need to adjust that monthly requirement if I am going to meet the 100k quota. That would change the math as i would have to sell 95k, in 9 months, giving me a new goal of 10,555.60 in order to meet my quota.
On the sheet i have attached, i have the proper control data, and have a simple question of "How many Quarters Remain In This Year?" If I enter "2", then I would like the results beneath to only show Quarters 3 and 4. If I enter 3, then i'd like the results to indicate quarters 2,3,4. I would also like to have the option of breaking this down monthly, but will be happy if I can get it to work quarterly only.
Any help would be greatly appreciated. In the covid era, everything is more micromanaged and it has gotten more difficult to keep food on the plate. Being able to make this work will be all the difference in the world as far as planning and succeeding.
Thanks Folks!
Bookmarks