Forecast september sales volume

Assignment Help Operation Management

Reference no: EM131920616

Problem

National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows:

Month	Sales (000)Units
Feb.	15
Mar.	16
Apr.	13
May.	20
Jun.	20
Jul.	23
Aug.	25

b. Forecast September sales volume using each of the following:

(1) A linear trend equation.(Round your intermediate calculations and final answer to 2 decimal places.)

thousands

(2) A five-month moving average. (Round your answer to 2 decimal places.)

Moving average

thousands

(3) Exponential smoothing with a smoothing constant equal to .20, assuming a March forecast of 17(000). (Round your intermediate forecast values and final answer to 2 decimal places)

Forecast

thousands

(4) The naive approach.

Naive approach

thousands

(5) A weighted average using .50 for August, .10 for July, and .40 for June. (Round your answer to 2 decimal places.)

Weighted average

thousands

Reference no: EM131920616

Questions Cloud

Obtain forecasts for periods 6 through 10 : The initial estimate of trend is based on the net change of 30 for the three periods from 1 to 4, for an average of +10 units.

What is the amount of the monthly payment for wiggley : Mr. Wiggley wants to buy a new house. It will cost $178,000. What is the amount of the monthly payment if he intends to pay the house off in 25 years?

What would happen to total profits : What would happen to total profits if Tapco stopped selling Product A but continued to sell 4,000 units of Product B?

What is mr smiths return on assets : Mr. Smith Corp is in the business of filing parts used in fixing automobiles. Mr. Smith Corp has gross profit of 180.000. What is Mr. Smith's Return on Assets?

Forecast september sales volume : Exponential smoothing with a smoothing constant equal to .20, assuming a March forecast of 17(000).

What products are being offered by a shop : What products are being offered by a shop that specializes in bicycles? By a travel agent? By a supermarket? By a new car dealer?

What amount of cash dividends payable to common stockholders : Mozart & Company paid cash dividends totaling $150,000 in 2013 and $75,000 in 2014. What is the amount of cash dividends payable to common stockholders in 2015?

How lack of physical good affect efforts to promote service : Consumer services tend to be intangible, and goods tend to be tangible. Use an example to explain how the lack of a physical good in a pure service might.

Prepare a forecast for september : A dry cleaner uses exponential smoothing to forecast equipment usage at its main plant. August usage was forecasted to be 60 percent of capacity;

User Account

All Pages