Question
Answers the questions
EXCEL EXERCISES X 35 15.) The financial records of the Colonial Restaurant reveal the following figures for the year ending December 31, 20xx: Depreciation, $25,000 Food sales, $375,000 Cost of beverages sold, $30,000 Other controllable expenses, $60,000 Salaries and wages, $130,000 Beverage sales, $125,000 Employee benefits, $20,000 Cost of food sold, $127,500 Occupancy costs,$55,000 a. Following the form illustrated in Figure 1.1, prepare a statement of income for the business. b. Determine the following percentages: Food cost percent Labor cost percent (p?yroll, plus payroll taxes and employee benefits) Beverage cost percent Combined food and beverage cost percent Percentage of profit before income taxes c. Assuming the restaurant has 75 seats, determine food sales per seat for the year. 16. Define the key terms in this chapter
0 0
Add a comment Improve this question Transcribed image text
Request Professional Answer

Request Answer!

We need at least 10 more requests to produce the answer.

0 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)


All students who have requested the answer will be notified once they are available.
Know the answer?
Add Answer to:
Answers the questions EXCEL EXERCISES X 35 15.) The financial records of the Colonial Restaurant reveal...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
  • 13. In the current year, the manager of the Downtowner Restaurant has been following the operating...

    13. In the current year, the manager of the Downtowner Restaurant has been following the operating budget reduced here: For the coming year, the following changes are expected: Given these anticipated changes, prepare ab operating budget for the Downtowner Restaurant for the coming year. 13. In the current year, the manager of the Downtowner Restaurant has been following the operating budget reproduced here For the coming year, the following changes are expected a. Food sales will increase by 10 percent...

  • QUESTIONS AND PROBLEMS 69 Sales Food Beverage Total sales 630,000 140,000 $770,000 Cost of Sales ...

    question 13 14 Thanks for your help We were unable to transcribe this imageQUESTIONS AND PROBLEMS 69 Sales Food Beverage Total sales 630,000 140,000 $770,000 Cost of Sales Food Beverages Total costs 252,000 35,000 Gross Profit Controllable Expenses 287,000 $483,000 Salaries and wages Employee benefits Other controllable $173,250 45,045 82,000 expenses Total Controllable Expenses Income before Occupancy $300,295 $182,705 Costs, Interest, Depreciation, and Income Taxes Occupancy Costs Income before Interest 64,000 $118,705 Depreciation, and Income Taxes Interest Depreciation Total Restaurant...

  • Please help me for question 12 13 14. Thank you !! searched before they leave the...

    Please help me for question 12 13 14. Thank you !! searched before they leave the premises each dy this will reduce the problem of employee theft. Discuss the pos costs and potential benefits the manager should consider before tuting this policy. 11. Define standard procedures, and give two examples from your own 12. The following information has been prepared by the manager of the experience. Market Restaurant. It represents his best estimates of sales and various costs for the...

  • 9. The Wheatfield Valley golf course has been owned by the Miley family for two generations. Currently, it is mana...

    9. The Wheatfield Valley golf course has been owned by the Miley family for two generations. Currently, it is managed by Cyrus Miley, a graduate of State University, where he majored in hospitality management. Last year was a good one for the golf course. Now Cyrus is preparing next year's operating budget. He has gathered a great deal of information to help him prepare the best budget possible. After carefully analyzing that information, Cyrus predicts that next year the course...

  • 9. Lucir manages a German restaurant in a large western city. The restaurant's owner wants to...

    9. Lucir manages a German restaurant in a large western city. The restaurant's owner wants to know how well Lucir did this year at generating sales, controlling costs, and providing a profit. The owner promised Lucir that he would give her a raise if she increased return on sales (profit margin) by at least 1 percent. Complete Lucir's P&L. Should Lucir receive a raise? 9. Lucir manages a German restaurant in a large western city. The restaurant's owner wants to...

  • Hospitality Cost Accounting Exercise XYZ RESTAURANT SALES $1,400,000.00 100.00% FOOD BEVERAGE TOTAL SALES COST OF FOOD...

    Hospitality Cost Accounting Exercise XYZ RESTAURANT SALES $1,400,000.00 100.00% FOOD BEVERAGE TOTAL SALES COST OF FOOD SOLD $485,000.00 34.64% GROSS PROFIT $915,000.00 65.36% EXPENSES SALARY $180,000.00 12.86% WAGES $200,000.00 14.29% 4.64% 6.43% 9.29% EMPLOYEE $65,000.00 BENEFITS SUPPLIES $90,000.00 RENT $130,000.00 UTILITIES $120,000.00 TRASH REMOVAL $8,500.00 LEGAL & $20,000.00 ACCOUNTING 8.57% 0.61% 1.43% TOTAL EXPENSES $813,500.00 58.11% LEGAL & ACCOUNTING $20,000.00 1.43% TOTAL EXPENSES $813,500.00 58.11% PROFIT BEFORE DEPREC. AND INCOME TAXES $101,500.00 7.25% Please show all your work! a. Sales...

  • Insert Mi Duyexlsx - Protected Page Layout PROTECTED VIEW Formulas Data Be careful--files from the Internet...

    Insert Mi Duyexlsx - Protected Page Layout PROTECTED VIEW Formulas Data Be careful--files from the Internet can contain viruses. Unless you need to Review View H H9 --NM Income Statement D Percent 3 Sales 4 Food 5 Beverage 6 Total Sales 7 Cost of Sales 8 Food Cost 9 Beverage Cost 10 Cost of Goods Sold 11 Gross Profit Dollars 1,013,600 386,400 1,400,000 72.4% 27.6% 100.0% 331,447 85,394 416,841 32.7% 22.1% 29.8% 70.2% 12 403,200 96,600 499,800 916,641 28.8% 6.996...

  • 1. Nicole Englezakis manages a South African restaurant in a large southern city. The owner wants...

    1. Nicole Englezakis manages a South African restaurant in a large southern city. The owner wants to know how well Nicole did this year at generating sales, controlling expenses, and providing a profit. Complete Nicole's P&L using vertical analysis. Nicole's P&L Last Year % This Year SALES: $3,706,381 $647,555 $3,746,245 1,255,358 1,282,656 1,611,630 162,231 145,607 Food Beverage Total Sales COST OF SALES: Food Beverage Total Cost of Sales GROSS PROFIT: Food Beverage Total Gross Profit OPERATING EXPENSES: Salaries and Wages...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT