Creating the monthly sales data on a sheet of graph paper

Assignment Help Operation Management

Reference no: EM1399525

1. The monthly sales for Telco Batteries, Inc., were as follows: Month Sales
Jan 20
Feb 21
Mar 15
Apr 14
May 13
Jun 16
Jul 17
Aug 18
Sep 20
Oct 20
Nov 21
Dec 23
a. Plot the monthly sales data on a sheet of graph paper.
b. Forecast January sales for the new year using each of the following:
1) Basic naïve method.
2) A 3-month moving average.
3) A 6-month weighted moving average using 0.1, 0.1, 0.1, 0.2, 0.2, 0.3, with the heaviest weights applied to the most recent months.
4) Exponential smoothing using a smoothing constant of 0.3 and a September forecast of 18 (note that you must compute forecasts for Oct, Nov, and Dec before computing the one for January).
5) A trend projection using the least squares method
c. With the data given,which method would allow you to forecast next March's sales?

Reference no: EM1399525

Questions Cloud

Calculate the molecule weight of the liquid : Calculate the molecule weight of the liquid If 2.31grams of the vapor of a volatile liquid is able to fill a 498-ml flask at temperature of 100 degree Celsius and pressure of 775 mm Hg? also determine the density of the vapor under these conditi..

Write a hypothesis and null hypothesis : What are the dependent and independent variables?

Determine hydroxyl and hydrogen ion concentration : Determine hydroxyl and hydrogen ion concentration in this solution. (if Ka for ammonium ion = 5.0 x 10^-10.)

How brain recognize the difference between high c and low c : How does the brain recognize the difference between high C and low C? Between a loud and a soft sound.

Creating the monthly sales data on a sheet of graph paper : The monthly sales for Telco Batteries, Plot the monthly sales data on a sheet of graph paper and Forecast January sales for the new year.

Illustrate what are operating profits and invested capital : Based on this forecast method, illustrate what are operating profits and invested capital expected to be next year? Illustrate what are two critical operating assumptions (classify one for profit and one for capital) embedded in this forecast meth..

Central limit theorem-single sample hypothesis test : A spokesman for a popular television game show claims that contestants on the show win an average of $1200. In a random sample, 35 contestants were questioned on the amount of money they had won in order to test the hypothesis.

Describe the key steps in the decision-making process : describe the key steps in the decision-making process. Describe one area that you feel is most significant in this process

Explain how phosphate limiting conditions for photosynthesis : Explain how phosphate limiting conditions for photosynthesis.

User Account

All Pages