Fire is a BBQ restaurant serving dinner only at 'Y' Hotel Kangaroo Island. You are required...

Transcribed Image Text:

Fire is a BBQ restaurant serving dinner only at 'Y' Hotel Kangaroo Island. You are required to prepare a full P&L ($ and % to 2 decimal places) using the figures below. a) Fill in the empty cells in the spreadsheet (15 marks). b) Describe the reasons why the Y hotel owner and the hotel management (operators) has a different idea of the financial performance of Fire (5 marks). Food Sales $ 874,500 Gas & Electricity $ 18,524 Food Purchases $ 241,450 Insurance $ 12,265 Other Revenue Menu & printing Beverage Sales $ 52,850 Guest supplies $ 1,378 $ 560 Laundry $ 2,350 $ 245,815 Sales & Marketing $ 3,600 Beverage Cost $ 47,485 Glass $ 1,400 Wages & Salaries $ 395,605 Silver $ 830 Staff Benefits $ 62,530 China $ 1,230 Depreciation $ 21,461 Decoration $ 652 F&B Allocated Expenses $ 75,300 Linen $ 286 Revenue Food Sales Beverage Sales Other Revenue Profit and Loss Statement - Fish $ % Total covers 25478 SSSSA $ % Total working hours 5360 $ % $ % $ 100% Productivity 1. Cover/hour $ % 2. Revenue/hour $ SSS % % % Average check Total Revenue Cost of Goods Sold Food Cost Beverage Cost $ Total F&B costs Labour Cost $ % Wages & Salaries Staff Benefits $ Total Labour cost SSS $ % % % Gross Operating Profit $ % $ % Other expenses $ % Menu & printing S % Depreciation $ % F&B Allocated Expenses $ % Gas & Electricity $ % Insurance S % Guest supplies $ % Laundry $ % Sales & Marketing $ % Glass $ % Silver $ % China $ % Decoration $ % Linen $ % Total other expenses $ % Net operating profit $ % $ % 1. Average food check $ 2. Average beverage check $ Fire is a BBQ restaurant serving dinner only at 'Y' Hotel Kangaroo Island. You are required to prepare a full P&L ($ and % to 2 decimal places) using the figures below. a) Fill in the empty cells in the spreadsheet (15 marks). b) Describe the reasons why the Y hotel owner and the hotel management (operators) has a different idea of the financial performance of Fire (5 marks). Food Sales $ 874,500 Gas & Electricity $ 18,524 Food Purchases $ 241,450 Insurance $ 12,265 Other Revenue Menu & printing Beverage Sales $ 52,850 Guest supplies $ 1,378 $ 560 Laundry $ 2,350 $ 245,815 Sales & Marketing $ 3,600 Beverage Cost $ 47,485 Glass $ 1,400 Wages & Salaries $ 395,605 Silver $ 830 Staff Benefits $ 62,530 China $ 1,230 Depreciation $ 21,461 Decoration $ 652 F&B Allocated Expenses $ 75,300 Linen $ 286 Revenue Food Sales Beverage Sales Other Revenue Profit and Loss Statement - Fish $ % Total covers 25478 SSSSA $ % Total working hours 5360 $ % $ % $ 100% Productivity 1. Cover/hour $ % 2. Revenue/hour $ SSS % % % Average check Total Revenue Cost of Goods Sold Food Cost Beverage Cost $ Total F&B costs Labour Cost $ % Wages & Salaries Staff Benefits $ Total Labour cost SSS $ % % % Gross Operating Profit $ % $ % Other expenses $ % Menu & printing S % Depreciation $ % F&B Allocated Expenses $ % Gas & Electricity $ % Insurance S % Guest supplies $ % Laundry $ % Sales & Marketing $ % Glass $ % Silver $ % China $ % Decoration $ % Linen $ % Total other expenses $ % Net operating profit $ % $ % 1. Average food check $ 2. Average beverage check $