Budgeting and Sales data

shanka2020

New Member
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

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

jorismoerings

Well-known Member
Hi,

You didn't asked a specific question so there's little to go on. But try this.

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

</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

</tbody>

<tbody>
</tbody>

Replies
1
Views
298
Replies
1
Views
144
Replies
0
Views
145
Replies
2
Views
532
Replies
0
Views
95