Question: $ ______ 10. Use the figures given below to complete the statement of income for the Blackburn Tavern, calculate percentages for each category using the

$ ______

10. Use the figures given below to complete the statement of income for the Blackburn Tavern, calculate percentages for each category using the Excel spreadsheet provided on the course page (Assignment 2 folder). After you complete your Excel spreadsheet calculations, copy and paste your excel spreadsheet answer below.

Food Sales$723,556.00

Salaries and Wages$228,456.00

Beverage Sales$224,945.00

Other Controllable$145,532.00

Beverage Cost$ 57,534.00

Employee Benefits$ 14,667.00

Food Cost$265,998.00

Occupancy Costs$ 44,860.00

Depreciation Expense$ 74,856.00

Interest$ 21,790.00

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Worksheet question. Use the figures given below to complete the Statement of Income for the Sunshine Restaurant (you can use the Excel worksheet provided separately and copy/paste your answer below...

10. Each answer, a) and b) is worth .5. In answer b), each number is worth .1 . Us ing the Excel Spreadsheet provided separately, do the following: a) Prepare the Sunshine Pubs Income Statement and c...

8. Use the figures given below to complete the Statement of Income for the Sunshine Restaurant (use the Excel worksheet provided separately and copy/paste your answer below. In the Assignment 1...

9 . Each answer, a) and b) is worth 1 point . In answer b), each number is worth . 2 . Us ing the Excel Spreadsheet provided separately, do the following: a) Prepare the Sunshine Pubs Income...

question 8 : Use the figures given below to complete the Statement of Income for the Sunshine Restaurant (use the Excel worksheet provided separately and copy/paste your answer below if you would...

5. Calculation question. Use the information from question (4) above, assume that fixed cests will decrease by 10 percent in April and deterulbe lixed cost per cover if the number of covers increases...

Each answer, a) and b) is worth 1 point . In answer b), each number is worth . 2 . Us ing the Excel Spreadsheet provided separately, do the following: a) Prepare the Sunshine Pubs Income Statement...

Assignment: Excel (75 points) Read the brief case below. Using the Excel spreadsheet provided, complete the questions. Downtown Office Supply Downtown Office supply is a small family owned store in a...

Read the brief case below. Using the Excel spreadsheet provided, complete the questions. Downtown Office Supply Downtown Office supply is a small family owned store in a small suburb. In order to...

Prepare your analysis for Management. Create a Table of Contents. Create a new worksheet and move it to the beginning. This worksheet should list the contents of the workbook along with the purpose...

Prove that the 1/2 quantile as defined in Definition 3.3.2 is a median as defined in Definition 4.5.1.

Given the following items on a company's balance sheet, how much did the company owe its creditors at the time the balance sheet was constructed? Cash $2,200 Liabilities ??? Inventory $205 Equipment...

Question 5 1 pts Assume you borrow a PLAM of $ 1 2 0 , 0 0 0 for 3 0 years. If real interest rate is 4 . 7 5 % and inflation is expected to be 4 % in year 2 , what is the amount required to payoff...

Mario is working on building a high performance work organization as part of his HR duties. Which of these tasks will Mario most likely NOT perform during this process? Group of answer choices...

13.6 Explain how to set up aflexible benefits program.

13.2 Describe five government-mandated benefits.

13.3 Discussfive types of voluntary healthcare-related employee services or benefits offered to employees.