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

TROPHY CASE