Explore BrainMass

Stock of sales merchandise

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

Assume that your stock of sales merchandise is maintained based on the forecast demand. If the distributor's sales personnel call on the 1st day of each month, compute your forecast sales by each of the 3 methods requested below.
June 140
July 180
August 170

a. Using a simple 3-month moving average, what is the forecast for September?
b. Using a weighted moving average, what is the forecast for September with wights of .2,.3, and .5 for June, July & August respectively?
c. Using single exponential smoothing & assuming that the forecast for June had been 130, forecast sales for September with a smoothing constant alpha of .3.

Please use Microsoft excel spreadsheet, thanks!

© BrainMass Inc. brainmass.com October 16, 2018, 9:09 pm ad1c9bdddf
Similar Posting

Prepare a merchandise purchases budget for the first quarter.

See attached file for proper format.

3. This window shows what is correct and incorrect for the work you have completed so far.

Even if all of the work you have done so far is correct, you may not have completed everything.
Westile Company buys plain ceramic tiles and prints different designs on them for souvenir and gift stores.
It buys the tiles from a small company in Europe, so at all times it keeps on hand a stock equal to the tiles
needed for three months' sales. The tiles cost $2 each and must be paid for in cash. The company has
56,000 tiles in stock. Sales estimates, based on contracts received, are as follows for the next six

January 24,800
February 35,600
March 26,400
April 28,400
May 19,200
June 14,400


Estimate purchases (in units) and cash required to make purchases in January, February, and March.
(Omit the "$" sign in your response.)

Westile Company
Merchandise Purchases Budget
For the Period Ended March 31
(in units)
January February March
Units to be purchased 34400 6000
Estimated cost
$ 68800

Check Your Work http://ezto.mhhm.mcgraw-hill.com/hm.tpx

View Full Posting Details