{"id":1126,"date":"2017-05-06T15:02:20","date_gmt":"2017-05-06T23:02:20","guid":{"rendered":"http:\/\/bobbacon.net\/blog\/?p=1126"},"modified":"2020-05-11T10:09:04","modified_gmt":"2020-05-11T18:09:04","slug":"new-and-improved-capacity-planning-model","status":"publish","type":"post","link":"https:\/\/bobbacon.net\/blog\/archives\/1126","title":{"rendered":"New and Improved Capacity Planning Model"},"content":{"rendered":"<p><a href=\"http:\/\/bobbacon.net\/blog\/monthly-capacity-plan-2\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-1129\" src=\"http:\/\/bobbacon.net\/blog\/wp-content\/uploads\/2017\/05\/Poster-for-article-245x300.jpg\" alt=\"\" width=\"240\" height=\"294\" srcset=\"https:\/\/bobbacon.net\/blog\/wp-content\/uploads\/2017\/05\/Poster-for-article-245x300.jpg 245w, https:\/\/bobbacon.net\/blog\/wp-content\/uploads\/2017\/05\/Poster-for-article.jpg 387w\" sizes=\"auto, (max-width: 240px) 100vw, 240px\" \/><\/a><\/p>\n<p>A few years ago, I wrote <a href=\"http:\/\/bobbacon.net\/blog\/archives\/957\">this article<\/a> on capacity planning\u00a0with an approach\u00a0that\u00a0capitalized on\u00a0regional management buy-in\u00a0to pave\u00a0the path to achievement.\u00a0 Since then I&#8217;ve had several requests from Sales leaders to expand and improve\u00a0the model\u00a0as most\u00a0of them are in small start-ups without the availability of a resident Excel master.<\/p>\n<p>The expansion of this model\u00a0includes\u00a0a breakout of monthly quotas, instead of just quarterly, and independent ramp\u00a0parameters by role since, for example, \u00a0the new hire ramp for an Account Executive is likely to be longer than for an Inside Sales Rep.<\/p>\n<p>Given the data in this model is calculated at a monthly level, even if you only assign quotas on a quarterly basis, this model will produce slightly more accurate quotas as well as provide monthly targets for intra-quarter productivity bench-marking by management.<\/p>\n<p>All of the spreadsheet wizardry aside, the real\u00a0benefit in this approach is giving your regional sales managers\u00a0actual control over the allocation of targets for their team members, thus increasing their own\u00a0buy-in to their quota.<\/p>\n<p>If you are interested in optimizing the effectiveness of your quotas I recommend you read the <a href=\"http:\/\/bobbacon.net\/blog\/archives\/957\">original article<\/a> and download <a href=\"http:\/\/bobbacon.net\/blog\/monthly-capacity-plan-2\">the latest model<\/a> to check it out!\u00a0 As always, any comments or suggestions to further improve it\u00a0are welcome!<\/p>\n<p>Cheers!<\/p>\n<p>Bob Bacon<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A few years ago, I wrote this article on capacity planning\u00a0with an approach\u00a0that\u00a0capitalized on\u00a0regional management buy-in\u00a0to pave\u00a0the path to achievement.\u00a0 Since then I&#8217;ve had several requests from Sales leaders to expand and improve\u00a0the model\u00a0as most\u00a0of them are in small start-ups &hellip; <a href=\"https:\/\/bobbacon.net\/blog\/archives\/1126\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_s2mail":"no","footnotes":""},"categories":[23,4],"tags":[26,100,103,13,102,29,101,12],"class_list":["post-1126","post","type-post","status-publish","format-standard","hentry","category-sales_compensation","category-sales_ops","tag-bob-bacon","tag-capacity-plan","tag-capacity-planning","tag-incentive-comp","tag-quota-coverage-model","tag-sales-compensation","tag-sales-quota","tag-variable-comp"],"_links":{"self":[{"href":"https:\/\/bobbacon.net\/blog\/wp-json\/wp\/v2\/posts\/1126","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bobbacon.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bobbacon.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bobbacon.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bobbacon.net\/blog\/wp-json\/wp\/v2\/comments?post=1126"}],"version-history":[{"count":29,"href":"https:\/\/bobbacon.net\/blog\/wp-json\/wp\/v2\/posts\/1126\/revisions"}],"predecessor-version":[{"id":1345,"href":"https:\/\/bobbacon.net\/blog\/wp-json\/wp\/v2\/posts\/1126\/revisions\/1345"}],"wp:attachment":[{"href":"https:\/\/bobbacon.net\/blog\/wp-json\/wp\/v2\/media?parent=1126"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bobbacon.net\/blog\/wp-json\/wp\/v2\/categories?post=1126"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bobbacon.net\/blog\/wp-json\/wp\/v2\/tags?post=1126"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}