Adjusted forecast to predict demand for packaged tours

Assignment Help Operation Management

Reference no: EM132282569

The manager of a travel agency wants to use seasonally adjusted forecast to predict demand for packaged tours. The demand for the last 14 weeks are given below:

Week 1 2 3 4 5 6 7 8 9 10 11 12 13 14

Demand 80 95 141 132 104 114 168 152 122 143 198 185 141 158

a. Estimate weekly relatives for the demand using the centered moving average method.

b. Estimate weekly relatives for the demand using the SA method.

c. Select your estimates either in (a) or (b). Deseasonalize the data.

d. Estimate the trend equation using the deseasonalized data from part (d). e. (7 points) Forecast demand for weeks 15 and 16.

excel work

Reference no: EM132282569

Questions Cloud

Company has created non-toxic household cleaner : Suppose a company has created a non-toxic household cleaner that it wishes to introduce to the market (the kind you spray on and wipe with a sponge).

Discuss the differences in the domestic and global marketing : Discuss the differences in the domestic and global marketing strategy that companies use.

State university pertaining to the organizational structure : What are some differences and similarities of McDonald’s and Jackson State University pertaining to the organizational structure?

Key factor to the corporation strategic planning : You learned about the organizational vision and how it is a key factor to the corporation strategic planning,

Adjusted forecast to predict demand for packaged tours : The manager of a travel agency wants to use seasonally adjusted forecast to predict demand for packaged tours.

Discussing various obstacles to undertaking market research : Discussing various obstacles to undertaking market research.

What are some of the sources of cash for typical business : Which types of reference groups are marketers concerned with and why? What are some of the sources of cash for a typical business?

Combining quantitative and communication skills : Combining Quantitative and Communication Skills. Why are quantitative skills so highly valued in various business disciplines?

Comment on the framework for decision making in business : Comment on the framework for decision making in Business provided by the text that is made up of 7 elements including duty,

User Account

All Pages