{"id":6493,"date":"2012-10-01T16:47:33","date_gmt":"2012-10-01T21:47:33","guid":{"rendered":"http:\/\/bobbeaty.com\/wp\/?p=6493"},"modified":"2012-10-02T17:21:56","modified_gmt":"2012-10-02T22:21:56","slug":"added-seasonality-to-the-demand-data","status":"publish","type":"post","link":"https:\/\/bobbeaty.com\/wp\/archives\/6493","title":{"rendered":"Added Seasonality to the Demand Data"},"content":{"rendered":"

\"WebDevel.jpg\"<\/p>\n

One of the things that's really quite limiting<\/em> about the current demand forecast data from another system at The Shop is that it's not a month-by-month demand projection. They took the year's sales data and then extrapolated for the next month. But in doing so, they have removed<\/em> any monthly\/seasonal trends so that the demand for Boat Tours in Chicago is the same in July as January. Clearly, absurd. Unfortunately, there doesn't seem to be the will to push a change in and fix the Demand in a reasonable timeframe. So I had to add in some kind of demand adjustment<\/em> based on the month and some sense of the time to close a deal.<\/p>\n

What I came up with was a series of factors - one per month, that could be individually adjusted in a GUI - like an equalizer, and then we'd take each of these and multiply the given demand by this factor and divide by 100 (converting it into a percentage). In this way, we can ramp things up, and shut them down, a month at a time.<\/p>\n

If they want to boost something up, they can pretend it's seasonal, and use move everything up to 200%\u2026 if they want to suppress something, then move all months to 25% - simple. It's a great plan, and we can \"seed\" the data with the sales data by service, by month.<\/p>\n

What I need to do is to start with the code and then work back as I'm not about to do the GUI first - I'm no artist, and that's what this is going to take to make it look really nice.<\/p>\n","protected":false},"excerpt":{"rendered":"

One of the things that’s really quite limiting about the current demand forecast data from another system at The Shop is that it’s not a month-by-month demand projection. They took the year’s sales data and then extrapolated for the next month. But in doing so, they have removed any monthly\/seasonal trends so that the demand […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,6],"tags":[],"class_list":["post-6493","post","type-post","status-publish","format-standard","hentry","category-coding","category-cube-life"],"_links":{"self":[{"href":"https:\/\/bobbeaty.com\/wp\/wp-json\/wp\/v2\/posts\/6493","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bobbeaty.com\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bobbeaty.com\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bobbeaty.com\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bobbeaty.com\/wp\/wp-json\/wp\/v2\/comments?post=6493"}],"version-history":[{"count":2,"href":"https:\/\/bobbeaty.com\/wp\/wp-json\/wp\/v2\/posts\/6493\/revisions"}],"predecessor-version":[{"id":6495,"href":"https:\/\/bobbeaty.com\/wp\/wp-json\/wp\/v2\/posts\/6493\/revisions\/6495"}],"wp:attachment":[{"href":"https:\/\/bobbeaty.com\/wp\/wp-json\/wp\/v2\/media?parent=6493"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bobbeaty.com\/wp\/wp-json\/wp\/v2\/categories?post=6493"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bobbeaty.com\/wp\/wp-json\/wp\/v2\/tags?post=6493"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}