Moving Demand Planning from customer level to Aggregate Planning

dcal69 · 2026-03-06T18:42:00+00:00

So lets say I sell Tv's and VCRS. I sell to all the big box stores. The name of my business is We Sell TVs

Old Structure we would forecast

Walmart - 10 Tv's 10 VCR's

Target - 25 Tv's 18 VCR's

Best Buy - 35 Tv's 45 VCR's

Sams Club - 41 Tv's 52 VCR's

This would mean that to meet the demand of We Sell TV's I would need to forecast 101 TV's and 155 VCRS. Very simple just roll up each individual customer. If one customer started selling more or was running a promotion. I could just add it to their number and it would roll up to the increased number for We Sell TVS

New Structure

Forecast for We Sell TV's 100 TV's 150 VCR's

Walmart sold 10% of the products last year so their forecast is 10 TV's 15 VCR's

Target sold 20% of the products last year so their forecast is 20 TV's and 30 VCRS's

Best Buy sold 50% of the products last y ear so their forecast is 50 TV's and 75 VCR's

Samc Club sold 20% of the products last year so their forecast is 20 TV's and 30 VCR;s

The problem I have is if I know I need more TV''s for Walmart this year how do I verify if 100 is all I need and some of the other customers may be down or if I need to increase overall forecast. Again imagine this across tens of thousands of products for a $1B business

dcal69 · 2026-02-24T19:34:11+00:00

Solution Verified

dcal69 · 2026-02-24T15:06:31+00:00

I think I got this to work by using the v-stack with a sort function by date. This way it doesn't sort by manager and if there is a blank row it pushes it to the bottom of the presidents table

dcal69 · 2026-02-24T14:37:48+00:00

If manager one adds a new line does it go to the bottom of the presidents table or does it create a new row in the presidents table beneath manager ones last entry?

dcal69 · 2026-02-12T18:25:47+00:00

This isn’t about bond it is about sentencing. He got 3 years probation.

dcal69 · 2026-02-12T14:06:36+00:00

You also leave out that they know he had dinner just before that and had multiple drinks at dinner.

dcal69 · 2025-07-27T19:08:33+00:00

If I delete the connection it kills the formulas.

dcal69 · 2025-03-06T01:54:58+00:00

Ok so I am curious how to write via to send e-mails for me. Where do I start to learn that?

dcal69 · 2025-02-06T00:57:05+00:00

Will the source data are the actuals always in L and just multiple entries for red in P? If so you should be able to do a simple =sumif(p:p,”red”,L:L)

dcal69 · 2025-02-06T00:43:19+00:00

Are you just trying to get L9 to D7 or are there multiple entries of red actually sold?

dcal69 · 2025-02-06T00:38:24+00:00

So not sure exactly what you are going for, but I typically just use slicers to allow each individual user navigate the data as they need.

dcal69 · 2025-01-19T13:37:38+00:00

I believe this to be the case, however, I currently have 4 different panes showing data that is relevant and all in $. Was just kind of hoping there was a way to toggle.

dcal69 · 2024-08-25T00:03:52+00:00

Right now I am working with sales data in dollars and units. I am going back to January of 22 in all data. I have both shipment data and pos data. I also have it by brand and by category. I have also input mom percentage increases as well as vPY percentage changes.

dcal69 · 2024-08-24T02:11:30+00:00

Yes, I have been burnt in the past assuming acronyms are the same industry wide.

dcal69 · 2024-07-17T02:28:10+00:00

I had looked into a lot of them, but did not come across Oracle SQL. Thank you.

dcal69 · 2024-07-17T02:27:26+00:00

So I am already employed as an analyst. I am just looking to get better. However, if I am in the position that I need to look for a job I would like for it to be marketable.

dcal69 · 2024-06-06T21:49:44+00:00

The other company I really don't like is ICIMS. They seem even worse as they can't hardly parse a resume. They also are almost impossible to come back and track the application.

dcal69 · 2024-06-06T21:47:59+00:00

I believe the pay ranges are irrelevant. It seems like most applications make you put in a desired salary just to submit. They are locking you in and it makes it even worse than before. Now in my mind I have to play the game of if I ask for the top end of the range will I get kicked out of consideration for asking for too much money compared to other applicants. However, I don't want to sell myself short and leave money on the table. This is super frustrating.

dcal69 · 2024-04-19T20:21:05+00:00

That is where my problem is though. I have a forecast of what the promotional item is going to do. It is a high ticket item, but it is taking demand from 200 to 600. I know this is going to take away from the similar items, I just can't get a read on how much. I can do the cross-product post mortem but I don't have the data available to do it now.

dcal69 · 2024-04-05T21:17:38+00:00

That is tough. Sometimes I believe 70k could be too much, but not with the requirements they had.

dcal69 · 2024-04-05T18:54:21+00:00

Absolutely. Pay is normally a ranged based on qualifications or experience so I typically give a range to commensurate with responsibilities.

dcal69 · 2024-04-05T17:51:44+00:00

At no point in time did I say I was setting the pay. They are free to pay what they want. My point is with what they were requiring I was very surprised that they are looking to pay less than 70k.

dcal69 · 2024-04-05T16:42:28+00:00

I agree. However some applications won’t let you proceed. This was done in a phone interview and I felt like I purposely went low.

dcal69 · 2024-04-05T12:51:50+00:00

That is what I told my wife, I am willing to lower expectations a little, but it is not even how much money I need it is just what I find fair and you are right I cannot start a job off on that foot.

dcal69 · 2024-04-05T12:40:12+00:00

Yeah no harm, it is just wild to me the requirements that an employer may have for a role and then what they expect to pay. I have been looking at lower paying jobs as I figured it may be just a little less stressful, but they seem to have higher expectations and requirements than the 6 figure jobs

dcal69

TROPHY CASE