Initial Prompt: The manager of a restaurant has just received an income statement report comparing the establishment$$s financial performance this year to last year$$s performance. After reviewing the Excel workbook report below, answer the questions that follow to help the manager better understand the operation and its financial performance:

Week $7$ Discussion.xlsx

Questions:

What was the difference between the operation$$s food sales this year from the previous year?

Does this mark an improvement or a decline?

What was the difference between the operation$$s beverage sales this year from the previous year?

Does this mark an improvement or a decline?

What was the difference between the operation$$s total sales this year from the previous year?

Does this mark an improvement or a decline?

Did the operation spend more or less for food when comparing this year$$s expense to last year$$s expense?

By how much?

Did the operation spend more or less for beverages when comparing this year$$s expense to last year$$s expense?

By how much?

What was the amount of increase in management costs this year compared to last year?

What was the amount of increase in staff costs this year compared to last year?

What was the amount of increase in total labor costs this year compared to last year?

In what area or areas were this year$$s expense less than last year$$s expense?

What was the amount of profit made in the establishment this year?

What was the amount of profit made last year?

Why do you think the operation$$s cost of sales food this year is higher than last year?

Why do you think the operation$$s cost of sales beverage this year is lower than last year?

Response Prompt: Respond to at least two peers answers to questions $11$ & $12.$

SALES THIS YEAR LAST YEAR

Food $$750,000\mathrm{.}00$ $$690,000\mathrm{.}00$

Beverage $300,000\mathrm{.}00310,000\mathrm{.}00$

Total Sales $$1,050,000\mathrm{.}00$ $$1,000,000\mathrm{.}00$

COST OF SALES

Food $$250,000\mathrm{.}00$ $$225,000\mathrm{.}00$

Beverage $80,000\mathrm{.}0083,000\mathrm{.}00$

Total Cost of Sales $$330,000\mathrm{.}00$ $$308,000\mathrm{.}00$

LABOR

Management $$55,000\mathrm{.}00$ $$52,000\mathrm{.}00$

Staff $225,000\mathrm{.}00221,500\mathrm{.}00$

Employee benefits $85,000\mathrm{.}0083,500\mathrm{.}00$

Total Labor $$365,000\mathrm{.}00$ $$357,000\mathrm{.}00$

Prime Cost $$695,000\mathrm{.}00$ $$665,000\mathrm{.}00$

Other Controllable Expenses:

Legal$/$accounting $$1,750\mathrm{.}00$ $$1,690\mathrm{.}00$

Music and entertainment $12,000\mathrm{.}0011,500\mathrm{.}00$

Marketing $12,400\mathrm{.}0012,000\mathrm{.}00$

Utility services $18,000\mathrm{.}0017,500\mathrm{.}00$

General and administrative $12,500\mathrm{.}0012,000\mathrm{.}00$

Repairs and maintenance $15,000\mathrm{.}0013,500\mathrm{.}00$

Total Other Controllable Expenses $$71,650\mathrm{.}00$ $$68,190\mathrm{.}00$

Controllable Income $$283,350\mathrm{.}00$ $$266,810\mathrm{.}00$

Non$-$controllable Expenses:

Rent $$95,000\mathrm{.}00$ $$95,000\mathrm{.}00$

Depreciation $6,000\mathrm{.}006,000\mathrm{.}00$

Licenses$/$permits $500450$

Leases $2,500\mathrm{.}002,500\mathrm{.}00$

Total Non$-$Controllable Expenses $$104,000\mathrm{.}00$ $$103,950\mathrm{.}00$

Operating Income $$179,350\mathrm{.}00$ $$162,860\mathrm{.}00$

Interest Expense $$18,000\mathrm{.}00$ $$19,000\mathrm{.}00$

Other $($Income$)$ expense $500500$

Income Before Income Taxes $$160,850\mathrm{.}00$ $$143,360\mathrm{.}00$