Use a spread sheet program to calculate and facilitate the development of final figures for property1 as follows:? calculate the dollar deviations for room sales, food sales, liquor sales, wages, rent and overheads.? calculate the percentage deviations for room sales, food sales, liquor sales, wages, rent and overheads.? indicate if the identified deviations are positive or negative.

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 identify issues that need to be addressed based on an analysis 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 1 Selected budget data Item Projected/Budgeted figure Actual figure Room Sales 20,000.000 12,000,000 Food sales 5,000.000 9,000,000 Liquor sales 3,000,000 5,000,000 Wages 2,100.000 2,500,000 Rent 1.000,000 1,200,000 Overheads 500.000 450,000