Budgeting and Sales data

[shanka2020]

Hi there Excel Wizzes, I hope you can help. I'm trying to keep track of my sales team budget versus sales on a weekly basis by dividing their monthly budget into 4 weeks and then tracking their weekly sales against this. I would like to provide them at the start of the month their weekly targets (eg. Budget $1000 so Wk 1 $250, Wk 2 $250 etc) and then as they pull in sales I can add them to a total and the remaining weeks are then recalculated to reflect the balance remaining. I have created a spreadsheet already with some of this info on it if that makes it easier for you guys to work off, just ask and I will post it.

Thanks in Advance to you all

 

[jorismoerings]

Hi,

You didn't asked a specific question so there's little to go on. But try this.
Hope it will help you in the rightr direction.

	A	B	C	D	E
1	target	1200
2
3
4	Weekno	Target	Sales	Remain Wk	Remain Target
5	1	300	200	100	1000
6	2	300	300	0	700
7	3	300		300	700
8	4	300		300	700

<colgroup><col style="width: 25pxpx"><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula D5 =[@Target]-[@Sales] E5 =$B$1-SUM($C$4:C5) D6 =[@Target]-[@Sales] E6 =$B$1-SUM($C$4:C6) D7 =[@Target]-[@Sales] E7 =$B$1-SUM($C$4:C7) D8 =[@Target]-[@Sales] E8 =$B$1-SUM($C$4:C8) B5 =$B$1/4 B6 =$B$1/4 B7 =$B$1/4 B8 =$B$1/4 <thead> </thead><tbody> </tbody>

<tbody>
</tbody>