a)
Linear trend y = a+bx
a = intercept
b = slope
x = time period
y = forecast for demand for period x
b = (?.ry _ nzy)/(? r2 _ nz?)
a=bar{y}-bbar{x}
n = no of peiods
bar{x}=sum x/n = the mean of the x values
bar{y}=sum y/n = the mean of the y values
https://d2vlcm61l7u1fs.cloudfront.net/media%2Fad2%2Fad2ad76c-fe5f-4ed4-86f8-f0f614da2a4a%2FphpacyyOz.png
Slope b = (90465-(18*470.56*9.5))/(2109-(18*9.5*9.5)) = 10000/484.5 = 20.64
Intercept a = 470.56 – (20.64*9.5) = 274.48
Y = 274.48 + 20.64x
b)
Forecast for week 20 and 21
Y (x= 20) = 274.48 + 20.64* 20
= 687.28
Y (x= 21) = 274.48 + 20.64* 21 = 707.92
c)
Y =910
910 = 274.48 +20.64*x
x = 30.79 week
It should reach 910 loadings in Week 30.79 week
“Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!”
What Students Are Saying About Us
.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐"Honestly, I was afraid to send my paper to you, but splendidwritings.com proved they are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 14***| Rating: ⭐⭐⭐⭐⭐
"The company has some nice prices and good content. I ordered a term paper here and got a very good one. I'll keep ordering from this website."