Set of time series sales data for growing company

Assignment Help Operation Management

Reference no: EM132297348

Consider the following set of time series sales data for a growing company over the past 8 months: Month Sales

1 15

2 13

3 18

4 22

5 20

6 23

7 22

8 21

Construct a time series plot. What type of pattern exists? Develop a forecast for the next month using the averaging method. Develop a forecast for the next month using the naïve last-value method. Develop a forecast for the next month using a four-month moving average method. Use the Excel Functions SLOPE and INTERCEPT to write the linear regression prediction equation with Months as the independent variable and sales as the dependent variable. Use the prediction equation to estimate the number of sales in month 9. Please show steps.

Reference no: EM132297348

Questions Cloud

Use the information from fred flow soldering process : Use the information from Fred’s flow soldering process that solders chips onto a board that goes into his cell phones

How might these stem from country and regional cultures : Are there regional variations in country and company efforts to support innovation? How might these stem from country and regional cultures?

Settle discrimination charges prior to litigation : Employers are generally quick to settle discrimination charges prior to litigation. Labor relations laws apply to.

Affect product design and process selection : Name the three (3) computer applications that affect product design and process selection:

Set of time series sales data for growing company : Consider the following set of time series sales data for a growing company over the past 8 months: Month Sales

Approach the networking event and potential contacts : How did you approach the networking event and potential contacts?

How to improve employee relationship-engagement : How do these topics correlate with leadership impact on negativity at the workplace and how to improve employee relationship/engagement.

Organizational structure and business information systems : What are the 3 factors that can strengthen the relationship between organizational structure and business information systems?

When preparing an effective strategy : A social media marketing manager needs to address several key questions when preparing an effective strategy.

User Account

All Pages