Task 1 Design Task 3 On the Case 5 worksheet, calculate the revenues and expenses for the next year using the proposed increases in the case. [Use the =ROUND function when

calculating the TTC fare increase. Round to 3 decimals, then format as percentage showing 1 decimal.] Task 2 Goal Seek Properly design the worksheet to allow the user to easily change any assumption value. All 2022 cells should contain formulas containing cell references. At the TOP of the worksheet, calculate the sum of the projected revenues and expenses as well as the size of the surplus or deficit. Format all values as Currency. TTC What is the percent increase in the TTC fare? Cell reference your answer into cell D6 on this worksheet. REV What is the sum of the project revenues for 2022? Cell reference your answer into cell D7 on this worksheet. EXP What is the sum of the project expenses for 2022? Cell reference your answer into cell D8 on this worksheet. diff What is the size of the deficit or surplus? Cell reference your answer into cell D9 on this worksheet. On the Task 2 worksheet, use Goal Seek to determine what overall property tax increase would be needed to balance next year's operating budget. Assume the formula in cell C5 calculates the difference between the total revenues and the total expenses. Copy the Case 5 worksheet and rename it as Task 3. Using Solver, revise the Task 3 worksheet to incorporate your recommendations for balancing the budget if the TTC fare increase is canceled, "all other categories of revenue" and "all other categories of expenses" are allowed to increase subject to "all other categories of revenue" being not less than 2%. (Property tax, water, solid waste, police and public health assumptions remain unchanged.) LITH 113 Marks Answer 5 2 3 3 1 3 0.000000000