Tim is open from 11:30am until 9:00pm 5 days per week, which works out to 250 days per year considering holiday closures. Tim recently invested in Toast, a mobile POS system for taking orders and issuing checks. The new system, which cost $35,000, provides key information on sales and costs, while also facilitating the job of employees who take orders and issue the checks. Using this new system, Tim obtained the following information on his results for 2019:
Sales from Food: $430,000 (excludes tips)
Sales from Drinks: $240,000 (excludes tips)
Number of customer bills/checks 18,000 (includes drinks and food)
Direct Costs of Food: $200,000
Direct Costs of Drinks: $ 80,000
Wages for hourly Workers: $140,000 (includes all employment costs)
Salary of Manager: $ 60,000 (includes all employment costs)
Other operating Expenses $ 80,000 (rent, insurance, supplies, real estate taxes, etc.)
Please calculate the following for Tim’s Bar and Grill:
a) Average bill for food: ______
b) Average bill for drinks: ________
c) Average CM for food: _________ (CM = contribution margin)
d) Average CM for drinks: ______
e) CM % on food: _______
f) CM % on drinks: _______
g) Total CM %: _______
h) Total Revenue: _______
i) Total CM: ________
j) Operating Expenses: _______
k) Operating income: ________
l) Average hourly labor cost per bill: _______
Sales from Drinks: $240,000 (excludes tips)
Number of customer bills/checks 18,000 (includes drinks and food)
Direct Costs of Food: $200,000
Direct Costs of Drinks: $ 80,000
Wages for hourly Workers: $140,000 (includes all employment costs)
Salary of Manager: $ 60,000 (includes all employment costs)
Other operating Expenses $ 80,000 (rent, insurance, supplies, real estate taxes, etc.)
Please calculate the following for Tim’s Bar and Grill:
a) Average bill for food: ______
b) Average bill for drinks: ________
c) Average CM for food: _________ (CM = contribution margin)
d) Average CM for drinks: ______
e) CM % on food: _______
f) CM % on drinks: _______
g) Total CM %: _______
h) Total Revenue: _______
i) Total CM: ________
j) Operating Expenses: _______
k) Operating income: ________
l) Average hourly labor cost per bill: _______
In 2020, Tim’s expects the following changes to his business:
a) Wages for workers will increase by 15% because of a new minimum wage.
b) He will increase the salary of the manager by 5%.
c) All other costs, including material costs per meal, are not expected to change.
d) He plans to increase his prices of food by 3% and to increase his drink prices by 5%.
e) The number of customers (meals) is expected to increase by 2%
a) Wages for workers will increase by 15% because of a new minimum wage.
b) He will increase the salary of the manager by 5%.
c) All other costs, including material costs per meal, are not expected to change.
d) He plans to increase his prices of food by 3% and to increase his drink prices by 5%.
e) The number of customers (meals) is expected to increase by 2%
Using this new information, please forecast the following for 2020:
a) Average bill for food: ______
b) Average bill for drinks: ________
c) Average CM for food: _______
d) Average CM for drinks: ______
e) Average total CM per bill: ________
f) Total CM %: _______
g) Total Revenue: _______
h) Total CM: ________
i) Operating income: ________
j) Average hourly labor cost per bill: _______
a) Average bill for food: ______
b) Average bill for drinks: ________
c) Average CM for food: _______
d) Average CM for drinks: ______
e) Average total CM per bill: ________
f) Total CM %: _______
g) Total Revenue: _______
h) Total CM: ________
i) Operating income: ________
j) Average hourly labor cost per bill: _______
