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

  Find the name of current wto round of trade negotiations

Determine the WTO and how its relate to international trade? Dicuss how many nations belong to the WTO? What did the Uruguay Round (1994) of WTO trade negotiations accomplish?

  What is related to high foreign demand for japanese goods

If Japan generally runs a significant trade surplus, do you thinkthis is most related to high foreign demand for Japanese goods, lowJapanese demand for foreign goods, a high Japanese saving raterelative to Japanese investment, or structural barrie..

  Financial crisisdefinition

The title will be about the Financial Crisis in USA IN 2008 and it willcontain:1. Financial Crisisdefinition2. the causes which made this crisis3. the USE economy situation during the crisis4. the salvation this crisis5. the result of salvation

  Calculate the quota rent

Calculate the quota rent and asuming that the quota licenses are given to domestic producers, what is the net effect of the quota on Agronomia's welfare?

  Why president george w. bush suspended the u.s. tariffs

a) In 2002 the United States introduced tariffs on certain steel imports from China and Europe. One can argue that in some cases, the introduction of these tariffs improved welfare in the United States. Why?b) Use your answer to part a) to explain..

  The nation of acirema is small unable to affect world

the nation of acirema is small unable to affect world prices. it imports peanuts at the price of 10 per bag. the demand

  American comparative advantage

Give some example of a good the U.S. would be considered to have a comparative advantage in producing. Why do you think the United States has this comparative advantage?

  Calculate the us interest rate differential

The United Kingdom pound is trading at 1.82 U.S. dollars per United Kingdom pound. There is purchasing power parity at this exchange rate.

  Is the company allocating resources efficiently

A survey performed by a major research organization indicated that businesses are wary of current economic conditions and are now restoring to electronic media, such as the Internet and the telephone, to transact business.

  Define the natural monopolies provided by a private firm

Discuss the difference between a traditional monopoly and a natural monopoly. Include the following points in your discussion. Identify the incentives to produce and price the product for a traditional monopoly and natural monopoly.

  Which is not a strategic driver of the internet economy

Which of the following is not a strategic driver of the Internet economy? ________ is the term used to describe information systems that provide a complete picture.

  Targeting money stock

Suppose the Fed has already make a decision that it wishes to target the money stock. Will the Fed come closer to its target by setting the interest rate at a given level, or will it do better by fixing the money supply through open market operations..

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