2. The quarterly sales for Grinder Inc are as follows: Period Sales ($M) 2014 96 2015...

2. The quarterly sales for Grinder Inc are as follows:

Period Sales ($M)
2014 96
2015 106
2016 100
2017 115
2018 122
2019 120
2020 ???

• Calculate and fit the best straight line to the points using linear regression.
• Using the data for trend forecast, estimate the sales for 2020.
• Estimate the forecast error.
• Show on the graph the regression line, the forecasted sale, and the forecast error.

Expert Solution

Answer

The exponential smoothing forecasting method is used here which is given as

Ft = Alpha*At-1 +(1-Alpha)*Ft-1

Using this we calculated the demand forecast for 2020 which comes out to be 108.6 or 109 as below

PERIOD	Actual SALES	FORECCAST SALE	ERROR
2014	96	96	0
2015	106	96	10
2016	100	98	2
2017	115	98.4	16.6
2018	122	101.72	20.28
2019	120	105.776	14.224
2020		108.6208

For your data, the regression equation for Y is:

ŷ = 5.22857X - 10433.58095

Calculation Summary

Sum of X = 12099
Sum of Y = 659
Mean X = 2016.5
Mean Y = 109.8333
Sum of squares (SSX) = 17.5
Sum of products (SP) = 91.5

Regression Equation = ŷ = bX + a

b = SP/SSX = 91.5/17.5 = 5.22857

a = MY - bMX = 109.83 - (5.23*2016.5) = -10433.58095

ŷ = 5.22857X - 10433.58095

SS: 17.5

SP: 91.5

Rahul Sunny answered 1 year ago

Chorus, Inc. expects quarterly sales volume for 2017 as follows: 1) 40,000 units; 2) 60,000; 3)...

Chorus, Inc. expects quarterly sales volume for 2017 as follows: 1) 40,000 units; 2) 60,000; 3) 100,000; and 4) 50,000. Additionally, Chorus expects quarterly sales volume for 2018 as follows: 1) 70,000 units; 2) 80,000; 3) 75,000; and 4) 85,000. Chorus has an inventory policy which requires ending finished goods inventory to be 30% of budgeted sales for the next quarter. (T or F) The amount of production necessary to meet the expected sales for 2017 is 275,000 units.

Question 2 The income statement for Tiger Co. for 2015 is summarized as follows: Sales...

Question 2 The income statement for Tiger Co. for 2015 is summarized as follows: Sales (200,000 units) $3,000,000 Variable costs 1,000,000 Contribution margin 2,000,000 Fixed costs (80% manufacturing related) 500,000 Operating income $1,500,000 Variable costs include: Direct materials $1.50/unit $300,000 Direct labour $2.00/unit $400,000 Variable MOH $1.25/unit $250,000 Variable selling & admin $0.25/unit $50,000 There were 0 units in beginning inventory, and 50,000 units in ending inventory. Required -...

The revenue and cost information for Odessa Outfitters inc. for 2015 follows: Sales Revenue 560,000 COGS...

The revenue and cost information for Odessa Outfitters inc. for 2015 follows: Sales Revenue 560,000 COGS (at standart) 342,000 DM price variance 1,000 F DM quantity variance 6,000 F DL rate varinace 4,000U DL efficiency variance 2,000 F Overhead controllable variance 3,500U Overhead volüme variance 8,000f a)What is gross profit at standard? b)What is gross profit actual? c)Write journal entries for all variance accounts assuming all units are produced and sold in the same period.

Pepsi 2013 2014 2015 2016 2017 Sales/Revenue 66.42B 66.68B 63.05B 62.8B 63.53B Coca-Cola 2013 2014 2015...

Pepsi 2013 2014 2015 2016 2017 Sales/Revenue 66.42B 66.68B 63.05B 62.8B 63.53B Coca-Cola 2013 2014 2015 2016 2017 Sales/Revenue 46.76B 46B 43.7B 41.38B 35.02B Using the year 2013-2017 financial data of Coca-Cola and PepsiCo companies, determine their 5-year average growth rates related to net sales and income from continuing operations. Coca Cola: Net Sales: 7.86% Increase. PepsiCo: Net Sales: 3.11% Increase. And what data to use to calculate.

2018 2017 2016 2015 2014 Sales $ 80,000 $ 73,000 $ 61,000 $ 57,000 $ 50,000...

2018 2017 2016 2015 2014 Sales $ 80,000 $ 73,000 $ 61,000 $ 57,000 $ 50,000 Cost of goods sold 72,600 53,400 45,600 33,300 30,000 Dollar amounts stated above are in thousands. a. Compute trend percentages for the above items taken from the financial statements of Lopez Plumbing over a five-year period. Treat 2014 as the base year. b. State whether the trends are favorable or unfavorable. Required A Required B Compute trend percentages for the above items taken from...

2018 2017 2016 2015 2014 Sales $ 672,729 $ 434,019 $ 347,215 $ 242,808 $ 181,200...

2018 2017 2016 2015 2014 Sales $ 672,729 $ 434,019 $ 347,215 $ 242,808 $ 181,200 Cost of goods sold 332,087 214,419 173,535 120,176 88,788 Accounts receivable 32,560 25,434 23,715 14,180 12,376 Compute trend percents for the above accounts, using 2014 as the base year. (Round the percents to whole numbers.)

2017 2016 2015 2014 2013 Sales $ 699,332 $ 466,221 $ 368,554 $ 252,434 $ 189,800...

2017 2016 2015 2014 2013 Sales $ 699,332 $ 466,221 $ 368,554 $ 252,434 $ 189,800 Cost of goods sold 352,166 234,761 187,327 128,167 94,900 Accounts receivable 33,918 27,227 25,283 14,767 13,001 Compute trend percents for the above accounts, using 2013 as the base year. Trend Percent for Net Sales: Choose Numerator: / Choose Denominator: / = Sales 2017: / = % 2016: / = % 2015: / = % 2014: / = % Trend Percent for Cost of Goods...

Partial income statements for Sherwood Company summarized for a four-year period show the following: 2014 2015...

Partial income statements for Sherwood Company summarized for a four-year period show the following: 2014 2015 2016 2017 Net Sales $ 2,000,000 $ 2,400,000 $ 2,500,000 $ 3,000,000 Cost of Goods Sold 1,400,000 1,660,000 1,770,000 2,100,000 Gross Profit 600,000 740,000 730,000 900,000 An audit revealed that in determining these amounts, the ending inventory for 2015 was overstated by $20,000. The inventory balance on December 31, 2016, was accurately stated. The company uses a periodic inventory system. 1. Restate...

On January 2, 2015, L Corporation issued $2,050,000 of 10% bonds at 96 due December 31,...

On January 2, 2015, L Corporation issued $2,050,000 of 10% bonds at 96 due December 31, 2024. Interest on the bonds is payable annually each December 31. The discount on the bonds is also being amortized on a straight-line basis over the 10 years. (Straight-line is not materially different in effect from the preferable “interest method.”) The bonds are callable at 101 (i.e., at 101% of face amount), and on January 2, 2020, L Corp. called $1,230,000 face amount of...

As an airline financial analyst, your forecast of 2015 for DirectJet is as follows: Sales: $200...

As an airline financial analyst, your forecast of 2015 for DirectJet is as follows: Sales: $200 million Cost of goods sold: $100 million You plan to use the following information to forecast next year’s balance sheet: Inventory turnover = 5 Current ratio = 2 Asset turnover = 0.50 Debt ratio = 40% Cash = $70 million Accounts receivable turnover = 20 a. Forecast total assets. b. Estimate the current assets. c. Estimate the current liabilities. d. Forecast the total shareholder...

Question