* Attached is the excel that needs to be examined
Based on the variances highlighted by the Upselling, Efficiency, Coverage ratios, identify a total of 8 (EIGHT) relevant issues in the 2009 figures. A minimum of 2 issues/elements should be included from each component:
i) Revenue; ii) Dep. Expenses; iii) Undistributed Operating expenses.
For each of the issues/elements, the student should analyse.
a. What is the distinctive feature that has attracted the attention of the student to that particular issue/element?
b. What are the inconsistencies that the issue/element reveal?
c. Is there any information available in the Budget that justifies/explains the issue.
d. What would you ask to the Manager of the corresponding component to explain/justify