Question: 5. Trend Projection: Method that assumes that future sales will assume the same trend as that followed by previous sales records. Month (X) Pizza Sales
5. Trend Projection: Method that assumes that future sales will assume the same trend as that followed by previous sales records.
Month (X)
Pizza Sales (Y)
January 1st)
850
February (2)
945
March (3)
1,075
April (4)
1,050
May (5)
1,067
Step 1: Add the numbers related to each month and your sales
Total numbers related to each month =
Total sales =
Step 2: Solve,
Total months = 5
Total numbers related to each month / total months = ??
Total sales / total months =
Step 3: Solve table for xy, x2
Month (X)
Pizza Sales (Y)
xy = Number of Months per pizza sale of the month
=
Month number squared
January 1st)
850
850
1
February (2)
945
?
?
March (3)
1,075
?
?
April (4)
1,050
?
?
May (5)
1,067
?
?
Total numbers related to each month
Total sales
Total of xy =?
Total of x2 =?
STEP 4: Solve for b, a, and
b = Total of xy - (Total of months = 5) () (y ) / Total of x2 - (Total of months = 5) () =
=?
a = y - (b) ()
=?
Pizza sales for the month of June: y = a + (b) (June x) =?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help