Question at position 22 ONLY SUBMIT NUMBER ANSWERS (NO TEXT) Compute the sales forecast for the month of January using the 5-month simple moving average forecasting technique and the following data: Monthly sales for the RUOK Company for the last 6 months are as follows: [table]
Month | Units July | 135000 August | 165000 September | 120000 October | 135000 November | 150000 December | 180000
[/table]AnswerONLY SUBMIT NUMBER ANSWERS (NO TEXT) Compute the sales forecast for the month of January using the 5-month simple moving average forecasting technique and the following data: Monthly sales for the RUOK Company for the last 6 months are as follows: [table]
Month | Units July | 135000 August | 165000 September | 120000 October | 135000 November | 150000 December | 180000
[/table][input]

Question

BlackTom AI · Accepted Answer

The question asks for the January forecast using a 5-month simple moving average based on the last 6 months of data. To compute a 5-month moving average for January, we average the five months immediately preceding January: August, September, October, November, and December.

Values: August 165,000; September 120,000; October 135,000; November 150,000; December 180,000.
Sum = 165000 + 120000 + 135000 + 150000 + 180000 = 750000.
Average (5 months) = 750000 / 5 = 150000.

So, the forecast for January using the 5-month simple moving average is 150,000 units.

Note on data/input: The provided data table lists the six months (July through December). For a 5-month SMA to forecast January, we correctly exclude July and use the five months immediately preceding January (Aug–Dec). The problem statement’s instruction to submit a number and the given answer (150000) align with this calculation. If there were multiple-choice options, one would select the option showing 150,000; since the options are not provided here, the essential calculation steps are shown above for verification.

View Explanation

Log in for full answers

Similar Questions

Given the record of weekly cash flows below, calculate the four-week moving averages for this data for a forecast of week 6. Week 1 $100,000 Week 2 $125,000 Week 3 $145,000 Week 4 $130,000 Week 5 $110,000

A company forecasts next month’s demand by averaging the past three months’ actual sales. This approach is an example of:

When the actual demand data for Day 6 became available, the manager asked for the forecast error. You calculated it as _____________ rolls. Hints: - Calculate the moving average first. - Round the answer to two decimal place. For example, 11.11.

In a consumer society, many adults channel creativity into buying things

Economic stress and unpredictable times have resulted in a booming industry for self-help products

People born without creativity never can develop it

A product has a selling price of $20, a contribution margin ratio of 40% and fixed cost of $120,000. To make a profit of $30,000. The number of units that must be sold is: Type the number without $ and a comma. Eg: 20000

More Practical Tools for Students Powered by AI Study Helper

Homework AI Solver

Stylized AI Paper Writer

Plagiarism Checker Assistant

Citation AI Academic Writing Tool

In-Class Translation Assistant

AI Note Generator

AI Quiz Answers

Past Exam Questions from University Test Bank

Smart Practice Assistant

Adaptive Practice

Making Your Study Simpler