Sales Variance analysis XYZ Restaurant generated the following sales during previous year. Analyze the figures and...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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? 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?
Expert Answer:
Answer rating: 100% (QA)
1 To calculate the sales variance in terms of cover average check and sales we need to compare the forecasted sales with the actual sales for each month Cover Variance Subtract the forecasted covers f... View the full answer
Related Book For
Financial Accounting and Reporting a Global Perspective
ISBN: 978-1408076866
4th edition
Authors: Michel Lebas, Herve Stolowy, Yuan Ding
Posted Date:
Students also viewed these accounting questions
-
Suppose that you are valuing an American - type put option on non - dividend - paying stock with a strike price of 9 5 . The expiration date of this option is exactly in 2 years from now. The spot...
-
Question: Old MathJax webview Old MathJax webview i need ans of these question but the source is alot Old MathJax webviewOld MathJax webview i need ans of these question but the source is alot these...
-
"Excess Cash" Calculation (Read Carefully) So, how and why did I adjust Nike's financial statements for the excess cash? Well, if I want to add the excess cash on the valuation date to my DCF...
-
Find the indicated quantities for the appropriate arithmetic sequence. The sum of the angles inside a triangle, quadrilateral, and pentagon are 180, 360, and 540, respectively. Assuming this pattern...
-
A test indicates the presence of a particular disease 90% of the time when the disease is present and the presence of the disease 2% of the time when the disease is not present. If 0.5% of the...
-
Describe the evolution of Action Research, identify theoretical foundations associated with Action Research, compare and contrast methodologies and researcher's approaches used to implement Action...
-
TekCare Corp. is considering purchasing one of two new diagnostic machines. Either machine would make it possible for the company to bid on jobs that it currently isn't equipped to do. Estimates...
-
Gottschalk Company sponsors a defined benefit plan for its 100 employees. On January 1, 2017, the company's actuary provided the following information. Accumulated other comprehensive loss...
-
Questions 6 - 9 utilize the following information. If you select answer d, indicate the correct amount. The manufacturing cost accounts of Varsity Manufacturing Co. provide the following information...
-
Northwest Desserts, Inc., (NDI) produces a variety of premium cheesecakes and sells them in individual packages directly to retail customers and in packages of 10 cakes to restaurants in Washington,...
-
Which of the following statements is true? 1. Future costs that do not differ between the alternatives in a decision are avoidable costs. II. A cost that is traceable to a segment through...
-
If a bar under longitudinal vibration is free at node 1 , the forward difference formula gives a. \(U_{1}=0\) b. \(U_{1}=U_{2}\) c. \(U_{1}=U_{-1}\)
-
What is the difference between explicit and implicit integration methods?
-
The central difference approximation of \(d^{4} W / d x^{4}-\beta^{4} W=0\) at grid point \(i\) with step size \(h\) is a. \(W_{i+2}-4 W_{i+1}+\left(6-h^{4} \beta^{4} ight) W_{i}-4...
-
Can we use the numerical integration methods discussed in this chapter to solve nonlinear vibration problems?
-
Express the following \(n\) th-order differential equation as a system of \(n\) first-order differential equations: \[a_{n} \frac{d^{n} x}{d t^{n}}+a_{n-1} \frac{d^{n-1} x}{d t^{n-1}}+\cdots+a_{1}...
-
A truly supportive message does all EXCEPT make light of the person's situation. show your concern for the other person. encourage the other person. convey sympathy for the other person.
-
The financial statements of Eastern Platinum Limited (Eastplats) are presented in Appendix A at the end of this textbook. Instructions (a) Does East plats report any investments on its statement of...
-
Jud's Manufacturing Company produces one product, Kebo. Because of wide fluctuations in demand for Kebo, the Assembly Department experiences significant variations in monthly production levels. The...
-
Lorch Company uses budgets in controlling costs. The May 2002 budget report for the company's Packaging Department is as follows. The budget amounts in the report were on the master budget For the...
-
Lakem elder Dutch manufactures expensive watch eases sold as souvenirs. Three ol its sales departments are: Retail Sales, Wholesale Sales, and Outlet Sales. The Retail Sales Department is a profit...
Study smarter with the SolutionInn App