Task 13 Financial report 1. Analyse the data in table above to identify: a) In terms...

  
 

Transcribed Image Text:

Task 13 Financial report 1. Analyse the data in table above to identify: a) In terms of sales, state which is the best performing department? Food & Beverage b) In terms of Net profit, state which is the worst performing department? c) State the total Gross Profit d) What could improve the Gross Profit figure? State 2 different ways. e) In what way does improving staff performance increase the profits of the hotel. State 2 different ways. From the Accommodation Profit & Loss Account, state the total of the following costs: a) Inventory b) Fixed c) Variable Present conclusions as to the effectiveness of the guest service operation in the hotel, supporting your evidence with financial evidence. As manager of a poorly performing department, what processes would you implement to resolve guest service problems? Task 12.1 Task 12.1 Department Accommodation Food & Beverage Spa Total Department Accommodation Food&Beverage Spa Total Sales (SAR 000) 2532.50 3325.00 2000.00 7898.00 Gross Profit 2.097.700 2.125.500 150.000.00 5.723.00 Sales Cost of sales Controllable expences 2.532.500 434.800.00 1.508.000.00 3.325.500 2.125.500.00 1.580.000.00 2000000 5.000.000 704.000.00 7.858.000 2.134.800 3.792.000 Net Profit 149.70 105.50 720.00 2322.00 Fixed expences 440.000.00 440.000.00 76.000.00 3.792.000 Total expences 1.948.000.00 2.020.000.00 780.000.00 4.748.000 Gross profit Net profit 2097.700.00 149.700.00 2.125.000.00 105.000.00 1.500.000.00 720.000.00 5.728.000 9,747,000 Task 12.2 Inventory sales-hotel ro Variable cost Salaries and wages 380.000.00 Heating 38.000.00 Glassware and drinks 80.000.00 Repairs and renewal 60.000.00 From the Accommodation Profit & Loss Account, list the following costs Electricity 200.000.00 Replacing linen 150.000.00 Newspapers and flow 200.000.00 Printing and stational 400.000.00 Total variable cost 1.508.000.00 434,800 Fixed cost Rent and rates Equipment lease Insurance Total fixed expenses 300.000.00 20.000.00 120.000.00 440.000.00 Task 13 Financial report 1. Analyse the data in table above to identify: a) In terms of sales, state which is the best performing department? Food & Beverage b) In terms of Net profit, state which is the worst performing department? c) State the total Gross Profit d) What could improve the Gross Profit figure? State 2 different ways. e) In what way does improving staff performance increase the profits of the hotel. State 2 different ways. From the Accommodation Profit & Loss Account, state the total of the following costs: a) Inventory b) Fixed c) Variable Present conclusions as to the effectiveness of the guest service operation in the hotel, supporting your evidence with financial evidence. As manager of a poorly performing department, what processes would you implement to resolve guest service problems? Task 12.1 Task 12.1 Department Accommodation Food & Beverage Spa Total Department Accommodation Food&Beverage Spa Total Sales (SAR 000) 2532.50 3325.00 2000.00 7898.00 Gross Profit 2.097.700 2.125.500 150.000.00 5.723.00 Sales Cost of sales Controllable expences 2.532.500 434.800.00 1.508.000.00 3.325.500 2.125.500.00 1.580.000.00 2000000 5.000.000 704.000.00 7.858.000 2.134.800 3.792.000 Net Profit 149.70 105.50 720.00 2322.00 Fixed expences 440.000.00 440.000.00 76.000.00 3.792.000 Total expences 1.948.000.00 2.020.000.00 780.000.00 4.748.000 Gross profit Net profit 2097.700.00 149.700.00 2.125.000.00 105.000.00 1.500.000.00 720.000.00 5.728.000 9,747,000 Task 12.2 Inventory sales-hotel ro Variable cost Salaries and wages 380.000.00 Heating 38.000.00 Glassware and drinks 80.000.00 Repairs and renewal 60.000.00 From the Accommodation Profit & Loss Account, list the following costs Electricity 200.000.00 Replacing linen 150.000.00 Newspapers and flow 200.000.00 Printing and stational 400.000.00 Total variable cost 1.508.000.00 434,800 Fixed cost Rent and rates Equipment lease Insurance Total fixed expenses 300.000.00 20.000.00 120.000.00 440.000.00

Answer rating: 100% (QA)

Task 13 Financial Report Analysis a In terms of sales state which is the bestperforming department Food Beverage department has the highest sales SAR ... View the full answer