Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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.)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting

Authors: Ray H. Garrison, Eric W. Noreen, Peter C. Brewer

13th Edition

978-0073379616, 73379611, 978-0697789938

Students also viewed these Mathematics questions