Question
Suppose a firm has had the historical sales figures shown as follows. What would be the...
Suppose a firm has had the historical sales figures shown as follows. What would be the forecast for next year's sales using regression to estimate a trend?
| Year | 2008 | 2009 | 2010 | 2011 | 2012 | |||||||||||||||
| Sales | $ | 2,000,000 | $ | 1,800,000 | $ | 2,200,000 | $ | 2,400,000 | $ | 2,300,000 | ||||||||||
Homework Answers
Answer #1
Not the answer you're looking for?
Similar Questions
Suppose a firm has had the historical sales figures shown as follows. What would be the...
Suppose a firm has had the historical sales figures shown as
follows. What would be the forecast for next year's sales using
regression to estimate a trend?
Year
2008
2009
2010
2011
2012
Sales
$
2,000,000
$
1,800,000
$
2,200,000
$
2,400,000
$
2,300,000
Multiple Choice
$2,140,000
$2,225,000
$2,300,000
$2,500,000
Suppose a firm has had the following historic sales figures year 2016 sales $1450000, year 2017...
Suppose a firm has had the following historic sales figures year
2016 sales $1450000, year 2017 $1710000, year 2018 $ 1600000, year
2019 $2000000 and year 2020 $1850. What would be the forecast for
next year's sales using regression to estimate a trend?
A company’s sales for the years 2010 to 2018 were as follows: ( x N$ 10...
A company’s sales for the years 2010 to 2018 were as follows: (
x N$ 10 000 )
Year
2010
2011
2012
2013
2014
2015
2016
2017
2018
Sales
324
296
310
305
295
347
348
364
370
2.1) Derive, by using the method of least squares, an equation
of linear trend for the sales of the company. (Use sequential
numbering with x = 1 in 2010) (8)
2.2) Use the trend line equation obtained in Question 2.1 to
compute...
Find the required linear model using least-squares regression. The table below gives the total sales (in...
Find the required linear model using least-squares
regression.
The table below gives the total sales (in billions of dollars)
for the aerospace industry.
Year
2006
2007
2008
2009
2010
2011
Total Sales
184.4184.4
186.7186.7
188.3188.3
189.5189.5
190.5190.5
191.3191.3
(a) Find a linear model for the data with x=6
corresponding to the year 2006.
(b) Assuming the trend continues, estimate
the total sales for the year 2015.
(a) The linear model for the data is
yequals=nothing xplus+nothing .
Garlington Technologies Inc. s 2010 financial statements are shown below. Suppose that in 2011 sales increase...
Garlington Technologies Inc. s 2010 financial statements are
shown below. Suppose that in 2011 sales increase by 10% over 2010
sales and that 2011 dividends will increase to $ 112,000. Construct
the pro forma financial statements using the percent of sales
method. Assume the firm operated at full capacity in 2010. Use an
interest rate of 13% on the debt balance at the beginning of the
year. Assume that the AFN will be in the form of notes payable.
2010...
1- In the previous 5 years, Google paid an annual dividend as follows: Year Dividends 2011...
1- In the previous 5 years, Google paid an annual dividend as
follows:
Year
Dividends
2011
2.7
2010
2.5
2009
2.2
2008
1.8
2007
1.5
1. Google is expected to pay a dividends of $3 in the next year
(2012). What is the cost of equity of Google if its current stock
price is $90? Calculate using excel (formulas
viewable).
2. 2- As a technology-based firm, Google has a high beta of 1.4.
if the risk-free rate of return is...
Carolina Roof Construction sells roofing supplies and equipment. Experience has shown the owner, John Fransen, that...
Carolina Roof Construction sells roofing supplies and equipment.
Experience has shown the owner, John Fransen, that the sales have a
significant seasonal variability. It is critical that the sales
forecasts are accurate so Fransen can plan the cash flow of the
business. The file Carolina Roof Construction Spring
2019 contains the sales figures for 2011 to
2018. Produce a forecast using regression of
deseasonalized sales and reseasonalize the forecast. Write
a report to Frans and include your forecast for winter, spring,...
Carolina Roof Construction sells roofing supplies and equipment. Experience has shown the owner, John Fransen, that...
Carolina Roof Construction sells roofing supplies and equipment.
Experience has shown the owner, John Fransen, that the sales have a
significant seasonal variability. It is critical that the sales
forecasts are accurate so Fransen can plan the cash flow of the
business. The file Carolina Roof Construction Spring
2019 contains the sales figures for 2011 to
2018. Produce a forecast using regression of
deseasonalized sales and reseasonalize the forecast. Write
a report to Frans and include your forecast for winter, spring,...
Problem 1: Auto sales at Carmen’s Chevrolet are shown below. Develop a 3-week moving average. Week...
Problem 1:
Auto sales at Carmen’s Chevrolet are shown below. Develop a
3-week moving average.
Week
Auto Sales
1
8
2
10
3
9
4
11
5
10
6
13
7
-
Problem 2:
Carmen’s decides to forecast auto sales by weighting the
three weeks as follows:
Weights Applied
Period
3
Last
week
2
Two
weeks ago
1
Three
weeks ago
6
Total
Problem 3:
A firm uses simple exponential smoothing with to forecast
demand. The forecast for the week...
Festive Floral is gearing up for online carnation sales this Mother’s Day. They specialize in selling...
Festive Floral is gearing up for online carnation sales this
Mother’s Day. They specialize in selling organic extra-large red
and pink carnations. The price is $0.7 per stem, which includes
free one-day shipping to the customer. Festive Floral pre-orders
carnations directly from a certified organic farm at the cost of
$0.15 per stem. The order is made prior to the growing season and
flowers are grown accordingly, so the pre-order quantity cannot be
changed. However, if Festive Floral runs out...
ADVERTISEMENT
Need Online Homework Help?
Get Answers For Free
Most questions answered within 1 hours.
ADVERTISEMENT
Active Questions
asked 21 minutes ago
asked 32 minutes ago
asked 37 minutes ago
asked 46 minutes ago
asked 50 minutes ago
asked 52 minutes ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 2 hours ago