Problem 3-12 (Algo) Assume that your stock of sales merchandise is maintained based on the...
80.2K
Verified Solution
Link Copied!
Question
Finance
Problem 3-12 (Algo) Assume that your stock of sales merchandise is maintained based on the forecast demand. If the distributor's sales personnel call on the first day of each month, compute your forecast sales by each of the three methods requested here. June July August ACTUAL 130 170 190 a. Using a simple three-month moving average, what is the forecast for September? (Round your answer to 2 decimal places.) Forecast for September 363.33 b. Using a weighted moving average, what is the forecast for September with weights of 0.30, 0.40, and 0.30 for June July, and August, respectively? (Do not round Intermediate calculations, Round your answer to 2 decimal places.) Forecast for September b. Using a weighted moving average, what is the forecast for September with weights of 0.30, 0.40, and 0.30 for June, July, and August, respectively? (Do not round intermediate calculations. Round your answer to 2 decimal places.) Forecast for September c. Using single exponential smoothing and assuming that the forecast for June had been 132, forecast sales for September with a smoothing constant a of 0.20. (Do not round intermediate calculations. Round your answer to 2 decimal places.) Forecast for September
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
