I am working on this question and need help. I am unsure how to move forward or what I am needing to include. I am stuck. Can you help?

complete the Income Statement and Balance Sheet on the appropriate tabs in the Financial Forecasting Template. Assume the following:

• Sales will increase for the next quarter by the same percentage increase from the previous quarter to the last reported quarter. For example, if sales increased 8% from the last quarter to the current reported quarter, you will use 8% as the sales increase for your pro formas.

Calculate the expenses to determine what will change and what will remain the same.

Within each line item expense explain your rationale, as well as provide a brief summary.

Then, calculate a quarterly variance analysis using the Variance Analysis tab of the Financial Forecasting Template (the same template you used for Part 1). Complete the following in your variance analysis:

• In the Excel template, insert the line items.
• In Column C, (Q4, 20NN) enter the previous quarter's numbers as the budget.
• In Column D, (Q1, 20NN) enter the current 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, analyze and speculate the rationale for the variances.

The following is the link to Starbucks reporting and I included a copy paste:

https://www.sec.gov/cgi-bin/viewer?action=view&cik=829224&accession_number=0000829224-23-000037&xbrl_type=v#

\fA B C D E F PROFORMA BALANCE SHEET Q4 2022 Q1 2023 Total Net Revenues - Company Operated Stores 7142.3 6276.7 WN Total Net Revenues - Licensed Stores 1069.5 849.5 4 Total Net Revenues - Product & Service, Other 508 509.4 5 Assets 6 Cash & Cash Equivilents 7 8 9 10 11 12 13 14 15 16 17 18 19 20 IN 22Cells E9 and F9 have prepopulated formulas and will calculate automatically for you. EXAMPLE ASSIGNMENT 7 End of Variance Analysis worksheet and , end of workbook LINE ITEM 04' QL AMOUNT PERCENT POTENTIAL RATIONALE FOR VARIANCE ZDNN ZDNN VARIANCE ' Due to raising interest rates, the company was able to earn more money Interest Expense 5 (25.90) S (75.00) S (49.10) 189.58% from interest bearing investments. (14, Q1, PERCENT LINE ITEM ZDNN ZDNN AMOUNT VARIANCE POTENTIAL RATIONALE FOR VARIANCE Enter your line item or \"DIV/DI 3 Months Ended 5 Months Ended (2 d ed Consolidated Statements of Earnin 5 USD shares in Millions in Millions 0" ens g m '5 Apr. 02, 2023 Apr. 03, 2022 Apr. 02, 2023 Total net revenues S8,?19.8 S?,535.5 51?,433.8 Product and distribution costs 2,801.? 2,455.8 5,511.9 Store operating expenses 3,535 3,314.2 2,301.3 Other operating expenses 125.2 101.? 255.4 Depreciation and amortization expenses 341.9 35?.? 559 General and administrative expenses 520.4 481.5 1,201.3 Restructuring and impairments 8.8 4.4 14.? Total operating expenses 2,535 5,235.3 15,053.5 Income {Loss} from Equity Method Investments 51.4 49.1 109.2 Gain on sale of assets 91.3 0 91.3 Operating income 1,32?.5 948.9 2,580.? Interest income and other, net 18.4 45.3 30 Interest expense {135.3} {119.1} {255} Earnings before income taxes 1,209.5 8?5.1 2,344.? Income tax expense 301.3 201.1 581.1 Net earnings including noncontrolling interests 1,?53.5 Net earnings attributable to noncontrolling interests 0 Net earnings attributable to Starbucks S1,?53.5 EPSbasic $1.54 EPS diluted 5 1.53 Weighted average shares outstanding: Basic 1,148.5 1,149.2 1,148.4 Diluted 1,152.2 1,153.5 1,152.3 Companyoperated stores [Member] Total net revenues S?,142.3 55,2?5.? 5 14,225.? Licensed stores [Member] Total net revenues 1,059.5 849.5 2,189 Product and Service, Other [Member] Total net revenues $508 $509.4 S 1,019.1 Apr. 03, 2022 3 15,535 4,55 2.2 5,214.5 203.4 233.3 1,002.3 {3.1} 13, 543.2 35.4 0 2,125.2 45.2 {234.4} 1,533.5 442.4 1,451.1 0.2 S 1,450.4 s 1.25 s 1.23 1,155.4 1,155.2 S 12,5551 1,200.3 s 535.5