##Use of Inflation Measures in Projections ##

1. ##Your agency spent $5,000 on supplies in 2022. What is your best estimate as to how much the organization would have to spend in 2023 to purchase the same amount of supplies? 2024? Should you account for inflation? Explain your methodology and show any calculations.##

2. ###Your city agency provides transportation for elderly residents and had the following expenses for 2022:##

Drivers $180,000

Maintenance of vehicles $50,000

Gasoline $20,000

##How would your analysis differ (if at all) from the approach used in question 1? What are your best estimates for each category in 2023 and 2024? Create a spreadsheet in Excel to show how you arrived at your calculations and explain your methodology. ##