Question
2. Calculate the forecasted sales revenue for May using the following data. Month Sales Revenue January $ 11,000 February $ 12,000 March $ 14,000 April
2. Calculate the forecasted sales revenue for May using the following data.
MonthSales Revenue
January$ 11,000
February$ 12,000
March$ 14,000
April$ 15,000
A. Use a simple 3-month moving average to forecast May sales revenue. Assume that the data above represents actual sales revenue.
B. Use a simple 4-month moving average to forecast May sales revenue. Assume that the data above represents actual sales revenue.
C. Use a 4-month weighted average to calculate forecasted May sales where the weights of the various months are as follows:
January - 10%
February - 20%
March- 30%
April- 40%
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started