Cost of living has been estimated at going up by 3.93% over the next 6 months. We would like to forecast what the expenditure will be over that period. In cell Z2 enter the value 3.93%. In Z5 enter a formula to calculate the forecast expenditure. To do this you will need to calculate the increase in expenditure (current total expenditure multiplied by the percentage increase) and add it to the current total expenditure. Copy the formula down the column. (Make sure that all the calculations are using the value in Z2!). QUESTION: What is the Forecast Expenditure for Case 15?
Answers
Answer:
uestions
Practice Problems
What is the total March Expenditure now
4. What is the total March Expenditure now?(cell Q2)
5. An incorrect value has been entered for Case ID 5299. use the Find tool to find this Case ID and the January Income to 5200. What is the total January Income now? (cell 12)
6. There are several calculations missing Which need to be added. An additional Column showing the total number of people per household is required. Perform all the following steps and then answer the question.
7. In cell V5 enter a calculation to get an average of income from January to June (JS to 05). C. the formula down the column. What is the Average Income for Case 9 (cell V6)?
8. In cell WS enter a calculation to add up the total income from January to June. Copy the down the column, the column so that you Can See the results. What is the total Case 9 (cell W6)?
9. In cell X5 enter a calculation to add up the total expenditure from January to June (PS to US). Copy the formula down the column. What is the total expenditure for Case 15?
11. Cost of living has been estimated at going up by 3.93% over the next 6 months. We would like to forecast what the expenditure will be over that period. In cell Z2 enter the value 3.93% In Z5 enter formula to calculate the forecast expenditure. To do this you will need to calculate the increase in expenditure (current total expenditure multiplied by the percentage increase) and add it to the current total expenditure. Copy the formula down the column. (Make sure that all the calculations are using the value in Z2!).
Assuming that the current total expenditure is in cell Z3, the formula to calculate the forecast expenditure for each case would be:
=Z3*(1+Z2)+Z3
This formula calculates the increase in expenditure by multiplying the current total expenditure in Z3 by the percentage increase in Z2, adding it to the current total expenditure in Z3, and then adding the two together to get the forecast expenditure.
To calculate the Forecast Expenditure for Case 15, you would need to know the current total expenditure for Case 15, which should be entered in cell Z3 for that particular case. Then, you would enter the above formula in cell Z5 for Case 15 and copy it down the column to get the forecast expenditure for each of the next 6 months.
#SPJ3