What should be the forecast for August? - ProProfs Discuss
Advertisement

What should be the forecast for August?

John’s House of Pancakes uses a weighted moving average method to forecast pancake sales. It assigns a weight of 5 to the previous month’s demand, 3 to demand two months ago, and 1 to demand three months ago. If sales amounted to 1000 pancakes in May, 2200 pancakes in June, and 3000 pancakes in July.

Asked by Ryanbecker, Last updated: Mar 26, 2024

+ Answer
Request
Question menu
Vote up Vote down

3 Answers

L. Hawkes

L. Hawkes

L. Hawkes
L. Hawkes, Teacher, Memphis

Answered Nov 05, 2018

There is a formula for the weighted moving average and it can be calculated by getting the product of the price or amount with the quotient of the number of amounts by its weight. Then those are added up together. In the other words, you first have to divide the weighting number first and then multiply each weighting number with the price or amount. Those numbers have to be added together.

Therefore, in the word problem, the weighting number is five, three or one and the number is the number of pancakes that sold for each month. When you use the formula to forecast the weighted moving average with the information given about the pancakes, you would result with the number 2511.

upvote downvote
Reply 

M. Klose

M. Klose

M. Klose
M. Klose, Content Writer, Oakland

Answered Jul 09, 2018

The answer to this is2511. The question states that to get the right answer, the weighted moving average method should be used. This method requires the use of multiplying the given price based on the weighting details. The values will then be totaled in order to get the answer. Take note that this is different from the moving average. This is something that a lot of people get confused about.

To get the weighted average you first need to multiply each number by its weight. Add all of the weighted scores. If you are using percentages, you should reach a total of 100%. This should be multiplied with 100 so that you can get the answer.

upvote downvote
Reply 

ryanbecker24

ryanbecker

ryanbecker24
Ryanbecker

Answered Feb 03, 2018

2511
upvote downvote
Reply 

Advertisement
Advertisement
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader

Email Sent
We have sent an email to your address "" with instructions to reset your password.