Download - Chapter 2. Determining Sales Forecast
-
7/27/2019 Chapter 2. Determining Sales Forecast
1/12
Determining Sales
Forecast
-
7/27/2019 Chapter 2. Determining Sales Forecast
2/12
Sales Forecast
- predict the
number of guests thatwill be serve and therevenues that will
generate in a givenfuture time period.
-
7/27/2019 Chapter 2. Determining Sales Forecast
3/12
Point of sales (POS) system
- A computerizedsystem that can
determine the actualsales for a currenttime period that hasbeen designed toprovide specific salesinformation.
-
7/27/2019 Chapter 2. Determining Sales Forecast
4/12
Sales Volume- the number of
units soldSales History- is the
systematic recording
of all sales achievedduring apredetermined timeperiod.
Sales to date- is thecumulative total ofsales reported in theunit
-
7/27/2019 Chapter 2. Determining Sales Forecast
5/12
Daily Sales (day 1)+ Daily sales (day2) = Sales to dateSales to date(day2)+ Daily sales(day3) = Sales to date
Ezras Restaurant
Sales Period Date Daily Sales Sales to Date
Monday 2/1 Php. 5,550.75 Php. 5,550.75
Tuesday 2/2 2,000.00 7,550.75
Wednesday 2/3 6,785.01 14,335.76
Thursday 2/4 1,800.00 16,135.76Friday 2/5 9,859.54 25,995.30
Saturday 2/6 15,889.80 41,885.10
Sunday 2/7 25,842.75 67,727.85
Weeks Total 67,727.85
-
7/27/2019 Chapter 2. Determining Sales Forecast
6/12
Sales Variances
- Or changes frompreviously
experienced saleslevels, gives theindication of whetherthe sales areimproving, declining,or staying the same.
-
7/27/2019 Chapter 2. Determining Sales Forecast
7/12
Sales this year Sales last year = Variance
Fast eat foods
Month Sales This Year Sales Last Year VarianceJanuary Php. 280,000 Php. 200,500 Php. 79,500
February 305,000 250,700 54,300
March 175,500 89,800 85,700
First-QuarterTotal
760,500 541,000 219,500
-
7/27/2019 Chapter 2. Determining Sales Forecast
8/12
Percentage Variance- percentage change in their sales from one time period to
the next.
Fast eat foods
Month Sales This
Year
Sales Last
Year
Variance % Variance
January Php.280,000
Php.200,500
Php. 79,500 3.97%
February 305,000 250,700 54,300 2.16%
March 175,500 89,800 85,700 9.54%
First-QuarterTotal
760,500 541,000 219,500 4.0%
Variance Sales Last Year = Percentage Variance
-
7/27/2019 Chapter 2. Determining Sales Forecast
9/12
Revenue ForecastSales Last Year + (Sales Last Year x % Increase Estimate) =Revenue Forecast
Sales Last Year + Increase Amount = Revenue Forecast
Queso Pizza
Month Sales LastYear
% IncreaseEstimate
IncreaseAmount
RevenueForecast
January Php. 108,000 7.5% Php. 8,100 Php. 116,100
February 275,500 7.5% 20,662.50 296,162.50
March 150,000 7.5% 11,250 161,250
FirstQuarter Total
533,500 7.5% 40,012.50 573,512.50
-
7/27/2019 Chapter 2. Determining Sales Forecast
10/12
Questions?
-
7/27/2019 Chapter 2. Determining Sales Forecast
11/12
8s Coffee Shop
Month Sales ThisYear
Sales LastYear
Variance PercentageVariance
January Php. 575,000 Php. 600,000
February 585,700 480,000
March 320,500 415,000
April 250,000 175,000
May 120,000 200,800
June 115,000 208,500
6 month total
-
7/27/2019 Chapter 2. Determining Sales Forecast
12/12
Month Sales LastYear
PredictedChange
ProjectedSales
Increase
RevenueForecast
July Php. 475,000 4.75%
August 320,000 4.75%
September 275,500 4.75%
October 350,000 4.75%
November 410,000 4.75%
December 550,000 4.75%6 month total
8s Coffee Shop