menu
bartleby
search
close search
Hit Return to see all results

The following table contains the number of complaints received in the department store for first 6 months of operation:Month Jan Feb Mar April May JuneComplaints 36 45 81 90 108 144a. Calculate the forecast for the month from April through June using 3 month moving average? b. What will be the forecast for the month of July using 3 month moving average?c. If actual sales for the month of July turned out to be 145, what will be theforecast for August month using 3 month moving Average?

Question

The following table contains the number of complaints received in the department store for first 6 months of operation:
Month Jan Feb Mar April May June
Complaints 36 45 81 90 108 144

a. Calculate the forecast for the month from April through June using 3 month moving average? 


b. What will be the forecast for the month of July using 3 month moving average?

c. If actual sales for the month of July turned out to be 145, what will be the
forecast for August month using 3 month moving Average? 

check_circleAnswer
Step 1

Moving average

The moving average takes a moving window of actual values and forecasts for the next period. Since a 3 month moving average has been specified, we compute the moving average forecast for month of April by take the average of the actual values for the previous 3 months. Similarly we c...

Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Our solutions are written by experts, many with advanced degrees, and available 24/7

See Solution
Tagged in

Business

Operations Management

Forecasting Approaches

Related Operations Management Q&A

Find answers to questions asked by student like you

Show more Q&A add
question_answer

Q: I need a detailed explanation and assistance on how to solve this problem: The company decided that ...

A: Since the project network diagram is not given we are assuming the following network diagram in AOA ...

question_answer

Q: The need for coordination is high in transnational firms. True or False True False

A: Transnational model represents a compromise between local autonomy and centralized decision making. ...

question_answer

Q: George Johnson recently inherited a large sum of money;he wants to use a portion of this money to se...

A: (a) In the linear program the general mathematical model and the linear objective function set of li...

question_answer

Q: While monitoring the forecast values in last 5 months, the tracking signals are consistently coming ...

A: The tracking signal is given the ratio of the cumulative forecast error to the average error and a v...

question_answer

Q: ProHaul specializes in trans-American shipments for businesses through the delivery of containers. F...

A: Calculating the value of break-even sales for the company. We have, Break-Even Sales = Fixed Cost / ...

question_answer

Q: In order to increase the responsiveness (volatility) of following forecast models, what can you do? ...

A: In order to increase the responsiveness of the forecast model using exponential smoothing, we need t...

question_answer

Q: ProHaul specializes in trans-American shipments for businesses through the delivery of containers. ...

A: Step1: Calculating the value of break-even sales for the company. We have,Break-Even Sales = Fixed C...

question_answer

Q: How to write a problem formulation?

A: Intelligence is that the ability to assume,learn and act in keeping with a state of affairs and also...

question_answer

Q: Susan Williams runs a small Flagstaff job shop where garments are made. The job shop employs eight w...

A: Determine the labor productivity: 

Sorry about that. What wasn’t helpful?