PROFIT AND LOSS STATEMENT
Given: Total Seats
100
Total turns 2
ASSUMPTIONS: Average check: $25 food and $10 beverage.
Food cost is 28% of food sales. Beverage cost is 19% of beverage sales, and labor is 29%.
Direct operating expenses are 28% and occupancy cost is 8%.
What are total
weekly
sales?
What is the SALES MIX as a percentage?
What is food cost as a dollar amount? Remember, you must find food sales first.
What is beverage cost as a dollar amount? Remember, you must find beverage sales first.
What is the cost of goods sold as a percentage?
What is the gross profit as a dollar amount?
What is the gross profit as a percentage?
What is labor cost as a dollar amount?
What are direct operating expenses in dollars?
What are occupancy costs in dollars?
What is the profit in dollars?
A. Total Seat | 100 | |||
B. No of Turn | 2 | |||
C. Total number of seats (A*B) | 200 | |||
D. Averge check Food | 25 | |||
E. Averge check beverage | 10 | |||
F. Total Food sale (D*C) | 5000 | |||
G. Total Beverage sale (E*C) | 2000 | |||
H. Total Sale (F+G) | 7000 | |||
Q1 | Total Weekly Sale (H*7days) | 49000 | ||
Q 2 | I. Sales mix Food (F/H) | 71.4% | ||
J. Sales mix Beverage (G/H) | 28.6% | |||
K. Food cost / food sale | 28% | |||
Q3 | L. Total Food cost (K*F)/day | 1400 | 9800 | /week |
M. Beverage cost/beverage sale | 19% | |||
Q 4 | N. Total beverage cost (M*G)/day | 380 | 2660 | /week |
O. Total cost of good sold/day (L+N) | 1780 | 12460 | /week | |
Q 5 | P. Cost of good sold as % (O/H) | 25.4% | ||
Q 6 | Q. Gross operating profit /day(H-O) | 5220 | 36540 | /week |
Q 7 | R. Gross operating profit in % (Q/H) | 74.6% | ||
S. Labour | 29% | |||
Q 8 | T. Labour cost/day (S*H) | 2030 | 14210 | /week |
U. Direct Operating exp | 28% | |||
Q 9 | V. Direct operating cost/day (U*H) | 1960 | 13720 | /week |
W. Occupancy cost | 8% | |||
Q 10 | X. Occupancy Cost (W*H) | 560 | 3920 | /week |
Q 11 | Profit /day (Q-T-V-X) | 670 | 4690 | /week |
PROFIT AND LOSS STATEMENT Given: Total Seats 100 Total turns 2 ASSUMPTIONS: Average check: $25 food...
Download the Profit and Loss example associated w/ this module (3). Using the notes from this weeks class, complete the pro-forma Profit and Loss statement and upload to this link. PROFIT AND LOSS STATEMENT Given: Total Seats 100 Total turns 2 ASSUMPTIONS: Average check: $25 food and $10 beverage. Food cost is 28% of food sales. Beverage cost is 19% of beverage sales, and labor is 29%. Direct operating expenses are 28% and occupancy cost is 8%. What are total...
Need help creating a income statement with the following information provided. Information from the Income Statement for December 2017 • Past year revenues were $2,200,000 with food accounting for 80% of sales. • Cost of sales were 32.62% of total sales with a food cost of 37.1% and a beverage cost of 14.7% • Expenses as a percentage of total sales were provided by Mr. Medom • Annual Rent is $154,000 Salaries & Wages Depreciation Interest Marketing General & Administrative...
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...
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...
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...
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...
Sales $ 35,000,000 Operating expenses Variable expenses Fixed expenses $28,000,000 3,500,000 Total expenses 31,500,000 Operating profit $ 3,500,000 1. Determine the breakeven point in sales dollars Breakeven point in sales dollars 17,500,000 2. Determine the required sales in dollars to earn a before-tax profit of $4,500,000. (Do not round intermediate calculations. Round your answer to the nearest whole dollar amount.) Required sales in dollars $ 40,000,000 3. What is the breakeven point in sales dollars if the variable cost increases...
Contribution Margin, Break-Even Sales, Cost-Volume-Profit Chart, Margin of Safety, and Operating Leverage Belmain Co. expects to maintain the same inventories at the end of 20Y7 as at the beginning of the year. The total of all production costs for the year is therefore assumed to be equal to the cost of goods sold. With this in mind, the various department heads were asked to submit estimates of the costs for their departments during the year. A summary report of these...
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...
1. Which of the following are elements of revenue? a. food and beverage b. volume and price c. profits and cash flow d. advertising and profits 2. Ignoring price elasticity, which of the following is the best contributor to larger profits? a. increase in menu prices b. increase in customers c. increase in advertising d. inelastic demand 3. Which of the following can be used to forecast sales? a. statistical models b. CVP c. moving average method d. all of...