Question

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?

Business   Finance   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
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
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
2019 2018 2017 2016 2015 Sales $ 442,210 $ 285,297 $ 222,021 $ 153,648 $ 116,400...
2019 2018 2017 2016 2015 Sales $ 442,210 $ 285,297 $ 222,021 $ 153,648 $ 116,400 Cost of goods sold 223,505 144,349 114,161 78,174 58,200 Accounts receivable 21,359 16,718 15,231 8,942 7,950 Compute trend percents for the above accounts, using 2015 as the base year. Trend Percent for Net Sales: Choose Numerator: / Choose Denominator: / = Trend percent 2019: / = % 2018: / = % 2017: / = % 2016: / = % Trend Percent for Cost of...
A company had the following income statement figures for 2016 and 2017 : 2017 2016 Sales...
A company had the following income statement figures for 2016 and 2017 : 2017 2016 Sales Cost of goods Sold 570 000 550 000 300 000 310 000 Gross Margin Operating Expenses 270 000 240 000 180 000 150 000 Net income 90 000 90 000 Calculate component percentages for this information. Please, state your conclusions.
2019 2018 2017 2016 Net Sales Revenue $    766,000 $   708,000 $   644,000 $664,000 Net Income...
2019 2018 2017 2016 Net Sales Revenue $    766,000 $   708,000 $   644,000 $664,000 Net Income 60,000 38,000 36,000 44,000 Ending Common Stockholder’s equity 368,000 352,000 326,000 296,000 Net sales​ revenue, net​ income, and common​ stockholders' equity for EyesightEyesight Mission​ Corporation, a manufacturer of contact​ lenses, follow for a​ four-year period Compute trend analyses for each item for 2017—2019. Use 2016 as the base​ year, and round to the nearest whole percent. Begin by computing Eyesight Mission​ Corporation's trend analysis...
The Municipal Government has asked you to forecast the sales tax revenue it will collect in...
The Municipal Government has asked you to forecast the sales tax revenue it will collect in 2017, 2018 and 2019. Data on revenue in recent years is presented below. Year Q1 Q2 Q3 Q4 TOTAL 2012          695          788          809       1,302 $3,594 2013          896          941       1,018       1,677 $4,532 2014       1,037          929       1,353       2,090 $5,409 2015       1,067       1,081       1,574       2,143 $5,865 2016       1,147       1,161...
The following information is for Tide Corporation: ($ thousands) 2017 2016 Net sales $ 438,060 $...
The following information is for Tide Corporation: ($ thousands) 2017 2016 Net sales $ 438,060 $ 298,000 Cost of goods sold 214,649 88,208 Determine the 2016 and 2017 trend percents for net sales using 2016 as the base year.
Would like to see it done in EXCEL Vehicle Sales: Consider the data below ( in...
Would like to see it done in EXCEL Vehicle Sales: Consider the data below ( in thousands of units):   year Quarter 1 Quarter 2 Quarter 3 Quarter 4 2016: 4072 4521 4452 4418 2017: 4010 4392 4399 4334 2018: 4092 4484 4277     4360 Obtain the seasonal factors and enter them into the appropriate yellow cells below: Quarter 1 Quarter 2 Quarter 3 Quarter 4 Seasonal Factor Using the columns Year and Total (Annual Sales) below, obtain the regression equation...
2018 2017 2016 2015 2014 Sales $ 282,880 $ 270,800 $ 252,600 $ 234,560 $ 150,000...
2018 2017 2016 2015 2014 Sales $ 282,880 $ 270,800 $ 252,600 $ 234,560 $ 150,000 Cost of goods sold 128,200 122,080 115,280 106,440 67,000 Accounts receivable 18,100 17,300 16,400 15,200 9,000 Compute trend percents for the above accounts, using 2014 as the base year.
1. Suppose the following data represents total revenues (in $ millions) for a mining   company. Year...
1. Suppose the following data represents total revenues (in $ millions) for a mining   company. Year Revenue 4-Year Moving Average 4 Weighted Moving Average Weights 4,3,2,1    Exponential smoothing          α = 0.6 2010 75 2011 81 2012 74 2013 79 2014 69 2015 92 2016 73 2017 85 2018 90 2019 73 2020 Forecast         Use 2 decimal places, Compute the 4-year moving averages and forecast the revenue for 2020. ( 4 marks) Compute the 4-year weighted moving averages...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT