Business Homework Solutions
#174226
Assume that your stock of sales merchandise is maintained based on the forecast demand.
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.
ACTUAL
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!
What is this?
By OTA - Overall OTA Rating
Gaurav Agarwal, MS - 4.8/5
Purchase Cost Now
$2.19 CAD (was ~$3.99)
Included in Download
- Plain text response
- Attached file(s):
- 4_1.xls
Why you can trust BrainMass.com
- Your Information is Secure
- Best Online Academic Help Service
- Students find real academic Success
- Finished goods inventory & budgeted sales revenue - A lamp distributor marks up its merchandise by 60% of cost to obtain the invoice price at which it sells lamps to dealers. On July 1, finished goods inventory was $200,000, and the distributor wants ...
- This file contains examples of journal entries. - This file contains examples of journal entries.
- Accounting questions & spreadsheet - need help. - Can you help me with the two following accounting questions and spreadsheet? Having a hard time with examples. Questions: *How to define accrual accounting & how to contrast it with cash basis acc ...
- Operations Management - 1. Explain exponential smoothing and what the MAD and MSE scores mean in the attached spreadsheet. The original assignment was as follows. Your Director of Supply Chain needs help in developing ...
- Supply Chain Management - Question 4 - 4. Use the spreadsheet provided in the textbook's CD-ROM to answer the following questions on supply chain coordination. We say a supply chain is coordinated if it achieves the global optimal solutio ...
