Using the ratio-to-moving-average method

Assignment Help Financial Management

Reference no: EM13927724

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

Reference no: EM13927724

Questions Cloud

What is the single period model : What is the single period model, and under what circumstances is it appropriate?

Considering the purchase of a high volume photocopier : Staples Business Solutions is considering the purchase of a high volume photocopier. The new machine will cost $150,000 and will last for 5 years at which time it will have a salvage value of $35,000. The new machine will result in before-tax cost sa..

Compute the market value of the bonds : (Cost of debt) Gillian Stationery Corporation needs to raise $569,000 to improve its manufacturing plant. It has decided to issue a $1,00 par value bond with an annual coupon rate of 8.4% with interest paid semi-annually at 15-year maturity. Investor..

What factors other than price must be taken : What are the implications of this price escalation with respect to order size? What factors other than price must be taken into consideration?

Using the ratio-to-moving-average method : The production of Reliable Manufacturing Company for 2012 and part of 2013 follows. Using the ratio-to-moving-average method, determine the specific seasonals for July, August, and September 2012.

Enable a company to raise additional equity capital : Which of the following actions will best enable a company to raise additional equity capital, other things held constant?

Find the most recent one-year dividend payment : Find the most recent one-year dividend payment that is four most recent quarterly dividends paid by Kia Motors and 3M Corporation, if any. Add the most recent one-year dividend payment to your Culminating Project Report for both companies.

Proposed cost-saving device has an installed cost : A proposed cost-saving device has an installed cost of $760,000. The device will be used in a five-year project but is classified as three-year MACRS property for tax purposes. The required initial net working capital investment is $58,000, the margi..

What is meant by the term service level : What is meant by the term service level? Generally speaking, how is service level related to the amount of safety stock held?

User Account

All Pages