Compute the equation of a trend line to forecast sales

Assignment Help International Economics
Reference no: EM131357748

Discussion

"Sales Forecasting, Managing in the Global Economy, and Outsourcing Offshore"

From the scenario for Katrina's Candies, assuming the absence of quantitative data, determine the qualitative forecasting techniques that could be used within this scenario. Now, assume you have acquired time series data that would enable you to make forecasts. Ascertain the quantitative forecasting technique that will provide you with the most accurate forecast.

When deciding whether or not to outsource offshore, list the key factors the manager should consider, aside from maximizing profits. Which of these key factors do you believe are the most influential?

Optional: (You may substitute one of the above discussion prompts).

Consider the sales pattern shown in the data set below:

Sales

Year

Time Index

121

2004

0

130

2005

1

145

2006

2

160

2007

3

155

2008

4

179

2009

5

215

2010

6

208

2011

7

235

2012

8

262

2013

9

?

2014

10

?

2015

11

Using the regression feature of Excel, compute the equation of a trend line to forecast sales in 2014 and 2015. Note, you can use 'Year' as the explanatory variable or the 'Time Index' as the explanatory variable, but not both in the same equation. In your opinion, is this a good equation for forecasting future sales? Why or why not?

Reference no: EM131357748

Questions Cloud

What marketing strategy or strategies has aldi has adopted : What marketing strategy or strategies has Aldi has adopted since it was created? For Australian-based students, you might like to focus your analysis on the Aldi Australia experience.
Give the answer of muliple choice question : Which of the following statements is false? Mansa Musa was the ruler of the African kingdom of.Although the demand for slaves was great, Angolan and Brazilian merchants only permitted a steady trickle of slaves into Brazil because.
Yield to maturity on long-term bonds : How does a higher beta affect WACC and why? What is the WACC for a public utility given the following information: beta: 0.8, expected rate of return on the S&P 500: 12.4%, risk-free rate (T-bill yield): 4%, yield to maturity on long-term bonds: 7.2%..
Epidemiological transition of wealthy industralized nations : Consider the political economy, economics, behaviroral and biomedical factors that contributed to the epidemiological transition of wealthy industralized nations and compare and contrast it with circumstances in contemporary Africa. Include the de..
Compute the equation of a trend line to forecast sales : ECO 550- Using the regression feature of Excel, compute the equation of a trend line to forecast sales in 2014 and 2015. Note, you can use 'Year' as the explanatory variable or the 'Time Index' as the explanatory variable, but not both in the sam..
What effect did the smoothing constant have on the forecast : Refer to Solved Problem. Using smoothing constants of .6 and .9, develop forecasts for the sales of VW Beetles. What effect did the smoothing constant have on the forecast
How the internet has changed competitive forces : Describe how the Internet has changed competitive forces and competitive advantages in businesses -  explain how the value web helps businesses identify opportunities for strategic information systems.
American airlines announced a new pricing strategy : American Airlines announced a new pricing strategy that they believed would address concerns and benefit the company. Conduct further research on American Airlines' value pricing.
Write a paragraph about each demographic : Write a paragraph about each demographic and speculate on how the distributions might be related to health measurements. Be sure to save a copy of your work!

Reviews

Write a Review

International Economics Questions & Answers

  Which has resulted in a severe decrease in auto sales

James Black and Howard Decker (i.e. Black & Decker), both skilled carpenters, find themselves out of work because of a housing slump brought about by higher interest rates and a mild economic recession.

  What do you think happened to university revenues

When the British government tripled university fees for foreign students in Great Britain, about one-half of them left to study in other countries." What is the implied price elasticity of demand by foreigners for a British education is (in absolu..

  Develop an estimated regression equation

Perform a logarithmic transformation on the dependent variable. Develop an estimated regression equation using the transformed dependent variable. Do the model assump¬tions appear to be satisfied by using the transformed dependent variable?

  Research on international freight companies increased costs

Write a Research paper on International freight companies increased costs that are directly related to transportation of people, products and technological advances.

  Describe the cost structures of these funds

Identify the process by which the company identifies and raises funds for capital investments. Describe the cost structures of these funds from both internal and external sources.

  Identify the main effects of the economic crisis

Identify the main effects of the economic crisis of 2008-2009 on tourism in Canada, the USA and Mexico. Why did the economic crisis of 2008-2009 affect Canada, the USA and Mexico unevenly?

  Questions on forward rates

Mary Beth Morgan and Shaban Shoshi are currency traders for Mercury Forex Corporation They have compiled the following data concerning currencies in Sweden, New Zealand, and United States.

  Explain the differences between horizontal and vertical fdi

Explain the differences between horizontal and vertical FDI. Can you summarize each of the OLI advantages. How can FDI be used to overcome high transaction costs and prevent market failure

  Describe the economy of the united states today

John Maynard Keynes was the first to show that government policy could be used to change aggregate output and prevent recessions by stabilizing the economy. Describe the economy of the world at the time Keynes was writing.

  How do the shifts manifest in the world economy

How do the shifts manifest in the world economy? Give at least five examples. What are the implications for business in North America? Great Britain? Hong Kong?

  The law of increasing cost would still apply

On the production possibilities frontier graph, the closer the economy's production is to the origin of the graph and the farther away it is from the PPF.

  Calculate the value of the intraindustry trade

Calculate the value of the Intraindustry Trade

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