- This topic has 5 replies, 2 voices, and was last updated 9 months ago by
.
- Posts
The sales revenue trend for Helic Co for 20×1-20×3 has been calculated as follows:
Year Season Season number Sales Revenue Trend (4 season moving average)
20×1 Spring 1 86
Summer 2 120
Autumn 3 90 92.75
Winter 4 70 95.75
20×2 Spring 5 96 98.25
Summer 6 134 100.00
Autumn 7 96 102.50
Winter 8 78 106.25
20×3 Spring 9 108 109.50
Summer 10 152 111.50
Autumn 11
Winter 12Calculate the multiplicative seasonal variations (to four decimal places) and determine the Sales
Revenue for Autumn and Winter season in 20×3ive got how to the seasonal variations which is the sales revenue/trend, but I still cant find the answer for sales revenue for autumn and winter season in 20×3
From what you have given me
To calculate the multiplicative seasonal variation for each season in 20×1-20×3, divide the actual sales revenue by the corresponding trend:Autumn 20×1: 90 / 92.75 = 0.9709
Winter 20×1: 70 / 95.75 = 0.7306
Spring 20×2: 96 / 98.25 = 0.9778
Summer 20×2: 134 / 100.00 = 1.3400Autumn 20×2: 96 / 102.50 = 0.9376
Winter 20×2: 78 / 106.25 = 0.7341
Spring 20×3: 108 / 109.50 = 0.9854
Summer 20×3: 152 / 111.50 = 1.3638To determine the sales revenue for the Autumn and Winter seasons in 20×3, multiply the trend for each season by the corresponding multiplicative seasonal variation.
i got this from an exam paper in my university that i have not gotten any answer scheme for it
is by this u mean
autumn 0.9709*0.9376
winter 0.7306*0.7341from here how will i get the answer for 20×3 autumn and winter? how do i calculate the sales revenue for it?
- You must be logged in to reply to this topic.