The production of reliable manufacturing company for 2012


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 7 6 July 3 2 February 5 6 August 7 March 12 17 September 13 April 9 6 October 8 May 2 6 November 8 June 3 2 December 4 Picture 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 seasonal 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.0 106.8 92.3 2013 88.9 102.7 178.6 118.9 60.8 43.5 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.7 77.7 196.1 89.4 113.5 80.9 2015 79.6 105.7 165.4 124.1 62.7 41.3 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.)

Request for Solution File

Ask an Expert for Answer!!
Financial Management: The production of reliable manufacturing company for 2012
Reference No:- TGS01236350

Expected delivery within 24 Hours