Sales of a particular product (in the thousands of dollars) for the years 2015 through 2018...
Sales of a particular product (in the thousands of dollars) for the years 2015 through 2018 have been $48,000, $64,000, $67,000, and $83,000 respectively. (a) What sales would you predict for 2019, using a simple four year moving average? (b) What sales would you predict for 2019, using a weighted moving average with weights of 0.50 for the immediate preceding year and 0.3, 0.15, and 0.05 for the three years before that? Please show the work of this problem.
Homework Answers
Add Answer to:
Sales of a particular product (in the thousands of
dollars) for the years 2015 through 2018...
Here are the data for the past 21 months for actual sales of a particular product:...
Here are the data for the past 21 months for actual sales of a particular product: LAST YEAR THIS YEAR January 330 285 February 450 385 March 455 355 April 455 410 May 410 440 June 435 350 July 400 390 August 310 300 September 355 395 October 480 November 555 December 540 Develop a forecast for the fourth quarter using a three-quarter, weighted moving average. Weight the most recent quarter 0.50, the second most recent 0.25, and the third...
i Data Table Years Ended December 31, 2019 and 2018 Dollars in thousands 2019 2018 2017...
i Data Table Years Ended December 31, 2019 and 2018 Dollars in thousands 2019 2018 2017 Net Sales Revenue Cost of Goods Sold Selling and Administrative Expenses Interest Expense $ 184,000 $ 152,000 98,500 83,000 47,000 43,000 8,500 10,000 13,000 9,500 $ 17,000 $ 6,500 Income Tax Expense Net Income Additional data: Total Assets Common Stockholders' Equity Preferred Dividends Common Shares Outstanding During the Year $ 210,000 $ 190,000 $ 174,000 92,500 82,500 77,000 3,000 3,0000 20,000 20,000 10,000 Print...
You build several models predicting job performance (sales dollars in thousands) using years of industry experience...
You build several models predicting job performance (sales dollars in thousands) using years of industry experience as a predictor. The slope of years of industry experience is .40 (p < .0001) for a simple linear regression and 60 (p<.0001) when including three other predictors (education level, SAT score, and age) in a multiple linear regression. Which of the following statements are correct (check all that apply)? Select one or more a. Holding education level, SAT score, and age constant, we...
HAROUN COMPANY Comparative Income Statements For Years Ended December 31, 2019–2013 ($ thousands) 2019 2018 2017...
HAROUN COMPANY Comparative Income Statements For Years Ended December 31, 2019–2013 ($ thousands) 2019 2018 2017 2016 2015 2014 2013 Sales $ 2,778 $ 2,433 $ 2,214 $ 2,029 $ 1,893 $ 1,760 $ 1,443 Cost of goods sold 1,997 1,625 1,398 1,223 1,137 1,063 847 Gross profit 781 808 816 806 756 697 596 Operating expenses 595 465 427 315 273 269 224 Net income $ 186 $ 343 $ 389 $ 491 $ 483 $ 428 $ 372...
Question 1 4 pts The actual demand for your sales merchandise is provided in the table...
Question 1 4 pts The actual demand for your sales merchandise is provided in the table below. The weights for June, July, and August have historically been 20..35, and.45, respectively. Actual June July August 140 180 170 Using the weighted moving average format, what is the forecasted demand for September? O 140 163 O 170 O 168 O 270 Question 6 4 pts Assuming no safety stock, what is the reorder point (R) given an average daily demand of 50...
A. Use a 3-year moving average to forecast the quantity of fish for the years 1983 through 2006 for these data...
A. Use a 3-year moving average to forecast the quantity of fish for the years 1983 through 2006 for these data. Compute the error of each forecast and then determine the mean absolute deviation of error for the forecast. B. Use exponential smoothing and a = 0.2 to forecast the data through 2006. Let the forecast for 1981 equal the actual value for 1980. Compute the error of each forecast and then determine the mean absolute deviation of error for...
1Year Sales (in $1000s) 283 288 336 388 406 412 416 435 428 435 462 452...
1Year Sales (in $1000s) 283 288 336 388 406 412 416 435 428 435 462 452 474 476 497 487 523 528 532 552 4 4 6 6 9 10 11 10 12 11 13 12 14 13 1514 16 15 17 16 18 17 19 18 20 19 21 20 23 24 Module 2 Assisted Problems Note: Data for these problems are in the Module 2 Assisted Assignments Data file-there is a tab for each problem. All answers should...
Masters Level work....all work must be shown. FORECASTING Forecasting ASSIgnment 1. Given the following data, use...
Masters Level work....all work must be shown. FORECASTING
Forecasting ASSIgnment 1. Given the following data, use a three-quarter moving average to forecast the demand for the third quarter of this year. Note, the first quarter is January, February, and March; the second quarter is April, May, and June; the third quarter is July, August, September, and the 4° quarter is October, November, and December ul ct 50 This year 235 245 255 295 305 295 Answer (Please show your work...
A relatively recent firm has been active for the last five years and now wants to...
A relatively recent firm has been active for the last five years and now wants to forecast annual sales for the current year, 2020, based on the following historical data: Sales YEAR t (y) t*y t? 1 2015 1 3.000 3.000 2016 2 6.000 12.000 4 2017 3 8.000 24.000 9 2018 4 7.000 28.000 16 2019 5 10.000 50.000 25 SUM 15 34000 117.000 55 a. What is the forecast for this year, 2020, using a four-year simple moving...
Using the model, predict sales for the fourth quarter of year 2015 You are projecting future...
Using the model, predict sales for the fourth quarter of year 2015 You are projecting future sales and have constructed a linear model using historical sales data for each of the four quarters between years 2011 and 2014. Answer questions 24-28 using the information below Regression Statistics Obs Quarter Year Sales Sales 1 2011 71 Multiple R 0.995 7 2011 49 R Square 0.990 90 58 3 2011 Adjusted R Square 0.986 80 4 2011 78 Standard Error 1.561 70...
i Data Table Years Ended December 31, 2019 and 2018 Dollars in thousands 2019 2018 2017 Net Sales Revenue Cost of Goods Sold Selling and Administrative Expenses Interest Expense $ 184,000 $ 152,000 98,500 83,000 47,000 43,000 8,500 10,000 13,000 9,500 $ 17,000 $ 6,500 Income Tax Expense Net Income Additional data: Total Assets Common Stockholders' Equity Preferred Dividends Common Shares Outstanding During the Year $ 210,000 $ 190,000 $ 174,000 92,500 82,500 77,000 3,000 3,0000 20,000 20,000 10,000 Print...
You build several models predicting job performance (sales dollars in thousands) using years of industry experience as a predictor. The slope of years of industry experience is .40 (p < .0001) for a simple linear regression and 60 (p<.0001) when including three other predictors (education level, SAT score, and age) in a multiple linear regression. Which of the following statements are correct (check all that apply)? Select one or more a. Holding education level, SAT score, and age constant, we...
Question 1 4 pts The actual demand for your sales merchandise is provided in the table below. The weights for June, July, and August have historically been 20..35, and.45, respectively. Actual June July August 140 180 170 Using the weighted moving average format, what is the forecasted demand for September? O 140 163 O 170 O 168 O 270 Question 6 4 pts Assuming no safety stock, what is the reorder point (R) given an average daily demand of 50...
A. Use a 3-year moving average to forecast the quantity of fish for the years 1983 through 2006 for these data. Compute the error of each forecast and then determine the mean absolute deviation of error for the forecast. B. Use exponential smoothing and a = 0.2 to forecast the data through 2006. Let the forecast for 1981 equal the actual value for 1980. Compute the error of each forecast and then determine the mean absolute deviation of error for...
1Year Sales (in $1000s) 283 288 336 388 406 412 416 435 428 435 462 452 474 476 497 487 523 528 532 552 4 4 6 6 9 10 11 10 12 11 13 12 14 13 1514 16 15 17 16 18 17 19 18 20 19 21 20 23 24 Module 2 Assisted Problems Note: Data for these problems are in the Module 2 Assisted Assignments Data file-there is a tab for each problem. All answers should...
Masters Level work....all work must be shown. FORECASTING
Forecasting ASSIgnment 1. Given the following data, use a three-quarter moving average to forecast the demand for the third quarter of this year. Note, the first quarter is January, February, and March; the second quarter is April, May, and June; the third quarter is July, August, September, and the 4° quarter is October, November, and December ul ct 50 This year 235 245 255 295 305 295 Answer (Please show your work...
A relatively recent firm has been active for the last five years and now wants to forecast annual sales for the current year, 2020, based on the following historical data: Sales YEAR t (y) t*y t? 1 2015 1 3.000 3.000 2016 2 6.000 12.000 4 2017 3 8.000 24.000 9 2018 4 7.000 28.000 16 2019 5 10.000 50.000 25 SUM 15 34000 117.000 55 a. What is the forecast for this year, 2020, using a four-year simple moving...
Using the model, predict sales for the fourth quarter of year 2015 You are projecting future sales and have constructed a linear model using historical sales data for each of the four quarters between years 2011 and 2014. Answer questions 24-28 using the information below Regression Statistics Obs Quarter Year Sales Sales 1 2011 71 Multiple R 0.995 7 2011 49 R Square 0.990 90 58 3 2011 Adjusted R Square 0.986 80 4 2011 78 Standard Error 1.561 70...
Most questions answered within 3 hours.
-
List and compare different forms of passive transport and active
transport.
asked 5 minutes ago -
In Netherland Dwarf rabbits, dwarf size is determined by allele
N, and normal-size by allele n....
asked 11 minutes ago -
During Heaton Company’s first two years of operations, it
reported absorption costing net operating income as...
asked 26 minutes ago -
Consider testing the
hypotheses:
H0: p = 0.56
H1: p > 0.56
where p is
the...
asked 29 minutes ago -
In a two-factor analysis of variance a main effect is defined as
____.
a. the unique...
asked 36 minutes ago -
A bank's loan officer rates applicants for credit. The ratings
are normally distributed with a mean...
asked 37 minutes ago -
Fill in the following information for Adipic Acid: molecular
weight, g or ml, mole, melting point,...
asked 42 minutes ago -
how
to use a for loop to iterate over the string below and print each
character...
asked 44 minutes ago -
Please type answer, Thanks.
Respond to the following in a minimum of 175
words:
Research industry...
asked 43 minutes ago -
Assume that all interest rates in the economy increase from 9
percent to 10 percent. Which...
asked 53 minutes ago -
Describe the function of a Change Control Board.
When calculating Planned Value (PV), what is the...
asked 59 minutes ago -
The customer help center in your company receives calls from
customers who need help with some...
asked 1 hour ago