Sales Budget Spreadsheet
Budget: $30 – $250 AUD
Hi,
I need to build a spreadsheet to track my multiple stores budget (sales target) daily, weekly and monthly for the FY2023 financial year (01/07/2023-30/06/2024).
I have been given monthly targets and I want to break this down to weekly and daily (7 days).
The complicated part is I have different splits for the different days of the weeks and I also need to exclude NSW (Australia) public holidays.
The splits are:
Mon 12%
Tues 12%
Wed 14%
Thur 15%
Fri 12%
Sat 20%
Sun 15%
It would be great if I could use this model for subsequent years.
Thanks!
I need to build a spreadsheet to track my multiple stores budget (sales target) daily, weekly and monthly for the FY2023 financial year (01/07/2023-30/06/2024).
I have been given monthly targets and I want to break this down to weekly and daily (7 days).
The complicated part is I have different splits for the different days of the weeks and I also need to exclude NSW (Australia) public holidays.
The splits are:
Mon 12%
Tues 12%
Wed 14%
Thur 15%
Fri 12%
Sat 20%
Sun 15%
It would be great if I could use this model for subsequent years.
Thanks!