HELP PLEASE! PLEASE INCLUDE ALL FORMULA IF NEEDED

10. Jerri Ellias is the owner of small craft brewery. In a casual setting, her oper- ation serves food and a variety of specialty brewed beers. June is a busy month for her and she has just completed it. Jerri uses a modified version of the Uniform System of Accounts for Restaurants (USAR) to prepare her budgets and income statements because she wants to identify her opera- tion's total gross profit (see Chapter 9). Below are her original budget and her actual operating results for the month of June. Complete the worksheet for her by providing variance dollars and variance percentages for each budgeted item and then answer the questions that follow. Jerri's Budget Versus Actual Results Comparison for June Budget ($) % Actual ($) % Variance ($) % Sales Food 179,200 71.8% 193,251 68.4% Beverage 70,250 28.2% 89,250 31.6% Total sales 249,450 100.0% 282,501 100.0% Cost of Sales Food 67,500 37.7% 68,925 35.7% Beverage 14,500 20.6% 22.9% Total cost of sales 20,415 89,340 82,000 32.9% 31.6% Gross Profit Food 111,700 62.3% 124,326 64.3% 55,750 79.4% 68,835 77.1% 167,450 67.1% 193,161 68.4% Beverage Total gross profit Operating Expenses Management & staff Employee benefits Direct operating expenses Music & entertainment 38,750 15.5% 44,850 15.9% 9,500 3.8% 11,203 4.0% 26,500 10.6% 27,210 9.6% 0 0.0% 0 0.0% 1,200 0.5% 150 Marketing 0.1% 3,250 1.3% 3,289 1.2% 3,500 1.4% 2,874 1.0% Utility services Repairs & maintenance Administrative & general 24,750 9.9% 25,598 9.1% 1,200 0.5% 1,200 0.4% 2,200 0.9% 2,200 0.8% Occupancy Depreciation Total operating expenses 110,850 44.4% 118,574 42.0% Chapter 10 Planning for Profit Jerri's Budget Versus Actual Results Comparison for June Budget ($) % Actual ($) % Variance ($) % Operating Income 56,600 22.7% 74,587 26.4% Interest 7,100 2.8% 7,100 2.5% Income Before Income Taxes 49,500 19.8% 67,487 23.9% Income taxes 12,625 5.1% 16,872 6.0% Net Income 36,875 14.8% 50,615 17.9% What is the variance (dollar and percent) in Jerri's total cost of sales for the month of June? What was the cause of the variance in Jerri's total cost of sales for the month of June? What is the variance (dollar and per- cent) in Jerri's management and staff costs for the month of June? To what would you attribute the variance in Jerri's management and staff costs for the month of June