Forecasting with time series analysis

Assignment Help Applied Statistics
Reference no: EM134555

Forecasting with Time Series Analysis

Objective: Crusty Pizza Executives have to forecast December sales for the 10 stores given in table.

• Plot the data for each store.Use data in table.
• Develop a sales forecast for each store for December, using:

a) A three month moving average

b) A 2- month weighted moving average, with weights of 0.7 on the most recent month and 0.3 on the older month.

c) Exponential smoothing with an alpha value of 0.25.

Which resulting forecast and forecasting technique is the best technique to use? Why?

Crusty Dough Pizza Company

Monthly Sales Data for ten stores


Store Jan Feb Mar Apr May Jun

A1 $22,910.28 $20,827.53 $27,336.13 $22,389.59 $29,418.88 $29,418.88

A2 $1,604.99 $1,547.67 $1,929.81 $1,853.38 $2,139.98 $2,159.09

A3 $23,317.20 $16,142.68 $15,943.38 $20,128.52 $18,135.60 $19,530.65

A4 $12,339.01 $13,585.38 $14,457.83 $13,585.38 $13,086.83 $12,588.29

A5 $12,771.04 $12,771.04 $11,223.03 $15,093.05 $10,707.03 $11,997.04

A6 $19,694.54 $16,145.98 $17,565.40 $15,791.12 $19,517.11 $20,226.83

A7 $19,258.64 $18,391.14 $14,227.11 $20,299.65 $17,003.13 $15,268.11

A8 $18,483.54 $21,344.08 $19,143.66 $20,243.87 $24,864.76 $23,984.59

A9 $23,471.33 $21,430.35 $28,063.55 $22,195.72 $29,339.17 $30,614.78

A10 $15,572.27 $18,041.04 $22,788.68 $22,029.06 $19,750.19 $22,788.68

















Store Jul Aug Sep Oct Nov Dec

A1 $26,815.44 $25,774.07 $21,868.90 $24,732.69 $30,980.95 ?

A2 $2,216.41 $1,968.02 $1,585.88 $1,776.95 $2,235.52 ?

A3 $17,537.72 $21,922.15 $17,737.01 $23,117.91 $20,726.40 ?

A4 $10,469.47 $9,970.92 $11,092.65 $13,336.11 $14,083.92 ?

A5 $15,351.05 $12,900.04 $10,320.03 $11,610.04 $14,190.04 ?

A6 $18,629.97 $14,549.12 $21,291.40 $16,855.69 $16,855.69 ?

A7 $15,268.11 $15,441.62 $13,880.10 $15,441.62 $18,391.14 ?

A8 $23,324.46 $20,023.83 $19,363.70 $25,304.84 $23,984.59 ?

A9 $23,981.58 $24,236.70 $30,104.54 $30,614.78 $27,298.18 ?

A10 $17,851.14 $19,750.19 $18,800.66 $22,218.97 $17,471.32 ?

Reference no: EM134555

Questions Cloud

Monitor expenditure and compare with financial plan : Report and monitor expenditure and compare with financial plans so that recommendations are developed for key stakeholders.
Design a set of 3nf tables for database scenario : Draw an ER diagram for your database scenario. Design a set of 3NF tables for your database scenario.
Calculate the stock price of ibm : Calculate the stock price of IBM - Using the information of the present year to evaluate the current stock.
Prepare a dcf analysis on amd : Prepare a DCF analysis on AMD· Ultimate goal is for to determine a range of implied AMD share price you believe is related -
Forecasting with time series analysis : Develop a sales forecast for each store for December Plot the data for each store.Use data in table.
Write a report on toxic and hazardous waste : Toxic and Hazardous waste: how are they treated, safety measures, regulations in USA about hazardous waste.
Build and describe a prototype model : Mathematical Programming and Optimisation: Build and describe a prototype model Use your model to recommend a schedule of burning and, if required buying fuels
What do you meant by blue ocean strategy : This problem is related to Busniess Management What do you meant by ‘blue ocean' strategy? How does it differ from brainstorming?
What is effectiveness of battery as an energy storage device : What is effectiveness of battery as an energy storage device

Reviews

Write a Review

Applied Statistics Questions & Answers

  Hypothesis testing

What assumptions about the number of pedestrians passing the location in an hour are necessary for your hypothesis test to be valid?

  Calculate the maximum reduction in the standard deviation

Calculate the maximum reduction in the standard deviation

  Calculate the expected value, variance, and standard deviati

Calculate the expected value, variance, and standard deviation of the total income

  Determine the impact of social media use on student learning

Research paper examines determine the impact of social media use on student learning.

  Unemployment survey

Find a statistics study on Unemployment and explain the five-step process of the study.

  Statistical studies

Locate the original poll, summarize the poling procedure (background on how information was gathered), the sample surveyed.

  Evaluate the expected value of the total number of sales

Evaluate the expected value of the total number of sales

  Statistic project

Identify sample, population, sampling frame (if applicable), and response rate (if applicable). Describe sampling technique (if applicable) or experimental design

  Simple data analysis and comparison

Write a report on simple data analysis and comparison.

  Analyze the processed data in statistical survey

Analyze the processed data in Statistical survey.

  What is the probability

Find the probability of given case.

  Frequency distribution

Accepting Manipulation or Manipulating

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd