Forecast time series for first four months of next year

Reference no: EM13135714

The number of employees on the payroll at a food processing plant is recorded at the start of each month. These data are provided in the attached file. a. Is there a seasonal pattern in these data? If so, how do you explain this seasonal pattern? Also, if necessary, deseasonalize these data using the ratio-tomoving-average method. b. Forecast this time series for the first 4 months of the next year using the most appropriate method. Defend your choice of forecasting method.

Reference no: EM13135714

Questions Cloud

Prepare the stockholders’ equity section of balance sheet : Prepare the stockholders’ equity section of the balance sheet immediately after these transactions have been recognized.

The most common misconception concerning the legal system : What do you believe to be the most common misconception concerning the legal system in the United States?

Calculate the manufacturing cost markup needed : Calculate the manufacturing cost markup needed to obtain a target profit of $100,000.

How much is earnings per share for the year : If net income for the year was $75,000 and a preferred stock dividend of $20,000 was paid, what was the beginning value of retained earnings? How much is earnings per share for the year?

Forecast time series for first four months of next year : Forecast this time series for the first 4 months of the next year using the most appropriate method. Defend your choice of forecasting method.

Amount charged to income-expense and loss : The company estimated a 10-year useful life for the patent and uses the straight-line amortization method for all intangible assets. In 2014, Vega spent $40,000 in legal fees for an unsuccessful defense of the patent. The amount charged to income ..

Using the regression module : Using the regression module of Excel's Add-in Data Analysis, perform 3 simple regressions by regressing overhead costs against each of the proposed independent variables. Show the output for each regression and evaluate each of the regression results..

What is the target cost : Pauw's Pots is considering the production of a new line of pottery. Based on preliminary market research, management has decided that each pot should be priced at $60. Furthermore, management believes that the profit margin should be 40 percent of..

What else might you consider : If you were looking at two companies and one had a large amount of debt and the other didn't, would you choose the one without debt? Always? What else might you consider?

User Account

All Pages