I completed the first $2$ tabs but cannot understand how to do the Variance Analysis. In the Variance Analysis project, $\backslash$table$[[$A$,$B$,$C$,$D$,$E$,$F$,$G$,$H$],[$PRO FORMA INCOME STATEMENT$],[$In millions, except per share data,$202$N $($Forecast$),$Rationale,March $31,2024,$June $30,2024,$Percentage Change,September $30,2024($Projected$),],[$Net Sales,$$9,059\mathrm{.}9$M$,$Variable $-$ Sales decreased by $0\mathrm{.}59\%.,9059\mathrm{.}9,9100,0\mathrm{.}004426097,9140\mathrm{.}277487,],[$Cost of Sales,$$2,724\mathrm{.}6$M$,$Variable $-$ Cost of Sales decreased by $0\mathrm{.}59\%.,2724\mathrm{.}6,2730,0\mathrm{.}001981942,2735\mathrm{.}410702,],[$Gross Profit,$$6,373\mathrm{.}0$M$,$Gross profit reflects projected sales.,$6373,6370,-0\mathrm{.}000470736,6370,],[$Selling$,$ General and Administrative,$$3\mathrm{.}886\mathrm{.}5$M$,$SG&A increased by $1\mathrm{.}5\%$ based on fixed$/$variable sp$.,3886\mathrm{.}5,3900,0\mathrm{.}003473562,3900,],[$Depreciation and Amortization,$$143\mathrm{.}9$M$,$Fixed $-$ Depreciation and Amortization unchanged.,$143\mathrm{.}9,143\mathrm{.}9,0,143\mathrm{.}9,],[$Total Operating Expenses,$$3,973\mathrm{.}0$M$,$Operating expenses based on SG&A and depreciatio,$0,0,,0,],[$Operating Income,$$5,140\mathrm{.}9$M$,$Operating income adjusted based on sales and expen:,$0,0,,0,],[$Interest Income and Other, Net,$$-7\mathrm{.}0$M$,$Interest income unchanged.,$0,0,,0,],[$Interest Expense,$$413\mathrm{.}0$M$,$Interest expense unchanged.,$0,0,,0,],[$Earnings Before Provision for Income Taxes,$$4,727\mathrm{.}9$M$,$Earnings before tax adjusted for operating income anc,$0,0,,0,],[$Provision for Income Taxes,$$1,403\mathrm{.}0$M$,$Provision for income taxes remains proportional to ea$,0,0,,0,],[$Net Earnings,$$3,324\mathrm{.}9$M$,$Net earnings based on adjusted sales and expenses.,$0,0,,0,],[,,0,0,,0,],[,,0,0,,0,],[\backslash$table$[[$Summary Note:$],[-$ The latest quarterly financial report for$],[$Starbucks $($June $30,2024)$ showed a $0\mathrm{.}59\%],[$decrease in sales compared to the previous$],[$quarter $($July $2,2023).],[-$ Based on the assignment instructions, which$],[$specify using the same percentage increase or$],[$decrease from the previous quarter, a $0\mathrm{.}59\%],[$decrease was applied to forecast the next$],[$quarter$\text{'}$s sales.$],[-$ All variable costs, including Cost of Sales$],[$and operating expenses, were adjusted in line$],[$with the sales decrease, while fixed costs$],[$remained constant.$]]],[,,,,,,,],[,,,,,,,],[,,,,,,,],[,,,,,,,],[,,,,,,,],[>,$ Pro Forma Income Statement,Pro Forma Bala,ance Sheet Variance Analysis $,+,,,,4,]]$

Complete the Variance Analysis Sheet on the appropriate tab in the Financial Forecasting Template, using the downloaded data.

Calculate a quarterly variance analysis using the Variance Analysis tab of the Financial Forecasting Template $($the same template you used in Week $3).$ Complete the following in your variance analysis:

In the Excel template, insert the line items.

In Column C$,($Previous Quarter, $20$NN$)$ enter the previous quarter$$s $($previous to the most recent quarter$)$ numbers as the budget.

In Column D$,($Current Quarter, $20$NN$)$ 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.

Note: This needs to be an MBA level of analysis. $1-$ or $2-$line items in the variance analysis are significantly below expectations. You must have at least $10$ or more$-$line items in your variance analysis.