Calculate the forecast for quarters

Assignment Help Operation Management
Reference no: EM13792453

Question

Demand for cameras at Best Buy had the following demand (in thousands) history by quarters over a three-year period.

2012

Demand

2013

Demand

2014

Demand

1

14

1

18

1

16

2

27

2

34

2

47

3

78

3

73

3

86

4

54

4

64

4

49

The Multiplicative seasonal relatives for the four quarters are given to be: QI 0.35  Q2=0.83 Q3=1.67 Q4=1.26

The Additive seasonal relatives for the four quarters are given to be:

Q1=-31.5 Q2 = -8.18 Q3 = 30.13 Q4 =12.25

a) Using yearly demands from 2012-2014 and a 3-year weighted moving average, with weights of 0.5, 0.3 and 0.2 (using 0.5 for the most recent year), to forecast the yearly demand for 2015.

Following this, calculate the forecast of demand for each quarter of 2005 using the seasonal factors Show calculations for both multiplicative and additive seasonal relatives.

b) Using a Linear Trend equation, 20 + 6t, and the Seasonal relatives for the four quarters given above, calculate the Forecast for Quarters 1, 2, 3, 4 of Year 2015 (using both Multiplicative model and Additive Model)

Reference no: EM13792453

Questions Cloud

Guidelines found in the gcu style guide : Use a minimum of three of the sources provided to support your journal entry and be sure to cite the sources. Prepare this assignment according to the guidelines found in the GCU Style Guide, located in the Student Success Center.
Explain the success of an mnc within a global market : Analyze the significant manner in which the external environment affects the success of an MNC within a global market. Suggest two to three (2-3) actions that MNCs should take in order to be more socially
Describe how the division addresses customer needs : Describe how the division addresses customer needs and achieves competitive advantage. Create a vision and a business model for this new division that clearly demonstrates your decision on what you want your business to become in the future.
Assignment on trials and verdicts : Trials and Verdicts
Calculate the forecast for quarters : Demand for cameras at Best Buy had the following demand (in thousands) history by quarters over a three-year period.
How did you address counterarguments without weakening : Where did you place the most effective arguments in your paper? Explain your reasoning. How did you address counterarguments without weakening your own premise?
Define the us healthcare system : Define the U.S. healthcare system by addressing the items below: Describe the history (e.g., teacher's union in Dallas, Texas; the American Medical Association; and the First Marine Hospital).
Fuel cell develpoment,air and water purification : Provide at least three examples of real -world applications in use or in development with reliable references.
Role of an ordinary individual : Assume the role of an ordinary individual (i.e. not a famous artist or politician) in Italy during the 15th century. What do you believe are the most important factors of the Italian Renaissance and why?

Reviews

Write a Review

Operation Management Questions & Answers

  Adaptation is defined

Adaptation is defined as _

  Consider a two-stage distribution supply chain

Consider a two-stage distribution supply chain: a distribution center in the upstream and 5 retailers in the downstream. Retailer demand is normal random variables independent of each other.

  Use a firm fixed-price contract type for his procurement

Project Manager Buddy Lee has elected to use a Firm Fixed-Price contract type for his procurement. Which type of Procurement Document(s) are most appropriate for Buddy Lee to use?

  The types of drugs for use in mental services

Outline a plan for communicating these findings to a local consortium of nurses and physicians at your hospital. This plan must include, at a minimum, the cost of the drugs, as well as the types of drugs for use in mental, behavioral, and general ..

  The resource planning tool

The resource planning tool that enables us to identify who we need to carry out what tasks is called: a. A resource Gantt chart b. A resource matrix

  Explain how might the subsequent business specialists use

Explain how might the subsequent business specialists use learning curves: accountants, marketers, financial analysts, personnel managers also computer programmers.

  Formulate and solve a linear optimization model

Formulate and solve a linear optimization model using the auxiliary variable cells method and write a short memo to the production manager explaining the sensitivity information.

  Location for wannaburger fast food business

Using the SWOT Analysis, Michael E.Porter's Five forces & Value Chain analysis about location for wannaburger fast food business

  Illustrate what risk of stock out would result

Design a model with methods also procedures for analyzing diversity also elucidate how you would implement results in a cultural diversity training program. Illustrate what risk of stock out would result from a decision not to have any safety stock..

  Explain how are the mean activity times

Explain how are the mean activity times and activity variances computed in probabilistic CPM/PERT analysis.

  What remedies are available to him

Kristina does not want to pay him $1000 on delivery. Can the baker sue Kristina for payment of the cake? What remedies are available to him?

  Assume the initial forecast for day

Your job is to compute forecasts using exponential smoothing technique with alpha of 0.3. Assume the initial forecast for day 1is 37. Show details for at least three calculations

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