Data to adjust quarterly seasonal fractions problem

Assignment Help Operation Management

Reference no: EM132282681

Given three years of quarterly data: Year 1 2 3 Q1: 12 16 14 Q2: 25 32 45 Q3: 76 71 84 Q4: 52 62 47 (a) Use the first 2 years to compute seasonal factors (fractions) (b) Use these seasonal factors to estimate the quarterly demands and errors for year three (c) Use a MVA(8 quarters of data) to estimate the yearly demand total for the next quarter for the third year of data (d) Use the 3rd year of data to adjust the quarterly seasonal fractions Problem 2 Using the data of Problem 1, apply regression to estimate the third year quarterly data?

Please answer all of the questions and try to solve it by writing on papers not by excel.

Reference no: EM132282681

Questions Cloud

Pick the industry of firm relevant to you : Pick the industry of a firm relevant to you; ideally the industry of your employer.

Explain the three main roles that any organizations function : Identify and explain the three main roles that any organizations function has to play within an organization? by giving an example for each.

Domestic firms sell more to domestic consumers : Should foreign -invested and domestic firms sell more to domestic consumers in Thailand?

Factors affecting work environment : Factors affecting work environment of Wendy's store that needs to be considered in order to improve the work system design of it would be behavioral feasibility

Data to adjust quarterly seasonal fractions problem : Use the 3rd year of data to adjust quarterly seasonal fractions Problem 2 Using data of Problem 1, apply regression to estimate the third year quarterly data?

New phenomenon called apparel on demand : IT in Action A new phenomenon called 'Apparel on Demand' is slowly making its presence felt

Can cuba effectively become free market economy : Can Cuba effectively become a free market economy? What do multiple trade theories have to say about Cuba, pre and post embargo?

Value created from dubai resources and capabilities : What resources, capabilities, and competencies does Dubai have? How is value created from Dubai’s resources and capabilities?

Identify other forms of communication : Identify other forms of communication that take place in the workplace

User Account

All Pages