Budgeting and Sales data

shanka2020

New Member
Joined
Jan 4, 2016
Messages
1
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 :)
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

jorismoerings

Well-known Member
Joined
Jul 4, 2014
Messages
1,284
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.

ABCDE
1target1200
2
3
4WeeknoTargetSalesRemain WkRemain Target
513002001001000
623003000700
73300300700
84300300700

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

Worksheet Formulas
CellFormula
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>
 

Watch MrExcel Video

Forum statistics

Threads
1,114,528
Messages
5,548,576
Members
410,852
Latest member
WernerS
Top