Using the ratio-to-moving-average method, determine the specific seasonals for J

Question

Using the ratio-to-moving-average method, determine the specific seasonals for July, August, and September 2012. (Round your answers to 1 decimal place.)

Assume that the specific seasonal indexes in the following table are correct. Insert in the table the specific seasonals you computed in part (a) for July, August, and September 2012, and determine the 12 typical seasonal indexes. (Round your answers to 1 decimal place.)

The production of Reliable Manufacturing Company for 2012 and part of 2013 follows.

Explanation / Answer

a) Using the ratio-to-moving-average method, determine the specific seasonals for July, August, and September 2012

12 months total =addtion of production of 12 months

12 months moving average =12 months total /12

center of moving average =average of 2 consecutive 12 months moving average

specific seasonal = (months production / months center of moving average )*100

Using the ratio-to-moving-average method, the specific seasonals for July, August, and September 2012 are:

July: 69.0

August: 79.6

September: 190.5

b)

Adjusted index = (average / (total average/12))*100

i.e.

for january,

adjusted index = 86.275 / (1203.875/12)*100 =85.9973

c. The highest month above average was 9

the lowest month below average was 6

Year Month Sales 12 Months MA CMA Specific Seasonal 2012   January 5 2012   February 6 2012   March 12 2012   April 8 2012   May 2 2012   June 5 7.083 2012   July 5 7.250 69.0 7.417 2012   August 6 7.542 79.6 7.667 2012   September 15 7.875 190.5 8.083 2012   October 9 2012   November 7 2012   December 5 2013   January 9 2013   February 9 2013   March 17 2013   April 7 2013   May 7 2013   June 4 2013   July 5

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.