Calculate the forecast using smoothing constants

Assignment Help Business Management

Reference no: EM131261344

HiTek Computer Services repairs and services personal computers at its store, and it makes local service calls. It primarily uses part-time State University students as technicians. The company has had steady growth since it started. It purchases generic computer parts in volume at a discount from a variety of sources whenever they see a good deal.

Thus, they need a good forecast of demand for repairs so that they will know how many computer component parts to purchase and stock, and how many technicians to hire. The company has accumulated data shown in the accompanying table for repair and service calls for the past 12 months.

In the following table, please calculate the forecast using smoothing constants (a) equal to 0.30.

			Forecast, F_(t+1)
Period	Month	Demand	a = 0.30	a = 0.50
1	January	37
2	February	40		37.00
3	March	41		38.50
4	April	37		39.75
5	May	45		38.37
6	June	50		41.68
7	July	43		45.84
8	August	47		44.42
9	September	56		45.71
10	October	52		50.85
11	November	55		51.42
12	December	54		53.21
13	January	---		53.61

• The company has also calculated the exponential smoothing forecasts using smoothing constants (a) equal to 0.50 (provided above). What can you say about the responsiveness of the two forecasts? Which one is likely to be more responsive?

• The company wants to compare the accuracy of these two different forecasts using MAD. Please compute MAD for (a) equal to 0.30 and (a) equal to 0.50 compared to the actual demand data. Which alpha provides a more accurate forecast? Describe why it might be more accurate.

Reference no: EM131261344

Questions Cloud

Key aspect of a health care facility culture : Determine a key aspect of a health care facility's culture that is necessary to support the implementation of an integrated delivery system. Support your response.

Do you support machiavelli opinion : How do you like what you have read? Do you support Machiavelli's opinion? Should a prince act in that way? Does a prince's strong rule, based on Machiavelli's advice, benefit his people? What about moral and ethical values?

Underlying database for a new point of sale : Your team has been asked by a small retail client, SmallMart, to create the underlying database for a new point of sale (POS) system. You will be going through the Database Development Life Cycle, beginning with the analysis of requirements and e..

What is the required power for the pump : If the valve at location D is open and the discharge through the pump is 11,000 gal/hr, determine the discharge in pipe 4.

Calculate the forecast using smoothing constants : Calculate the forecast using smoothing constants (a) equal to 0.30. - What can you say about the responsiveness of the two forecasts?

Is lego engaged in socially responsible behavior : Is LEGO engaged in socially responsible behavior? Which external environmental factor, in this case, is most important to LEGO's continuing success? Would LEGO be considered a "green" company?

Effects on operational outcomes : Analyze the use of an Enterprise Software Systems (ESS) in a health care organization with regard to its effects on operational outcomes. Select one of the following applications.

Could this passage symbolize the entire work : Are there metaphors (words that represent something else without using like or as)? What kinds? Is there one controlling metaphor? If not, how many different metaphors are there, and in what order do they occur? How might that be significant?

Evaluate best practices for leading teams : This assignment involves two objectives that ale important for this course: Develop a personal understanding of one's values, skills, and styles to effectively lead people and teams. Evaluate best practices for leading teams

User Account

All Pages