Question 1: You are required to analyse the performance of the restaurant, and the following information is given:

Note: During this period, the monthly average number of serving employees was 85 employees per month and they did not have enough breaks due to a shortage in staff.

Required: a. Conduct the variance analysis. b. Answer the following questions: - Did the restaurant meet the targeted sales? If not, why was the restaurant not able to meet the target? - Were the marketing activities successful? How can you tell? - The restaurant planned the COGS to be 20% of the sales. Did the restaurant meet the target? c. From Part a, are there any significant failures that you can identify? If so, how can the restaurant resolve the issue? d. According to the serving employees KPIs, their weekly sales targets were $2000 per week. Did they meet the target? If not, does the restaurant have to amend its KPIs?

Planned Drink 5280 Total 29280 29280 Month Food January 24000 February 24000 March 25000 April 25000 May 26000 June 26000 5280 5500 5500 Actual outcomes Food Drink Total 24000 4800 28800 24000 4200 28200 26000 3100 29100 28700 2700 31400 28800 1800 30600 29100 1400 30500 Expected Actual visitors visitors 1952 2100 1952 2250 2033 2270 2033 2310 2115 2290 2115 2320 30500 30500 31720 5720 5720 31720 Planned Month Sales COGS January 29280 5856 February 29280 5856 March 30500 6100 April 30500 6100 May 31720 6344 June 31720 6344 Actual outcome Sales COGS 28800 6336 28200 6204 29100 6693 31400 7222 30600 7344 30500 7320