![]() ![]() ![]() A date in the Start Date column will determine the first fortnightly payment. Formatted tables were covered in the August 2018 edition of INTHEBLACK.Ī date in the End Date column determines the last fortnight that the employee will be paid. The formatted table in Figure 1 has been named WagesForecast via the Design ribbon tab that is displayed when the table is selected. In future, this forecast structure could be used as the budget. The wages assumptions used in Figure 1 are shown in column M in Figure 2, which also includes a fortnightly breakdown of the wages based on the table from Figure 1. I have added and populated the Start Date and End Date columns to enable forecasting. In Figure 1, columns A to H were used to create the initial wages budget. The example relates to wages, but could be applied to any situation where you have costs that start and stop. This article is based on a question from a CPA Australia member who wanted to convert an existing budget structure into a forecast structure. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |