week4 629

• Complete the Variance Analysis Sheet . Complete the following in your variance analysis:
  • In the Excel template, insert the line items.
  • In Column C, (Previous Quarter, 20NN) enter the previous quarter’s (previous to the most recent quarter) numbers as the budget.
  • In Column D, (Current Quarter, 20NN) enter the current (most recent) quarter’s actual numbers.
  • In Column E, the spreadsheet will calculate the dollar difference between the budget and actual numbers.
  • In Column F, the spreadsheet will calculate the percentage change.
  • In Column G, provide a rationale for the variances.

 You must have at least 5 or more-line items in your variance analysis.