ACCT 610 Advanced Managerial Accounting Data Analytics Problem PB 24 Student Summary Use the PivotTable and the variance reports to answer the following questions Which department experienced the greatest variance between budgeted and actual cost (in dollars) ANSWER Which expense type in that department accounted for the largest share of the variance ANSWER Which expense type had the highest unfavorable variance (in dollars) ANSWER Which department had the highest unfavorable variance in that expense type ANSWER Which expense type had the highest favorable variance (in dollars) ANSWER Which department had the highest favorable variance in that expense type ANSWER Which department had the highest percentage variance ANSWER Which type of expense was most over or under budget in that department ANSWER Which expense type had the highest percentage variance ANSWER Which department was most over or under budget in that expense type ANSWER Schools had the largest budget Does it appear that the budget dollars were well managed Explain your answer 4 In general, should the council members be more concerned about the departments or expense types with the highest unfavorable dollar variances or the highest unfavorable percentage variances Should the council members be concerned about departments or expense types with favorable variances Explain your answers

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jul 29, 2024

ACCT 610 Advanced Managerial Accounting Data Analytics Problem PB-24 Student Summary Use the PivotTable and the variance reports to answer the following questions: Which department

ACCT 610

Advanced Managerial Accounting

Data Analytics Problem PB-24

Student Summary

Use the PivotTable and the variance reports to answer the following questions:

Which department experienced the greatest variance between budgeted and actual cost (in dollars)?

ANSWER:

Which expense type in that department accounted for the largest share of the variance?

ANSWER:

Which expense type had the highest unfavorable variance (in dollars)?

ANSWER:

Which department had the highest unfavorable variance in that expense type?

ANSWER:

Which expense type had the highest favorable variance (in dollars)?

ANSWER:

Which department had the highest favorable variance in that expense type?

ANSWER:

Which department had the highest percentage variance?

ANSWER:

Which type of expense was most over or under budget in that department?

ANSWER:

Which expense type had the highest percentage variance?

ANSWER:

Which department was most over or under budget in that expense type?

ANSWER:

Schools had the largest budget. Does it appear that the budget dollars were well managed? Explain your answer.

4. In general, should the council members be more concerned about the departments or expense types with the highest unfavorable dollar variances or the highest unfavorable percentage variances? Should the council members be concerned about departments or expense types with favorable variances? Explain your answers.