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

  What are the critical values

A sample of 10 executives indicated that they spent an average of $11.30 with a sample standard deviation of 0.56 on lunch. Let = 0.05. What are the critical values?

  Queuing theory-clarke and wright algorithm

How many turnstiles must be opened in each direction every morning and describe the suppositions underlying the solution of this problem by using queuing theory.

  Calculate the median for the group of results

State the five types of central tendency in general use. Which of these are most frequently used in SPC work and calculate the median for the group of results tabulated below: 1,3,4,6,7,9,11,14,16,17,18.

  Compute the value of beta for each stock.

Evaluate the value of beta for each stock. Which of these stocks would you expect to perform best in an up market? Which would you expect to hold their value best in a down market?

  What is the variable of interest

Explain the methodology you will use to answer the question you posed. Your explanation should include answers to the questions - What is the variable of interest?

  Calculate the correlation between pretest and posttest score

Calculate the correlation between pretest and posttest scores separately for each gruop and determine sperately for each group whether performance improved from pretest to posttest

  Prepare a research on applied statistics

Perspective about the problem you are trying to analyze; in other words, you should review the literature concerning your subject. The library or the web will be a good source of information.

  Create a histogram for iq and include normal distribution

Use Analyze, Descriptive statistics, Frequencies to summarize nonmetric variables, and create a pie-chart for Year in college and create a histogram for IQ and include the normal distribution.

  Statistics and research methods for business decisions

Empirical Research, Sampling Methods and Reliability - Identify a business research and define the research questions for the identified problem or opportunity

  Identify the type of observational study

Identify the type of observational study (cross-sectional, retrospective, or prospective) described

  Build a regression model

Build a regression model

  Determine length of line at which transmission line effects

As a rule of thumb a line is considered as a transmission line if the length of the line is greater than one-sixteenth of the wavelength of the electromagnetic wave. Based on this rule of thumb

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