Please answer in an excel spreadsheet

Chigs (Year 2) Assignment Names in Group: Part 1 Part 1 Bud et Variance Ana! is 1. I would like to see some budget variance analysis (actual results vs. budget). Show the variance vs. budget in dollars and percentages for the Income Statement and Balance Sheet. The spreadsheet has been set up for you to do so. Calculate the S and % variances in the spreadsheet. Forthe S calculations, use Actual S minus Budget S. Forthe % calculations, calculate the % difference ((Actual S minus Budget S) divided by the Budget S). Use the results and budgets on the Revenue tab of the spreadsheet to analyze why revenue exceeded budget. Your analysis should be in the format as presented in Canvas. Summarize briefly why our actual revenue exceeded our budget revenue. To further analyze revenue, do a Price Volume Mix analysis for each store's Actual vs. Budget revenue. Gross Margin S was higher than budget but Gross Margin % was lower than budget. Why? Analyze the Gross Margin per cookie (Average Price, Average Material Cost, Average Labor Cost, Average Total Cost ofSales) to explain your answer. Operating Expenses finished higherthan budget. List the 3 items that were over budget the most (in S)? How much was each of these items over budget in S and %? Did you see any other items of concern? Part 2 Year-ta- Year Variance Anal sis 1. Perform Yearto-Year Variance Analysis comparing 2021 Actual Results to 2020 Actual Results (This Year vs. Last Year). Complete the Actual 2021 Results vs. Last Year sections ofthe spreadsheet. For the S calculations, use Actual This Year S minus Actual Last Year S. For the % calculations, calculate the % difference ((Actual This Year S minus Actual Last Year S) divided by Last Year S). It looks like we were successful in reducing our Long-Term Debt from last year's balance. Analyze the change from last year's LongTerm Debt (decrease of $86,480 from last year). Net Profit plus depreciation was one factor. What were the 2 biggest contributors on the Balance Sheet to the decrease this year compared to last year. Show each item (Net Profit plus depreciation, plus 2 balance sheet items and the amount they contributed to the decrease in Long-Term Debt. What was our sales growth year over year? Your analysis should be in the format presented in Canvas. Summarize briefly why our revenue grew over last year's revenue. Analyze the hours worked and wages paid for our Storefront workers and Bakers by comparing to last year's hours and wages. Your analysis should be in the format presented in Canvas. Briefly summarize your analysis. We had budgeted some increases. Were the increases in line with our budget? Explain. Use graphs to show the changes if helpful. I want the Board of Directors and company to focus on some Key Performance Indicators going forward. Based on your analysis, suggest 3 Key Performance Indicators (KPI) you think we should use to help us manage the business. Chips Income Statement Revenue Material Cost of Goods Sold Labor Cost of Goods Sold Total Cost of Goods Sold Gross Margin Gross Margin % Operating Expenses Lease Expense Utilities Expense Manager Salary Expense Manager Salary PT&B Expense Hourly Wage Expense Hourly Wage PT&B Expense Marketing Expense Professional Services Expense Office Supplies and Misc Supplies Expense Repairs and Maintenance Expense Insurance Expense Depreciation Expense Total Operating Expenses mmmmmmmmmmmmm Earnings Before Interest and Taxes S Interest Expense Tax Expense Net Income Net Income % Chips Balance Sheet Current Assets Cash Accounts Receivable Inventory Total Current Assets 2021 (Year 2) Actual 1,205,195 495,335 $ 5 $ 519,403 43.1% 110,931 42,987 122,400 38,475 87,249 5,409 21,545 30,583 2,976 18,257 1,647 13,390 495,849 mmmmmmmmmmmmm 23,554 4,712 4,710 123,419 190,457 186,276 685,792 652,577 2021 (Year 2) 1,153,441 466,301 500,864 43.4% 110,931 41,205 122,400 37,942 85,146 5,279 17,800 30,300 3,000 11,500 7,980 13,390 486,873 13,991 3,595 2,599 108,142 133,896 133,896 Accumulated Depreciation (64,542) (64,542) Tota Fixed Assets S 69,354 69,354 Equipment and Leasehold Improvements Total Assets 192,773 177,496 Current Liabilities Accounts Payable Taxes Payable Total Current Liabilities Longterm Debt Total Liabilities 96,200 87,257 Stock S 100,000 100,000 Retained Earnings S (3,427) (9,761) Total Equity S 96,573 90,239 Total Liabilities and Equity 192,773 177,496 $ % $ % 2020 (Year 1) 2021 Actual vs 2021 Actual vs 2021 Actual vs 2021 Actual vs Actual Budget Budget Last Year Last Year S 1,101,368 444,094 182,624 626,718 474,650 43.1% 108,756 40,399 120,000 37,198 83,477 5,176 18,497 36,478 2,983 12,479 7,598 13,390 486,430 (11,780) 11,631 5,852) 17,558) 1.6% 127,445 9,052 14,897 151,394