Question: A. Plot the monthly data on a sheet of graph paper. B. Compute the sales forecast for July using the following approaches: (1) a three-month

A. Plot the monthly data on a sheet of graph paper.

B. Compute the sales forecast for July using the following approaches: (1) a three-month moving average; (2) a weighted three-month moving average using .50 for June, .30 for May and .20 for April; (3) a linear trend equation (4) exponential smoothing with a (smoothing constant) equal to 40, assuming a February forecast of 18,000

C. Which method do you think is the least appropriate? Why?

D. Calculate the MAD for each of the four techniques in part (1). Which is the best? Why?"

1. Ms. Winnie Lin's company sells computers. Monthly sales for a six-month period are as follows: MONTH Jan Feb Mar Apr May Jun SALES 18,000 22,000 16,000 18,000 20,000 24,000

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

1. Ms. Winnie Lin's company sells computers. Monthly sales for a six-month period are as follows: Month Sales Jan 18,000 Feb Mar 22,000 16,000 18,000 Apr May 20,000 Jun 24,000 a. Plot the monthly...

calculate and answer all question. 1. Ms. Winnie Lin's company sells computers. Monthly sales for a six-month period are as follows: a. Plot the monthly data on a sheet of graph paper. b. Compute the...

Please explain and show how to do problem number 3 for problem B, thanks. 1. Ms. Winnie Lin's company sells computers. The monthly sales for a six-month period are as follows: MONTH SALES Jan 18,000...

Excel format please: 1. Ms. Winnie Lin's company sells computers. The monthly sales for a six-month period are as follows: MONTH Jar Feb Mar Apr May Jun SALES 18.000 22.000 16.000 18.000 20.000...

how would i put these answers on an excel spread sheet? PROBLEMS 1. Ms. Winnie Lin's company sells computers. The monthly sales for a six-month period are as follows: MONTH SALES Jan Feb Mar Apr May...

MOnTH Jan Feb Mar Apr May Jun SALeS 1 8 , 0 0 0 2 2 , 0 0 0 1 6 , 0 0 0 1 8 , 0 0 0 2 0 , 0 0 0 2 4 , 0 0 0 a . Plot the monthly data on a sheet of graph paper. b . Compute the sales forecast for...

1. Ms. Winnie Lin's company sells computers. Monthly sales for a six-month period are as follows: MONTH SALES Jan Feb Mar Apr May Jun 18,000 22,000 16,000 18,000 20,000 24,000 a. Plot the monthly...

Ms. Winnie Lin's company sells computers. Monthly sales for a six-month period are as follows: Jan 18,000 Feb 22,000 Mar 16,000 Apr 18,000 May 20,000 Jun 24,000 a. plot the monthly data on a sheet of...

1. Ms. Winnie Lin's company sells computers. Monthly sales for a six-month period are as follows: MONTH SALES Jan Feb Mar Apr May Jun 18,000 22,000 16,000 18,000 20,000 24,000 a. Plot the monthly...

complete on spreadsheet 1. Ms. Winnie Lin's company sells computers. The monthly sales for a six- month period are as follows: MONTH SALES Jan Feb Mar Apr 18,000 22,000 16,000 18,000 20,000 24.000...

Find last non-zero digit in n! Description For a given integer n, find the last non-zero digit in thefactorial of n. n! = n * (n-1) * (n-2) * .... * 3 * 2 * 1 Input format: The first line should be...

In analyzing hits by V-l buzz bombs in World War II, South London was subdivided into regions, each with an area of 0.25 km2. Use the values listed here to test the claim that the actual frequencies...

Required inflormation Use the following information for the Exercises below. ( Suatic ) ( The following information applies to the questions displyyed betowe ) The following dets is previded for...

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...