Have no idea how to solve this....

Elizabeth Harry is the owner of Harry's Grill&Bars. Elizabeth is preparing 2021 operations budget. Based upon her sales histories, sales projections, and cost records, Elizabeth predicted following changes in the operations for 2021 over 2020: Harry's Grill&Bars Budget Worksheet for December 31, 2020 3.16% 2020 Actual 2021 Budget 5.16%6 391,480 SALES Food Beverage Total Sales 130,493 ? ? ? 521,973 1 Increase in food sales revenue 2 Increase in beverage sales revenue 3 Food and beverage cost percentages will remain the same in 2021. (You need to calculate these percentages). 4 Salaries and wages cost will increase 5 Benefits will increase 6 An increase in all other operating expenses (except depreciation) 7 No change in annual depreciation & Interest payments for loans will total 9 Tax payments are estimated to be 5.66% 10.16% 2.16% $1,305 per month 21% of income before income taxes COST OF SALES Food Beverage Total Cost of Sales 137,018 27,404 164,422 ? ? ? GROSS PROFIT 357,552 ? Required: Prepare Harry's Grill&Bars' operations budget for 2021 in the budget worksheet using the information provided above. No hardcoded numbers are allowed. You need to enter formulas to make the calculations in the 2021 Budget column. OPERATING EXPENSES: Salaries and Wages Employee Benefits Direct Operating Expenses Music and Entertainment Marketing Utility Services Repairs and Maintenance Administrative and General Depreciation Total Operating Expenses Operating Income Interest Income Before Income Taxes Income Taxes Net Income 82,472 14,093 18,791 3,654 7,308 13,571 4,176 14,615 8,400 167,080 190,472 15,659 174,813 36,711 138,102 ? ? 2 ? ? ? ? ? 2