chapter 2. determining sales forecast

7/27/2019 Chapter 2. Determining Sales Forecast

1/12

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.


3/12

Point of sales (POS) system

- A computerizedsystem that can

determine the actualsales for a currenttime period that hasbeen designed toprovide specific salesinformation.


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


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


6/12

Sales Variances

- Or changes frompreviously

experienced saleslevels, gives theindication of whetherthe sales areimproving, declining,or staying the same.


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


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


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


10/12

Questions?


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


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

chapter 2. determining sales forecast

Documents