Lycamobile 51% 10:37 pm SITXFINOO3-004-Task-2 ? o INSTRUCTIONS Read the case study below and…

Lycamobile 51% 10:37 pm SITXFINOO3-004-Task-2 ? o INSTRUCTIONS Read the case study below and answer all questions correctly. Budget review You are an Operations Manager with Marino Enterprises and oversee the operations for six of the venues. John Marino has asked you to monitor and review specific budget figures for two businesses as presented below and present an analysis of their meaning for the organisation The management team are keen to identity that need to be addressed bed on an anwys and review of the budget data in order to optimise the viability of the business while retaining market share market position and their high product and service standards You have been presented with the following information Property Selected budget data mem Projected Budgeted figure Actual figure Room Sales 20.000.000 12.000.000 Food sales 5.000.000.000.000 Liquor sales 3,000,000 5.000.000 Wages 2.100,000 2.500.000 Rent 1.000.000 200.000 Overheads 500,000 450.000 Property 2 Six month’s total sales figures Month Budget Actual July 50.000 49.00 August 54.000 56,970 September 10.000 66,160 October 62.000 65.500 November 66.000 67,570 December 70.000 89,040 QUESTION 1 Use a spreadsheet program to calculate and facilitate the development of final figures for Property 1 as follows: Calculate the dollar deviations for room sales, food sales, liquor sales, wages, rent and overheads.