Question: QUESTION 2 Use a spreadsheet program to calculate and facilitate the development Of final figures for Property 2 as follows: - Total the budgeted and

QUESTION 2 Use a spreadsheet program to calculate and facilitate the development Of final figures for Property 2 as follows: - Total the budgeted and actual sales for the 6 months. - Calculate the dollar deviations for sales on a month-by-month basis. - Calculate the percentage deviations for sales on a month-by-month basis. - Calculate year-to-date budgeted totals for sales on a month-by-month basis. - Calculate year-to-date actual totals for sales on a month-by-month basis. - Calculate the dollar deviations for YTD figures on a month-by-month basis. - Calculate the percentage deviations for YTD figures on a month-by-month basis. QUESTION 3 For Property 1 suggest four possible causes for the variation in room sales. QUESTION 4 For Property 1 suggest four possible ways to manage the variation in room sales. QUESTION 5 Identify four possible causes of the results for food sales in Property 1. QUESTION 6 There is no need for you to investigate the 'wages' deviance: why might this be so
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
