Question

16 Review Later Identify which of the following is not a goal of the variance dashboard. Conveying a lot of information as quickly as possible Presenting several different types of information all on one screen Using graphs in place of tables where appropriate A detailed written report 17 Review Later To find out the value of the assumptions that are needed to hit a certain budget target, you would use to optimize output, you would an use Solver, goal seek Pivot table, consolidate Consolidate, pivot table Goal seek, solver 18 Review Later Which of the following is not an advantage to link workbooks? Provides flexible reporting system Small management budget templates can be sent to budget holders Different spreadsheets can be worked on simultaneously by different people The links will update themselves when the file name changes Review Later Use the same Excel data in the previous question and run a multiple regression to estimate the relationship between promotion, advertising (independent variables) and revenue (dependent variable). Calculate the revenue if the promotion cost is $150 and the advertising COst is $250. 1624,33 1060.83 1358.71 1743.04 20

Answer 1

16. Solution: The correct option is “4^th option” i.e A detailed written report

A variance dashboard aims at conveying a lot of information using graphs and charts in order to disclose the actual values , the changes in the period and the variances from the budget. This ensures that the comparison of the actual performance with the budgets set are quickly done and variances are highlighted and made available quickly in an easy manner with guided user interface. There is no detailed written report and therefore this can never be the goal of the variance dashboard.