Evaluate equation of a trend line to forecast sales

Assignment Help Microeconomics
Reference no: EM131369582

Economics Assignment- Discussion

• 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: EM131369582

Questions Cloud

What specific supply chain processes and specific metrics : What specific supply chain processes and specific metrics might you look carefully at if you were in charge of improving and or redesigning your company's supply chain to decrease cost?
Represent important understandings of identity and worldview : Flags have significant symbolic meaning in a culture and represent important understandings of identity and worldview. Explain how flags represent cultural patterns and characteristics. Explain their influence on your personal connection to a cult..
What is the utilization rate of the booth workers : How many booth workers are required for the average potential customer to spend no more than 5 minutes waiting and being served? How many potential customers are waiting to be served, on average? What is the utilization rate of the booth workers?
Multi-service aviation business and including fuel : Earhart Aviation operates a multi-service aviation business, including fuel, aircraft maintenance, charter flights, aircraft rentals, and flight instruction. Not only should the user interface be thoroughly tested, there must be sufficient user docum..
Evaluate equation of a trend line to forecast sales : Using the regression feature of Excel, compute 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.
Forensics investigation trainee at two way communications : In this course, you have assumed the role of a forensics investigation trainee at Two Way Communications. You have received positive feedback from the CEO regarding your last report, and you are asked to train with the Internal Security department..
What is the probability that its top executive made : If a firm is randomly chosen from the list of 10 firms studied, what is the probability that its top executive made over $1 million per year?
Independent of the actual number of passengers on the plane : Northwest Airlines runs daily flights from Detroit to Amsterdam. They face a fixed cost of $70,000 for each flight independent of the actual number of passengers on the plane. There are 310 seats available on a plane. One way tickets generate revenue..
Pricing structure of the provider : 1. Do they offer PaaS, SaaS, or both? 2. How is the pricing structure of the provider designed? example price per gb storage price per vm, price per gb data transfer? 2. How easy does it appear to be to set up an account and start using their serv..

Reviews

Write a Review

Microeconomics Questions & Answers

  The free rider problem

Question: Explain why the free rider problem makes it difficult for perfectly competitive markets to provide the Pareto efficient level of a public good.

  Failure of the super committee is good thing for economy

Some commentators have argued that the failure of the “Super committee” is good thing for the economy?  Do you agree?

  Case study analysis about optimum resource allocation

Case study analysis about optimum resource allocation: -  Why might you suspect (even without evidence) that the economy might not be able to produce all the schools and clinics the Ministers want? What constraints are there on an economy's productio..

  Fixed cost and vairiable cost

Questions:  :   Which of the following are likely to be fixed costs and which variable costs for a chocolate factory over the course of a month?  Explain your choice.

  Problem - total cost, average cost, marginal cost

Problem - Total Cost, Average Cost, Marginal Cost: -  Complete the following table of costs for a firm.  (Note: enter the figures in the  MC   column  between  outputs of  0 and 1, 1 and 2, 2 and 3, etc.)

  Oligopoly and demand curve problem

Problem based on Oligopoly and demand curve,  Draw and explain the demand curve facing each firm, and given this demand curve, does this mean that firms in the jeans industry do or do not compete against one another?

  Impact of external costs on resource allocation

Explain the impact of external costs and external benefits on resource allocation;  Why are public goods not produced in sufficient quantities by private markets?  Which of the following are examples of public goods (or services)? Delete the incorrec..

  Shifts in demand and movements along the demand curve

Describe the differences between shifts in demand and movements along the demand curve. What are the main factors which can shift the demand curve? Explain why they cause the demand curve to shift. Use examples and draw graphs to support your discuss..

  Article review question

Article Review Question: Read the following excerpts from the article "Fruit, veg costs surge' by Todd, Dagwell, published in the Herald on January 25th 2011 and answer questions below:

  Long-term growth, international trade & globalization

Long-term Growth, International Trade & Globalization:- This question deals with concepts such as long-term growth, international trade and globalization. Questions related to trade deficit, trade surplus, gains from trade, an international trade sce..

  European monetary union (emu) in crisis

"Does the economic bailout of Spain and Greece spell the beginning of the end for the European Monetary Union (EMU)?"

  Development game “settlers of catan”

Read the rules of the game, the overview and the almanac for the Development Game "Settlers of Catan"

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