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

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

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,421
Messages
5,547,824
Members
410,813
Latest member
Vhinzvirgo
Top