Evaluate the sales forecast

Assignment Help Management Information Sys

Reference no: EM1324337

Projecting Monthly Computer Sales

Ms. Winnie Lynn's company sells computers monthly sales for a six-month period are as follows.
January 18,000
February 22,000
March 16,000
April 18,000
May 20,000
June 24000

a.) Plot the monthly data
b.) Compute the sales forecast for July using the following approaches:
1.) 4 month moving average,
2.) A weighted three-month moving average (using .5 for June and .3 for May and .2 for April)
3.) A linear trend equation, simple exponential moving with smoothing constant equal to.4 and assuming February forecast of 18,000

c.) Which method do you think is least appropriate? Why?

Reference no: EM1324337

Questions Cloud

Visual perception in the cognitive methods : Describe the significance of visual perception in cognitive processes.

Expalin importance of human resource information systems : The Importance of Human Resource Information Systems - What you learned in HRIS research, and what surprised you the most in HRIS capabilities.

Managerial ethics and behavior : Describe the three examples of ethical criteria with the supporting examples (cite company or executive decision) State one questionable negotiation tactics and ethical criteria with the supporting examples (cite company or executive decision)

Experience-visual perception-color spectrum vision : How does experience influence visual perception? Give an example in your response.

Evaluate the sales forecast : Projecting Monthly Computer Sales - Evaluate the sales forecast for July using the following approaches:

Routing protocols and criteria : Routing protocols and criteria - Please detail the differences between cold sites, warm sites, and hot sites.

Motivation-perception-motivation : What do you mean by motivation? Does perception affect motivation? Explain Why or why not?

Cultural diversity and business : Sealwrap, a producer of plastics in United States, is about to expand its business. As part of this expansion, they will begin to sell their products in Europe and Asia. In addition, they plan to open a plant in Asia.

Prepare for the changes you anticipate : Electronic Medical Record's impact - What obstacles will have to be overcome to move forward, and what should be done now to prepare for the changes you anticipate?

User Account

All Pages