a$)$ Answer the following questions using the dashboard:

i$.$ What is the overall variance from budget? $($Remember to determine whether it is favourable or unfavourable.$)$

ii$.$ Which province has the highest favourable variance?

iii. If all cities with an unfavourable variance were eliminated, what would be the budget variance?

b$)$ Using the following Information Format chart:

Level of management Decision type Time frame affected $($approximate$)$ Information format and source

Employees and supervisors Operational$/$routine decisions Short term $$ one day to one month Structured

Sourced internally via:

$$ transaction processing systems $($accounting based$)$

$$ Excel spreadsheets

Middle management Tactical decisions $$ what$-$if analysis One month to one year Semi$-$structured

Sourced mostly internally via:

$$ reports from management information systems

$$ Excel data analysis tools and dashboards

Senior management Strategic decisions $$ one$-$off decisions Long term $$ one year to future years Non$-$structured$/$ad hoc:

Sourced internally and externally via business intelligence systems:

$$ decision support systems

$$ data mining

$$ expert systems

i$.$ Identify which level of management would most likely use this dashboard. Back up your answer by discussing the decision type and the time frame affected.

ii$.$ If the dashboard contained multiple years of data, how would your answer change?

c$)$ Provide the leadership team with the following:

i$.$ Ways in which the dashboard can be used to assist in future expansion plans.

ii$.$ Ways in which the dashboard can be expanded to provide more information. Identify other performance measures the leadership team might be interested in seeing.