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

  Agricultural trade between australia and china

Agricultural trade between Australia and China - facts and figures - which area are increasing / decreasing -factors affecting this trade

  Porters five forces model to the auto industry

Economists generally use Porter's 5-forces framework when making a qualitative evaluation of a company's strategic position. According to Porter, his model should be used at industry level,

  Write from the perspective of business

Write from the perspective of business, please write in a way that which country should be better to do business for the business people who will come and do business.

  How imports and exports can have an impact on the economy

The question is from Economics and the question is explains about imports and exports. How imports and exports can have an impact on the economy. And the impact of imports and exports has been discussed in the answer along with some examples.

  How to compare living standards between countries

Among the problems that hinder growth in developing economies are poor infrastructure, lack of financial institutions and a sound money supply, a low saving rate, poor capital base, and lack of foreign exchange.

  Determine how supply and demand affect prices of homes

You are between jobs and have decided to relocate to a city west of the Mississippi River, but you are unsure of what size or type of city you and your family can afford to live in.

  Exchange rate of the country

Suppose that a nation faces a balance of payments deficit with high unemployment. Determine what exchange-rate adjustment can be made to solve these problems?

  Select a current exchange rate practice and explain

Team, as we continue to understand the power of economics in a global context, evaluate the impact of exchange rate adjustments and their effects on the balance of payments

  Why are some countries today much poorer than other country

Why are some countries today much poorer than other countries? Are today's poor countries destined to always be poorer than today's rich countries? If so, explain why.

  Determine the trade balance between the us and china

Determine the trade balance between the U.S. and China for the most recent five year period. Illustrate the trend over this period with a graph of the data.

  Capital from foreign countries to finance its current

Comment on the following statement: “Since the U.S. imports more than it exports, it is necessary for the U.S. to import capital from foreign countries to finance its current account deficits.”

  Find the price and quantity for the european air route

Formerly, the market for air travel within Europe was highly regulated. Entry for new airplanes was severely restricted, and air fare were set by regulation. Partly as a result, European air fares were higher than US fares for routes of comparable..

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