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 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-to-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

Property 2 Six month's total sales figures Month $ Budget $ Actual July 50.000 49.300 August 54.000 56.970 September 68.000 66. 160 October 62 000 65.500 November 66.000 67.570 December 70.000 69 040