W13 Homework templateupdate-3-1 (1)
.xlsx
School
San Jose State University**We aren't endorsed by this school
Course
BUS2 190
Subject
Accounting
Date
Dec 16, 2024
Pages
10
Uploaded by BaronMetal17194
Template for Seasonal FactorsTrue YearMonthValueType of Seasonality1Jan352Monthly1Feb3291Mar3651Apr358Estimate for1May412MonthSeasonal Factor1Jun446Jan1Jul420Feb1Aug471Mar1Sep355Apr1Oct312May1Nov567June1Dec533July2Jan317Aug2Feb331Sep2Mar344Oct2Apr386Nov2May423Dec2Jun4722Jul4152Aug4922Sep3402Oct3012Nov6292Dec5053Jan3383Feb3463Mar3833Apr4043May4313Jun4593Jul4333Aug5183Sep3093Oct3353Nov5943Dec5274Jan364ABCDEFGH1234567891011121314151617181920212223242526272829303132333435363738394041
4Feb3434Mar3914Apr4374May4584Jun4944Jul4684Aug5554Sep3874Oct3644Nov6624Dec581ABCDEFGH4243444546474849505152
Range NameCellsSeasonalFactorG10:G21TrueValueD5:D41TypeOfSeasonalityF5IJ1234567891011121314151617181920212223242526272829303132333435363738394041
Template for Moving-Average Forecasting Method with SeasonSeasonallySeasonallyTrue AdjustedAdjustedYearMonthValueValueForecast1Jan3521Feb3291Mar3651Apr3581May4121June4461July4201Aug4711Sep3551Oct3121Nov5671Dec5332Jan3172Feb3312Mar3442Apr3862May4232June4722July4152Aug4922Sep3402Oct3012Nov6292Dec5053Jan3383Feb3463Mar3833Apr4043May4313June4593July4333Aug5183Sep3093Oct335ABCDEF123456789101112131415161718192021222324252627282930313233343536373839
3Nov5943Dec5274Jan3644Feb3434Mar3914Apr4374May4584June4944July4684Aug5554Sep3874Oct3644Nov6624Dec581ABCDEF4041424344454647484950515253
nalityActualNumber of previousForecastperiods to considern =3Type of SeasonalityMonthlyMonthSeasonal FactorJan0.8Feb0.79Mar0.87Apr0.93May1.01June1.1July1.02Aug1.19Sep0.82Oct0.77Nov1.44Dec1.26GHIJK123456789101112131415161718192021222324252627282930313233343536373839
GHIJK4041424344454647484950515253
Template for Exponential Smoothing Forecasting Method with SeasonaSeasonallySeasonallyTrue AdjustedAdjustedActualYearMonthValueValueForecastForecast1Jan3521Feb3291Mar3651Apr3581May4121Jun4461Jul4201Aug4711Sep3551Oct3121Nov5671Dec5332Jan3172Feb3312Mar3442Apr3862May4232Jun4722Jul4152Aug4922Sep3402Oct3012Nov6292Dec5053Jan3383Feb3463Mar3833Apr4043May4313Jun4593Jul4333Aug5183Sep3093Oct335ABCDEFGHI123456789101112131415161718192021222324252627282930313233343536373839
3Nov5943Dec5274Jan3644Feb3434Mar3914Apr4374May4584Jun4944Jul4684Aug5554Sep3874Oct3644Nov6624Dec581ABCDEFGHI4041424344454647484950515253
alitySmoothing Constanta =0.40Type of SeasonalityMonthlyMonthSeasonal FactorJan0.8Feb0.79Mar0.87Apr0.93May1.01June1.1July1.02Aug1.19Sep0.82Oct0.77Nov1.44Dec1.26JK123456789101112131415161718192021222324252627282930313233343536373839