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.
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
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
Estimate purchases (in units) and cash required to make purchases in January, February, and March.
(Omit the "$" sign in your response.)
Merchandise Purchases Budget
For the Period Ended March 31
January February March
Units to be purchased 34400 6000
Check Your Work http://ezto.mhhm.mcgraw-hill.com/hm.tpxView Full Posting Details