Question
In computing *MA's and CMA's, take the exact values. *Ratios, round-off the values to 3 decimals. *Unadjusted Seasonal and Adjusted Seasonal Indexes, round-off the values
In computing
*MA's and CMA's, take the exact values.
*Ratios, round-off the values to 3 decimals.
*Unadjusted Seasonal and Adjusted Seasonal Indexes, round-off the values to 2 decimals.
*the adjusting factor, round-off the value to 4 decimals.
1. Find MA3 (Exact Value)
2. Find CMA3 (Exact Value)
3. Find Ratio 2 (Two Decimal, Round off correctly)
4. Find Ratio 3 (Two Decimal)
5. Find the adjusted seasonal index for QI. (Two Decimal)
6. Find the adjusted seasonal index for QII (Two Decimal)
7. Find the seasonal adjusted index for QIII (Two Decimal)
8. Find the adjusted seasonal index for QIV (Two Decimal)
Use the following information for Q1 - 08 The following quarterly sales figures at Video-Comp were recorded over a four-year period. Based on the following data, compute the 4 seasonal Index numbers. Ratio to CMA ( %) Year Q MA CMA III IV 2017 2 MA1 III CMA1 Ratio 1 MA2 IV CMA2 Ratio 2 MA3 2018 I CMA3 Ratio 3 MA4 5 CMA4 Ratio 4 5.50 6 5.625 Ratio 5 5.75 IV 7 5.875 Ratio 6 6.00 2019 5 6.125 Ratio 7 6.25 6.375 Ratio 8 6.50 T IV Unadjusted Seasonal Indexes Adjusted Seasonal IndexesStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started