Problem 3-12 (Algo) Assume that your stock of sales merchandise is maintained based on the...

80.2K

Verified Solution

Question

Finance

image
image
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!
Become a Member

Other questions asked by students