COMPLETEEE SOLUTION AND ANSWER PLEASEE

XYZ YOUGURT MAKER

= 30,464 + 121.3t

= predicted monthly yogurt sales in gallons in month t

30,464 = number of gallons sold when t=0

t = time period (months) where December 2017 is 0, January 2018 is 1, February 2018 is 2,...

121.3 = coefficient of t; sales may be expected to increase by 121.3 gallons on the average each month

Activity 1:

• Forecast yogurt sales for August 2022
• t = number of months from December 2017 to August 2022

Activity 2:

LINEAR TREND FORCASTING

• Forecast yogurt sales for May 2023
• t = number of months from December 2017 to May 2023

ACTIVITY 3

• Predict the sales in AUGUST 2022
• Use the Linear Trend Forecasting for the past 4 years (2018-2021) to predict the AUGUST sales patterns

AUGUST	FORECAST	ACTUAL	ACTUAL/FORECAST
2018		33,600
2019		35,600
2020		36,400
2021		38,200
2022
			=