Determine the sales forecast for this month

Assignment Help Financial Management

Reference no: EM131883883

The actual sales of an item at a retail store during the past six months are shown below: MONTH ACTUAL SALES (number of units sold) (show work)

Six months ago 344

Five months ago 340

Four months ago 352

Three months ago 350

Two months ago 356

One month ago 360

THIS MONTH ACTUAL SALES NOT KNOWN

Determine the sales forecast for THIS MONTH using each of the following methods:

a. A 4-month moving average.

b. A 3-month weighted moving average using weights of 15, 10, and 5 for one month ago, two months ago, and three months ago, respectively. (Hint: the heavier weights are applied to the more recent time periods.)

c. Exponential smoothing using the following: smoothing constant, α = 0.35 and the sales forecast for three months ago = 349 units.

Reference no: EM131883883

Questions Cloud

What are the disadvantage of multiple sourcing : Question - What are the disadvantage of multiple sourcing

How successful was the post-meeting : What factors contributed to the success or failure of the post -meeting?What kind of project management structure does Horizon use? Is it the right structure?

Why should the united state pursue given type of strategy : In your opinion, is this an economically beneficial strategy for a government to follow? Should the United State pursue this type of strategy? Why or why not?

Review problem regarding role of the physician : The role of the physician has evolved significantly over the past 10 years. There has been an introduction of new physical roles at the hospital level.

Determine the sales forecast for this month : Determine the sales forecast for THIS MONTH using each of the following methods:

Analyze communication techniques : This exercise allows you to analyze communication techniques and reflect upon your own communication skills.

Draw a state transition diagram for a simple stack machine : Draw a state transition diagram for a simple stack machine. Assume the stack holds n data items where n is a small positive number

Which currency is appreciating and depreciating : based on the 12 months of data, which currency is appreciating and which is depreciating (losing value)? Remember it can do both in a year.

Examine the performance assessment categories : StopNShopToday, Inc.'s management team has implemented several of your ideas on incentive pay and is now reviewing the company's performance appraisal forms.

User Account

All Pages