Sales Variance analysis XYZ Restaurant generated the following sales during previous year. Analyze the figures and make a sales analysis report. Seating capacity 100 Operating for breakfast, lunch and dinner Maximum rate 1.5 or 150% seating capacity Forecasted Sales Actual Sales Attainment Month Turnover Cover Rate Ave Sales Check Turnover Rate Cover Ave Check Sales Sales% Attainment Sale Variance Covers Ave Check Sales Jan 1.00 20250 250 P5.062.500 1.5 21262.5 250 Feb 1.50 30375 250 P7,593,750 1.24 25200 210 P5.580,000 P5.292.000 Mar 1.50 30375 250 P7,593,750 0.55 11160 200 P2,232,000 Apr 1.50 30375 250 P7,593,750 0.71 14400 205 P2,952,000 May 1.50 30375 250 P7,593,750 0.55 11160 195 P2,176,200 Jun 0.60 12150 250 P3,037,500 0.36 7200 190 P1,368,000 Jul 0.40 8100 250 P2,025,000 0.28 5580 198 P1,104,840 Aug 0.40 8100 250 P2,025,000 0.28 5580 200 P1,116,000 Sept 0.55 11137.5 250 P2,784,375 0.53 10800 220 P2,376,000 Oct 0.70 14175 250 P3,543,750 0.64 13020 225 P2.929,500 Nov 0.70 14175 250 P3,543,750 0.71 14400 230 P3,312,000 Dec 1.50 30375 250 P7,593,750 1.38 27900 255 P7,114,500 Total 239963 P59,990,625 8.33 167662.5 P37,553,040 Workshop Problems 1. Get the sales variance in terms of covers, average check and sales. 2. Compute the percentage attainment of actual sales vs forecasted sales. 3. Analyze the actual, in what months did the restaurant have a good business and in what months did the restaurant lose? 4. If you are the manager of the restaurant, what will you do to increase sales for the bad or lean months?