Using average historical proportions
Now that you have a regional sales forecast for the metropolitan region we can distribute this forecast down. First, let's try distributing it down using the average historical proportion technique. Your forecast is saved as for_MET_t_xts
, your sales objects are MET_hi
, MET_lo
, MET_sp
, and MET_total
, and you have three validation data sets called MET_hi_v
, MET_lo_v
, and MET_sp_v
.
This exercise is part of the course
Forecasting Product Demand in R
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Calculate the average historical proportions
prop_hi <- mean(___/MET_total)
prop_lo <- mean(___/___)
prop_sp <- ___(___/___)