Appropriate forecasting model for the sales of toasters

Assignment Help Marketing Management
Reference no: EM131037842

The department manager has decided that the appropriate forecasting model for the sales of toasters at a local department store is the Winter’s Model with additive trend and multiplicative seasonality. Given the time series data set in the Excel spreadsheet (Sheet 1 - Toasters), make the forecasts for the four (4) quarters (Q1, Q2, Q3 and Q4) for the year 2016. Make sure to include a line chart with markers indicating the actual demand, the trend line, and your forecasts. Also, calculate the MAD, MSE, MAPE, bias and the tracking signal for the manager's forecast. Use the supplied Excel spreadsheet to input your answers with the correct formulas. Would you accept the manager’s forecast based on any of the measurements above? Explain briefly. 2. Graduate Management Assessment Tests (GMAT) scores are often used as an indicator of graduate school performance in terms of predicting a student’s grade point average (GPA). Given the following data (Excel File Sheet 2 - GMAT), use a linear regression model to predict the GPA for a student scoring 720 on his/her GMAT exam. Make sure to identify the independent and dependent variables correctly. You must show the output from the Regression model. Also, provide the trend or regression line equation and show your calculations for the forecast. GMAT Score GMAT Score 600 710 540 660 580 740 620 570 650 680 GPA 3.52 3.75 3.24 3.83 3.36 4.00 3.48 3.10 3.31 3.67.

Reference no: EM131037842

Questions Cloud

Internal consistency or market competitiveness : Which do you believe is most important for a company's competitive advantage: internal consistency or market competitiveness? Explain your answer.
Percent upward shift in the production function : Show the effects of an increase in labor supply to 5,000. Show the effects of a twenty percent upward shift in the production function. By the way did i do marginal product correctly
Is the strategy defined in terms of product or process : What are the strategies of the following organizations? Is the strategy defined in terms of product or process or both? A. McDonald’s B. AT&T Telephone Co . General Motors D. Harvard Business School
What percentage of companies fail in execution of strategy : Apple is an example of a company who successfully did what? Although many organizations engage in the “right” projects, what action do they also pursue which impedes their success? What percentage of companies fail in the execution of their strategy?
Appropriate forecasting model for the sales of toasters : The department manager has decided that the appropriate forecasting model for the sales of toasters at a local department store is the Winter’s Model with additive trend and multiplicative seasonality. Would you accept the manager’s forecast based on..
Power supply of the cmos amplifier analyzed : 8.46 The power supply of the CMOS amplifier analyzed in Example 8.4 is increased to 5 V. What will the extent of the linear region at the output become?
When is an acceptance effective and discuss the mailbox rule : When is an acceptance effective? Discuss the mailbox rule. If the UCC does not apply, how are contrary terms in the acceptance treated? What if the UCC does apply?
Price elasticity of demand for steel : If the price elasticity of demand for steel is greater abroad than it is in Japan, which of the following will be correct?
A company is said to be an international competitor when : A company is said to be an international competitor when?

Reviews

Write a Review

Marketing Management Questions & Answers

  Explain what is magazine reviews

Explain What would your advice be to the traditional newspaper editors be on how to compete with craigslist and Magazine reviews and other mentions in the press

  The nestleacute company is considering introducing its

the nestleacute company is considering introducing its coffee product in thailand. market research has revealed the

  Consider the key reasons why you believe these variances

please respond to the following diffusion of innovationbullper the text health care consumers vary in their willingness

  What method to determine an appropriate marketing budget

The advertising strategy of the business to business market has differences with the business to consumer market - each is unique. How do you think your strategy or process would change from a B2B market vs. a B2C market? Or, would it be the same?

  What is your zip code

What is your zip code and How likely are you to visit a Phil's BBQ location in Orange County

  Apple next products- is a new strategy needed

Apple's Next Products: Is a New Strategy Needed, Based on the video http://www.youtube.com/watch?v=glnTz5HD05U, fast forward to current day

  Characteristics of the us population

Use the Internet to describe the following characteristics of the U.S. population in 2025 (www.ccnsus.gov is a good place to start). How will this differ from the way it is today? What are the marketing strategy implications of these shifts

  Culture and perspective of new zealand

Culture and Perspective of New Zealand

  Services that could be highlighted in a marketing campaign

Discuss some of the goods or services that could be highlighted in a marketing campaign that involves a concierge practice of medicine. What advantages do you think a concierge practice of medicine might contribute to the hospital's offerings of p..

  Select a company that has an online presence

Select a company that has an online presence, review their Promotional Mix in terms of how they are using it online. Is their online Promotional Mix the same, different or close to what they do via traditional marketing methods?

  Discuss and describe how e-business will affect the

discuss and describe how e-business will affect the following areas of endeavor including both positive and negative

  What is dynamic pricing

What is dynamic pricing? When is it best used? Is it legal? Why or why not? Using a specific example, explain how it relates to yield management.

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