An Updated Calculation Guide for the 2022 Family Living Wage for Manitoba

The 2022 report presents the amounts of the living wages (using for the most part data as of the end of 2021) for Winnipeg, Brandon and Thompson, and summarizes the assumptions in the calculations, the formula that calculates the living wages, and how the family expenses are calculated. [...] The Mechanics of the Excel Spreadsheet The following explains the layout and components of the Excel spreadsheet that accompanies this guide and how the elements of the living wage are integrated into the spreadsheet. [...] Multiply $487.63 by the CPI for “Electricity” for Manitoba in the year for which you are doing the study and divide by the CPI for 2009. [...] For “Geography” include only “Manitoba, rural.” For “Component” include only “Transportation.” • Step 2: Adjust for inflation by multiplying the amount in Step 1 by the CPI for “Operation of passenger vehicles” for Manitoba in the year for which you are doing the study and divide by the CPI for 2020. [...] As you work through the Federal and Provincial tax sections, be sure to update the formulas in the cells to the right of Table IV in the Excel spreadsheets according to the specific tax rules for the year in which you are working.