Database design - actual vs budget model
Posted on 2002-04-12
I want to put together a database to produce actual vs budget comparisons and would like some direction in how best to set up the structure. The output will be weekly variance reports by account number for each department as well as for the total company.
The 52 weeks of the calendar year are subtotaled into months in a 5-4-4 pattern. For example Jan consists of the first 5 weeks of the year, Feb the next 4, Mar the next 4, Apr the next 5 and so on. Due to this 'fiscal month' setup I am unsure how to structure the tables so that I can easily construct reports for weekly, month-to-date, quarter-to-date, and year-to-date accumulations and comparisons.
Any advice is greatly appreciated.