User Account

All Pages

Forecasting with time series analysis objective crusty

Assignment Help Applied Statistics
Reference no: EM13350600

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: EM13350600

Questions Cloud

Part a - performance objectivereport and monitor : part a - performance objectivereport and monitor expenditure and compare with financial plans so that recommendations
Metropolitan city church managementmetropolitan city church : metropolitan city church managementmetropolitan city church management mccm has hired you as a consultant to modernize
Calculate the stock price of ibm1using ddm pe ggm multiple : calculate the stock price of ibm1.using ddm pe ggm multiple approach show the calculation2. make your assumptions about
Prepare a dcf analysis on amdmiddot ultimate goal is for to : prepare a dcf analysis on amdmiddot ultimate goal is for to determine a range of implied amd share price you believe is
Forecasting with time series analysis objective crusty : forecasting with time series analysis objective crusty pizza executives have to forecast december sales for the 10
Each report may cover all items included in the description : each report may cover all items included in the description of the project below1. toxic and hazardous waste how are
Mathematical programming and optimisationindividual : mathematical programming and optimisationindividual assignmentapproach this as if it were a piece of commercial work
Question 1 give examples of companies that have improved : question 1. give examples of companies that have improved their market position market leader by dramatically shifting
Question1on vacation your 1350 kg car pulls a 540 kg : question1on vacation your 1350 kg car pulls a 540 kg trailer away from a stop light with an acceleration of 1.90 ms2.a

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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