- Problem 3 19 Algo The Tulunitele Luwe Lool Due Comen S Quarterly Sales Sur Le Culleri Yedi Wieloles Would You Predict 1 (61.31 KiB) Viewed 54 times
National Scan, Inc., sells radio frequency inventory tags.
Monthly sales for a seven-month period were as follows:
a. Forecast September sales volume using
each of the following:
(1) The naive approach.
(2) A five-month moving average. (Round your answer to
2 decimal places.)
(3) A weighted average using 0.55 for August, 0.10 for July, and
0.35 for June. (Round your answer to 2 decimal
places.)
(4) Exponential smoothing with a smoothing constant equal to
0.25, assuming a March forecast of 17(000). (Round
your intermediate forecast values and final answer to 2 decimal
places.)
(5) A linear trend equation. (Round
your intermediate calculations and final answer to 2 decimal
places.)
Problem 3-9 (Algo)
a. Obtain the linear trend equation for
the following data on new checking accounts at Fair Savings Bank
and use it to predict expected new checking accounts for periods 16
through 19. (Round your intermediate calculations and
final answers to 2 decimal places.)
Problem 3-9 (Algo)
a. Obtain the linear trend equation for
the following data on new checking accounts at Fair Savings Bank
and use it to predict expected new checking accounts for periods 16
through 19. (Round your intermediate calculations and
final answers to 2 decimal places.)
b.Use trend-adjusted smoothing with α = .2 and β =
.1 to smooth the new account data in part a. What is the forecast
for period 16? Compute the initial trend estimate
(Tt) for Period 5 as follows: (Period 4 data – Period 1
data) / 3. Then compute the initial trend-adjusted forecast
(TAFt) for Period 5 as follows: Period 4 data + Initial
trend estimate for Period 5. Then compute all remaining values
(including the St value for Period 5) using the
textbook formulas or Excel template. (Round the
"Trend"values (Tt) to 3 decimal places and all other intermediate
forecast values (TAFt and St) to 2 decimal places. Round your
final answer to 2 decimal places.)
Problem 3-9 (Algo)
a. Obtain the linear trend equation for
the following data on new checking accounts at Fair Savings Bank
and use it to predict expected new checking accounts for periods 16
through 19. (Round your intermediate calculations and
final answers to 2 decimal places.)
b.Use trend-adjusted smoothing with α = .2 and β =
.1 to smooth the new account data in part a. What is the forecast
for period 16? Compute the initial trend estimate
(Tt) for Period 5 as follows: (Period 4 data – Period 1
data) / 3. Then compute the initial trend-adjusted forecast
(TAFt) for Period 5 as follows: Period 4 data + Initial
trend estimate for Period 5. Then compute all remaining values
(including the St value for Period 5) using the
textbook formulas or Excel template. (Round the
"Trend"values (Tt) to 3 decimal places and all other intermediate
forecast values (TAFt and St) to 2 decimal places. Round your
final answer to 2 decimal places.)
Problem 3-9 (Algo)
a. Obtain the linear trend equation for
the following data on new checking accounts at Fair Savings Bank
and use it to predict expected new checking accounts for periods 16
through 19. (Round your intermediate calculations and
final answers to 2 decimal places.)
Y= _________ + __________t
Y16 = __________
Y17= __________
Y18= __________
Y19= __________
B.Use trend-adjusted smoothing with α = .2 and β =
.1 to smooth the new account data in part a. What is the forecast
for period 16? Compute the initial trend estimate
(Tt) for Period 5 as follows: (Period 4 data – Period 1
data) / 3. Then compute the initial trend-adjusted forecast
(TAFt) for Period 5 as follows: Period 4 data + Initial
trend estimate for Period 5. Then compute all remaining values
(including the St value for Period 5) using the
textbook formulas or Excel template. (Round the
"Trend"values (Tt) to 3 decimal places and all other intermediate
forecast values (TAFt and St) to 2 decimal places. Round your
final answer to 2 decimal places.)
Forecast for Period 16 =
Problem 3-19 (Algo)
The following table shows a tool and die company’s quarterly
sales for the current year. What sales would you predict for the
first quarter of next year? Quarter relatives are SR1=
.97, SR2 = .94, SR3 = 1.20, and
SR4 = .89. For the trend forecast (T), add the
difference between quarter 3 and quarter 4's deseasonalized sales
data to the deseasonalized quarter 4 sales. (Round
your answer to 1 decimal place.)
Forecast = __________
b.Use trend-adjusted smoothing with α = .2 and
β = .1 to smooth the new account data in part a. What is the
forecast for period 16? Compute the initial trend estimate
(Tt) for Period 5 as follows: (Period 4 data – Period 1
data) / 3. Then compute the initial trend-adjusted forecast
(TAFt) for Period 5 as follows: Period 4 data + Initial
trend estimate for Period 5. Then compute all remaining values
(including the St value for Period 5) using the
textbook formulas or Excel template. (Round the
"Trend"values (Tt) to 3 decimal places and all other intermediate
forecast values (TAFt and St) to 2 decimal places. Round your
final answer to 2 decimal places.)
Problem 3-19 (Algo) The Tulunitele luwe lool due comen's quarterly sales ſur le culleri yedi. Wieloles would you predict for the list erler of rexlyes? Curler le lives are SR, -97. SR-91. SR. - 1.20. SR. - 39. For the end forecast.de ference tretween Guarie 2 and quarters deseasonalized sales skirta to the deseasonalized quarter sales (Round your answer to 1 decimal place.) Quarter alex 1 2 27.01.: 11.1 115. TXN Problem 3-9 (Algo) a Obam the lineet Leidsliul lor de following lirewchecking out Savings Batik und use illo predict expected neachecking counts for periods 16 through 19. (Round your intermediate calculations and final answers to 2 decimal places.) Print 1 2 3 Ne Srents proport 28 2:3 515 7 31 211 8 250 4 225 น 252 Pri 12 . 13 13 14 15 291 73 231 فت 5 y YE 74. 718 19 b. Use trend-adjusted smoching with - 2 and 3 - 110 smooth the new account data la part a What is the forecast for periode? Coacute the natrend estimate or Period 5 as follows: Period 40eta-Period 1/3 Iter compute the initial trend- les forcestion Period 5 g fullows: Period 1 de la libel tren de miste Tu Pelou 5. Then we alle er velues : Onduding the Sy value for Period Sing the textbook formulas an Excel template. (Round the Trend values (Te) to 3 decimal places and all other intermediate forecast values ITAF. and Sc) to 2 decimal places. Round your final answer to 2 decimal places.) Forector od 10 Problem 3-2 (Algo) National Scents ladio fequencyivellory legs. Munthly sales lola revertrou penuo were follows: تا قازقة 145 SA ( und Col. Por pr. Pay Jun. lut .. 28 28 32 29 20 25 23 37 ה Olck here to the wallata lile 6. Coreces September Ses volume using eech of the following 11 TIONC Ndique VI Atv-month moving werage (Round your answer to 2 decimal places. Mong arra thousands 21A weighter werage as no.56 for August, 010 forly and 0.25 forume (Round your answer to 2 decimal places.) Vaa | 2 UOUS 11 Experience Collingwie wolling regel 0.25. exsulting March forec. of 1710001. Round your intermediate forecast values and final answer to 2 decimal places.) ете ня! that 151 A lineer werd euali. (Round your intermediate calculations and final answer to 2 decimal places. Y!