Develop a forecast for the firms annual sales for each year

Assignment Help Operation Management

Reference no: EM131857605

Question : Forecasting - Linear Regression

A manufacturer is developing a facility plan to provide production capacity for its factory. The amount of capacity required in the future depends on the number of products demanded by its customers. The data below reflect past sales of its roducts:

Year	Annual Sales (number of products)	Year	Annual Sales (number of products)
1	490	5	461
2	487	6	475
3	492	7	472
4	478	8	458

a) Use simple linear regression to forecast annua demand for the products for each of the next three (3) years, by using the tabular method to:

i. derive the values for the intercept and slope

ii. derive the linear equation

iii. plot the linear regression line , and

iv. develop a forecast for the firm's annual sales for each of the next three years

b) Repeat the forecast using excel software to :

i. plot the normal graph with the regression trend line using the raw data provided

ii. indicate the linear regression equation on the graph

iii. extrapolate the regression trend line to forecast the firm's sales for each of the next three years.

Reference no: EM131857605

Questions Cloud

What health care access challenges do they have : Conduct an interview with an anonymous relative, acquaintance, or client. Someone who is at least 65 years old and/or someone who has a disability.

What type of political system might have greatest potential : What type of political system might have the greatest potential for imposing adverse political risk on an international business?

Star emits light with a peak wavelength : A star emits light with a peak wavelength of 8900 angstroms (1 Angstrom = 10-10 meters). What type of star is this and what color is this star?

How does feedback contribute to improvement of competence : BSBWOR501 Manage personal work priorities and professional development Assignment. How does feedback contribute to improvement of competence

Develop a forecast for the firms annual sales for each year : The amount of capacity required in the future depends on the number of products demanded by its customers.

Density at the center of a neutron star : How does this compare with the density at the center of a neutron star, about 3 ? 1018 kg/m3?

Describe nike and foxconn business strategies : Describe NIKE and FOXCONN business strategies and how they involved controversial manufacturing relations. Discuss your opinions about these strategies.

Find the orbital period of a star moving in a circular : Find the orbital period of a star moving in a circular orbit of radius 535 AU around the supermassive black hole in M87.

Civilization broadcasting a signal with a power : Consider a civilization broadcasting a signal with a power of 1.9×104 watts. The Arecibo radio telescope, which is about 300 meters in diameter

User Account

All Pages