Question
Please help me design the spreadsheet 'a yvu Calibri (Body) 11 Wrap Text v Merge & Center v General Paste 83 X fx Asper decisions
Please help me design the spreadsheet
'a yvu Calibri (Body) 11 Wrap Text v Merge & Center v General Paste 83 X fx Asper decisions made by the city council, the following increases for 2022 were agreed upon: c As per decisions by the city council, the following 2022 were upon: the revenue side, the city budget committee proposes the following Increases: -an overall propertytax increase of 2.7% which representsaweighted average ofthe following: 4.4% Incree for residentid properties (2.9% for inflation plus a 1.5% lew), 1.45% increze for commercial properties , 0.97% for industrial properties , and 0% increase for mu residential/apartment buildings as per provincial legislation, and some reductions in property tax for small business -a water rate increze of 3.0% -a solid rate increase of 3.0% -a Toronto Transit Commission (Conventional) fare increase by SC per ride, from $3.25 to $3.30 for an Presto 6re - a 2.11% increase for all other c*egories of revenue the expense the city budget committee propogs to increase each expense category by an averV predicted inflation of 3.3% except the -an increase of2.3% to the Toronto Police Service - a 3.1% increase to Toronto Public Health Marks Answer Task 1 Design 5 TTC 6 REV EXP On the Case S worksheet, calculate the revenues and expenses for the next year using the proposed increases in the case. [Use the=ROUNDfunction when calculating the TTCfare increase. Round to 3 decimals, then format as percentage showing 1 decimal.] 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 ofthe worksheet, calculate the sum of the projected revenues and expenses as well as the size of the surplus or deficit. Format all val uz as Curre'cy. What is the percent increase in the TTC fare? GI reference your answer into cdl DS on this worksheet. What is the sum of the projet revenues for 2022? Cell reference your answer into cell D7 on this worksheet. What isthesum oftheproject expenses for 2022? Cell reference your answer into cell D8 on this worksheet. diff What isthe size ofthe deficit or surplus? Cell reference your answer into cell D9 on thisworksheet. On the Task 2 worksheet, use Goal Sek to determine what overall property tax increase would be needed to balance next operating Task 2 Goal Seek budget. Assumetheformulain cell CS calculates the difference between the total revenuesand the total expenses. 5 2 3 3 1 3 3 3 2 25 D 0.000000000 10 Task 3 11 12 13 14 15 16 Solver Rev Solver Exp Solver Setup Copy the Case 5 worksheet and renameit as Task 3. Using Solver, revise the Task 3 worksheet to incorporate your recommendations for balancing the budget if the TTC fare increaseiscanceled, "all other categories of re.'enue" and "all other categories of expulses" areallowed to increase subjt to "all other categoriesof re.ue" being not lessthan 2%. (Property tax, water, solid waste police and public health assumptions remain After Solver, what is the percent increase for "all other categorie of revenue"? Cell reference your answer into cell Dl 3 on this worksheet. After Solver, what is the increase for "all other categories of expenses"? Cell reference your answer into cell 013 on this worksheet. Solver is used
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started