Where F1 is the forecast for the period t, given we know the value of the variable X in the period t. The coefficients a and b are constants: a is the intercept value for the vertical (F) axis and b is the slope of the line. Often the equation is expressed as:<\/p>\n\n\n\n
Y=a + bX.<\/p>\n\n\n\n
In this equation we have substituted F for Y, to indicate b is the forecasted value. In order to find coefficients a and b, old demand is utilized rather than the old forecast. These coefficients are computed by the following two equations<\/p>\n\n\n\n
b=: a ($X1D1)-($X1)($D1)___<\/p>\n\n\n\n
n ($X1*$X1)-($X1)($X1)<\/p>\n\n\n\n
a=$D1- b & X1<\/p>\n\n\n\n
n<\/p>\n\n\n\n
Where D = a + bX, and a= no. of periods<\/p>\n\n\n\n
Example:<\/strong> A pepperbox company carryout pizza boxes. The operation planning department knows that the pizza sales of major client are a function of the advertisement amount, the client spends, on account of which they receive in advance of the expenditure. Operation planning is interested in determining the relationship the client\u2019s advertisement and sales. The amount of pizza the client would order. In money value is known to be a fixed percentage of sales<\/p>\n\n\n\n Quarterly advertising and sales<\/p>\n\n\n\n Computing b and a, where advertising is X1 for the quarter t, sales are D1 for the quarter t and forecast is F1 for the future Period t<\/p>\n\n\n\n b = 10(328) \u2013 (96)30 =29<\/p>\n\n\n\n 10(1060) _96*96<\/p>\n\n\n\n a = 30- .29(96) = .22 \/10<\/p>\n\n\n\n Thus the estimated regression line, the relationship between future sales F, and advertising X is<\/p>\n\n\n\n F=22+.29X<\/p>\n\n\n\n The operation planner can now ask for planned expenditure expenditures, and from that sales can be forecast<\/p>\n","protected":false},"excerpt":{"rendered":" The Least Squares Regression (LSR) method derives an equation describing a straight line relationship between the historical sales data and the passage of time. LSR fits a line to the selected range of data so that the sum of the squares of the differences between the actual sales data points and the regression line are…<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-101751","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"\nQuarter<\/strong><\/td> Advertising (in 1,00,000 Rs.)<\/strong><\/td> Sales (in 1, 00,000 Rs.)<\/strong><\/td><\/tr><\/thead> 1 2 3 4 5 6 7 8 9 10 <\/td> 4 10 15 12 8 16 5 7 9 102<\/td> 1 4 5 4 3 4 2 1 4<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n ![\"\"](\"https:\/\/www.vskills.in\/lms\/wp-content\/uploads\/2017\/08\/image020.jpg\")
<\/figure><\/div>\n\n\n\n