<p>The business analyst for Video Sales, Inc. wants to forecast yearly demand for DVD decoders based on the following historical data:</p><p><table><thead><tr class="firstRow"><th style="text-align: left;">Year</th><th style="text-align: left;">Demand</th></tr></thead><tbody><tr><td>5 years ago</td><td>900</td></tr><tr><td>4 years ago</td><td>700</td></tr><tr><td>3 years ago</td><td>600</td></tr><tr><td>2 years ago</td><td>500</td></tr><tr><td>Last year</td><td style="word-break: break-all;">300</td></tr></tbody></table><br/></p><p>What is the forecast for this year using a three-year simple moving average? </p><p>What is the forecast for last year using simple exponential smoothing with smoothing constant alpha = 0.4, if the forecast for two years ago was 750? </p><p>What is the forecast for this year using simple exponential smoothing with smoothing constant alpha = 0.4, if the forecast for two years ago was 750? </p>

Question

In: Other

The business analyst for Video Sales, Inc. wants to forecast yearly demand for DVD decoders based...

The business analyst for Video Sales, Inc. wants to forecast yearly demand for DVD decoders based on the following historical data:

Year	Demand
5 years ago	900
4 years ago	700
3 years ago	600
2 years ago	500
Last year	300

What is the forecast for this year using a three-year simple moving average?

What is the forecast for last year using simple exponential smoothing with smoothing constant alpha = 0.4, if the forecast for two years ago was 750?

What is the forecast for this year using simple exponential smoothing with smoothing constant alpha = 0.4, if the forecast for two years ago was 750?

Solutions

Expert Solution

Amanda K answered 1 year ago

Next > < Previous

Related Solutions

The business analyst for Video Sales, Inc. wants to forecast this year's demand for DVD decoders...

The business analyst for Video Sales, Inc. wants to forecast this year's demand for DVD decoders based on the following historical data: YearDemand5 years ago9004 years ago7003 years ago6002 years ago500Last year300What is the forecast for this year using the naive approach? What is the forecast for this year using a three-year weighted moving average with weights of .5, .3, and .2? What is the forecast for this year using exponential smoothing with alpha = .4, if the forecast for two years ago...

Exhibit 1: Sales and Cost Forecast The sales forecast is based on projected levels of demand....

Exhibit 1: Sales and Cost Forecast The sales forecast is based on projected levels of demand. All the numbers are expressed in today’s dollars. The forecasted average inflation per year is 3.0% . Price per bus $220,000 Units sold per year 11,000 Labor cost per bus $50,000 Components & Parts per bus $95,000 Selling General & Administrative (fixed) $250,000,000 NOTE: Average warranty cost per year per bus for the first five years is $1,000. The present value of this cost...

Exhibit 1: Sales and Cost Forecast The sales forecast is based on projected levels of demand....

Exhibit 1: Sales and Cost Forecast The sales forecast is based on projected levels of demand. All the numbers are expressed in today’s dollars. The forecasted average inflation per year is 3.0% Price per bus $220,000 Units sold per year 11,000 Labor cost per bus $50,000 Components & Parts per bus $95,000 Selling General & Administrative (fixed) $250,000,000 NOTE: Average warranty cost per year per bus for the first five years is $1,000. The present value of this cost will...

1) A business analyst wants to know if there is a correlation in a sales person’s...

1) A business analyst wants to know if there is a correlation in a sales person’s intelligence and the average weekly sales. The Excel spreadsheet list the data for a random selection of 15 sales persons. The intelligence is measured by an inventory each employee takes. a)Create the scatterplot on your Excel Spreadsheet. Does it appear to be a positive linear correlation? Why or why not? b)Fill out the necessary cells in the spreadsheet to calculate the correlation coefficient ?....

The sales forecast is based on projected levels of demand. All the numbers are expressed in...

The sales forecast is based on projected levels of demand. All the numbers are expressed in today’s dollars. Price per bus $220,000 Units sold per year 12,250 Labor cost per bus $32,500 Components & Parts $86,500 Selling General & Administrative $200,000,000 The average warranty cost per year per bus for the first five years is $2,000. The present value of this cost will be used as a cost figure for each bus. Afterwards, the bus operator will become responsible the...

Assume that your stock of sales merchandise is maintained based on the forecast demand. If the...

Assume that your stock of sales merchandise is maintained based on the forecast demand. If the distributor's sales personnel call on the first day of each month, compute your forecast sales by each of the three methods requested here. ACTUAL June 142 July 182 August 121 Using single exponential smoothing and assuming that the forecast for June had been 120, forecast sales for September with a smoothing constant α of 0.30. (Do not round intermediate calculations. Round your answer to...

Business Decision Case The sales department of Donovan Manufacturing, Inc. has completed the following sales forecast...

Business Decision Case The sales department of Donovan Manufacturing, Inc. has completed the following sales forecast for the months of January through March 20X1 for its only two products: 50,000 units of J to be sold at $90 each and 30,000 units of K to be sold at $70 each. The desired unit inventories at March 31, 20X1, are 10% of the next quarter’s unit sales forecast, which are 60,000 units of J and 30,000 units of K. The January...

A sales analyst wants to determine whether there is difference in the mean monthly sales (in...

A sales analyst wants to determine whether there is difference in the mean monthly sales (in RM) of cosmetic company of six sales region in Johor. Several salespersons from each region are chosen and their monthly sales were recorded in Table Q2. Monthly sale (RM) Company A Company B Company C Company D Company E Company F 4250 3930 3960 4350 4150 3970 3980 4010 4020 4450 3890 4160 4020 4050 4130 3880 4568 4370 4130 4220 4350 4574 4480...

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...

Zeebadee Inc. wants to forecast free cash flow to equity (FCFE) using the percent-of-sales method. Prior...

Zeebadee Inc. wants to forecast free cash flow to equity (FCFE) using the percent-of-sales method. Prior year sales were $10,000. Year 1 Year 2 Year 3 Year 4 Year 5 Sales growth 8.00% 14.00% 12.00% 10.00% 6.00% Profit margin 8.00% 10.00% 12.00% 12.00% 11.00% Net FCInv (% of Sales) 8.00% 8.00% 8.00% 6.00% 3.00% WCInv (% of Sales) 3.00% 3.00% 3.00% 2.00% 1.00% DR 30.00% 30.00% 30.00% 30.00% 30.00% What is net borrowing in Year 4? $364.04 $386.66 $406.30 $455.05...

Subjects