The production of Reliable Manufacturing Company for 2012 and part of 2013 follows. 2012 2013 2012 2013 Production Production Production Production Month (thousands) (thousands) Month (thousands) (thousands) January 8 8 July 3 5 February 9 6 August 6 March 10 15 September 13 April 7 8 October 7 May 6 3 November 6 June 1 2 December 3 Click here for the Excel Data File a. Using the ratio-to-moving-average method, determine the specific seasonals for July, August, and September 2012. (Round your answers to 1 decimal place.) July____?____ , August____?_____ , September ____?_____ b. 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.) Year Jan. Feb. Mar. Apr. May June July Aug. Sept. Oct. Nov. Dec. 2012 ? ? ? 92.9 106.2 92.6 2013 88.3 102.9 178.4 118.5 60.5 43.3 44.0 74.0 200.9 90.0 101.9 90.9 2014 87.6 103.7 170.2 125.9 59.4 48.6 44.3 77.2 196.9 89.4 113.8 80.4 2015 79.7 105.5 165.2 124.3 62.4 41.6 48.2 72.1 203.6 80.2 103.0 94.2 2016 89.0 112.1 182.9 115.1 57.6 56.9 Month Seasonal index Jan. ___?____ Feb. ___?____ March ___?____ April ___?____ May ____?____ June ____?____ July ___?___ August ____?____ Sept. ____?____ Oct. ___?____ Nov. ____?____ Dec. ____?____ c. Interpret the typical seasonal index. The highest month above average was ___?___ the lowest month below average was ___?___. (Use the number of the month for your answer. E.g. April = 4.)
The production of Reliable Manufacturing Company for 2012 and part of 2013 follows. |
2012 | 2013 | 2012 | 2013 |
Production | Production | Production | Production |
Month | (thousands) | (thousands) | Month | (thousands) | (thousands) |
January | 8 | 8 | July | 3 | 5 |
February | 9 | 6 | August | 6 |
March | 10 | 15 | September | 13 |
April | 7 | 8 | October | 7 |
May | 6 | 3 | November | 6 |
June | 1 | 2 | December | 3 |
Click here for the Excel Data File
a. | Using the ratio-to-moving-average method, determine the specific seasonals for July, August, and September 2012.(Round your answers to 1 decimal place.) |
July____?____ , August____?_____ , September ____?_____ |
b. | 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.) |
Year | Jan. | Feb. | Mar. | Apr. | May | June | July | Aug. | Sept. | Oct. | Nov. | Dec. |
2012 | ? | ? | ? | 92.9 | 106.2 | 92.6 |
2013 | 88.3 | 102.9 | 178.4 | 118.5 | 60.5 | 43.3 | 44.0 | 74.0 | 200.9 | 90.0 | 101.9 | 90.9 |
2014 | 87.6 | 103.7 | 170.2 | 125.9 | 59.4 | 48.6 | 44.3 | 77.2 | 196.9 | 89.4 | 113.8 | 80.4 |
2015 | 79.7 | 105.5 | 165.2 | 124.3 | 62.4 | 41.6 | 48.2 | 72.1 | 203.6 | 80.2 | 103.0 | 94.2 |
2016 | 89.0 | 112.1 | 182.9 | 115.1 | 57.6 | 56.9 |
Month | Seasonal index |
Jan. | ___?____ |
Feb. | ___?____ |
March | ___?____ |
April | ___?____ |
May | ____?____ |
June | ____?____ |
July | ___?___ |
August | ____?____ |
Sept. | ____?____ |
Oct. | ___?____ |
Nov. | ____?____ |
Dec. | ____?____ |
c. | Interpret the typical seasonal index. |
|
The highest month above average was ___?___ the lowest month below average was ___?___. (Use the number of the month for your answer. E.g. April = 4.) |