Budgets and actuals for businesses are generally reported at two different calendar scales. For example, budgets are often presented at the month or year scale, while actuals are generally presented on the day scale. Because of these two different scales, it can be difficult to track daily revenue versus budget to determine whether a particular month or year is on track to meet or exceed the budget for that month or year.
This recipe demonstrates how to rationalize and compare revenue figures that are provided at two different time scales by demonstrating how to compare actual revenue provided at a daily scale with budget numbers provided at a monthly scale.
